obj$ status 5
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: obj$ status 5

  1. #1
    Join Date
    Nov 2000
    Posts
    89
    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

  2. #2
    Join Date
    Mar 2001
    Posts
    314
    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




  3. #3
    Join Date
    Nov 2000
    Posts
    89

    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







  4. #4
    Join Date
    Nov 2000
    Posts
    89
    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
  •  



Click Here to Expand Forum to Full Width