Database Administration (MOSC)

MOSC Banner

After upgrading from 12c to 19C getting ORA-01031: insufficient privileges

Hi , I am facing an issue after upgrading  from 12c to 19c. I get issues when executing the below :

BEGIN

 DBMS_SCHEDULER.define_chain_step (

  'SCHEDULE.TEST_SCHDULER',

  'STEP' || '1' ,

  'SCHEDULE.TEST_SCHDULER' || '_PGM' || '1');

END;

/

BEGIN

*

ERROR at line 1:

ORA-01031: insufficient privileges

ORA-06512: at "SYS.DBMS_CHAIN_INVOKER", line 291 -------> Introduced in 19c

ORA-06512: at "SYS.DBMS_RULEADM_INTERNAL", line 275

ORA-06512: at "SYS.DBMS_CHAIN_INVOKER", line 287

ORA-06512: at "SYS.DBMS_SCHEDULER", line 1762

ORA-06512: at line 2

I have granted execute priv to public and directly to the user executing the above.

Has anyone come across this issue?

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