Moving to AWS Oracle RDS from Oracle RAC - tnsnames.ora?
Date: Mon, 20 Mar 2023 12:35:13 -0500
Message-ID: <CAFH+ifd6JiFHep6ErMw6vpa8oLZqyJMRgoxwx8HsYREX2WmC5g_at_mail.gmail.com>
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?
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 20 2023 - 18:35:13 CET