oracle 10 rac 升級 10.2.0.1升級到10.2.0.5
Oracle? Database 10g Release 2 (10.2.0) RAC for RedHat4
Oracle Rac 10.2.0.1升級至10.2.0.5
升級叢集件-滾動升級
升級資料庫軟體-停用後升級
升級資料庫
第一部分：叢集件滾動升級$CRS_HOME
1、系統環境
作業系統版本
[root@ordb1 ~]# uname -a
Linux ordb1 2.6.9-55.ELsmp #1 SMP Fri Apr 20 17:03:35 EDT 2007 i686 i686 i386 GNU/Linux
CRS版本
[oracle@ordb1 ~]$ crsctl query crs softwareversion
CRS software version on node [ordb1] is [10.2.0.1.0]
[oracle@ordb1 ~]$ crsctl query crs activeversion
CRS active version on the cluster is [10.2.0.1.0]
資料庫版本：
[oracle@ordb2 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Mar 15 09:47:45 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> select * from gv$version;
INST_ID BANNER
---------- ----------------------------------------------------------------
2 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
2 PL/SQL Release 10.2.0.1.0 - Production
2 CORE 10.2.0.1.0 Production
2 TNS for Linux: Version 10.2.0.1.0 - Production
2 NLSRTL Version 10.2.0.1.0 - Production
1 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
1 PL/SQL Release 10.2.0.1.0 - Production
1 CORE 10.2.0.1.0 Production
1 TNS for Linux: Version 10.2.0.1.0 - Production
1 NLSRTL Version 10.2.0.1.0 - Production
10 rows selected.
叢集狀態
[oracle@ordb1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application ONLINE ONLINE ordb2
ora....l1.inst application ONLINE ONLINE ordb1
ora....l2.inst application ONLINE ONLINE ordb2
ora....SM1.asm application ONLINE ONLINE ordb1
ora....B1.lsnr application ONLINE ONLINE ordb1
ora.ordb1.gsd application ONLINE ONLINE ordb1
ora.ordb1.ons application ONLINE ONLINE ordb1
ora.ordb1.vip application ONLINE ONLINE ordb1
ora....SM2.asm application ONLINE ONLINE ordb2
ora....B2.lsnr application ONLINE ONLINE ordb2
ora.ordb2.gsd application ONLINE ONLINE ordb2
ora.ordb2.ons application ONLINE ONLINE ordb2
ora.ordb2.vip application ONLINE ONLINE ordb2
關閉節點1
$ emctl stop dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Stopping Oracle Enterprise Manager 10g Database Control ...
... Stopped.
$ isqlplusctl stop
iSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle. All rights reserved.
getnameinfo failed
iSQL*Plus instance on port 5560 is not running ...
srvctl stop instance -d orcl -i orcl1
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application ONLINE ONLINE ordb2
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application ONLINE ONLINE ordb2
ora....SM1.asm application ONLINE ONLINE ordb1
ora....B1.lsnr application ONLINE ONLINE ordb1
ora.ordb1.gsd application ONLINE ONLINE ordb1
ora.ordb1.ons application ONLINE ONLINE ordb1
ora.ordb1.vip application ONLINE ONLINE ordb1
ora....SM2.asm application ONLINE ONLINE ordb2
ora....B2.lsnr application ONLINE ONLINE ordb2
ora.ordb2.gsd application ONLINE ONLINE ordb2
ora.ordb2.ons application ONLINE ONLINE ordb2
ora.ordb2.vip application ONLINE ONLINE ordb2
srvctl stop asm -n orcl1
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application ONLINE ONLINE ordb2
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application ONLINE ONLINE ordb2
ora....SM1.asm application OFFLINE OFFLINE
ora....B1.lsnr application ONLINE ONLINE ordb1
ora.ordb1.gsd application ONLINE ONLINE ordb1
ora.ordb1.ons application ONLINE ONLINE ordb1
ora.ordb1.vip application ONLINE ONLINE ordb1
ora....SM2.asm application ONLINE ONLINE ordb2
ora....B2.lsnr application ONLINE ONLINE ordb2
ora.ordb2.gsd application ONLINE ONLINE ordb2
ora.ordb2.ons application ONLINE ONLINE ordb2
ora.ordb2.vip application ONLINE ONLINE ordb2
srvctl stop nodeapps -n ordb1
[oracle@ordb1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application ONLINE ONLINE ordb2
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application ONLINE ONLINE ordb2
ora....SM1.asm application OFFLINE OFFLINE
ora....B1.lsnr application OFFLINE OFFLINE
ora.ordb1.gsd application OFFLINE OFFLINE
ora.ordb1.ons application OFFLINE OFFLINE
ora.ordb1.vip application OFFLINE OFFLINE
ora....SM2.asm application ONLINE ONLINE ordb2
ora....B2.lsnr application ONLINE ONLINE ordb2
ora.ordb2.gsd application ONLINE ONLINE ordb2
ora.ordb2.ons application ONLINE ONLINE ordb2
ora.ordb2.vip application ONLINE ONLINE ordb2
升級節點1 CRS
./ruinstaller
The installer has detected that your Cluster Ready Services (CRS) installation is distributed across the following nodes:
ordb1
ordb2
Because the software consists of local identical copies distributed across each of the nodes in the cluster, it is possible to patch your CRS installation in a rolling manner, one node at a time.
To complete the installation of this patchset, you must perform. the following tasks on each node:
1. Log in as the root user.
2. As the root user, perform. the following tasks:
a. Shutdown the CRS daemons by issuing the following command:
/oracle/product/10.2.0/crs/bin/crsctl stop crs
b. Run the shell script. located at:
/oracle/product/10.2.0/crs/install/root102.sh
This script. will automatically start the CRS daemons on the
patched node upon completion.
3. After completing this procedure, proceed to the next node and repeat.
[root@ordb2 ~]# /oracle/product/10.2.0/crs/bin/crsctl stop crs
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
[root@ordb2 ~]# /oracle/product/10.2.0/crs/install/root102.sh
Creating pre-patch directory for saving pre-patch clusterware files
Completed patching clusterware files to /oracle/product/10.2.0/crs
Relinking some shared libraries.
Relinking of patched files is complete.
WARNING: directory '/oracle/product/10.2.0' is not owned by root
WARNING: directory '/oracle/product' is not owned by root
WARNING: directory '/oracle' is not owned by root
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
/etc/profile: line 55: ulimit: max user processes: cannot modify limit: Operation not permitted
Starting up the CRS daemons.
Waiting for the patched CRS daemons to start.
This may take a while on some systems.
.
10205 patch successfully applied.
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully deleted 1 values from OCR.
Successfully deleted 1 keys from OCR.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node :
node 2: ordb2 ordb2-priv ordb2
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
clscfg -upgrade completed successfully
Creating '/oracle/product/10.2.0/crs/install/paramfile.crs' with data used for CRS configuration
Setting CRS configuration values in /oracle/product/10.2.0/crs/install/paramfile.crs
[oracle@ordb1 ~]$ crsctl query crs softwareversion
CRS software version on node [ordb1] is [10.2.0.5.0]
[oracle@ordb1 ~]$ crsctl query crs activeversion
CRS active version on the cluster is [10.2.0.5.0]
[oracle@ordb2 ~]$ crsctl query crs activeversion
CRS active version on the cluster is [10.2.0.5.0]
[oracle@ordb2 ~]$ crsctl query crs softwareversion
CRS software version on node [ordb2] is [10.2.0.5.0]
第二部分：資料庫軟體升級
升級前版本：
select comp_name,version,status from dba_registry;
COMP_NAME VERSION STATUS
------------------------------ ------------ ----------------------
Oracle Database Catalog Views 10.2.0.1.0 VALID
Oracle Database Packages and T 10.2.0.1.0 VALID
ypes
Oracle Workspace Manager 10.2.0.1.0 VALID
JServer JAVA Virtual Machine 10.2.0.1.0 VALID
Oracle XDK 10.2.0.1.0 VALID
Oracle Database Java Packages 10.2.0.1.0 VALID
Oracle Expression Filter 10.2.0.1.0 VALID
Oracle Data Mining 10.2.0.1.0 VALID
Oracle Text 10.2.0.1.0 VALID
COMP_NAME VERSION STATUS
------------------------------ ------------ ----------------------
Oracle XML Database 10.2.0.1.0 VALID
Oracle Rules Manager 10.2.0.1.0 VALID
Oracle interMedia 10.2.0.1.0 VALID
OLAP Analytic Workspace 10.2.0.1.0 VALID
Oracle OLAP API 10.2.0.1.0 VALID
OLAP Catalog 10.2.0.1.0 VALID
Spatial 10.2.0.1.0 VALID
Oracle Enterprise Manager 10.2.0.1.0 VALID
Oracle Real Application Cluste 10.2.0.1.0 VALID
關閉dbconsole,isqlplus,asm,資料庫
節點1：
emctl stop dbconsole
isqlplusctl stop
節點2:
emctl stop dbconsole
isqlplusctl stop
節點1：
srvctl stop instance -d orcl -i orcl1
srvctl stop instance -d orcl -i orcl2
srvctl stop asm -n ordb1
srvctl stop asm -n ordb2
srvctl stop nodeapps -n ordb1
srvctl stop nodeapps -n ordb2
升級節點ORACLE軟體
./ruinstaller
[root@ordb2 ~]# sh /oracle/product/10.2.0/db_1/root.sh
Running Oracle 10g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /oracle/product/10.2.0/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying coraenv to /usr/local/bin ...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
srvctl start nodeapps -n ordb1
srvctl start nodeapps -n ordb2
srvctl start asm -n ordb1
srvctl start asm -n ordb2
[oracle@ordb1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application OFFLINE OFFLINE
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE ordb1
ora....B1.lsnr application ONLINE ONLINE ordb1
ora.ordb1.gsd application ONLINE ONLINE ordb1
ora.ordb1.ons application ONLINE ONLINE ordb1
ora.ordb1.vip application ONLINE ONLINE ordb1
ora....SM2.asm application ONLINE ONLINE ordb2
ora....B2.lsnr application ONLINE ONLINE ordb2
ora.ordb2.gsd application ONLINE ONLINE ordb2
ora.ordb2.ons application ONLINE ONLINE ordb2
ora.ordb2.vip application ONLINE ONLINE ordb2
Oracle Database 10.2 Upgrade Status Utility 03-16-2011 09:39:53
.
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.5.0 00:07:47
JServer JAVA Virtual Machine VALID 10.2.0.5.0 00:02:19
Oracle XDK VALID 10.2.0.5.0 00:00:40
Oracle Database Java Packages INVALID 10.2.0.5.0 00:00:54
Oracle Text VALID 10.2.0.5.0 00:00:33
Oracle XML Database VALID 10.2.0.5.0 00:01:35
Oracle Real Application Clusters VALID 10.2.0.5.0 00:00:02
Oracle Workspace Manager VALID 10.2.0.5.0 00:00:04
Oracle Data Mining VALID 10.2.0.5.0 00:00:33
OLAP Analytic Workspace VALID 10.2.0.5.0 00:00:19
OLAP Catalog VALID 10.2.0.5.0 00:00:56
Oracle OLAP API VALID 10.2.0.5.0 00:01:45
Oracle interMedia VALID 10.2.0.5.0 00:05:34
Oracle Expression Filter VALID 10.2.0.5.0 00:00:54
Spatial VALID 10.2.0.5.0 00:00:41
Oracle Rule Manager VALID 10.2.0.5.0 00:00:05
Oracle Enterprise Manager VALID 10.2.0.5.0 00:00:07
.
Oracle Database 10.2 Upgrade Status Utility 03-16-2011 09:39:53
.
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.5.0 00:07:47
JServer JAVA Virtual Machine VALID 10.2.0.5.0 00:02:19
Oracle XDK VALID 10.2.0.5.0 00:00:40
Oracle Database Java Packages VALID 10.2.0.5.0 00:00:54
Oracle Text VALID 10.2.0.5.0 00:00:33
Oracle XML Database VALID 10.2.0.5.0 00:01:35
Oracle Real Application Clusters VALID 10.2.0.5.0 00:00:02
Oracle Workspace Manager VALID 10.2.0.5.0 00:00:04
Oracle Data Mining VALID 10.2.0.5.0 00:00:33
OLAP Analytic Workspace VALID 10.2.0.5.0 00:00:19
OLAP Catalog VALID 10.2.0.5.0 00:00:56
Oracle OLAP API VALID 10.2.0.5.0 00:01:45
Oracle interMedia VALID 10.2.0.5.0 00:05:34
Oracle Expression Filter VALID 10.2.0.5.0 00:00:54
Spatial VALID 10.2.0.5.0 00:00:41
Oracle Rule Manager VALID 10.2.0.5.0 00:00:05
Oracle Enterprise Manager VALID 10.2.0.5.0 00:00:07
.
Total Upgrade Time: 00:24:50
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> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1272600 bytes
Variable Size 155190504 bytes
Database Buffers 8388608 bytes
Redo Buffers 2920448 bytes
Database mounted.
Database opened.
如果升級完成後有無效元件，可以參考以下文件:
metalink 原文：
After upgrade CATPROC and CATALOG comps are INVALID even if only user invalid objects are found [ID 745183.1]
Oracle Rac 10.2.0.1升級至10.2.0.5
升級叢集件-滾動升級
升級資料庫軟體-停用後升級
升級資料庫
第一部分：叢集件滾動升級$CRS_HOME
1、系統環境
作業系統版本
[root@ordb1 ~]# uname -a
Linux ordb1 2.6.9-55.ELsmp #1 SMP Fri Apr 20 17:03:35 EDT 2007 i686 i686 i386 GNU/Linux
CRS版本
[oracle@ordb1 ~]$ crsctl query crs softwareversion
CRS software version on node [ordb1] is [10.2.0.1.0]
[oracle@ordb1 ~]$ crsctl query crs activeversion
CRS active version on the cluster is [10.2.0.1.0]
資料庫版本：
[oracle@ordb2 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Mar 15 09:47:45 2011
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
SQL> select * from gv$version;
INST_ID BANNER
---------- ----------------------------------------------------------------
2 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
2 PL/SQL Release 10.2.0.1.0 - Production
2 CORE 10.2.0.1.0 Production
2 TNS for Linux: Version 10.2.0.1.0 - Production
2 NLSRTL Version 10.2.0.1.0 - Production
1 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
1 PL/SQL Release 10.2.0.1.0 - Production
1 CORE 10.2.0.1.0 Production
1 TNS for Linux: Version 10.2.0.1.0 - Production
1 NLSRTL Version 10.2.0.1.0 - Production
10 rows selected.
叢集狀態
[oracle@ordb1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application ONLINE ONLINE ordb2
ora....l1.inst application ONLINE ONLINE ordb1
ora....l2.inst application ONLINE ONLINE ordb2
ora....SM1.asm application ONLINE ONLINE ordb1
ora....B1.lsnr application ONLINE ONLINE ordb1
ora.ordb1.gsd application ONLINE ONLINE ordb1
ora.ordb1.ons application ONLINE ONLINE ordb1
ora.ordb1.vip application ONLINE ONLINE ordb1
ora....SM2.asm application ONLINE ONLINE ordb2
ora....B2.lsnr application ONLINE ONLINE ordb2
ora.ordb2.gsd application ONLINE ONLINE ordb2
ora.ordb2.ons application ONLINE ONLINE ordb2
ora.ordb2.vip application ONLINE ONLINE ordb2
關閉節點1
$ emctl stop dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
Stopping Oracle Enterprise Manager 10g Database Control ...
... Stopped.
$ isqlplusctl stop
iSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle. All rights reserved.
getnameinfo failed
iSQL*Plus instance on port 5560 is not running ...
srvctl stop instance -d orcl -i orcl1
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application ONLINE ONLINE ordb2
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application ONLINE ONLINE ordb2
ora....SM1.asm application ONLINE ONLINE ordb1
ora....B1.lsnr application ONLINE ONLINE ordb1
ora.ordb1.gsd application ONLINE ONLINE ordb1
ora.ordb1.ons application ONLINE ONLINE ordb1
ora.ordb1.vip application ONLINE ONLINE ordb1
ora....SM2.asm application ONLINE ONLINE ordb2
ora....B2.lsnr application ONLINE ONLINE ordb2
ora.ordb2.gsd application ONLINE ONLINE ordb2
ora.ordb2.ons application ONLINE ONLINE ordb2
ora.ordb2.vip application ONLINE ONLINE ordb2
srvctl stop asm -n orcl1
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application ONLINE ONLINE ordb2
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application ONLINE ONLINE ordb2
ora....SM1.asm application OFFLINE OFFLINE
ora....B1.lsnr application ONLINE ONLINE ordb1
ora.ordb1.gsd application ONLINE ONLINE ordb1
ora.ordb1.ons application ONLINE ONLINE ordb1
ora.ordb1.vip application ONLINE ONLINE ordb1
ora....SM2.asm application ONLINE ONLINE ordb2
ora....B2.lsnr application ONLINE ONLINE ordb2
ora.ordb2.gsd application ONLINE ONLINE ordb2
ora.ordb2.ons application ONLINE ONLINE ordb2
ora.ordb2.vip application ONLINE ONLINE ordb2
srvctl stop nodeapps -n ordb1
[oracle@ordb1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application ONLINE ONLINE ordb2
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application ONLINE ONLINE ordb2
ora....SM1.asm application OFFLINE OFFLINE
ora....B1.lsnr application OFFLINE OFFLINE
ora.ordb1.gsd application OFFLINE OFFLINE
ora.ordb1.ons application OFFLINE OFFLINE
ora.ordb1.vip application OFFLINE OFFLINE
ora....SM2.asm application ONLINE ONLINE ordb2
ora....B2.lsnr application ONLINE ONLINE ordb2
ora.ordb2.gsd application ONLINE ONLINE ordb2
ora.ordb2.ons application ONLINE ONLINE ordb2
ora.ordb2.vip application ONLINE ONLINE ordb2
升級節點1 CRS
./ruinstaller
The installer has detected that your Cluster Ready Services (CRS) installation is distributed across the following nodes:
ordb1
ordb2
Because the software consists of local identical copies distributed across each of the nodes in the cluster, it is possible to patch your CRS installation in a rolling manner, one node at a time.
To complete the installation of this patchset, you must perform. the following tasks on each node:
1. Log in as the root user.
2. As the root user, perform. the following tasks:
a. Shutdown the CRS daemons by issuing the following command:
/oracle/product/10.2.0/crs/bin/crsctl stop crs
b. Run the shell script. located at:
/oracle/product/10.2.0/crs/install/root102.sh
This script. will automatically start the CRS daemons on the
patched node upon completion.
3. After completing this procedure, proceed to the next node and repeat.
[root@ordb2 ~]# /oracle/product/10.2.0/crs/bin/crsctl stop crs
Stopping resources.
Successfully stopped CRS resources
Stopping CSSD.
Shutting down CSS daemon.
Shutdown request successfully issued.
[root@ordb2 ~]# /oracle/product/10.2.0/crs/install/root102.sh
Creating pre-patch directory for saving pre-patch clusterware files
Completed patching clusterware files to /oracle/product/10.2.0/crs
Relinking some shared libraries.
Relinking of patched files is complete.
WARNING: directory '/oracle/product/10.2.0' is not owned by root
WARNING: directory '/oracle/product' is not owned by root
WARNING: directory '/oracle' is not owned by root
Preparing to recopy patched init and RC scripts.
Recopying init and RC scripts.
Startup will be queued to init within 30 seconds.
/etc/profile: line 55: ulimit: max user processes: cannot modify limit: Operation not permitted
Starting up the CRS daemons.
Waiting for the patched CRS daemons to start.
This may take a while on some systems.
.
10205 patch successfully applied.
clscfg: EXISTING configuration version 3 detected.
clscfg: version 3 is 10G Release 2.
Successfully deleted 1 values from OCR.
Successfully deleted 1 keys from OCR.
Successfully accumulated necessary OCR keys.
Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.
node :
node 2: ordb2 ordb2-priv ordb2
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
clscfg -upgrade completed successfully
Creating '/oracle/product/10.2.0/crs/install/paramfile.crs' with data used for CRS configuration
Setting CRS configuration values in /oracle/product/10.2.0/crs/install/paramfile.crs
[oracle@ordb1 ~]$ crsctl query crs softwareversion
CRS software version on node [ordb1] is [10.2.0.5.0]
[oracle@ordb1 ~]$ crsctl query crs activeversion
CRS active version on the cluster is [10.2.0.5.0]
[oracle@ordb2 ~]$ crsctl query crs activeversion
CRS active version on the cluster is [10.2.0.5.0]
[oracle@ordb2 ~]$ crsctl query crs softwareversion
CRS software version on node [ordb2] is [10.2.0.5.0]
第二部分：資料庫軟體升級
升級前版本：
select comp_name,version,status from dba_registry;
COMP_NAME VERSION STATUS
------------------------------ ------------ ----------------------
Oracle Database Catalog Views 10.2.0.1.0 VALID
Oracle Database Packages and T 10.2.0.1.0 VALID
ypes
Oracle Workspace Manager 10.2.0.1.0 VALID
JServer JAVA Virtual Machine 10.2.0.1.0 VALID
Oracle XDK 10.2.0.1.0 VALID
Oracle Database Java Packages 10.2.0.1.0 VALID
Oracle Expression Filter 10.2.0.1.0 VALID
Oracle Data Mining 10.2.0.1.0 VALID
Oracle Text 10.2.0.1.0 VALID
COMP_NAME VERSION STATUS
------------------------------ ------------ ----------------------
Oracle XML Database 10.2.0.1.0 VALID
Oracle Rules Manager 10.2.0.1.0 VALID
Oracle interMedia 10.2.0.1.0 VALID
OLAP Analytic Workspace 10.2.0.1.0 VALID
Oracle OLAP API 10.2.0.1.0 VALID
OLAP Catalog 10.2.0.1.0 VALID
Spatial 10.2.0.1.0 VALID
Oracle Enterprise Manager 10.2.0.1.0 VALID
Oracle Real Application Cluste 10.2.0.1.0 VALID
關閉dbconsole,isqlplus,asm,資料庫
節點1：
emctl stop dbconsole
isqlplusctl stop
節點2:
emctl stop dbconsole
isqlplusctl stop
節點1：
srvctl stop instance -d orcl -i orcl1
srvctl stop instance -d orcl -i orcl2
srvctl stop asm -n ordb1
srvctl stop asm -n ordb2
srvctl stop nodeapps -n ordb1
srvctl stop nodeapps -n ordb2
升級節點ORACLE軟體
./ruinstaller
[root@ordb2 ~]# sh /oracle/product/10.2.0/db_1/root.sh
Running Oracle 10g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /oracle/product/10.2.0/db_1
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying dbhome to /usr/local/bin ...
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying coraenv to /usr/local/bin ...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
srvctl start nodeapps -n ordb1
srvctl start nodeapps -n ordb2
srvctl start asm -n ordb1
srvctl start asm -n ordb2
[oracle@ordb1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application OFFLINE OFFLINE
ora....l1.inst application OFFLINE OFFLINE
ora....l2.inst application OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE ordb1
ora....B1.lsnr application ONLINE ONLINE ordb1
ora.ordb1.gsd application ONLINE ONLINE ordb1
ora.ordb1.ons application ONLINE ONLINE ordb1
ora.ordb1.vip application ONLINE ONLINE ordb1
ora....SM2.asm application ONLINE ONLINE ordb2
ora....B2.lsnr application ONLINE ONLINE ordb2
ora.ordb2.gsd application ONLINE ONLINE ordb2
ora.ordb2.ons application ONLINE ONLINE ordb2
ora.ordb2.vip application ONLINE ONLINE ordb2
Oracle Database 10.2 Upgrade Status Utility 03-16-2011 09:39:53
.
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.5.0 00:07:47
JServer JAVA Virtual Machine VALID 10.2.0.5.0 00:02:19
Oracle XDK VALID 10.2.0.5.0 00:00:40
Oracle Database Java Packages INVALID 10.2.0.5.0 00:00:54
Oracle Text VALID 10.2.0.5.0 00:00:33
Oracle XML Database VALID 10.2.0.5.0 00:01:35
Oracle Real Application Clusters VALID 10.2.0.5.0 00:00:02
Oracle Workspace Manager VALID 10.2.0.5.0 00:00:04
Oracle Data Mining VALID 10.2.0.5.0 00:00:33
OLAP Analytic Workspace VALID 10.2.0.5.0 00:00:19
OLAP Catalog VALID 10.2.0.5.0 00:00:56
Oracle OLAP API VALID 10.2.0.5.0 00:01:45
Oracle interMedia VALID 10.2.0.5.0 00:05:34
Oracle Expression Filter VALID 10.2.0.5.0 00:00:54
Spatial VALID 10.2.0.5.0 00:00:41
Oracle Rule Manager VALID 10.2.0.5.0 00:00:05
Oracle Enterprise Manager VALID 10.2.0.5.0 00:00:07
.
Oracle Database 10.2 Upgrade Status Utility 03-16-2011 09:39:53
.
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.5.0 00:07:47
JServer JAVA Virtual Machine VALID 10.2.0.5.0 00:02:19
Oracle XDK VALID 10.2.0.5.0 00:00:40
Oracle Database Java Packages VALID 10.2.0.5.0 00:00:54
Oracle Text VALID 10.2.0.5.0 00:00:33
Oracle XML Database VALID 10.2.0.5.0 00:01:35
Oracle Real Application Clusters VALID 10.2.0.5.0 00:00:02
Oracle Workspace Manager VALID 10.2.0.5.0 00:00:04
Oracle Data Mining VALID 10.2.0.5.0 00:00:33
OLAP Analytic Workspace VALID 10.2.0.5.0 00:00:19
OLAP Catalog VALID 10.2.0.5.0 00:00:56
Oracle OLAP API VALID 10.2.0.5.0 00:01:45
Oracle interMedia VALID 10.2.0.5.0 00:05:34
Oracle Expression Filter VALID 10.2.0.5.0 00:00:54
Spatial VALID 10.2.0.5.0 00:00:41
Oracle Rule Manager VALID 10.2.0.5.0 00:00:05
Oracle Enterprise Manager VALID 10.2.0.5.0 00:00:07
.
Total Upgrade Time: 00:24:50
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> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 1272600 bytes
Variable Size 155190504 bytes
Database Buffers 8388608 bytes
Redo Buffers 2920448 bytes
Database mounted.
Database opened.
如果升級完成後有無效元件，可以參考以下文件:
metalink 原文：
After upgrade CATPROC and CATALOG comps are INVALID even if only user invalid objects are found [ID 745183.1]
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/31520497/viewspace-2156768/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- ORACLE10G 10.2.0.1升級到10.2.0.5Oracle
- oracle rac 10.2.0.1 升級到 oracle 10.2.0.4Oracle
- 10.2.0.1安裝並升級到10.2.0.5
- oracle 10.2.0.1 rac 升級到10.2.0.4 rac時，dbua升級的元件列表Oracle元件
- oracle 10.2.0.4 rac 升級到oracle 10.2.0.5 rac步驟Oracle
- Oracle10.2.0.1RAC 升級 Oracle10.2.0.5案例分享 -DATABASE篇OracleDatabase
- Oracle10.2.0.1RAC 升級 Oracle10.2.0.5案例分享 -CRS篇Oracle
- Oracle 10g rac升級(10.2.0.1 Rac到10.2.0.4)Oracle 10g
- Oracle10g RAC : 10.2.0.1 升級到 10.2.0.4Oracle
- 從10.2.0.1升級到10.2.0.5操作實驗（下）
- 從10.2.0.1升級到10.2.0.5操作實驗（上）
- RAC資料庫升級到10.2.0.5資料庫
- Oracle 10.2.0.1 升級到 10.2.0.4Oracle
- linux下oracle RAC10.2.0.1升級到10.2.0.4LinuxOracle
- (轉)Oracle 10.2.0.1 升級到 10.2.0.4Oracle
- 9.2.0.4 升級到10.2.0.5升級後 Oracle Ultra Search 元件NO SCRIPTOracle元件
- Oracle RAC 10.2.0.5升級到11.2.0.4遇到的問題Oracle
- 升級Oracle10.2.0.1Oracle
- Oracle RAC 10.2.0.1 升級 10.2.0.4 簡單描述Oracle
- Oracle RAC ASM 例項 從10.2.0.1 升級到 10.2.0.4 說明OracleASM
- Oracle 10.2.0.1 升級到 10.2.0.4--轉載Oracle
- windows 下oracle從10.2.0.1升級到10.2.0.4WindowsOracle
- windows環境下oracle 10.2.0.2升級到10.2.0.5WindowsOracle
- Oracle 10.2.0.5升級至11.2.0.4Oracle
- oracle 之 安裝10.2.0.1 且 升級到 10.2.0.4Oracle
- 用dbua實現oracle 9.2.0.8到10.2.0.1的升級Oracle
- windows 2003,oracle 10.2.0.1升級到10.2.0.4WindowsOracle
- RHEL4.4下oracle10.2.0.1升級到10.2.0.3Oracle
- Redhat 5.4 Orcle RAC 資料庫 從10.2.0.1升級到 10.2.0.4Redhat資料庫
- Oracle database 升級（文件）to 10.2.0.4 from 10.2.0.1OracleDatabase
- Oracle10.2.0.1 升級到Oracle10.2.0.4 簡單步驟Oracle
- linux平臺下oracle從10.2.0.1升級到10.2.0.4LinuxOracle
- oracle 10g rac升級Oracle 10g
- Oracle10g RAC 資料庫升級為10.2.0.4 ，clusterware需要升級到10.2.0.4 ？Oracle資料庫
- 靜默升級oracle（文件）to 10.2.0.4 from 10.2.0.1Oracle
- oracle在linux平臺從10.2.0.1升級到10.2.0.4方法OracleLinux
- RAC 資料庫升級 10.2.0.1.0 到 10.2.0.2.0 之升級catalog資料庫
- oracle rac 11.2.0.3 升級到11.2.0.4Oracle