ORA-12709: error while…

来源:互联网 发布:淘宝账户能注销吗 编辑:程序博客网 时间:2024/06/01 15:31

Problem Description:
====================
 
You are trying to start your instance via SQLPLUS or Server Managerwhen you encounter the
following error:

SQL> connect / as SYSDBA
or
SVRMGR> connect internal
SQL/SVRMGR> startup

  ORA-12709: error while loading createdatabase character set
     Cause: This is an internal error.
    Action: Contact Oracle Customer Support.

You have confirmed that your ORACLE_HOME and ORACLE_SID are setcorrectly for
this instance.

No changes have been made to the database prior toshutdown.,

Solution Description:
=====================
In the Installation Guide for your Operating System and databaseversion, it
mentions that when specifying a character set other than US7ASCIIyou will need
to set one of the following ORA_NLS parameters at the operatingsystem level:

  RDBMS 7.2.x  ->ORA_NLS
  RDBMS 7.3.x  ->ORA_NLS32
  RDBMS 8.0.x  ->ORA_NLS33
  RDBMS 8.1.x  ->ORA_NLS33
  RDBMS 9.X.X  ->ORA_NLS33
  RDBMS 10.X  -> ORA_NLS10

Only one of these parameters should be set at anytime. 

On Unix the parameter should be set in the environment andshould
point to your $ORACLE_HOME/ocommon/nls/admin/data directory (pre10g)
or $ORACLE_HOME/nls/data (10g and up).

On windows this is typically *not* set in the registry

For more information on how to set ORA_NLSxx correctly pleaseread:
Note 77442.1 ORA_NLS (ORA_NLS32, ORA_NLS33, ORA_NLS10) EnvironmentVariables explained.


8.0/8i, 9i Unix Example:
------------------------
=====================

Use the correct setting for the environment variableORA_NLS33. 
 
Per your platform specific Oracle Installation and ConfigurationGuide, the
ORA_NLS33 parameter should be set to the following:

ORA_NLS33 = $ORACLE_HOME/ocommon/nls/admin/data

To set the variable to the correct location, use the followingsyntax:

C-shell:

       % setenv ORA_NLS33 $ORACLE_HOME/ocommon/nls/admin/data

Bourne or Korn shell:

       $ ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
       $ export ORA_NLS33

Restart your SQLPLUS or Server Manager session and restart thedatabase.

Check the files under ORACLE_HOME/ocommon/nls/admin/datadirectory.

1.  Verify the ownership/permissions on thefiles are correct.

2.  Verify the number of files in thisdirectory are the same as the number
of files in a previous backup or another database.

3.  Restore all files in this directory frombackup.

Explanation:
============

Not finding the proper location for the NLS files, or some ofthe *.nlb files
in the ORACLE_HOME/ocommon/nls/admin/data directory are eithermissing or
corrupt.  These are the files needed to supportyour NLS settings.

REFERENCE
=========
Note1058400.6      ORA-12701 When Creating a Database
Note275107.1       ORA-12709: error while loading create database character set

Note77442.1     ORA_NLS (ORA_NLS32, ORA_NLS33, ORA_NLS10) Environment
                    Variables explained.

0 0
原创粉丝点击