Quick Intro: How to use Database Links with Oracle Autonomous Dedicated?

 Quick Into: How to use Database Links with Oracle Autonomous Dedicated.

There is a very good blog post by Jeffrey Cowen Senior Principal Product Manager at Oracle on How to use Database Links with Oracle Autonomous Dedicated.

Here is a quick recap.

• Only TCP connections are currently supported.
• Easy Connect syntax or the complete descriptor must be used.
• There is no access to the local tnsnames.ora file for editing.
• Create the DB Link and test it.
• OCI Egress Rules on the Autonomous Dedicated Infrastructure subnet must be open on port 1521 using Network Security Group (NSG) or a security list.
• If connecting your On-Prem to Autonomous you will need to make sure the scan or hostname used is resolvable by your source server through DNS lookup or a host file. 
• If connecting over VPN or FastConnect you must ensure that the On-Prem firewall is not blocking or timing out 1521 traffic for long queries.
• GLOBAL_NAMES is set to TRUE in OCI database services which requires the database link and the database to have the same name. This parameter is modifiable if needed. 
• If connecting to a public IP Address, the Autonomous Dedicated Infrastructure subnet will need proper route rules and network features enabled in the VCN such as a NAT Gateway if using a private subnet (recommended).

Enjoy this blog post on How to use Database Links with Oracle Autonomous Dedicated.

Cheers.