Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORACLE to POSTGRES db link not working

user13573211Sep 25 2013 — edited Oct 10 2013

cat /home/oracle/temp/psqlodbc-09.02.0100/test/odbc.ini

[postgresql]

Description             = psqlodbc regression test DSN

Driver                          = /home/oracle/temp/psqlodbc-09.02.0100/.libs/psqlodbcw.so

Trace                       = Yes

TraceFile               = /home/oracle/tmp/sql.log

Database                = postgresdb

Servername              = postgresdev.office.corp

Username                = postgres

Password                = ***********

Port                        = 5432

Protocol                = 6.4

ReadOnly                = No

RowVersioning           = No

ShowSystemTable         = No

ShowOidColumn           = No

FakeOidIndex            = No

ConnSettings            =

cat /home/oracle/temp/psqlodbc-09.02.0100/test/odbcinst.ini

[psqlodbc]

Description     = PostgreSQL ODBC driver (Unicode version), for regression tests

Driver          = ../.libs/psqlodbcw.so

Debug           = 0

CommLog         = 1

cat /oracle/database/11.2.0.3/hs/admin/initdg4odbc.ora

# This is a sample agent init file that contains the HS parameters that are

# needed for the Database Gateway for ODBC

#

# HS init parameters

#

HS_FDS_CONNECT_INFO =postgresql

HS_FDS_TRACE_LEVEL =off

HS_FDS_SHAREABLE_NAME = /usr/lib/libodbc.so

#

# ODBC specific environment variables

#

set ODBCINI=/home/oracle/temp/psqlodbc-09.02.0100/test/odbc.ini

set odbcinst=/home/oracle/temp/psqlodbc-09.02.0100/test/odbcinst.ini

cat /oracle/database/11.2.0.3/network/admin/listener.ora

LISTENER_POSTGRES =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = scfsdb.office.corp)(PORT = 1524))

    )

  )

SID_LIST_LISTENER_POSTGRES =

(SID_LIST =

(SID_DESC =

(SID_NAME = postgresql)

(ORACLE_HOME = /oracle/database/11.2.0.3)

(PROGRAM = hsodbc)

(ENVS = "LD_LIBRARY_PATH=/oracle/database/11.2.0.3/lib:/oracle/database/11.2.0.3/hs/lib:/usr/lib")

)

(SID_DESC =

(SID_NAME = postgresql)

(ORACLE_HOME = /oracle/database/11.2.0.3)

(PROGRAM = hsodbc)

)

)

#ADR_BASE_LISTENER_POSTGRES = /oracle/database

LOGGING_LISTENER_POSTGRES = OFF

cat /oracle/database/11.2.0.3/network/admin/tnsnames.ora

postgresql =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xx.x.xx)(PORT = 1524))

(CONNECT_DATA =

(SID = postgresql)

)(HS = OK)

)

This is not working, could you please let me know, where I should make the change. Thank you so much for all your help in Advance..!!! Guru's, please respond on this.

This post has been answered by Kgronau-Oracle on Oct 7 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2013
Added on Sep 25 2013
40 comments
23,203 views