Create Database Links from Autonomous Database to a Publicly Accessible Autonomous Database
You can create database links from an Autonomous Database to a target Autonomous Database that is on a public endpoint.
See How to Create a Database Link from Your Autonomous Database to a Database Cloud Service Instance for more information.
- Create Database Links from Autonomous Database to a Publicly Accessible Autonomous Database without a Wallet (TLS)
You can create database links from an Autonomous Database to a publicly accessible Autonomous Database without a wallet (TLS). - Create Database Links from Autonomous Database to a Publicly Accessible Autonomous Database with a Wallet (mTLS)
You can to create database links from an Autonomous Database to a publicly accessible Autonomous Database with a wallet (mTLS).
Create Database Links from Autonomous Database to a Publicly Accessible Autonomous Database without a Wallet (TLS)
You can create database links from an Autonomous Database to a publicly accessible Autonomous Database without a wallet (TLS).
To create database links to a public target, the target database must be accessible. Some databases, including Autonomous Databases, may limit access (for example, using Access Control Lists). Make sure you enable your target database to allow access from your source database for the database link to work. If you limit access with Access Control Lists (ACLs), you can find the outbound IP address of your source Autonomous Database and allow that IP address to connect to your target database. When the target database is another Autonomous Database, you can add the outbound IP address of the source database to the ACL of the target database.
See Obtain Tenancy Details for information on finding the outbound IP address.
To create a database link to a target Autonomous Database without a wallet (TLS):
For the credentials you create in Step 1, the target database 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.
You can create links to Big Data Service using
DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK
. See Query Big Data Service Hadoop (HDFS) Data from Autonomous Database for more information.
For additional information, see:
Create Database Links from Autonomous Database to a Publicly Accessible Autonomous Database with a Wallet (mTLS)
You can to create database links from an Autonomous Database to a publicly accessible Autonomous Database with a wallet (mTLS).
To create database links to a public target, the target database must be accessible. Some databases, including Autonomous Databases, may limit access (for example, using Access Control Lists). Make sure you enable your target database to allow access from your source database for the database link to work. If you limit access with Access Control Lists (ACLs), you can find the outbound IP address of your source Autonomous Database and allow that IP address to connect to your target database. For example, if the target database is another Autonomous Database, you can add the outbound IP address of the source database to the ACL of the target database.
See Obtain Tenancy Details for information on finding the outbound IP address.
To create database links to a target Autonomous Database with a wallet (mTLS):
For the credentials you create in Step 5, the target database 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.
You can create links to Big Data Service using
DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK
. See Query Big Data Service Hadoop (HDFS) Data from Autonomous Database for more information.
For additional information, see: