Sunday, August 16, 2009

ORA-12709: error while loading create database character set


On Test database error:
SQL> startup
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size 1326064 bytes
Variable Size 266060816 bytes
Database Buffers 805306368 bytes
Redo Buffers 1048576 bytes
ORA-12709: error while loading create database character set
What wrong?
SQL*Plus uses NLS files at $ORACLE_HOME/ocommon/nls/admin directory (pre 10g)
or $ORACLE_HOME/nls/ (10g and up), So have to verify:
- Verifify the ownership/permissions NLS files
- Verify the number of NLS files

Verify:
$ id
uid=200(oracle) gid=200(oinstall) groups=200(oinstall),201(dba)

$ cd $ORACLE_HOME/nls/
bash: cd: $ORACLE_HOME/nls/ : Permission denied
So, changed permmision in $ORACLE_HOME/nls path and verified every directories + files in $ORACLE_HOME/nls/*, that "oracle" user can access...

startup database again:
SQL> startup
ORACLE instance started.

Total System Global Area 1073741824 bytes
Fixed Size 1326064 bytes
Variable Size 266060816 bytes
Database Buffers 805306368 bytes
Redo Buffers 1048576 bytes
Database mounted.
Database opened.
;)

No comments: