On Test database error:
SQL> startupORACLE instance started.Total System Global Area 1073741824 bytesFixed Size 1326064 bytesVariable Size 266060816 bytesDatabase Buffers 805306368 bytesRedo Buffers 1048576 bytesORA-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:
$ iduid=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> startupORACLE instance started.Total System Global Area 1073741824 bytesFixed Size 1326064 bytesVariable Size 266060816 bytesDatabase Buffers 805306368 bytesRedo Buffers 1048576 bytesDatabase mounted.Database opened.
;)
No comments:
Post a Comment