Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

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

From: Jeffrey Yee <jeffyee_at_hotmail.com>
Date: 11 Dec 2003 03:42:24 -0800
Message-ID: <ec4cec95.0312110342.855c34a@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
Received on Thu Dec 11 2003 - 05:42:24 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US