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

Create DBLINK from ATP to onprem on port different than 1522

edited Nov 29, 2023 2:49PM in Autonomous Database 7 comments


Hello,

I tried to create a dblink from an ATP instance to a onprem db, and it works fine (mTLS) on port 1522.

However if I try to change the port (eg: 6666) the connection times out with a '12170. 00000 - "TNS:Connect timeout occurred"'

I can't even see any packet reaching the onprem firewall.

Is it supported to create dblink to a port different than 1522 ?

Where can I configure an ACL, if it's possible ?

BEGIN

 DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK(

  db_link_name => 'DBLINK1522',

  hostname => 'nat-to-onprem-db',

  port => '1522',

  service_name => 'dbservice',

  ssl_server_cert_dn => 'CN=testwalletserver',

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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