DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ora-04068,Ora-04063

  1. #1
    Join Date
    May 2004
    Posts
    2

    ora-04068,Ora-04063

    Hi,

    We have upgraded the oracle to 9.2.0.4.
    There are some daily jobs. For first few days after the upgardation it was working fine but on one day we are facing below error...
    ERROR at line 1:
    ORA-04068: existing state of packages has been discarded
    ORA-04063: package body "TMOADMIN.EDIT_SPT_EVNT_RULE" has errors
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at line 161
    We recompile the libraries and it was working fine.
    can any body let me know why this error occure and what could we do so that this error should not come in future.

    Thanks & regards,
    -amit

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    seems like some pl/sql code (function/proc or so) being called from TMOADMIN.EDIT_SPT_EVNT_RULE has either been droped/revoked privs/droped public synonym or so..

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    duplicate, closing
    Jeff Hunter

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