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

jeffyee_at_hotmail.com (Jeffrey Yee) wrote in 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

Actually you don't even WANT to MISUSE root to connect on a routine basis.
You don't NEED direct access to Oracle as root, nor SHOULD you have it at all, as you can easily run any oracle related tasks by using su -c oracle.
Other than that read up on OS authentication in your documentation.

Sybrand Bakker
Senior Oracle DBA Received on Thu Dec 11 2003 - 08:45:20 CST