Oracle RAC 10.2.0.1 升級 10.2.0.4 簡單描述

推薦crs版本高於db版本

If you also plan to apply this patch to Oracle Clusterware,
ensure that you apply the patch to Oracle Clusterware before
applying it to Oracle Database. This is because Oracle Clusterware
 should always be at the same or later version as the database.

涉及到資料庫而不是例項的，都只需要在節點1上執行即可。

1,  Update Oracle Time Zone Definitions 

SELECT version FROM v$timezone_file;

If this query reports version 4, no action is required; in this case, continue with steps described in section 7.6.

If this reports a version lower or higher then 4, see OracleMetalink document 553812.1 Actions for the DSTv4 update in the Release 10.2.0.4 patchset.

running utltzpv4.sql  (node1)

If a "select * from sys.sys_tzuv2_temptab;" gives no rows then there is no action to take for the Oracle time zone definitions

SQL> select * from sys.sys_tzuv2_temptab;     

no rows selected

 

2, Stop All Processes (node1)
 
$ srvctl stop database -d  ecsdb 
$ srvctl stop nodeapps -n ecsrac01 
$ srvctl stop nodeapps -n ecsrac02  
$ crs_stop -all

3. ./runInstaller  (node1)  -- upgrade CRS
    Name: OraCrs10g_home

4.  cd /u01/product/crs/install    
    # ./root102.sh   (each node)

5. ./runInstaller  (node1)  -- upgrade RDBMS
    name : OraDb10g_home1 

6.  cd /u01/product/oracle/   
    # ./root.sh   (each node)

7.  upgrade database
    manually :  ingore --- Run the Pre-Upgrade Information Tool
   
    $ srvctl start listener -n ecsrac01
    $ srvctl start listener -n ecsrac02 
   
    If you are using Automatic Storage Management, start the Automatic Storage Management instance.

    $ sqlplus /nolog
    SQL> CONNECT SYS AS SYSDBA
    Enter password: SYS_password
    SQL> STARTUP NOMOUNT
    SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile;
    SQL> SHUTDOWN

SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF

8.  Review the patch.log , If necessary, rerun the catupgrd.sql script. after correcting any problems.

9. SQL> SHUTDOWN IMMEDIATE
   SQL> STARTUP

10, Run the utlrp.sql script. to recompile all invalid PL/SQL packages   
   SQL> @?/rdbms/admin/utlrp.sql

11. SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;

12. SQL> ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=spfile;

13. SQL> SHUTDOWN IMMEDIATE
    SQL> STARTUP

14.  Start any database services that you want to use:
     $ srvctl start service -d db_name -s service_name

15. To configure and secure Enterprise Manager follow these steps:
    In the case of Oracle Real Application Clusters (RAC), execute
        emca -upgrade db -cluster