Problem Description:
====================
You are trying to start your instance via SQLPLUS or Server Manager when you encounter the
following error:
SQL> connect / as SYSDBA
or
SVRMGR> connect internal
SQL/SVRMGR> startup
You have confirmed that your ORACLE_HOME and ORACLE_SID are set correctly for
this instance.
No changes have been made to the database prior to shutdown.,
Solution Description:
=====================
In the Installation Guide for your Operating System and database version, it
mentions that when specifying a character set other than US7ASCII you will need
to set one of the following ORA_NLS parameters at the operating system level:
Only one of these parameters should be set at any time.
On Unix the parameter should be set in the environment and should
point to your $ORACLE_HOME/ocommon/nls/admin/data directory (pre 10g)
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 please read:
Note 77442.1 ORA_NLS (ORA_NLS32, ORA_NLS33, ORA_NLS10) Environment Variables explained.
8.0/8i, 9i Unix Example:
------------------------
=====================
Use the correct setting for the environment variable ORA_NLS33.
Per your platform specific Oracle Installation and Configuration Guide, 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 following syntax:
C-shell:
Bourne or Korn shell:
Restart your SQLPLUS or Server Manager session and restart the database.
Check the files under ORACLE_HOME/ocommon/nls/admin/data directory.
1.
2.
of files in a previous backup or another database.
3.
Explanation:
============
Not finding the proper location for the NLS files, or some of the *.nlb files
in the ORACLE_HOME/ocommon/nls/admin/data directory are either missing or
corrupt.
REFERENCE
=========
Note 1058400.6
Note 275107.1
Note 77442.1