David,
Off the top, it doesn’t look like modifying SID is
an option for RDS (non-custom/non-EC2 based),
Please see the following from aws documentation..
—-
For the Oracle database engine, database name is used to set the value of
ORACLE_SID, which must be supplied when connecting to the Oracle RDS instance.
—-
Essentially, it seems that for RDS (non-custom/non-EC2) the RDS db would have
to be recreated if SID needs anything other than whatever DB name was
picked /chosen during the installation time.
Rajeev
On Mar 20, 2023 at 3:27 PM, <Maris Elsins (mailto:elmaris@xxxxxxxxx)> wrote:
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
(mailto: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?