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 -> Re: sqlplus ORA-12547 TNS: Lost contact TNS: 00517

Re: sqlplus ORA-12547 TNS: Lost contact TNS: 00517

From: SW <flyhorse_127_at_hotmail.com>
Date: 26 Nov 2004 01:01:20 -0800
Message-ID: <1101457200.615377.226000@f14g2000cwb.googlegroups.com> 





    
  
  1.   I don't think it's related to the shared memory
  
  2.   Have you tried sqlplus "/ as sysdba" to connect to the DB? If you
run sqlplus natively, it should bypass the listener.
  
  3.   If you want to connect via the listener, make sure below:
3.1 You start the listener properly. Run 'lsnrctl services' to see if
the listener is listening on your DB service or not
3.2 You have an entry in $ORACLE_HOME/network/admin/tnsnames.ora
3.3 You connect using sqlplus user/pass_at_tnsname
  
  4.   Don't use 'sys/change_on_install' to connect. Better use an ordinary
user or '/ as sysdba' if you want to connect as DBA



Received on Fri Nov 26 2004 - 03:01:20 CST












Original text of this message













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