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:01 -0800
Message-ID: <1101457497.685736.287150@z14g2000cwz.googlegroups.com> 





    
  
  1.   I don't think it's related to the SHM things
  
  2.   Have you ever tried sqlplus "/ as sysdba" if you wan to connect as
DBA? If you run sqlplus natively, it should bypass the listener
  
  3.   If you want to test the listener, make sure
3.1 You start the listener properly. Run lsnrctl services to see if
it's listening on your DB service or not
3.2 There is an entry for your DB in
$ORACLE_HOME/network/admin/tnsnames.ora
3.3. sqlplus user/pass_at_tnsname
  
  4.   Better not to use 'sys/change_on_install' to access the DB. Use an
ordinary user or "/ as sysdba" if you wanna connect as SYSDBA



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












Original text of this message













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