Computing.Net > Forums > Solaris > problem starting oracle 9i

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

problem starting oracle 9i

Reply to Message Icon

Name: bokhari_jawad
Date: January 22, 2003 at 06:04:22 Pacific
OS: Solaris 9
CPU/Ram: Ultra Spark III
Comment:

Hi,
I have installed oracle 9i Enterprise edition well on Solaris 9.
Listener is started successfully and then dbstart script also starts well.

But when i connect as sysdba and start database, it gives error.
I go like:

$ sqlplus
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 135352820 bytes
Fixed Size 455156 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 679936 bytes
ORA-12709: error while loading create database character set

I don't know, why this error is coming. All kernal parameters and oracle profile parameters are also set.

Any help would be appreciated.

Thanks



Sponsored Link
Ads by Google

Response Number 1
Name: edgard
Date: January 24, 2003 at 11:34:18 Pacific
Reply:

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:
% 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 Server Manager session and restart the database. Check the files under ORACLE_HOME/ocommon/nls/admin/data directory. Verify the ownership/permissions on the files are correct.


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Solaris Forum Home


Sponsored links

Ads by Google


Results for: problem starting oracle 9i

Oracle 9i installation problem www.computing.net/answers/solaris/oracle-9i-installation-problem/3408.html

Install Oracle 9i on Solaris 9 www.computing.net/answers/solaris/install-oracle-9i-on-solaris-9-/2905.html

Oracle 9i run on sun ultra 5? www.computing.net/answers/solaris/oracle-9i-run-on-sun-ultra-5/4114.html