THREE NODE RAC - OEM STATUS IS DOWN with ORA-12514:
Three-node RAC is up and running smoothly after upgrading from 12.2 to 19c (19.21).
O/S : OEL 7.2
GRID VERSION : 19.3
Current Status:
- Load balancing is functioning across all three servers.(Checked through session distribution)
- The application connects to the database without any issues via SCAN.
- Both the local listener (pointing to the local IP) and remote listener are correctly configured.
Issue:
OEM reports two of the nodes as down with the following error:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Connect Descriptor:
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server-vip.quintiles.net)(PORT = 1521))
(CONNECT_DATA = (SID = 1111)(SERVER = DEDICATED))
)
When I restart the database wherever listener_scan1 is running (e.g., Node 3), its UP in OEM. However, if the listener moves to another node (e.g., Node 2 after a restart), the status in OEM shows Nodes 3 and 1 as down.
0