My Oracle Support Banner

[OCI]VMDB: Switchover failed by ORA-12514 meanwhile CRSD Agent failed by CRS-8503[kpufhndl0] (Doc ID 2960691.1)

Last updated on OCTOBER 06, 2023

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Switchover failed by ORA-12514 meanwhile CRSD Agent failed by CRS-8503[kpufhndl0].

-- Data Guard Broker output

[2023-06-27 16:54:38.370] DGMGRL> validate database <Standby DB Name>
[2023-06-27 16:58:48.961]
[2023-06-27 16:58:48.961] Database Role: Physical standby database
[2023-06-27 16:58:48.961] Primary Database: <Primary DB Name>
[2023-06-27 16:58:48.961]
[2023-06-27 16:58:48.961] Ready for Switchover: Yes
[2023-06-27 16:58:48.961] Ready for Failover: Yes (Primary Running)
[2023-06-27 16:58:48.961]
[2023-06-27 16:58:48.961] Flashback Database Status:
[2023-06-27 16:58:48.961] <Primary DB Name>: Off
[2023-06-27 16:58:48.961] <Standby DB Name>: Off
[2023-06-27 16:58:48.961]
[2023-06-27 16:58:48.961] Managed by Clusterware:
[2023-06-27 16:58:48.961] <Primary DB Name>: YES
[2023-06-27 16:58:48.961] <Standby DB Name>: YES
[2023-06-27 16:58:48.961]
[2023-06-27 16:58:48.961] DGMGRL> switchover to <Standby DB Name>
[2023-06-27 16:58:58.420] Performing switchover NOW, please wait...
[2023-06-27 16:59:02.283] Operation requires a connection to database "<Standby DB Name>"
[2023-06-27 16:59:02.283] Connecting ...
[2023-06-27 16:59:03.292] Connected to "<Standby DB Name>"
[2023-06-27 16:59:03.293] Connected as SYSDBA.
[2023-06-27 16:59:54.228] New primary database "<Standby DB Name>" is opening...
[2023-06-27 16:59:54.228] Oracle Clusterware is restarting database "<Primary DB Name>" ...
[2023-06-27 17:09:59.627] Unable to connect to database using <Primary DB Name>
[2023-06-27 17:09:59.627] ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
[2023-06-27 17:09:59.627]
[2023-06-27 17:09:59.627] Failed.
[2023-06-27 17:09:59.627] [W000 2023-06-27T17:10:00.329+09:00] Failed to attach to <Primary DB Name>.

 

-- GI alert log 

2023-06-27 16:42:03.707 [ORAAGENT(30160)]CRS-5011: Check of resource "<Primary DB Name>" failed: details at "(:CLSN00007:)" in "$GRID_HOME/crs/trace/crsd_oraagent_oracle.trc"
2023-06-27 16:42:04.509 [ORAAGENT(30160)]CRS-5011: Check of resource "<Primary DB Name>" failed: details at "(:CLSN00007:)" in "$GRID_HOME/crs/trace/crsd_oraagent_oracle.trc"
2023-06-27 16:42:08.935 [ORAAGENT(30160)]CRS-5011: Check of resource "<Primary DB Name>" failed: details at "(:CLSN00007:)" in "$GRID_HOME/crs/trace/crsd_oraagent_oracle.trc"
2023-06-27 16:42:09.016 [ORAAGENT(57057)]CRS-8500: Oracle Clusterware ORAAGENT process is starting with operating system process ID 57057
2023-06-27 16:42:10.584 [ORAAGENT(57089)]CRS-8500: Oracle Clusterware ORAAGENT process is starting with operating system process ID 57089
2023-06-27 16:42:10.735 [ORAAGENT(57089)]CRS-5011: Check of resource "<Primary DB Name>" failed: details at "(:CLSN00007:)" in "$GRID_HOME/crs/trace/crsd_oraagent_oracle.trc"
2023-06-27 16:59:58.157 [ORAAGENT(57089)]CRS-5011: Check of resource "<Primary DB Name>" failed: details at "(:CLSN00007:)" in "$GRID_HOME/crs/trace/crsd_oraagent_oracle.trc"
2023-06-27 16:59:58.203 [ORAAGENT(57089)]CRS-8503: Oracle Clusterware process ORAAGENT with operating system process ID 57089 experienced fatal signal or exception code 11.
2023-06-27T16:59:58.274080+09:00
Errors in file $GRID_HOME/crs/trace/crsd_oraagent_oracle.trc (incident=9):
CRS-8503 [kpufhndl0()+75] [Signal/Exception: 11] [Instruction Addr: 0x7fe75946291b] [Memory Addr: 0x200000001] [] [] [] [] [] [] [] []
Incident details in: $GRID_HOME/crs/incident/incdir_9/crsd_oraagent_oracle_i9.trc

2023-06-27 16:59:58.966 [ORAAGENT(76819)]CRS-8500: Oracle Clusterware ORAAGENT process is starting with operating system process ID 76819
2023-06-27 16:59:59.220 [ORAAGENT(76819)]CRS-5011: Check of resource "<Primary DB Name>" failed: details at "(:CLSN00007:)" in "$GRID_HOME/crs/trace/crsd_oraagent_oracle.trc"
2023-06-27 16:59:59.477 [ORAAGENT(76997)]CRS-8500: Oracle Clusterware ORAAGENT process is starting with operating system process ID 76997

 

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.