-
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.
-
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.
-
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
email: ocp_9i@yahoo.com
-
If u create the DB with scripts look at this scripts!
usually this scripts are:Oracle_home\admin\sid\create\
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|