Re: Moving to AWS Oracle RDS from Oracle RAC - tnsnames.ora?

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_at_gmail.com>
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?

>


--
http://www.freelists.org/webpage/oracle-l