SRVCTL STOP DATABASE -D hang in CJQ process
(Doc ID 1955637.1)
Last updated on FEBRUARY 17, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
srvctl stop database -d hangs and "IPC Send timeout detected" in alert log causing slow shutdown.
cjq0 process hung during shutdown of instance(s) for a RAC database.
node1 instance alert log:
Wed Nov 12 15:38:22 2014
ALTER SYSTEM SET service_names='<dbname>' SCOPE=MEMORY SID='<sid>';
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Stopping background process QMNC
Stopping background process MMNL
Stopping background process MMON
License high water mark = 12
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL /* db agent *//* {1:36932:7257} */
Wed Nov 12 15:38:29 2014
SMON: disabling tx recovery
Wed Nov 12 15:41:34 2014
Stopping background process CJQ0
ALTER SYSTEM SET service_names='<dbname>' SCOPE=MEMORY SID='<sid>';
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Stopping background process QMNC
Stopping background process MMNL
Stopping background process MMON
License high water mark = 12
All dispatchers and shared servers shutdown
ALTER DATABASE CLOSE NORMAL /* db agent *//* {1:36932:7257} */
Wed Nov 12 15:38:29 2014
SMON: disabling tx recovery
Wed Nov 12 15:41:34 2014
Stopping background process CJQ0
Node2 instance alert log
Wed Nov 12 15:38:22 2014
SMON: disabling tx recovery
Wed Nov 12 15:38:29 2014
IPC Send timeout detected. Sender: ospid 19398820 [oracle@<hostname> (CJQ0)]
Receiver: inst 1 binc 3 ospid 26804342
SMON: disabling tx recovery
Wed Nov 12 15:38:29 2014
IPC Send timeout detected. Sender: ospid 19398820 [oracle@<hostname> (CJQ0)]
Receiver: inst 1 binc 3 ospid 26804342
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 |