oracle10.2.04升级日志

oracle数据库升级过程以及问题处理，升级过程很坎坷，但最后得出心得：

1、注意文件系统的空间，不然要吃大亏

2、仔细阅读升级包中的升级文档说明，不然傻13

一、停止应用服务器

二、停oracle服务以及crs

su - oracle shutdown immediate; lsnrctl stop crsctl stop crs

 

三、停止hacmp

通过smitty hacmp停止

 

四、检查HA启动配置

停hacmp

XXX工程师在处理磁盘检查后，发现oracle启动出现故障，crs不能正常启动 通过ocrcheck检查，发现裸设备文件权限被修改，处理过程： chown -R oracle:dba control01_512m chown -R oracle:dba control02_512m chown -R oracle:dba control03_512m chown -R oracle:dba archivelv chown -R oracle:dba ncocr_1g chown -R oracle:dba ncspfile chown -R oracle:dba ncvote_1g chown -R oracle:dba xx_data01_50g chown -R oracle:dba xx_data01b_50g chown -R oracle:dba xxx_data01c_30g chown -R oracle:dba xxx_data02_50g chown -R oracle:dba xxx_data02c_30g chown -R oracle:dba xxx_data03_50g chown -R oracle:dba xxx_data03c_30g chown -R oracle:dba xxx_index01c_30 chown -R oracle:dba xxx_index02c_30 chown -R oracle:dba xxx_index03c_30 chown -R oracle:dba xxxindex01_50g chown -R oracle:dba xxxindex02_50g chown -R oracle:dba xxxindex03_50g

 

 

三、备份oracle下的所有文件

tar –cvf oracle.tar oracle

 

四、上传p6810189_10204_AIX5L.zip至数据库服务器

unzip -x p6810189_10204_AIX5L.zip 若无unzip则在补丁包\Disk1\install中有unzip工具，将其赋权限link至/usr/bin

ORACLE升级过程

1、升级CRS（CRS于DB升级在一个补丁包中，启动runInstall后需选择crs安装目录）

执行：/usr/sbin/slibclean oracle升级前会检测 Has '/usr/sbin/slibclean' been run by root? 升级过程中出现 问题：OUI-35000 处理：建立信任机制，在A机的主目录建立.rhosts文件       itdb2 　　  在B机的主目录建立.rhosts文件 itdb1

 

CRS升级后执行如下：

1.  On each node, do the following:         a.  Log in as the root user.         b.  As root, shutdown the CRS daemons on the node             using the following command:                 /oracle/crs_1/bin/crsctl stop crs         Repeat this step until the CRS daemons on all the nodes are shutdown.       2.  After all the CRS daemons on all the nodes are shutdown,         run the shell script. located at:             /oracle/crs_1/install/root102.sh         This script. will automatically start the CRS daemons on the         patched node upon completion.       3.  Wait until the script. finishes and then proceed to the          next node and repeat step 2. 出错提示： Error : Please change the CRS_ORACLE_USER id to have the following OS capabilities :   < CAP_PROPAGATE CAP_BYPASS_RAC_VMM CAP_NUMA_ATTACH > by running command then 'crsctl stop crs' and 'crsctl start crs'. The CSS daemon, ocssd.bin, will not run in realtime without  this change Oracle strongly recommends that the CSS daemon run realtime Creating pre-patch directory for saving pre-patch clusterware files 解决方法：/usr/sbin/lsuser -a capabilities oracle  /usr/bin/chuser capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle

检查CRS升级结果：

Completed patching clusterware files to /oracle/crs_1 Relinking some shared libraries. Relinking of patched files is complete. 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. Starting up the CRS daemons. Adding daemons to inittab Waiting for the patched CRS daemons to start.   This may take a while on some systems. . 10204 patch successfully applied. clscfg: EXISTING configuration version 3 detected. clscfg: version 3 is 10G Release 2. Successfully accumulated necessary OCR keys. Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897. node : node 2: itncdb2 itncdb2-priv itncdb2 Creating OCR keys for user 'root', privgrp 'system'.. Operation successful. clscfg -upgrade completed successfully

 

