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 HS to Postgres

GULAug 5 2008 — edited Sep 15 2008
Hi all,

I'm trying to connect from Oracle 11g to PostgresSQL database using hs and db-link.
When I execute queries (select * from temp@postgres) I get error "FATAL: password authentication failed for user "user"[Microsoft][ODBC Driver Manager] Invalid connection string attribute".
I'm absolutely sure that user and password are right and I notice that Postgres database receive and empty password.

Also tnsping works.

This is my configuration:

Oracle 11g on Windows 2003 Server;

initPostgres.ora:

HS_FDS_CONNECT_INFO = postgres
HS_FDS_TRACE_LEVEL = 4

---------------------------------------

listener.ora

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = server-oracle)(PORT = 1521))
)
)

SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=postgres)
(ORACLE_HOME=D:\app\Administrator\product\11.1.0\db_1)
(PROGRAM=dg4odbc)
)
)

--------------------------------------

tnsnames.ora

# Connection to Postgres DSN
postgres =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
(CONNECT_DATA=(SID=postgres))
(HS=OK)
)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 13 2008
Added on Aug 5 2008
20 comments
7,838 views