We are using Oracle database from Oracle Database Cloud Service, now we are not able to connect Cloud db from Local oracle db.
Somehow we created link using below commnd,
CREATE DATABASE LINK link_1 CONNECT TO "username" IDENTIFIED BY "password" USING 'https://x.x.x.oraclecloudapps.com/apex/';
Now once i execute query
select * from EMP@link_1 It throws an error
ORA-12154: TNS:could not resolve the connect identifier specified 12154. 00000 - "TNS:could not resolve the connect identifier specified"
with Cause and Actions.
Let me know if some additional configuration/changes required.