ORA-06512: at SYS.DBMS_SPACE And ORA-20000

Today I have been reported this error

ORA-12012: error on auto execute of job 140600
ORA-20000: ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalid
ORA-06512: at “SYS.PRVT_ADVISOR”, line 1624
ORA-06512: at “SYS.DBMS_ADVISOR”, line 186
ORA-06512: at “SYS.DBMS_SPACE”, line 1344
ORA-06512: at “SYS.DBMS_SPACE”, line 1560

Look at MOS I can see several bugs for this version but this system is a 24×7 and it isn’t easy to apply any patch. Because I don’t use DBMS_SPACE Advisor set it off by using this command;

execute dbms_scheduler.disable(‘AUTO_SPACE_ADVISOR_JOB’);

HTH – Antonio NAVARRO.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s