Tom's Guide | Tom's Hardware | Tom's Games
![]() |
![]() |
![]() |
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 setI don't know, why this error is coming. All kernal parameters and oracle profile parameters are also set.
Any help would be appreciated.
Thanks

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/dataBourne 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.

![]() |
![]() |
![]() |

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