SERVICE_NAME incorrectly uses extra dot when DB_DOMAIN is set to NULL
(Doc ID 2882290.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and laterInformation 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 |