Hi,
I don't think you need to edit the tnsnames on the RDS host.
* You can create and start additional services for the RDS instance using
DBMS_SERVICE
<https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_SERVICE.html#GUID-386E183E-D83C-48A7-8BA3-40248CFB89F4>
* you can create DB from RDS using EZ connect string, ie.e. create database
link test connect to myuser identified by mypass using
'rds_endpoint:port/service_name'
---
Maris Elsins
On Mon, Mar 20, 2023 at 7:36 PM David Barbour <david.barbour1@xxxxxxxxx>
wrote:
We are moving our Oracle Databases to AWS (with the further stated goal of
migrating to Postgres - but that's another story). Management is insisting
we move to RDS, NOT RDS Custom nor EC2. This means we will not have access
to the filesystem(s).
Currently we are running RAC at several of third-party colos. Our
applications connect to the databases using service names. Depending on
activity and type of query, in general reports go to a service called DW
while transactions (for the most part) are handled by either a service
called OLTP, or one of several others we've set up.
RAC is pretty good at distributing the load.
Now we move to RDS. Googled the heck out of this, but cannot find a way
to modify tnsnames.ora. If we have to go with SID=ORCL, then so be it.
But it would help out if we didn't have to modify all the application
servers and other connection strings embedded in code (don't ask, please
don't ask).
Does anyone know if it is possible to modify tnsnames.ora on a RDS box?
