Connectivity fails from Linked server
Dear Experts,
Our DB version 19.17
2 node RAC
CDB with single PDB
prodcdb1 and prodcdb2 are instances
PRODDB is PDB
From Linked server,We are unable to establish connection to Oracle Database. In linked server,below tnsnames.ora is used.
Error is as ORA-12514 TNS:listener does not currently know of .service requested.
listener status
Services Summary... Service "28182bc4cf6c4887e053b340d20a8b55" has 1 instance(s). Instance "prodcdb1", status READY, has 1 handler(s) for this service... Service "86b637b62fdf7a65e053f706e80a27ca" has 1 instance(s). Instance "prodcdb1", status READY, has 1 handler(s) for this service... Service "PRODDBXDB" has 1 instance(s). Instance "prodcdb1", status READY, has 1 handler(s) for this service... Service "PRODDB_ebs_patch" has 1 instance(s). Instance "prodcdb1", status READY, has 1 handler(s) for this service... Service "ebs_PRODDB" has 1 instance(s). Instance "prodcdb1", status READY, has 1 handler(s) for this service... Service "prodcdb" has 1 instance(s). Instance "prodcdb1", status READY, has 1 handler(s) for this service... Service "proddb" has 1 instance(s). Instance "prodcdb1", status READY, has 1 handler(s) for this service... The command completed successfully
0