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