Create and Configure Database Link in Autonomous Database
(Doc ID 2592265.1)
Last updated on FEBRUARY 29, 2024
Applies to:
Autonomous Database Serverless - Version N/A to N/AInformation in this document applies to any platform.
Goal
Create and setup the Database Links from Autonomous Instance.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| Setup the DBLink from Autonomous (Serverless) to DBaaS Classic / On-Prem (Single Instance) |
| a) Enable TCPS Authentication in Target Database |
| b) Setup the Database related Network configuration in Target server |
| c) Setup The Listener in Target Server |
| d) Connect to Target Database from Client via TCPS and Test the Connection |
| e) Create a DB Link from Autonomous Instance to Target Database |
| Setup the DBLink from Autonomous (Serverless) to OCI DBSystem (Grid Infrastructure) |
| a) Enable TCPS Authentication in Target Database |
| b) Setup the Database related Network configuration in Target server |
| c) Setup The Listener in Target Server |
| d) Connect to Target Database from Client via TCPS and Test the Connection |
| e) Create a DB Link from Autonomous Instance to Target Database |
| Setup the DBLink From DBCS to Autonomous Database (Serverless) |
| a) Download the Wallet from ADB Service Console or using API |
| b) Upload the Autonomous Wallet to DBCS instance using sftp or other tool |
| c) Unzip the wallet |
| d) Create DBlink using below command |
| e) Test |
| Setup the DBLink Between Autonomous Database (Serverless) |
| a) Copy your target ADB database wallet file cwallet.sso, containing the certificates for the target database to Object Store |
| b) Create credentials to access your Object Store where you upload the cwallet.sso |
| c) Upload the target database wallet to the data_pump_dir directory, or to another directory where you have write privileges, using DBMS_CLOUD.GET_OBJECT |
| d) On Autonomous Data Warehouse create credentials to access the target database |
| e) Create the database link to the target database using DBMS_CLOUD_ADMIN.CREATE_DATABASE_LINK |
| f) Use the database link you created to access data on the target database |