Re: Multiple instances with NT

From: Alex <alex.hudghton_at_capgemini.co.uk>
Date: Fri, 2 Jul 1999 14:49:27 +0100
Message-ID: <7lig1f$2pf$1@taliesin.netcom.net.uk>

Tony

To create the second instance you use 'oradim(?)' I think. I no longer have access to an NT server and am therefore a little unsure of the
process. You can connect to the database from the DOS prompt by: SET ORACLE_SID=SID
svrmgr80
etc, etc

Alex

Tony Adolph wrote in message <7lidv2$b7d$1_at_nnrp1.deja.com>...
>That worked a treat, thanks Alex. My oracle db is now renamed and I
>now need to create the second instance, but how do I connect to it. In
>Unix I would set ORACLE_SID and ORACLE_HOME and connect internal, but
>there are no environment vars regarding Oracle at on the box. I've not
>been very descriptive of the problem here, but I think you know what I
>mean ?!... And how does oracle know which SID to connect to if there
>are two instance running (without listener and tnsnames.ora)?
>
>Thanks again Alex,
>
>Regards
>Tony
>
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Fri Jul 02 1999 - 08:49:27 CDT