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: Error: Could not resolve SID... Oracle 8.1.7

Re: Error: Could not resolve SID... Oracle 8.1.7

From: <sybrandb_at_my-deja.com>
Date: Tue, 02 Jan 2001 05:48:51 GMT
Message-ID: <92rq43$7mp$1@nnrp1.deja.com>

In article <3a514eae.24378784_at_news.pacbell.net>,   rugga_at_pacbell.net (Chuck ) wrote:
>
> I am having a very annoying problem and I have seen it come and go on
> Linux, but never on Solaris.
>
> I have a version of 8.1.7 (although this problem exists on 8.1.6)
> running on SuSE 7.0. I had this working fine but needed to scratch the
> box and rebuild.
>
> Here is my tnsnames.ora file: (Sorry so long, but I recreated this
> file making sure there were no hidden characters or other errors, as I
> have gotten corrupted files in the past copying accross different
> machines)
>
> # BEGIN
> EXTPROC_CONNECTION_DATA.RHUGGA.ORG =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
> OPS1 =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = TCP)
> (HOST = canthus)
> (PORT = 1521)
> )
> )
> (CONNECT_DATA =
> (SID = OPS1)
> )
> )
> # END tnsnames.ora
>
> Here is my listener.ora file:
> #BEGIN
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = IPC)
> (KEY = EXTPROC)
> )
> )
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = TCP)
> (HOST = canthus)
> (PORT = 1521)
> )
> )
> )
> (DESCRIPTION =
> (PROTOCOL_STACK =
> (PRESENTTION = GIOP)
> (SESSION = RAW)
> )
> (ADDRESS =
> (PROTOCOL = TCP)
> (HOST = canthus)
> (PORT = 2481)
> )
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /u01/app/oracle/product/8.1.7)
> (PROGRAM = extproc)
> )
> )
> #END
>
> Now, if I try "sqlplus scott_at_OPS1" and then enter the password I get
> the following:
>
> Enter password:
> ERROR:
> ORA-12541: TNS:no listener
>
> If I try "sqlplus scott_at_OPS1." (with a period)and then enter the
> password I get the following:
>
> Enter password:
> ERROR:
> ORA-12505: TNS:listener could not resolve SID given in connect
> descriptor
>
> HOWEVER, if I execute "tnsping OPS1." I get the following:
> canthus:~ # tnsping OPS1.
>
> TNS Ping Utility for Linux: Version 8.1.7.0.0 - Production on
> 01-JAN-2001 19:39:44
>
> (c) Copyright 1997 Oracle Corporation. All rights reserved.
>
> Attempting to contact
> (ADDRESS=(PROTOCOL=TCP)(HOST=canthus)(PORT=1521))
> OK (10 msec)
>
> NOW, I have tried using "localhost", "canthus", and
> "canthus.rhugga.org" in the listener.ora and tnsnames.ora file. Before
> it worked as localhost.
>
> And YES, the listener is running:
>
> # ps -ef
> oracle 2687 1 0 19:27 ? 00:00:00 ora_pmon_OPS1
> oracle 2689 1 0 19:27 ? 00:00:00 ora_dbw0_OPS1
> oracle 2691 1 0 19:27 ? 00:00:00 ora_lgwr_OPS1
> oracle 2693 1 0 19:27 ? 00:00:00 ora_ckpt_OPS1
> oracle 2695 1 0 19:27 ? 00:00:00 ora_smon_OPS1
> oracle 2697 1 0 19:27 ? 00:00:00 ora_reco_OPS1
> oracle 2754 1 0 19:31 ? 00:00:00
> /u01/app/oracle/product/8.1.7/bin/tnslsnr LISTENER -inherit
>
> Here is the output of "lsnrctl status":
> canthus:~ # lsnrctl status
>
> LSNRCTL for Linux: Version 8.1.7.0.0 - Production on 01-JAN-2001
> 19:45:30
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
> STATUS of the LISTENER
> ------------------------
> Alias LISTENER
> Version TNSLSNR for Linux: Version 8.1.7.0.0 -
> Production
> Start Date 01-JAN-2001 19:31:22
> Uptime 0 days 0 hr. 14 min. 8 sec
> Trace Level off
> Security OFF
> SNMP OFF
> Listener Parameter File
> /u01/app/oracle/product/8.1.7/network/admin/listener.ora
> Listener Log File
> /u01/app/oracle/product/8.1.7/network/log/listener.log
> Services Summary...
> PLSExtProc has 1 service handler(s)
> The command completed successfully
>
> Here are my ORACLE ENV variables:
> canthus:~ # env | grep ORA
> ORACLE_SID=OPS1
> ORACLE_HOME=/u01/app/oracle/product/8.1.7
> ORACLE_TERM=vt100
>
> I also add $ORACLE_HOME/lib to LD_LIBRARY_PATH
>
> I can usually screw around and get this working but the time has come
> to dig deeply into the irritating problem and find a 100% difintive
> cause and solution. (Of course I am assuming I have not made a
> seemingly bonehead mistake) I am no Sr. level DBA or anything but
> sheesh, this should be simple.
>
> I would greatly appreciate some insight into this.
>
> Thanks,
> Chuck
>
>

Your problem is the SID OPS1 does NOT occur in the sid_list_listener block. Hence you have no service for TCP/IP set up and connecting using TCP/IP will fail, as fallback from TCP to IPC has been disabled in 8i.

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com
http://www.deja.com/
Received on Mon Jan 01 2001 - 23:48:51 CST

Original text of this message

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