oracle 10.2.0.3 or 10.2.0.4 업그레이드후 ORA-01092 발생할 경우

Please perform the post-installation scripts given in the readme of the patchset.

1. Please ensure to have a backup of the database
2. Startup the database in upgrade mode and run catalog.sql and catproc.sql'


SQL> STARTUP UPGRADE
SQL> @?/rdbms/admin/catupgrd.sql

Please note that the catupgrd.sql calls the catalog.sql and catproc.sql internally.If you are
running
@the catalog.sql and catproc.sql script it is not required to run the catupgrd.sql script
separately.

3.Shutdown and restart the database normally

SQL> SHUTDOWN
SQL> STARTUP

[출처] 10.2.0.3 업그레이드후 ORA-01092 발생할 경우, (ProDBA) |작성자 주노팔