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.
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.