Re: SIDs and connectivity

From: Dave <x_at_x.com>
Date: Sat, 23 Jul 2005 09:54:34 GMT
Message-ID: <utoEe.75568$G8.54442@text.news.blueyonder.co.uk>

"Dale" <dschmitz4_at_cox.net> wrote in message news:kknEe.120163$yV4.16791_at_okepread03...
> Ok, let me nail it down a bit more. In an effort to make all things
> equal, and eliminate as many variables as possible, I've set up a system
> with a production database ("prod") and cloned that database ("devtest")
> on a Unix system. Assuming I'm logged on to the Unix system directly,
> what are my best methods for logging into the prod or the devtest
> instance?
> "Dale" <dschmitz4_at_cox.net> wrote in message
> news:anfEe.120145$yV4.5321_at_okepread03...
>> At the risk of being incomplete, what, other than the ORACLE_SID
>> determines what instance a user connects to?
>>
>
>

either setting ORACLE_SID environment variable

or using a tns connect string e.g sqlplus scott/tiger_at_prod Received on Sat Jul 23 2005 - 04:54:34 CDT