Database Administration (MOSC)

MOSC Banner

Unable to kill session in a pluggable database

edited Jan 17, 2019 9:30AM in Database Administration (MOSC) 9 commentsAnswered

I have a RAC pluggable database (12c).  The application runs packages/procedures using dbms_scheduler to create and run scheduled jobs.  Sometimes, the dba_scheduler_running_jobs view does not show any running job but there is a session running  (this has occurred in multiple non-prod environments both CDB and nonCDB).  If we try to stop using dbms_scheduler.stop_job we get unknown job error.   Our work around at the moment is to kill the "rogue" job session.  We need to work on this issue, but we are now using a PDB in Dev to do this testing.  In the PDB, I am connecting as a common

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center