Dave wrote:
> "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
>
>
And I would add: do *not* provide a default; sooner or later
it will bite you, thinking you connect to devtest, while in
reality you are not...
--
Regards,
Frank van Bortel
Received on Sat Jul 23 2005 - 05:29:03 CDT
