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 |
Após executar o script, poderá ser feito a alteração;
Conectar novamente;
1 | sql> shutdown IMMEDIATE |
1 2 | sql> startup restricti <a href="http://blog.fabianobento.com.br/2016/11/alterando-o-character-set-no-oracle-11g-csscan-css-00107-character-set-migration-utility-schema-not-installed/csscan-5/" rel="attachment wp-att-2463"><img class="aligncenter size-full wp-image-2463" src="http://blog.fabianobento.com.br/wp-content/uploads/2016/11/csscan-5.png" alt="csscan-5" width="596" height="181" /></a> |
Rodar o script csalter.plb
1 | sql> @/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/csalter.plb |
1 | sql> shutdown IMMEDIATE |
1 2 | sql> startup <a href="http://blog.fabianobento.com.br/2016/11/alterando-o-character-set-no-oracle-11g-csscan-css-00107-character-set-migration-utility-schema-not-installed/csscan-8/" rel="attachment wp-att-2466"><img class="aligncenter size-full wp-image-2466" src="http://blog.fabianobento.com.br/wp-content/uploads/2016/11/csscan-8.png" alt="csscan-8" width="413" height="181" /></a> |
Conferir alteração
select * from nls_database_parameters where parameter=’NLS_CHARACTERSET’;
Referência:
Windows (in cmd window):
set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
Unix/ Linux:
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
http://www.orafaq.com/wiki/NLS_LANG