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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database Link Problem

RE: Database Link Problem

From: Daemen, Remco <R.Daemen_at_facent.nl>
Date: Wed, 11 Oct 2000 09:58:23 +0200
Message-Id: <10646.118938@fatcity.com>


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
Received on Wed Oct 11 2000 - 02:58:23 CDT

Original text of this message

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