Oracle Instance Hassles

[neohippy]

Hi all. tis the first time im installing an oracle server with more than 2 instances. I was wondering if anyone knew about any trouble i could run into... I have already created 2 Instances (this is Oracle 8.1.7 64 bit on Solaris 8 SPARC 64 bit) with some scripts but upon following the same procedure with the third instance to be created i get greeted with an

SVRMGR> connect internal
Connected.
SVRMGR> startup nomount
ORA-03113: end-of-file on communication channel
SVRMGR>

This is normally a Net8/Listener error. Is there some kind of limit of Instances per Listeners or something, this is a 2x900Mhz UltraSPARC 3 with 64 bit everything and 4 GB of SUN RAM, there are no performance issues (cpu around 99.5 percent idle most of the time, no %iowait, load averages of 0.04 etc etc) hes not busy basically so i cant see how it can be a resource issue, plenty of free RAM and everything else. Both of the other instances are totally usable, but i need to have 5 up.

Any help or ideas would be most helpful

 

[alexhu]

i've jumped from 8.0 to 9.0 so I may be wrong here, but should you not get 'connected to an idle instance' when you connect internal ? If so then you have a problem with your init.ora file or your ORACLE_SID setting.

Alex

 

[millerc2]

First question is, have you properly set up your Oracle environment? This error is seen lots when the ORA_NLS33, LD_LIBRARY_PATH, or LIBPATH is not set correctly. Are you using the oraenv file? If so, you should have all the instances and their oracle homes listed in the /etc/oratab file. Here is my settings for these variables:

ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib
LIBPATH=$ORACLE_HOME/lib

 

[neohippy]

Thanks for the help. Im at home now i think that the env may be set wrong although it did work wit hthe others.... Then again i have been making some changes so ill check that.

Tx a lot.