Re: sqlplus connection from unix with and without the oracle sid

From: nilesh kumar <>
Date: Fri, 16 May 2008 20:33:42 +0530
Message-ID: <>

Hello Ricks,

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 <> 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
> 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?

Temples & Softwares are more or less the same, first we build them and then
we pray ;)

Received on Fri May 16 2008 - 10:03:42 CDT

Original text of this message