Re: win2k: odbc to oracle-db

From: Alexander Haid <alexander.haid_at_leonhardlang.at>
Date: Thu, 15 Jul 2004 16:40:12 +0200
Message-ID: <pk3df0dfbf88c9lbq1u33ci50lla10s59u@4ax.com>

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)

)
)

Received on Thu Jul 15 2004 - 09:40:12 CDT