Oracle in World: CSSCAN fails with CSS-00107: Character set migration utility schema not installed

Problem Description
While running csscan in order to check all character data in the database and tests for the effects and problems of changing the character set encoding, "CSS-00107: Character set migration utility schema not installed" error returned as below.


C:\>csscan arju/a@san user=arju array=1024000 TOCHAR=AL32UTF8 process=2


Character Set Scanner v2.2 : Release 11.1.0.6.0 - Production on Mon Feb 2 18:31:14 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

CSS-00107: Character set migration utility schema not installed

Scanner terminated unsuccessfully.

Cause of the problem
In order to run character set scanner in the database it is needed to create tables for Database Character Set Migration Utility. The tables are required to run csscan utility successfully. These tables are created under csmig user. The script named $ORACLE_HOME/rdbms/admin/csminst.sql contains all the tables/synonyms/grants that is requied for cssan.

Solution of the problem
As sys user run the csminst.sql script under $ORACLE_HOME/rdbms/admin directory.
1)Connect as sys.
C:\>sqlplus sys/a@san as sysdba

SQL*Plus: Release 11.1.0.6.0 - Production on Mon Feb 2 18:32:38 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

2)Execute csminst.sql.
Here my $ORACLE_HOME is F:\app\Administrator\product\11.1.0\db_1.


SQL> @F:\app\Administrator\product\11.1.0\db_1\RDBMS\ADMIN\csminst.sql
Grant succeeded.


Grant succeeded.

drop user csmig cascade
        *
ERROR at line 1:
ORA-01918: user 'CSMIG' does not exist


Please create password for user CSMIG:
Enter value for csmig_passwd: a
old   1: create user csmig identified by &csmig_passwd
new   1: create user csmig identified by a

User created.


Grant succeeded.


Grant succeeded.
drop public synonym csmv$triggers
                  *
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist



Synonym created.


View created.


View created.


Commit complete.

Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

While execute the script it will prompt password of csscan. Type password as you like and then press enter.

3)Now run csscan


C:\>csscan arju/a@san user=arju array=1024000 TOCHAR=AL32UTF8 process=2


Character Set Scanner v2.2 : Release 11.1.0.6.0 - Production on Mon Feb 2 18:35:50 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Enumerating tables to scan...
.
.
.

And everything goes fine.

Oracle in World

Tuesday, February 24, 2009

CSSCAN fails with CSS-00107: Character set migration utility schema not installed

1 comment: