Re: win2k: odbc to oracle-db

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Thu, 15 Jul 2004 09:45:42 -0500
Message-ID: <hr5df0d1oauffpo0622moinb7v6picm617@4ax.com>

Alexander Haid <alexander.haid_at_leonhardlang.at> wrote:

>Thanks a lot for your replies. I'm an absolute beginner with oracle.
>Well, acutally I need to prgram an agent under lotus domino that
>fetches data from our ERP using an oracle db. Never done anything with
>it before.
>So I took your advice to heart :-) dug deep into the docs and am some
>steps further...
>
>I found out how the listener on the server is configured in
>LISTENER.ORA. Then I created an TNSNAMES.ORA locally on my win2k box
>with the Oracle Net Manager. The testing function was successful.
>I also tried to connect with the SQL*PLUS. That worked too.
>
>Then I created a DSN via the win ODBC-Manager. When I use the
>test-dialog it dies with the error 12514: "TNS:Listener does not
>currently know of service requested in connect descriptor"
>
>I will attach the contents of:
>- listener.ora (on server)
>- output of lsnrctl status
>- tnsnames.ora (on local PC)
>
>tnx, alex
>
>----------------------------------------------------------------------------------------------------------------------------------------------------
>LISTENER.ORA
>----------------------------------------------------------------------------------------------------------------------------------------------------
># Generated by Oracle configuration tools.
>
>LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST =
>semiramis.leonhardlang.at)(PORT = 1521))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> )
> )
>
>SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /opt/oracle/product/9ir2)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = orcl.semiramis.leonhardlang.at)
> (ORACLE_HOME = /opt/oracle/product/9ir2)
> (SID_NAME = orcl)
> )
> )
>----------------------------------------------------------------------------------------
>----------------------------------------------------------------------------------------
>
>----------------------------------------------------------------------------------------------------------------------------------------------------
>output of LSNRCTL status:
>----------------------------------------------------------------------------------------------------------------------------------------------------
>Verbindung mit
>(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=semiramis.leonhardlang.at)(PORT=1521)))
>wird aufgebaut
>STATUS des LISTENER
>------------------------
>Alias LISTENER
>Version TNSLSNR for Linux: Version 9.2.0.1.0 -
>Production
>Startdatum 14-JAN-2004 16:32:52
>Uptime 182 Tage 22 Std. 46 Min. 1 Sek.
>Trace-Ebene off
>Sicherheit OFF
>SNMP OFF
>
>Parameterdatei des Listener
>/opt/oracle/product/9ir2/network/admin/listener.ora
>
>Log-Datei des Listener
>/opt/oracle/product/9ir2/network/log/listener.log
>
>Zusammenfassung Listening-Endpunkte...
>
>(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=semiramis.leonhardlang.at)(PORT=1521)))
> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
>
>Services uebersicht...
>Dienst "PLSExtProc" hat 1 Instanz(en).
> Instanz "PLSExtProc", Status UNKNOWN, hat 1 Handler for diesen
>Dienst...
>
>Dienst "orcl.semiramis.leonhardlang.at" hat 2 Instanz(en).
> Instanz "orcl", Status UNKNOWN, hat 1 Handler for diesen Dienst...
> Instanz "orcl", Status READY, hat 1 Handler for diesen Dienst...
>----------------------------------------------------------------------------------------
>----------------------------------------------------------------------------------------
>
>
>----------------------------------------------------------------------------------------------------------------------------------------------------
>TNSNAMES.ORA
>----------------------------------------------------------------------------------------------------------------------------------------------------
># tnsnames.ora Network Configuration File:
>C:\Oracle\product\10.1.0\Client_1\NETWORK\ADMIN\tnsnames.ora
># Generated by Oracle configuration tools.
>
>SEMIRAMIS.LEONHARDLANG.AT =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)
> (HOST = semiramis.leonhardlang.at)
> (PORT = 1521))
> )
> (CONNECT_DATA =
> (SID = orcl)
> (GLOBAL_NAME = orcl.semiramis.leonhardlang.at)
> )
> )
>----------------------------------------------------------------------------------------
>----------------------------------------------------------------------------------------
>
>

When asked, what did you put in the DSN's service name entry?

Here's more info on that error message:

---

TNS-12514: TNS:listener does not currently know of service requested in connect descriptor Cause: The listener received a request to establish a connection to a database or other service. The connect descriptor received by the listener specified a service name for a service (usually a database service) that either has not yet dynamically registered with the listener or has not been statically configured for the listener. This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener. Action:
- Wait a moment and try to connect a second time.

• Check which services are currently known by the listener by executing: lsnrctl services <listener name>
• Check that the SERVICE_NAME parameter in the connect descriptor of the net service name used specifies a service known by the listener.
• If an easy connect naming connect identifier was used, check that the service name specified is a service known by the listener.
• Check for an event in the listener.log file.

  ---

Received on Thu Jul 15 2004 - 09:45:42 CDT