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@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.