Oracle Enterprise 8.1.6 - dbms_application_info

[dkleinman]

I just upgrade from Oracle Enterprise 8.1.5 to 8.1.6.&nbsp;&nbsp;I get the following error when starting SQLPlus<br><br>Error accessing package DBMS_APPLICATION_INFO<br>ERROR:<br>ORA-06553: PLS-908: The stored format of SYS.STANDARD is not supported by this<br>release<br><br>I recompiled the procedure and got the same error during the recompile.&nbsp;&nbsp;Any ideas.

 

[Guest_imported]

Did you do a full export of your database before attempting the upgrade from 8.1.5 to 8.1.6?&nbsp;&nbsp;I need to know that before I can tell you what to do to correct your problem.

 

[karluk]

Did you run any scripts after the upgrade, in particular CATPROC.SQL?&nbsp;&nbsp;It sounds as if the package STANDARD has to be upgraded in order to support the new release.

 

[Guest_imported]

The problem can be much greater than catproc.sql will cure.&nbsp;&nbsp;There is a bug in migrating from 8.1.5 to 8.1.6.&nbsp;&nbsp;Oracle support was not much help.&nbsp;&nbsp;Had to remove all 8.1.5 software and install 8.1.6, create new databases, then do imports at user level, since dictionary is not responsive to change from 8.1.5 to 8.1.6 via full import and will cause this error.&nbsp;&nbsp;That's why I asked if exports had been done prior to migration.&nbsp;&nbsp;

 

[dkleinman]

I did not do an export first.&nbsp;&nbsp;I ddi try to rerun the the procedures including catporc, but this did not help. I finally uninstalled 8.1.6 - deleted all of the oracle directories and reinstalled.&nbsp;&nbsp;Then I recreated my databases and everyting is working now.

 

[Guest_imported]

Looks like you found the answer yourself.&nbsp;&nbsp;For future reference, when upgrading and you have an existing database, ALWAYS do both a cold backup and a full export first, and ALWAYS create dynamic SQL scripts which can be used to restore tablespaces, users, roles, system privilege grants, any PUBLIC synonyms and database links, etc., in case you can't do a full import.&nbsp;&nbsp;Then you have the option to try the upgrade followed with a full import.&nbsp;&nbsp;If that doesn't work for some reason, as in migrations from 8.1.5 to 8.1.6, you can delete and re-install software, create empty database, run scripts to re-establish users, etc., and do an import at user-level.&nbsp;&nbsp;In case you decide not to proceed with upgrade and want to go back to a previous version, you can restore from your backup.&nbsp;&nbsp;And, of course, as soon as you determine your newly upgraded database is working okay, be sure to do a full backup.&nbsp;&nbsp;First rule in database CYA is backup before you start and again after you finish.&nbsp;&nbsp;It takes a little extra time, but it's worth the insurance.

 

[OracleNewbie]

I too have the same problem....I get the same error message when starting sqlplus....does anybody have a solution? I have run catproc, however I come up with errors during the process...I would rather not uninstall and reinstall and recreate my dbs. Any help would be greatly appreciated...thanks.

 

[GREGE]

you can upgrade 8.1.5 to 8.1.6 by using the u0801050.sql in the rdbms/admin directory it rebuilds all the pl sql scripts so that standard package works it is most common when moving from the 32bit to 64 bit versions. Tip make sure the system tablespace is about 150meg because it creates temporary objects.