Good Day
My DBMS Scheduler(body) is invalid when I valid :
1.After validation and refresh is remains invalid error
| Body | 0 | 0 | PLS-00907: cannot load library unit SYS.ANYDATA (referenced by SYS.DBMS_ISCHED) |
| Body | 0 | 0 | PLS-00907: cannot load library unit SYS.ANYDATA (referenced by SYS.DBMS_ISCHED) |
| Body | 0 | 0 | PLS-00907: cannot load library unit SYS.ANYDATA (referenced by SYS.DBMS_ISCHED) |
| Body | 0 | 0 | PLS-00907: cannot load library unit SYS.ANYDATA (referenced by SYS.DBMS_ISCHED) |
| Body | 0 | 0 | PLS-00907: cannot load library unit SYS.ANYDATA (referenced by SYS.DBMS_ISCHED) |
| Body | 0 | 0 | PLS-00907: cannot load library unit SYS.ANYDATA (referenced by SYS.DBMS_ISCHED) |
| Body | 0 | 0 | PLS-00907: cannot load library unit SYS.ANYDATA (referenced by SYS.DBMS_ISCHED) |
| Body | 1950 | 11 | PLS-00306: wrong number or types of arguments in call to 'GET_CHAIN_RULE_ACTION' |
| Body | 1954 | 12 | PLS-00306: wrong number or types of arguments in call to 'GET_CHAIN_RULE_ACTION' |
| Body | 3368 | 45 | PLS-00905: object SYS.RE$NV_LIST is invalid |
| Body | 3368 | 1 | PL/SQL: Item ignored |
Is there a way I can recompile using the source installation
because I tried this and still it did not help
sqlplus /as sysdba
SQL> spool fix_cat_logfile.txt
SQL> startup upgrade
SQL > @ORACLE_HOME/rdbms/admin/catalog.sql
SQL > @ORACLE_HOME/rdbms/admin/catproc.sql
SQL > @ORACLE_HOME/rdbms/admin/utlrp.sql
SQL> spool off
ORACLE 11.2.0.3