For those who attended the Oracle Open World 2019 in San Francisco, California in the USA (if you didn’t check out my compilation video about the event : https://www.youtube.com/watch?v=8bOLbXOJHmAh ) and have had the experience to also attend the KeyNotes probably would prefer to migrate their Oracle database On-Prem to Oracle Cloud Ed2 instead of AWS Amazon EC2 or RDS. However, as an IT professional, we have to do our best to deliver a high quality of service independently of the provider . So the purpose of this post is…
Day: November 16, 2019
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: To create your public Database Link in the AWS RDS Oracle , it has to be used…