Shutdown Immediate Hangs When Job With Dbms_lock.sleep Is Running
(Doc ID 2692108.1)
Last updated on AUGUST 24, 2021
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
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
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