Create Database Links with Customer-Managed Heterogeneous Connectivity to Publicly Accessible Non-Oracle Databases
Use DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK
to
create database links from an Autonomous Database
instance on a public endpoint to an Oracle Database Gateway to access Non-Oracle
databases.
To use database links from an Autonomous Database instance on a public endpoint, the target gateway must be configured to use TCP/IP with SSL (TCPS) authentication. See Configuring Secure Sockets Layer Authentication for more information.
To create database links from an Autonomous Database instance on a public endpoint to a target gateway, do the following:
For the credentials you create in Step 5, the Oracle Database Gateway credentials, if the password of the target user changes you can update the credential that contains the target user's credentials as follows:
BEGIN
DBMS_CLOUD.UPDATE_CREDENTIAL
(
credential_name => 'DB_LINK_CRED',
attribute => 'PASSWORD',
value => 'password');
END;
/
Where password is the new password.
After this operation, the existing database links that use this credential continue to work without having to drop and recreate the database links.
See the following for an example that shows you how to create a database link to an Oracle Database Gateway to access a Microsoft SQL Server database:
How to Access Non-Oracle Databases from Autonomous Database using Oracle Database Gateway
For additional information, see: