ORA-12701: CREATE DATABASE character set is not known when Db moved
802730Oct 3 2010 — edited Oct 4 2010Hi Guys,
I know that this question might have been asked but right now I'm having a hard time resolving this issue. It started when one of our 9i demo database was asked to be transferred to another server where there is an existing 8i database, so my colleague asked our system administrator to mount the oracle home and oracle database files to our new server and asked me I could bring up the database so what I did was to set ORACLE_SID and ORACLE_HOME to the correct paths and as I tried starting the database I've encountered this error:
SQL> startup
ORACLE instance started.
Total System Global Area 223314888 bytes
Fixed Size 730056 bytes
Variable Size 184549376 bytes
Database Buffers 33554432 bytes
Redo Buffers 4481024 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
Then I checked the alert and trace file and saw this error:
ORA-12701: CREATE DATABASE character set is not known
Sun Oct 3 21:21:48 2010
Error 12701 happened during db open, shutting down database
USER: terminating instance due to error 12701
Instance terminated by USER, pid = 12355
ORA-1092 signalled during: ALTER DATABASE OPEN...
I check the net and saw solutions in metalink involving ORA_NLS33 parameter to be set properly
so I set that parameter to bash-2.05$ export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data/
but the error still occurs. Nothing was changed from the database. Any more ideas? Thanks