ORACLE10g102010升级102040已经测试可用.doc

参考 /zyhzsz1/blog/item/79d884fc47878f1f09244d8a.html/2010/03/12/oracle-10-2-0-1%e9%9d%99%e9%bb%98%e5%8d%87%e7%ba%a7%e8%87%b310-2-0-4linux//zhou_zhou/archive/2009/10/07/oracle_patch.html一、root 用户任务unzip p6810189_10204_Linux-x86.ziprootclient1 oracle# chown oracle.oinstall -R Disk1/2、 oracle用户oracleclient1 $ env | grep ORACLEORACLE_SID=mydbORACLE_BASE=/usr/local/oracleORACLE_HOME=/usr/local/oracle/db_1SQL select * from v$version;获取版本信息BANNER-Oracle Database 10g Enterprise Edition Release .0 - 64biPL/SQL Release .0 - ProductionCORE .0 ProductionTNS for Linux: Version .0 - ProductionNLSRTL Version .0 - ProductionSQL select name from v$datafile;获取数据文件信息NAME-/usr/local/oracle/oradata/orcl10g/system01.dbf/usr/local/oracle/oradata/orcl10g/undotbs01.dbf/usr/local/oracle/oradata/orcl10g/sysaux01.dbf/usr/local/oracle/oradata/orcl10g/users01.dbfSQL select member from v$logfile;获取日志文件信息MEMBER-/usr/local/oracle/oradata/orcl10g/redo03.log/usr/local/oracle/oradata/orcl10g/redo02.log/usr/local/oracle/oradata/orcl10g/redo01.logSQL select name from v$controlfile;控制文件信息NAME-/usr/local/oracle/oradata/orcl10g/control01.ctl/usr/local/oracle/oradata/orcl10g/control02.ctl/usr/local/oracle/oradata/orcl10g/control03.ctlSQL archive log list 归档模式信息Database log mode No Archive ModeAutomatic archival DisabledArchive destination USE_DB_RECOVERY_FILE_DESTOldest online log sequence 3Current log sequence 51. 停止数据库以及相关服务oracleclient1 $ emctl stop dbconsole2. TZ set to US/Eastern3. OC4J Configuration issue. /usr/local/oracle/db_1/oc4j/j2ee/OC4J_DBConsole_client1_mydb not found. 4. oracleclient1 $ isqlplusctl stop5. iSQL*Plus .06. Copyright (c) 2003, 2005, Oracle. All rights reserved.7. getnameinfo failed8. iSQL*Plus instance on port 5560 is not running .9. oracleclient1 $ lsnrctl stop10.11. LSNRCTL for Linux: Version .0 - Production on 15-JUL-2011 15:41:1912.13. Copyright (c) 1991, 2005, Oracle. All rights reserved.14.15. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=client1)(PORT=1521)16. The command completed successfullysqlplus / as sysdbaSQL shutdown immediate（这个要关掉库要不然进程还在，安装不过去）17. Database closed.18. Database dismounted.19. ORACLE instance shut down.2. 冷备数据库备份 数据 日志 控制rootclient1 oracle# cd /usr/local/oracle/oradata/rootclient1 oradata# cp -a orcl10g/ backrootclient1 oradata# ls 多出一个备份的目录back(900M)back orcl10g备份 口令文件、spfileoraclelocalhost back$ cd /usr/local/oracle/db_1/dbs/rootclient1 dbs# cp -a orapworcl /usr/local/oracle/oradata/back/rootclient1 dbs# cp -a spfileorcl.ora /usr/local/oracle/oradata/back/3.配置并运行安装脚本3.1此处采用静默安装rootclient1 oracle# cd Disk1/rootclient1 Disk1# cd response/rootclient1 response# cp -a patchset.rsp patchset.rsp.old (-a复制保留原来文件同样的所有属性)=相关路径一定要对 否则会报OUI-10203错误oraclelocalhost response$ vi patchset.rsp模板中修改如下选项，其它保持不变：UNIX_GROUP_NAME=oinstall安装用户组FROM_LOCATION=/orapatch/Disk1/stage/products.xmlpatch包的products.xml路径ORACLE_HOME=/usr/local/oracle/db_1ORACLE_HOME_NAME=OraDb10g_home1确认ORACLE_HOME_NAME选项稍微麻烦点，ORACLE_HOME_NAME可以从/usr/local/oracle/oraInventory/ContentsXML/inventory.xml文件中 HOME NAME获取得出我的是less /usr/local/oracle/oraInventory/ContentsXML/inventory.xml# less /usr/local/oracle/oraInventory/ContentsXML/inventory.xml找到此处的OraDbHome1就是上面ORACLE_HOME_NAME选项的值。=3.1.2 运行脚本$ cd /opt/Disk1oracleclient1 Disk1$ ./runInstaller -silent -responseFile /home/oracle/Disk1/response/patchset.rsp3.1.3 以root身份运行rootclient1 # /usr/local/oracle/db_1/root.sh 一直按y覆盖原来文件4. 手工升级数据库5. rootclient1 # su - oracle6. oracleclient1 $ env | grep ORACLE 7. ORACLE_SID=mydb8. ORACLE_BASE=/usr/local/oracle9. ORACLE_HOME=/usr/local/oracle/db_1以oracle用户登陆打开终端，设置好环境变量$ORACLE_HOME，$ORACLE_SID，$PATH4.2运行utlu102i.sql 和 catupgrd.sql脚本4.2.1.启动数据库的upgrade 模式oraclelocalhost bin$ sqlplus as sysdba SQL*Plus: Release .0 - Production on Sat Jul 16 11:17:25 2011Copyright (c) 1982, 2007, Oracle. All Rights Reserved.SQL SQL startup upgrade;ORACLE instance started.Total System Global Area 591396864 bytesFixed Size 2085712 bytesVariable Size 180358320 bytesDatabase Buffers 402653184 bytesRedo Buffers 6299648 bytesDatabase mounted.Database opened.4.2.2.设置日志SQLSPOOL upgrade_info.log4.2.3.运行升级前信息工具SQL ?/rdbms/admin/utlu102i.sqlOracle Database 10.2 Upgrade Information Utility 07-16-2011 10:15:49.*Database:*- name: ORCL10G- version: .0- compatible: .0- blocksize: 8192.*Tablespaces: make adjustments in the current environment*- SYSTEM tablespace is adequate for the upgrade. minimum required size: 485 MB. AUTOEXTEND additional space required: 15 MB- UNDOTBS1 tablespace is adequate for the upgrade. minimum required size: 402 MB. AUTOEXTEND additional space required: 377 MB- SYSAUX tablespace is adequate for the upgrade. minimum required size: 245 MB. AUTOEXTEND additional space required: 15 MB- TEMP tablespace is adequate for the upgrade. minimum required size: 58 MB. AUTOEXTEND additional space required: 38 MB.*Update Parameters: Update Oracle Database 10.2 init.ora or spfile*- No update parameter changes are required.*Renamed Parameters: Update Oracle Database 10.2 init.ora or spfile*- No renamed parameters found. No changes are required.*Obsolete/Deprecated Parameters: Update Oracle Database 10.2 init.ora or spfile*- No obsolete parameters found. No changes are required.*Components: The following database components will be upgraded or installed*- Oracle Catalog Views upgrade VALID- Oracle Packages and Types upgrade VALID- JServer JAVA Virtual Machine upgrade VALID- Oracle XDK for Java upgrade VALID- Oracle Java Packages upgrade VALID- Oracle Text upgrade VALID- Oracle XML Database upgrade VALID- Oracle Workspace Manager upgrade VALID- Oracle Data Mining upgrade VALID- OLAP Analytic Workspace upgrade VALID- OLAP Catalog upgrade VALID- Oracle OLAP API upgrade VALID- Oracle interMedia upgrade VALID- Spatial upgrade VALID- Expression Filter upgrade VALID- EM Repository upgrade VALID- Rule Manager upgrade VALID.PL/SQL procedure successfully completed.4.2.4.关闭日志输出SQL SPOOL OFF4.2.5启动监听lsnrctl start4.26.运行catupgrd.sql脚本SQL SPOOL patch.logSQL ?/rdbms/admin/catupgrd.sql如果这一步顺利执行，升级已经完成了大半。(这里要等待比较长一段时间) 如图SQL SPOOL OFF4.2.6.检查path.log中的错误 如果有错误重新运行catupgrd.sqlSQL SHUTDOWN IMMEDIATESQL STARTUP6. 重新编译无效的对象SQL ?/rdbms/admin/utlrp.sql耐心等待，直至完毕，出现sql7.检查组件的升级情况SQLselect * from UTL_RECOMP_ERRORS; SQL col comp_name format a30SQL col version format a20SQL col status format a20SQL set line 200SQL select comp_name, version, status from sys.dba_registry;显示值为VALID，则成功完成升级。如下显示COMP_NAME VERSION STATUS- - -Oracle Database Catalog Views .0 VALIDOracle Database Packages and T .0 VALIDypesOracle Workspace Manager .3 VALIDJServer JAVA Virtual Machine .0 VALIDOracle XDK .0 VALIDOracle Database Java Packages .0 VALIDOracle Expression Filter .0 VALIDOracle Data Mining .0 VALIDOracle Text .0 VALIDOracle XML Database .0 VALIDOracle Rule Manager .0 VALIDOracle interMedia .0 VALIDOLAP Analytic Workspace .0 VALIDOracle OLAP API .0 VALIDOLAP Catalog .0 VALIDSpatial .0 VALIDOracle Enterprise Manager .0 VALIDSQL 另：最好查看下。SQL select tablespace_name,status from dba_tablespaces;TABLESPACE_NAME STATUS