Shutdown Immediate Hangs When Job With Dbms_lock.sleep Is Running
(Doc ID 2692108.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
Shutdown immediate on a PDB does not kill Jxxx secondary for dbms_jobs
ALTER PLUGGABLE DATABASE OPEN
Fri Sep 13 07:46:30 2019
Database Characterset for PDB1 is WE8MSWIN1252
Opening pdb PDB1 (3) with no Resource Manager plan active
Pluggable database PDB1 opened read write
Completed: ALTER PLUGGABLE DATABASE OPEN
ALTER PLUGGABLE DATABASE CLOSE IMMEDIATE
Fri Sep 13 07:51:04 2019
Immediate Kill Session#: 1, Serial#: 44079
Immediate Kill Session: sess: 4080fd2d8 OS pid: 24388
Fri Sep 13 07:56:05 2019
Active process 24542 user 'oracle' program 'oracle@solaris (J000)' ------------>>>>>>>>>>>> shutdown will not proceed here
SHUTDOWN: waiting for logins to complete.
Fri Sep 13 08:06:03 2019
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 |