yes, by starting the 9.01 instance first, then editing
/etc/profile.d/oracle.sh file and then start the second instance from a
second terminal window. Not very elegant, but it worked...
> -----Ursprüngliche Nachricht-----
> Von: Jack van Zanen [mailto:JACK_at_QUANTSYSTEMS.NL]
> Gesendet: Montag, 22. September 2003 13:20
> An: Multiple recipients of list ORACLE-L
> Betreff: RE: two instances on same box (Suse Linux ES 8)
>
>
> Have you ever succeded in starting the 9.2.0 database?
>
>
> jack
>
> -----Original Message-----
> Sent: Monday, September 22, 2003 12:40 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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:JACK_at_QUANTSYSTEMS.NL]
> > 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: JACK_at_QUANTSYSTEMS.NL
> >
> > 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: ListGuru_at_fatcity.com (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).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jack van Zanen
> INET: JACK_at_QUANTSYSTEMS.NL
>
> 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: ListGuru_at_fatcity.com (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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daiminger, Helmut
INET: Helmut.Daiminger_at_KirchGruppe.de
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: ListGuru_at_fatcity.com (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).
Received on Mon Sep 22 2003 - 07:04:55 CDT
