Rt-setup-database - Support for ServiceName and not just SID with Oracle

Following on from my previous discussion: Rt-setup-database - TNS:listener does not currently know of SID given in connect descriptor

Hi all,

So, we’ve come to the realisation that in order to get things working with our 12c environment, RT (or at-least the rt-setup-database utility, needs to support ServiceNames opposed to just SID’s.
Does anyone know of a way to do this, and if it can be done?

Quote:

Oracle prefers Service Names to SIDs. Don’t know why but that’s what they recommend and we followed their recommendations in 12c. It is also because we use Oracle Containers and the root container is the SID and the client databases are Services with Service Names.

1 Like

Ok, working with the oracle guys at my work:

There’s an option in the listener.ora to use the SID as a Service Name.
Its called USE_SID_AS_SERVICE_<> = ON

The relevant MOS Oracle doc is 1644355.1

That fixed it, so no more issues - YAY!