Ao usar o #CSSCAN foi retornado a critica “CSS-00107: Character set migration utility schema not installed”
select * from v$nls_parameters where parameter in (‘NLS_CHARACTERSET’,’NLS_LANGUAGE’);
— ALTER SESSION SET NLS_LANGUAGE = ‘AMERICAN’
— ALTER SESSION SET NLS_LANGUAGE = ‘BRAZILIAN PORTUGUESE’
–WE8ISO8859P1
–WE8MSWIN1252
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | [oracle@srvrussia ~]$ csscan Character Set Scanner v2.2 : Release 11.2.0.1.0 - Production on Sat Nov 26 09:58 :21 2016 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. Username: system Password: Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options CSS-00107: Character set migration utility schema not installed Scanner terminated unsuccessfully. |
Para resolver é simples, basta conectar com usuário SYS, localizar o script (csminst.sql) conforme o diretório de instalação do Oracle e executar.
1 | SQL> @/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/csminst.sql |
