Some time ago I posted a message about Invalid objects in the SYS schema. I found a reason - other people performed 8.1.5 -> 8.1.6 upgraid, and something was did wrong...
Using catproc, catrep and utlrp I fixed almost everithing -
but now I have a lot of invalid Java classes, near of 20%, as I see, and I just have no clue how could I recompile it.
I got that new Toad 6.5 which could show them, and I see now this classes - they are mostly in /oracle/jpub/reflect/ ,
/oracle/jdbc/, /oracle/net/, etc. directories.
I tried to recompile them (as SYSTEM, as SYS) but got the message: The following error has occurred: ORA-01031: insufficient privileges.
That Java stuff is pretty new for me - I tried to find an answer in documentation, but found nothing.
How should i deal with that problem? Which section of Oracle8i documentation covers that specific set of Java stuff administration problems?
I don`t know that is going on with that damn classes - but something don`t want to be compiled, something is compiling OK, and then all classes in that section becomes OK,
well, that`s the mess!!!
Do we have any FAQ or guaides about this administration tasks, I mean Java objects administration?
Well, it`s a pretty stupid algorithm, but:
I found only one utility which could recompile java classes -
Login as SYS, try to recompile first class. some could not be recompiled, but some - can.
Recompile first, if it was successful, recompile next, after
first "priveleges" error do refresh comand. With very high probability you will see that all section of classes now is VALID.