RE: Database Link Problem

From: Larry Taylor <ltaylor_at_iq.com>
Date: Wed, 11 Oct 2000 08:55:52 -0700
Message-Id: <10646.118980@fatcity.com>

Thanks a whole bunch,

-lt

-----Original Message-----
From: Daemen, Remco [mailto:R.Daemen_at_facent.nl] Sent: Wednesday, October 11, 2000 2:06 AM To: Multiple recipients of list ORACLE-L Subject: RE: Database Link Problem

Have you checked the port numbers and ORACLE_SID's the listener is listening for are the same as in the definition of your tnsnames.ora ?

Example tnsnames entry:

CODATST =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = panter)(Port = 1521))
    )
    (CONNECT_DATA =
(SID = CODATST)

    )
  )

Example matching entry in listener.ora:

LISTENER =
(ADDRESS_LIST =

        (ADDRESS=
          (PROTOCOL= IPC)
          (KEY= TEST)
        )
        (ADDRESS=
          (PROTOCOL= TCP)
          (Host = panter)
          (Port= 1521)                             ----- PORT NUMBER MUST
MATCH !!
        )

)

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = CODATST)
(ORACLE_HOME=/oracle/product/7.3.4)
    )
  )

HTH, Remco

> ----------
> From: 	Larry Taylor[SMTP:ltaylor_at_iq.com]
> Sent: 	woensdag 11 oktober 2000 4:15
> To: 	Multiple recipients of list ORACLE-L
> Subject: 	Database Link Problem
> 
> I've been running a few tests and I've come up with some more information
> (no solution yet, but perhaps this will help someone identify this as a
> problem they once had).
> I can execute tnsping from each of the UNIX servers and it will find the
> NT
> server. However, when I try to execute tnsping from the NT server to
> either
> of our UNIX servers, I get an error, TNS-12541 no listener.
> Now, I'm not so sure what this mesage really means. I was sure that I have
> a
> listener running on each of the machines. After all, I can run Oracle's
> Enterprise manager from any desktop or server and connect to any of the
> servers using the entry found in tnsnames.ora. I don't see how I could
> connect to the database on the NT server unless there was a listener up
> and
> running. Maybe the TNS-12541 covers more than just a 'missing listener'.
> Anyway, I hope this sounds familar to someone and that they have an
> answer.
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Larry  Taylor
>   INET: ltaylor_at_iq.com
> 
> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California        -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Daemen, Remco
  INET: R.Daemen_at_facent.nl

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may

Received on Wed Oct 11 2000 - 10:55:52 CDT