obj$ status 5

[rogerF]

Oracle People:

I patched my 8.1.7.0 to move up to 8.1.7.2 with all the fixes. After the patch I followed the instructions and ran:

-----------------------------------------------------
update obj$ set status=5 where type#=29 and owner#!=0; (required as per bug 1901673)
------------------------------------------------------

I'd like to know what the "status 5" is. I couldn't find info on bug 1901673 but I did find that these objects are owned by ORDSYS which is the "time series" stuff.

Atleast I'd like to known what "status 5" denotes from
obj$.

Thanks,
Roger

[amar]

Roger,

The update statement:

update obj$ set status=5 where type#=29 and owner#!=0;


is run to set the status of all JAVA CLASSES (type#=29 is Java Class) NOT owned by SYS (owner#!=0) to INVALID (status=5).

When you run the "utlrp.sql" script these are recompiled.

-amar

[rogerF]

Amar:

Thanks for replying- I guess I was on the wrong trail.


The instructions say:

------------------------------------------------------
utlrp.sql (optional - will recompile all PL/SQL packages now
rather than when accessed for the first time.
----------------------------------------------------

So if what you say is correct, the utlrp script must be run ? Or that the packages are auto-recomplied(as it seems they say) when accessed.

I'm asking because I ran:

-------------------------------------------------------
update obj$ set status=5 where type#=29 and owner#!=0;
--------------------------------------------------------

After I re-installed java because I had forgotten the "commit" when I ran it. Stupid, yes ... But I'm not sure if I need to "create or replace java system" because of this mistake.

Thanks,

Roger

[rogerF]

Amir:

I went ahead and ran utlrp and those "status 5" objects were re-compiled.

So, I guess(?) I didn't screw up too bad. I'm mainly worried that I had done some more serious mistake.

Thanks,

Roger