My Oracle Support Banner

Create and Configure Database Link in Autonomous Database (Doc ID 2592265.1)

Last updated on JUNE 29, 2020

Applies to:

Autonomous Database on Shared Infrastructure - Version N/A to N/A
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.