oracle RAC升级10.2.0.1-10.2.0.5数据字典

重建数据字典

     1、STARTUP NOMOUNT

     2、ALTER SYSTEM SET CLUSTER_DATABASE=FALSE
SCOPE=spfile;

3、SHUTDOWN

4、STARTUP UPGRADE

5、SPOOL patch.log

   @?/rdbms/admin/catupgrd.sql

SPOOL OFF

6、SHUTDOWN IMMEDIATE

7、STARTUP

8、@?/rdbms/admin/utlrp.sql

9、select comp_name, version, status from sys.dba_registry;

10、ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=spfile;

11、SHUTDOWN

12、STARTUP

13、srvctl start service -d db_name -s service_name

14、emca -upgrade db -cluster