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, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)