Re: Question - service_names in RAC/Exadata/Cloud having full domain name - can that be disabled somehow?

I see that it comes from having DB_DOMAIN specified in the database.

That explains why some of our services on RAC don't have a domain appended to the end of the service (as the database for those services has db_domain set to null)

Kind of interesting [to me] at least.

Makes managing tnsnames services with failover entries a bit easier when you don't have to manage separate db_domains (or we probably should have set db_domain to be the same everywhere).

Thanks,
Chris

On Mon, Aug 29, 2022 at 12:02 PM Chris Taylor < christopherdtaylor1994_at_gmail.com> wrote:

> So this is a curiosity question mainly.
>
> In RAC/Exadata/Cloud (and I'm not sure which is the cause), our service
> names always have the domain appended.
>
> So the service_names for TNS end up being service_name.<domain>
>
> Which, for a failover entry in TNS, makes the service names all very
> unique depending on where the failover/standby hosts are as those
> service_names will have a different domain.
>
> Is there somewhere to have "short" service_names that don't include domain
> name when using srvctl to add the service?
>
> Or is it the way we're adding the service_name that's allowing Oracle to
> setup the service with domain name?
>
> Example the way we use it:
>
> srvctl add service -d <db_name> -s <short_svc_name> -pdb
> <pdb_name> -preferred <preferred instance> -available <avail instance>
>
> I'm wondering if we should use quotes around the service name on creation
> or something to get rid of the domain getting appended.
>
> (I haven't searched this yet but will do so as well but wanted to ask here)
>
> Thanks,
> Chris
>
>
>
>

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