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

 

screenshot_1

Após executar o script, poderá ser feito a alteração;

csscan-2

csscan-3

Conectar novamente;

 

1
sql> shutdown IMMEDIATE

csscan-4

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

csscan-6

1
sql> shutdown IMMEDIATE

csscan-7

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’;

csscan-9

Referência:

Character Set migration Oracle 11g

 

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

 

Deixe um comentário

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

Post Navigation