2、升级oracle

oracle升级过程未出现问题，升级结束后116服务器执行root.sh出现异常 Database Configuration Assistant when a database is created chmod: libclntsh.so: A file or directory in the path name does not exist. chmod: ORACA.COB: A file or directory in the path name does not exist. chmod: ORACA.FOR: A file or directory in the path name does not exist. chmod: BNDDSC.FOR: A file or directory in the path name does not exist. 解决方法：更新116服务器相应库文件

 

3、通过存储过程升级oracle

STARTUP NOMOUNT ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile; SHUTDOWN STARTUP UPGRADE SPOOL patch.log @?/rdbms/admin/catupgrd.sql SPOOL OFF

 

检查升级过程，未出现异常

COMP_TIMESTAMP UPGRD_END  2010-01-16 22:03:30 . Oracle Database 10.2 Upgrade Status Utility           01-16-2010 22:03:30 . Component                                Status         Version  HH:MM:SS Oracle Database Server                    VALID      10.2.0.4.0  00:08:35 JServer JAVA Virtual Machine              VALID      10.2.0.4.0  00:03:31 Oracle XDK                                VALID      10.2.0.4.0  00:00:36 Oracle Database Java Packages             VALID      10.2.0.4.0  00:00:14 Oracle Text                               VALID      10.2.0.4.0  00:00:18 Oracle XML Database                       VALID      10.2.0.4.0  00:01:50 Oracle Real Application Clusters          VALID      10.2.0.4.0  00:00:00 Oracle Workspace Manager                  VALID      10.2.0.4.3  00:00:44 Oracle Data Mining                        VALID      10.2.0.4.0  00:00:19 OLAP Analytic Workspace                   VALID      10.2.0.4.0  00:00:32 OLAP Catalog                              VALID      10.2.0.4.0  00:00:47 Oracle OLAP API                           VALID      10.2.0.4.0  00:00:35 Oracle interMedia                         VALID      10.2.0.4.0  00:02:54 Spatial                                   VALID      10.2.0.4.0  00:01:37 Oracle Expression Filter                  VALID      10.2.0.4.0  00:00:07 Oracle Enterprise Manager                 VALID      10.2.0.4.0  00:02:04 Oracle Rule Manager                       VALID      10.2.0.4.0  00:00:07 . Total Upgrade Time: 00:24:57

 

双节点检查：

登陆116服务器

SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY; COMP_NAME                            VERSION                        STATUS   Oracle Enterprise Manager            10.2.0.4.0                     VALID OLAP Catalog                         10.2.0.4.0                     VALID Spatial                              10.2.0.4.0                     VALID Oracle interMedia                    10.2.0.4.0                     VALID Oracle XML Database                  10.2.0.4.0                     VALID Oracle Text                          10.2.0.4.0                     VALID Oracle Data Mining                   10.2.0.4.0                     VALID Oracle Expression Filter             10.2.0.4.0                     VALID Oracle Rule Manager                  10.2.0.4.0                     VALID               Oracle Workspace Manager            10.2.0.4.3                     VALID Oracle XDK                          10.2.0.4.0                     VALID JServer JAVA Virtual Machine        10.2.0.4.0                     VALID OLAP Analytic Workspace             10.2.0.4.0                     VALID Oracle Real Application Clusters    10.2.0.4.0                     VALID Oracle OLAP API                     10.2.0.4.0                     VALID Oracle Database Java Packages       10.2.0.4.0                     VALID Oracle Database Packages and Types  10.2.0.4.0                     VALID Oracle Database Catalog Views       10.2.0.4.0                     VALID

 

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

转载于:http://blog.itpub.net/795969/viewspace-625406/