oracle 10.2.0.4 rac 升級到oracle 10.2.0.5 rac步驟

paulyibinyi發表於2010-06-10
Oracle

       環境 aix 6.1 + emc cx500 +oracle 10gR2 

       oracle 10.2.0.5 for aix 版本到今天為止已經推出一週。

       今天有時間在公司做了 oracle 10.2.0.4 rac 升級到 oracle 10.2.0.5 rac 的 實驗,操作步驟與oracle 10.2.0.1

升級到oracle 10.2.0.4一樣,以下為oracle 10.2.0.4 rac 升級到oracle 10.2.0.5 rac 實驗步驟:

1.先升級cluster到10.2.0.5

   slibclean

   執行runInstaller,選擇CRS_HOME ,軟體安裝完成後,每個節點執行以下指令碼

   cd /crs/app/oracle/product/crs_1/bin

   ./crsctl stop crs

  cd /crs/app/oracle/product/crs_1/install

  ./root102.sh

2.安裝ORACLE程式碼到10.2.0.5

   slibclean

   執行runInstaller,選擇ORACLE_HOME ,軟體安裝完成後,每個節點執行以下指令碼

   cd  /oracle/app/oracle/product/10.2.0/clusterdb

   ./root.sh

2.升級資料庫資料字典到oracle 10.2.0.5

  1.    SQL> STARTUP NOMOUNT

  2. Set the CLUSTER_DATABASE initialization parameter to FALSE:

    SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile;

  3. Shut down the database:

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

  5. @?/rdbms/admin/utlrp.sql

  6. ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=spfile; 

  7. SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP

  8. srvctl start database -d db_name
  9. srvctl start service -d db_name -s service_name
 
升級成功
我們驗證下結果:
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE    10.2.0.5.0      Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.5.0 - Productio
NLSRTL Version 10.2.0.5.0 - Production
5 rows selected.
SQL> select comp_id,comp_name,version,status,modified from dba_registry;
COMP_ID
------------------------------
COMP_NAME
--------------------------------------------------------------------------------
VERSION                        STATUS                 MODIFIED
------------------------------ ---------------------- -----------------------
OWM
Oracle Workspace Manager
10.2.0.5.0                     VALID                  10-JUN-2010 13:05:24
CATALOG
Oracle Database Catalog Views
10.2.0.5.0                     VALID                  10-JUN-2010 13:04:12
CATPROC
Oracle Database Packages and Types
10.2.0.5.0                     VALID                  10-JUN-2010 13:04:12
RAC
Oracle Real Application Clusters
10.2.0.5.0                     VALID                  10-JUN-2010 13:04:14

4 rows selected.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/7199859/viewspace-664903/，如需轉載，請註明出處，否則將追究法律責任。

相關文章