Hello Jack,
The problem is that the NLS environment does not get reset when using oraenv.
It resets ORACLE_HOME and ORACLE_SID, but ORA_NLS33 always has the values of the first instance.
I had a look at the oraenv script, and there is no "NLS" string in there...
So when you try to switch to the second instance and start it, you get th error message that "missing or wrong value for NLS variable".
Any idea?
Thanks,
Helmut
> -----Ursprüngliche Nachricht-----
> Von: Jack van Zanen [mailto:[EMAIL PROTECTED]]
> Gesendet: Montag, 22. September 2003 12:20
> An: Multiple recipients of list ORACLE-L
> Betreff: RE: two instances on same box (Suse Linux ES 8)
>
>
> What are the error messages??
>
> Should be able to run w/o problems
>
>
>
> Jack
>
>
> -----Original Message-----
> Sent: Monday, September 22, 2003 11:55 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi!
> We are running 2 Oracle instances on one Suse Linux box
> (under the same Unix oracle user).
> We have two oracle homes
> 9.0.1 (/opt/oracle/iasdb)
> and
> 9.2.0 (/opt/oracle/loga)
> The first instance starts up fine, but the second one fails.
> It seems to me that switching the environments fails.
> How do I switch between environments? ORAENV and dbhome don't
> work too well.
>
> oratab looks fine.
> Does anybody have experience with multiple instance on Linux
> (especially Suse). not sure whether Red Hat is similar...
> This is 9i on Suse Linux Enterprise Server 8.
> Thanks,
> Helmut
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jack van Zanen
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
> and in the message BODY, include a line containing: UNSUB
> ORACLE-L (or the name of mailing list you want to be removed
> from). You may also send the HELP command for other
> information (like subscribing).
>
