Re: sqlplus connection from unix with and without the oracle sid
Date: Fri, 16 May 2008 20:33:42 +0530
Actually there are many database running on the unix server you are logging in. to see how many databses are running in your unix server issue "ps -ef |grep lgwr" . Now suppose you want to login to a database for ex:- 'xxxx' and you have username and password for the database you are logging in.
1. After you login to your unix machine. 2. . oraenv
here you need to enter the database you want to login to say xxxx 3. sqlplus username/password
4. You are done and you have logged in xxxx database as your username or passsword.
Note:- If there is only one database running on your machine then some times it takes by default.
Hope this helps.....
On Fri, May 16, 2008 at 7:09 PM, Rick Ricky <ricks12345_at_gmail.com> wrote:
> I have my ORACLE_SID set in my .bash_profile. I echo it and its there. I
> have until yesterday afternoon been able to log in without having to enter
> my ORACLE_SID
> so I do
> login: username/password
> now oracle needs my oracle sid. I think my sysadmin changed something. I do
> not know what it is.
> when do you need to enter a SID when you log into oracle from a unix/linux
> shell and when don't you?
-- Soni Temples & Softwares are more or less the same, first we build them and then we pray ;) -- http://www.freelists.org/webpage/oracle-lReceived on Fri May 16 2008 - 10:03:42 CDT