DB Link (On-Prem to ADW) ORA-12557: TNS:protocol adapter not loadable

Nov 10, 2021 3:38PM

Hi, we are encountering issues with DB link. Path is Set correctly and telnet between servers are successful.

SQL*Plus: Release 11.2.0.4.0 Production on Tue Nov 9 09:30:37 2021

Connected to:

Oracle Database 11g Release 11.2.0.4.0 - 64bit Production

With the Automatic Storage Management option

SQL> create database link ADWLINK

connect to SIEBEL identified by

using

'(description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=xxxxxxxx.adb.us-ashburn-1.oraclecloud.com))(connect_data=(service_name=xxxxxxxxx_adwtest001_medium.adb.oraclecloud.com))(security=(ssl_server_cert_dn="CN=adwc.uscom-east-1.oraclecloud.com, OU=Oracle BMCS US, O=Oracle Corporation, L=Redwood City, ST=California, C=US")))';

Database Administration (MOSC)

DB Link (On-Prem to ADW) ORA-12557: TNS:protocol adapter not loadable

Howdy, Stranger!

Category Leaderboard

Top contributors this month