-
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
-
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
-
Amir: 1 more question
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
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|