My Oracle Support Banner

SERVICE_NAME incorrectly uses extra dot when DB_DOMAIN is set to NULL (Doc ID 2882290.1)

Last updated on JANUARY 05, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 19.7.0.0.0 version, RDBMS

SERVICE_NAME incorrectly uses extra dot when DB_DOMAIN is set to NULL because of that Scheduled Job connects to the wrong instance.

In the alert log of the database, we see that the job tries to connect to the first listener it finds in the file listener.ora.
Apart from that, it tries to connect to the wrong service. It tries to always connect do database_name.db_domain. When db_domain is not set, it still adds the 'dot' to the service it connects to.

ERROR
-----------------------
TNS-12545, TNS-00515


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.