I changed My database NLS_CHARACTERSET wrongly.After shuting down and startup , it throws an error "ORA-12701 CREATE DATABASE character set is not known ".I am not able to do anything.Plz help me in this regard.
Thanks in advance.
This error usually means that the charachter set you are refereing to does not exist on the system.
what was the charachter set before you tried to change it ? and waht did you want to change it to ?
I f you are using a charachter set other than the default US7ASCII, you have to set the following partamters depending on your operatins sytem and database version:
RDBMS 7.2.x -> ORA_NLS
RDBMS 7.3.x -> ORA_NLS32
RDBMS 8.0.x -> ORA_NLS33
RDBMS 8.1.x -> ORA_NLS33
This parameter should
point to your $ORACLE_HOME/ocommon/nls/admin/data directory.
What is the Oracle version? If < Oracle8i, then once the database is created, the character set cannot be easilly changed without recreating the database.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
If u create the DB with scripts look at this scripts!
usually this scripts are:Oracle_home\admin\sid\create\
Click Here to Expand Forum to Full Width