"Frank van Bortel" <frank.van.bortel_at_gmail.com> wrote in message
news:dbt5pk$t4b$3_at_news3.zwoll1.ov.home.nl...
> 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
oh yeah, all been there
Received on Sat Jul 23 2005 - 05:43:48 CDT
