Re: login to oracle without specifying SID

From: NCR Employee <ncr.employee_at_ncr.com>
Date: Tue, 30 Oct 2001 15:40:04 -0000
Message-ID: <3bdec9eb@rpc1284.daytonoh.ncr.com>

Set the environment variable ORACLE_SID to the desired SID and export it.

eg ORACLE_SID=ORCL;export ORACLE_SID

"SN" <throne7_at_my-deja.com> wrote in message news:c2ec2c5b.0110251001.6411ad23_at_posting.google.com...
> What would I have to set to my Unix environment so that I don't have
> to type in the SID field everytime I log onto oracle. What i mean is:
>
> Instead of this
> Enter user-name: myaccount_at_SomeSID
> Enter password: mypassword
>
>
> I want this
>
> Enter user-name: myaccount
> Enter password: mypassword
Received on Tue Oct 30 2001 - 09:40:04 CST