My Oracle Support Banner

ORA-12514 When Connecting To Database Service On One Node After Apply RU19.18 (Doc ID 2965578.1)

Last updated on OCTOBER 06, 2023

Applies to:

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

Symptoms

There are 2  Database services(serv1, serv2)
[oracle@hostname]/home/oracle> srvctl status service -d <Database Name>
Service serv1 is running on instance(s) node1,node2
Service serv2 is running on instance(s) node1,node2

After apply RU19.18, found ORA-12514 when connect to service serv1 and serv2 with domain on node 1 but working fine for node2
db_domain parameter already set inside the database

on node 1 ,  service is not appended with domain in listener services
but on node 2 , service is appended with domain in listener services

listener services
node 1 :
Service "serv1" has 1 instance(s). <=========================================== Service is not appended with domain name
Instance "database name", status READY, has 1 handler(s) for this service...
Service "serv2" has 1 instance(s). <=========================================== Service is not appended with domain name
Instance "database name", status READY, has 1 handler(s) for this service...

node 2 :
Service "serv1.oracl.com" has 1 instance(s). <===========================================  oracl.com
Instance "Database name", status READY, has 1 handler(s) for this service...
Service "serv2.oracl.com" has 1 instance(s). <============================================ oracl.com
Instance "Database name", status READY, has 1 handler(s) for this service...

Changes

 Applied RU 19.18

Same issue after RU 19.19 apply

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
Changes
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.