ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle 升级数据库 10.2.04

oracle 升级数据库 10.2.04

原创 Linux操作系统 作者:gdd714 时间:2012-07-13 10:08:40 0 删除 编辑

下面是步骤,费时约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

$ srvctl start service -d db_name -s service_name


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8837988/viewspace-735362/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2012-03-25

  • 博文量
    3
  • 访问量
    2910