ORACLE AND AWS RDS FOR ORACLE TIP: How to configure your public Database Link in AWS RDS ORACLE. What happened with my TNSNAMES.ORA?

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.

Related posts

Leave a Comment