ORA-12701

[jay_arun]

Hi all,

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.
Regards,
jay.

[sazzadur]

Hi,

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.

[julian]

What is the Oracle version? If < Oracle8i, then once the database is created, the character set cannot be easilly changed without recreating the database.

[bensmail]

If u create the DB with scripts look at this scripts!
usually this scripts are:Oracle_home\admin\sid\create\