Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Can't connect to database using 'sqlplus <username>/<password>', even when ORACLE_SID is set.
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
Received on Thu Dec 11 2003 - 05:42:24 CST