My Oracle Support Banner

Database Link (DB Link) access error ORA-12529 - Autonomous Database (Doc ID 2830593.1)

Last updated on JANUARY 23, 2022

Applies to:

Autonomous Database on Shared Infrastructure - Version N/A and later
Information in this document applies to any platform.

Symptoms

If you have created more than two database link from ON-PREM / OCI to Autonomous Database(Shared) and trying to access the DB link from a single session and failing with ORA-12529 as shown in below example.

The issue is observed in version less than 19c.

For Database link creation in autonomous database (shared), please refer the Note 2592265.1.

 

Example : 

Two Database link is created from OCI to Autonomous Database.

SQL> create database link dblink1 connect to admin identified by XXXX using '(description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.<region>.oraclecloud.com))(connect_data=(service_name=diy75hl4ozg31o6_adblink1_medium.adb.oraclecloud.com))(security=(my_wallet_directory=/home/oracle/adblink1)(ssl_server_cert_dn="CN=adb.sa-saopaulo-1.oraclecloud.com, OU=Oracle ADB SAOPAULO, O=Oracle Corporation, L=Redwood City, ST=California, C=US")))';
Database link created.

SQL> create database link dblink2 connect to admin identified by XXXX using '(description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.<region>.oraclecloud.com))(connect_data=(service_name=diy75hl4ozg31o6_adblink2_medium.adb.oraclecloud.com))(security=(my_wallet_directory=/home/oracle/adblink2)(ssl_server_cert_dn="CN=adb.sa-saopaulo-1.oraclecloud.com, OU=Oracle ADB SAOPAULO, O=Oracle Corporation, L=Redwood City, ST=California, C=US")))'
Database link created.

 Attempt to access both Database link from a Single user session. The DB link access will be successful if you use one of them. 

SQL> select * from dual@dblink1;

D
-
X

SQL> select * from dual@dblink2;
select * from dual@dblink2
*
ERROR at line 1:
ORA-12529: TNS:connect request rejected based on current filtering rules

OR

SQL> select * from dual@dblink2;

D
-
X

SQL> select * from dual@dblink1;
select * from dual@dblink1
*
ERROR at line 1:
ORA-12529: TNS:connect request rejected based on current filtering rules

 

Cause

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
Symptoms
Cause
Solution
References


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