Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Database link between ADW and on-prem Oracle Database

Summary: Database link between ADW and on-prem Oracle Database

How to configure dblink on ADW to on-prem Oracle Database? Networking is ok, path analyzer return view valid networking.
I created with customer:

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=196376577358981&parent=EXTERNAL_SEARCH&sourceId=HOWTO&id=2592265.1&_afrWindowMode=0&_adf.ctrl-state=17tgx6rbzv_4#aref_section21

Sekcja:

 

Setup the DBLink from Autonomous (Serverless) to DBaaS Classic / On-Prem (Single Instance)

Unfortunately i get error:

ORA-12170: TNS:przekroczenie limitu czasu połączenia
12170. 00000 -  "TNS:Connect timeout occurred"

When I used hostname instead IP i get error:
ORA-12545: Nieudane połączenie, gdyż host lub obiekt docelowy nie istnieje

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!