Re: Can't connect to database using 'sqlplus <username>/<password>', even when ORACLE

Home -> Community -> Usenet -> c.d.o.server -> Re: Can't connect to database using 'sqlplus <username>/<password>', even when ORACLE_SID is set.

From: Alkos <azerty_at_nospam.org>
Date: Thu, 11 Dec 2003 14:10:07 +0100
Message-ID: <br9qbj$6592@news.rd.francetelecom.fr>

"Jeffrey Yee" <jeffyee_at_hotmail.com> a écrit dans le message news: ec4cec95.0312110342.855c34a_at_posting.google.com...
> 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
>
> Please please help. Thank you very much in advance.
>
> Best Regards,
> Jeffrey Yee

ORACLE_HOME not set when logged as root. You forgot to mention the OS and OS version.

--
Alkos

Received on Thu Dec 11 2003 - 07:10:07 CST