From: ÃÖÀç¿ø <jwchoi@modernlimes.com>
To: pgsql-admin@postgresql.org
Subject: How I do from PostgreSQL to Oracle Db Link
Date: Sat, 4 Jun 2011 10:05:46 +0900
Message-ID: <000f01cc2253$899cb400$9cd61c00$@com@gabia@pgsql-admin@postgresql.org> (raw)
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.
Attachments:image001.jpg (image/jpeg, 9.1K) downloadview image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: jwchoi@modernlimes.com
Subject: Re: How I do from PostgreSQL to Oracle Db Link
In-Reply-To: <000f01cc2253$899cb400$9cd61c00$@com@gabia@pgsql-admin@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox