Dbabc.Net

本文简单描述了Oracle10.2.0.1升级10.2.0.4的步骤，适用于已经创建数据库和尚为创建数据库的情况，安装完oracle10.2.0.1之后进行以下操作。
sql>startup upgrade
sql>@$ORACLE_HOME/rdbms/admin/catupgrd.sql;
sql>@$ORACLE_HOME/rdbms/admin/catalog.sql;
sql>@$ORACLE_HOME/rdbms/admin/utlrp.sql;

如在运行中出下ORA-04063: package body “SYS.DBMS_REGISTRY_SYS” has errors  错误，请运行@$ORACLE_HOME/rdbms/admin/prvtcr.plb

Total Upgrade Time: 00:28:07
DOC>#######################################################################
DOC>#######################################################################
DOC>
DOC>   The above PL/SQL lists the SERVER components in the upgraded
DOC>   database, along with their current version and status.
DOC>
DOC>   Please review the status and version columns and look for
DOC>   any errors in the spool log file.  If there are errors in the spool
DOC>   file, or any components are not VALID or not the current version,
DOC>   consult the Oracle Database Upgrade Guide for troubleshooting
DOC>   recommendations.
DOC>
DOC>   Next shutdown immediate, restart for normal operation, and then
DOC>   run utlrp.sql to recompile any invalid application objects.
DOC>
DOC>#######################################################################
DOC>#######################################################################
DOC>#
SQL> select count(*) from dba_objects where status =’INVALID’;

结果为空，说明升级ok。