Re: ora-04068

"WK Yeoh" <cwy006_at_motorola.com> a écrit dans le message news: 9efpu2$pqh$1_at_newshost.mot.com...
> I tried to re-apply the script dbmsutil.sql which is in the
> $ORACLE_HOME/rdbms/admin directory. After that I got error as below when I
> tried to run one of my script which query the db:
> Error accessing package DBMS_APPLICATION_INFO
> ERROR:
> ORA-04068: existing state of packages has been discarded
> ORA-04067: not executed, package body "SYSTEM.DBMS_APPLICATION_INFO" does
> not
> exist
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at line 1
>
> I checked the package inside the db and this is what I get:
> OWNER SYNONYM_NAME
> ------------------------------ ------------------------------
> TABLE_OWNER TABLE_NAME
> ------------------------------ ------------------------------
> DB_LINK
> ----------------------------------------------------------------------------
> ----
>
> PUBLIC DBMS_APPLICATION_INFO
> SYS DBMS_APPLICATION_INFO
>
> I have no idea of what has actually happen to this package. Anyone has any
> idea and solutions for this? Please help.
>
> Rgds,
> WK
>
>

I think you executed the dbmsutil.sql script as SYSTEM user. This script has to be executed as SYS.

--
Regards
Michel