Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Internal error after upgrade to 8.1.7.4

Internal error after upgrade to 8.1.7.4

From: Gerold Krommer <g.krommer_at_doremove.fns.co.at>
Date: Mon, 26 Apr 2004 17:25:43 +0200
Message-ID: <1082992899.567925@newsmaster-03.atnet.at>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US