Internal error after upgrade to 8.1.7.4

We are getting the following error when startin SQLPLUS after a 8.0.4 to 8.1.7.4 upgrade (HPUX). The application is running fine, though (quite surprisingly). Note that I did not do the upgrade, so I can't tell exactly what happened. But I guess when running the upgrade scripts some 'real errors' (as opposed to the many 'expected errors' ) were not caught.

I'm looking for advice what the best way to proceed is or even if my suspicion is correct. Re-Run all scripts (catproc.sql, etc.) again or just some subset?

The error is as follows:

SQL*Plus: Release 8.1.7.0.0 - Production on Tue Apr 13 15:57:12 2004 (c) Copyright 2000 Oracle Corporation. All rights reserved. ERROR:
ORA-06553: PLS-801: internal error [56319] Error accessing package DBMS_APPLICATION_INFO ERROR:
ORA-06553: PLS-801: internal error [56319] Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production JServer Release 8.1.7.4.0 - Production
SQL> select extents,max_extents,segment_type,segment_name from SQL> dba_segments
where extents=max_extents-12 ;
select extents,max_extents,segment_type,segment_name from dba_segments where extents=max_extents-1
* ERROR at line
1:
ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [56319] SQL>

We can describe the package DBMS_APPLICATION_INFO, but as soon as you touch it (e.g. by recompiling), it tells you the package does not exist. And how can I find out if there are more 'endangered' objects in the database.

Thanks for any hints,

/Gerold Received on Mon Apr 26 2004 - 10:25:43 CDT