oracle 升级数据库 10.2.04-CSDN博客

下面是步骤，费时约2小时。升级之前要备份：数据库，CRS_HOME, RAC_HOME, OCR,Voteing disk.

A,pre_install task
Step1:
check Oracle Time Zone Definitions in each database,update if necessary.
step 2 :
stop all processes:
$ emctl stop dbconsole
$ isqlplusctl stop
$ srvctl stop service -d db_name [-s service_name_list [-i inst_name]]
$ srvctl stop database -d db_name$ srvctl stop asm -n node
# srvctl stop nodeapps -n node
# CRS_home/bin/crsctl stop crs
$srvctl stop listener -n node [-l listenername]

B.Installation Tasks
Step1:
1) patch clusterware from node1 (should be initial install node), login as oracle
export $ORACLE_HOME=/u01/app/oracle/product/10.2.0/crs
./runInstaller
$ORACLE_HOME/root.sh on each node
$ORACLE_HOME/install/root102.sh on each node
Step2:
2) patch oracle rac from node1,login as oracle
export $ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
./runInstaller
$ORACLE_HOME/root.sh on each node

C.Postinstallation Tasks
Step1: Run the Pre-Upgrade Information Tool
SQL> STARTUP UPGRADE
SQL> SPOOL upgrade_info.log
SQL> @?/rdbms/admin/utlu102i.sql
SQL> SPOOL OFF
Check the output
(one of our db is hung when execute utlu102i.sql,after validate some of invalid objects , still huang. ignore this step, contunue next step)

Step2: Upgrading Database

$ srvctl start listener -n node
$ svrctl start ams -n node
export ORACLE_SID=XXX
$ 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
Review the patch.log ,If necessary, rerun the catupgrd.sql script. after correcting any problems
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
#Re-compile objects
SQL> @?/rdbms/admin/utlrp.sql
SQL> select comp_name, version, status from sys.dba_registry;
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=spfile;
SQL> SHUTDOWN
SQL> STARTUP