Monday, February 1, 2010

An open database is not really open ?

SQL> startup
ORACLE instance started.

Total System Global Area 2137886720 bytes
Fixed Size 2155464 bytes
Variable Size 637537336 bytes
Database Buffers 1476395008 bytes
Redo Buffers 21798912 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 3598
ORA-06512: at "SYS.DBMS_SCHEDULER", line 2881
ORA-06512: at line 1
Process ID: 6652282
Session ID: 1655 Serial number: 5


SQL> exec dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED', 'TRUE');

PL/SQL procedure successfully completed.

SQL>