Solution : https://service.sap.com/sap/support/notes/648203 (SAP Service marketplace login required)
Summary :
SAP users may encounter issues where DBA_OBJECTS and DBA_REGISTRY show components or objects with an "INVALID" status due to compilation errors. Specifically, identifiers might be undeclared, or package bodies may require their specifications for compilation. These statuses often arise during Oracle upgrades but are generally non-critical except for SYS and SYSTEM users. To address this, inspect INVALID objects using provided SQL scripts. In the BW context, irrelevant temporary objects can be cleaned with SAP_DROP_TMPTABLES. For Oracle 9i and above, ensure CATALOG and CATPROC components in DBA_REGISTRY are VALID. Use SELECT queries and specific cleanup methods as detailed for object validation, including running necessary database scripts and manually compiling objects prone to errors like 'PLS-00201' or 'ORA-00904'. Always check errors post-compilation with 'SHOW ERRARDS' and refer to SAP Notes for further guidance.
Key words :
$kqrsdgv$kqrpdgv$kqrsdv$kqrpdgv_$kqrsdv_$kqrsdgv_$kqrpdv_$kqrpd, failed command usingshow errors andselect, compilation unit analysis terminatedpls-00201, jserver release <release> - production, object_typefrom dba_objectswhere status = 'invalid', correct older upgrade scripts, invalid oracle ddic objects, jserver patch set, $oracle_home/rdbms/admin, contact sap support
Related Notes :
| 1054131 | Invalid DB objects after upgrade from 9.2.0.8 to 10.2.0.2 |
| 847424 | How to remove the JVM in 9.2.0.x |
| 842655 | Invalid UTL_FILE after migrate/upgrade to 9.2.0.6 on AIX5L |
| 722376 | ORA-18008: cannot find OUTLN schema |
| 618868 | FAQ: Oracle performance |
| 582427 | Error due to inconsistent Oracle DDIC |
| 449891 | Temporary database objects in BW 3.x |
| 308533 | Temporary Database Objects in BW 2.0 |
| 731 | Collective note: ORA-00904 |