Re: Can't connect to database using 'sqlplus <username>/<password>', even when ORACLE_SID is set.

On Thu, 11 Dec 2003 14:09:45 +0100, "Choco" <choco_at_nospam.freeler.nl> wrote:

>"Jeffrey Yee" <jeffyee_at_hotmail.com> wrote
>> Hi,
>>
>> As oracle user, I can use 'sqlplus <username>/<password>' to log in to
>> a database, when ORACLE_SID is set. But when I'm login as root, and
>> then set the ORACLE_SID, but 'sqlplus <username>/<password>' will give
>> me the following error:
>> ERROR:
>> ORA-01034: ORACLE not available
>>
>> I tried 'sqlplus <username>/<password>@BSCS_RTX' and I can connect.
>> I'm absolutely confuse on why I must use the alias to connect to the
>> database. The database version that I'm running on is 8.1.6.3
>>
>
>You need to start your database before you are able to connect to the
>database
>
>Try google and you will find the solutions :-)
>

If he can connect with 'sqlplus <username>/<password>@BSCS_RTX' then it's not an issue of the database not being started.

I've seen similar, but not exactly the same, problem if I didn't 'export ORACLE_SID'. Received on Thu Dec 11 2003 - 07:48:10 CST