AWS RDS Oracle is a managed service. Hence, there are some functions associated with the database that are managed by AWS instead of the customer and the tnsnames.ora file is one of those items managed by AWS. So the question is: how to create and configure my public Database Link to use a service configured on my previous On-Prem database?
So this is my Service configured in my TNSNAMES.ORA in my On-Prem database:
TECHDATABASKETm = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = techdatabasketserver)(PORT = 1521)) ) (CONNECT_DATA = (SID = TECHDB) ) )
To create your public Database Link in the AWS RDS Oracle , it has to be used as the service above so just copy the information and use as below:
SQL> create public database link TECHDBLINK USING 'DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = techdatabasketserver)(PORT = 1521)) ) (CONNECT_DATA = (SID = TECHDB) ) )' ; 2 3 4 5 6 7 8 9 10 11 Database link created.
Hi! I am Bruno, a Brazilian born and bred. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general.
(Continue reading)