DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE Failing With ORA-01033. (Doc ID 756740.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 26-Oct-2016***

Symptoms

Trying to run DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE right after a startup fails with ORA-01033.

SQL> startup restrict;
ORACLE instance started.

Total System Global Area 536870912 bytes
Fixed Size 1220460 bytes
Variable Size 234881172 bytes
Database Buffers 293601280 bytes
Redo Buffers 7168000 bytes
Database mounted.
Database opened.
SQL> exec dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED','TRUE')
BEGIN dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED','TRUE'); END;

*
ERROR at line 1:
ORA-01033: ORACLE initialization or shutdown in progress
ORA-06512: at "SYS.DBMS_ISCHED", line 2932
ORA-06512: at "SYS.DBMS_SCHEDULER", line 2210
ORA-06512: at line 1

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms