Database Administration (MOSC)

MOSC Banner

dbms_scheduler ora-01033. Wrong SID

edited Jul 16, 2012 2:29AM in Database Administration (MOSC) 9 commentsAnswered
Forgive me for my english....
Oracle 10.2.0.5 Standard edition

When i try to execute

exec dbms_scheduler.set_scheduler_attribute('SCHEDULER_DISABLED', 'FALSE');

I get the following response:

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

My suspect is that this DB may have some misconfiguration in relation to his SID.
Is possible that the package try to use a lowercase SID instead the correct UPPERCASE SID ?

There is a way to know what do the package in relation his ORA-01033 ?

Thank's all.....

Emanuele

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