Hi, I hope creating that Db Link from PostgreSQL to Oracle. I waw installed unixODBC and ODBC Link. And I test comleted unixODBC of isql. See. ------------------------------------------------------------------------------------------------------------------ [oracle@localhost ~]$ isql oracle +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> ------------------------------------------------------------------------------------------------------------------ But PostgreSQL was not connected oracle. And I wat got this problem.. ------------------------------------------------------------------------------------------------------------------ opennms=# select odbclink.connect('DSN=ORACLE'); ERROR: odbclink: unsuccessful SQLConnect call: [S1000] [12514] [[unixODBC][Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently know of service requested in connect descripto ------------------------------------------------------------------------------------------------------------------ odbc.ini and odbcinst.ini Configuration is that. [odbc.ini] ------------------------------------------------------------------------------------------------------------------ [ORACLE] Decription=Oracle ODBC Driver=OracleDriver Trace=yes TraceFile=/tmp/odbc_oracle.log ServerPost=192.168.10.25:1521 UserID=vsmon Password=dusrnth ------------------------------------------------------------------------------------------------------------------ [odbcinst.ini] ------------------------------------------------------------------------------------------------------------------ [OracleDriver] Description = Oracle ODBC Connection Driver Driver=/opt/instantclient_10_2/libsqora.so.10.1 Debug=0 CommLog=1 ------------------------------------------------------------------------------------------------------------------ Ø Oracle Tns Listener Status LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 04-JUN-2011 10:11:39 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=PNPKEY))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date 03-JUN-2011 16:31:14 Uptime 0 days 17 hr. 40 min. 24 sec Trace Level off Security ON: Local OS Authentication SNMP ON Listener Parameter File /home/oracle/ora10g/network/admin/listener.ora Listener Log File /home/oracle/ora10g/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521))) Services Summary... Service "ORACLE" has 1 instance(s). Instance "ORACLE", status UNKNOWN, has 1 handler(s) for this service... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "SNIOV2" has 1 instance(s). Instance "SNIOV2", status READY, has 1 handler(s) for this service... Service "SNIOV2XDB" has 1 instance(s). Instance "SNIOV2", status READY, has 1 handler(s) for this service... Service "SNIOV2_XPT" has 1 instance(s). Instance "SNIOV2", status READY, has 1 handler(s) for this service... The command completed successfully My Personal Computer connected oracle server. This mean is TNS Listener status is normal. My problem is what?? Please help me. Thanks, Jaewon Choi.
|
