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

"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 :-) Received on Thu Dec 11 2003 - 07:09:45 CST