ORA-12701

Printable View

07-02-2002, 04:58 AM
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.
07-02-2002, 05:09 AM
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.
07-02-2002, 05:09 AM
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.
07-02-2002, 06:13 AM
bensmail

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