Database Administration (MOSC)

MOSC Banner

Database link in windows server x64 to postgres database.

edited Jul 17, 2020 5:00AM in Database Administration (MOSC) 3 commentsAnswered

Hello,

I created a database link from oracle database to postgress, but when I run a select, I receive the error:

                         *

ERROR at line 1:

ORA-28511: lost RPC connection to heterogeneous remote agent using

SID=ORA-28511: lost RPC connection to heterogeneous remote agent using

SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=desa440)(PORT=1521))(CONNECT_DATA=

(SID=pg_link)))

ORA-02063: preceding line from POSTGRES_LNK

Process ID: 6396

Session ID: 9 Serial number: 41

The Database Server is 11.2.0.4.0 in windows x64.

The PostgreSQL is 11.8.

I did the folowing steps:

- Install odbc driver for postgres psqlodbc_12_02_0000-x64.

- Configure system dns on odbc 64 bits: PG_LINK, and tested it.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center