Oracle Database Discussions

Hi guys,

Why I'm not able to kill sessions connected to PDB when sessions are created for scheduler jobs.

select sid , serial# ,  program , con_id from v$session where status='ACTIVE' and username is not null;

SQL> show con_id

3

SQL> alter system kill session '1219,43811' immediate;

alter system kill session '1219,43811'  immediate

*

ERROR at line 1:

ORA-00026: missing or invalid session ID

I checked in MOS and there is a bug note however the status is :

Bug 22578465 : NOT ABLE TO KILL THE SESSION FROM PDB STARTED ON PDB BUT ABLE TO KILL FROM ROOT

Product Version 12.1.0.2

ORACLE LINUX 6

======================================
DETAILED PROBLEM DESCRIPTION
============================
A pdb local user creates a scheduler job.
User has 'alter system' privilege and 'select from v_$session' object
privilege granted.
Session of the job is visible when selected from v$session.
Attempt to kill the session ends with error.
 
alter system kill session '<sid>,<serial#>'
*
ERROR at line 1:
ORA-26: missing or invalid session ID

Any idea about this behaviour?

Thanks a lot