Hi Team,
I am trying to create a DB Link between 2 autonomous databases both with APEX workloads in Private Endpoints. Is there any guidance document you can share with me for the same?
Oracle documentation says to download Wallet from ADB and try the connection. But, for APEX workload the Connection information is not available in ADB console. The wallet cannot be downloaded as well.
Where we can find the connection information for ADB with APEX workload?
I am trying a script as below:
BEGIN
DBMS\_CLOUD\_ADMIN.CREATE\_DATABASE\_LINK(
db\_link\_name => 'bsm\_link1',
hostname => 'xxxxxxxxx.adb.us-ashburn-1.oraclecloud.com',
port => '1522',
service\_name => 'usbsmsandboxpvt2\_high.adb.oraclecloud.com',
ssl\_server\_cert\_dn => 'CN=adb.us-ashburn-1.oraclecloud.com,OU=Oracle ADB,O=Oracle Corporation,L=Redwood City,ST=California,C=US',
credential\_name => 'my\_credential',
private\_target => TRUE
);
END;
Note: the service name is based on assumption.
select * from dual@bsm_link1;
ORA-28759: failure to open file https://docs.oracle.com/error-help/db/ora-28759/ 28759. 00000 - "failure to open file" *Cause: The system could not open the specified file. *Action: Enable tracing to determine the exact cause of this error. Contact Oracle customer support if needed.
Thanks
Sandipan