How I do from PostgreSQL to Oracle Db Link

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(at)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.