oracle 10g 单实例 升级方案文档VIP专享VIP免费

WINXP32bit从10.2.0.1升级到10.2.0.4（单实例）1、安装前的工作1.1、下载升级包地址：ftp://updates.oracle.com/6810189/p6810189_10204_Win32.zip利用迅雷下载并作一个HASH认证，确保其正确下载文件:O:\ROOT\ROOT\ORACLE\p6810189_10204_Win32.zip大小:1034621834字节修改时间:2011年11月10日,11:56:50MD5:AF8818947E1903D008973B9F7CF3DF5BSHA1:97EDE71B760438411022B57A60A897E5911EC8BACRC32:BD7783A91.2检查系统状态检查dba_registry查看oracle组件状态Columncomp_nameformata40Columnversionformata12Columnstatusformata6Selectcomp_name,version,statusfromsys.dba_registry;COMP_NAME----------------------------------------------------VERSIONSTATUS---------------------------------------------------OracleDatabaseCatalogViews10.2.0.1.0VALIDOracleDatabasePackagesandTypes10.2.0.1.0VALIDOracleWorkspaceManager10.2.0.1.0VALIDJServerJAVAVirtualMachine10.2.0.1.0VALIDOracleXDK10.2.0.1.0VALIDOracleDatabaseJavaPackages10.2.0.1.0VALIDOracleExpressionFilter10.2.0.1.0VALIDOracleDataMining10.2.0.1.0VALIDOracleText10.2.0.1.0VALIDOracleXMLDatabase10.2.0.1.0VALIDOracleRulesManager10.2.0.1.0VALIDOracleinterMedia10.2.0.1.0VALIDOLAPAnalyticWorkspace10.2.0.1.0VALIDOracleOLAPAPI10.2.0.1.0VALIDOLAPCatalog10.2.0.1.0VALIDSpatial10.2.0.1.0VALIDOracleEnterpriseManager10.2.0.1.0VALID已选择17行。检查v$version查看系统版本SQL>select*fromv$version;BANNER----------------------------------------------------------------OracleDatabase10gEnterpriseEditionRelease10.2.0.1.0-ProdPL/SQLRelease10.2.0.1.0-ProductionCORE10.2.0.1.0ProductionTNSfor32-bitWindows:Version10.2.0.1.0-ProductionNLSRTLVersion10.2.0.1.0-Production如果存在invalid的组件执行如下脚本：SQL>executl_recomp.recomp_serial();1.3停止oracle的所有服务(可以在控制面板->性能与维护->管理工具->服务中停止所有和oracle相关的服务）如：命令方式：C:\>emctlstopdbconsoleOracleEnterpriseManager10gDatabaseControlRelease10.2.0.1.0Copyright(c)1996,2005OracleCorporation.Allrightsreserved.http://localhost:1158/em/console/aboutApplicationOracleDBConsoleorcl服务正在停止........OracleDBConsoleorcl服务已成功停止C:\>isqlplusctlstopiSQL*Plus10.2.0.1.0Copyright(c)2003,2005,Oracle.Allrightsreserved.StoppingiSQL*Plus...iSQL*Plusstopped.C:\>lsnrctlstopLSNRCTLfor32-bitWindows:Version10.2.0.1.0-Productionon11-11月-2011116:46Copyright(c)1991,2005,Oracle.Allrightsreserved.正在连接到(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cxj)(PORT=1521)))命令执行成功C:\>sqlplus/assysdbaSQL>shutdownimmediateDatabaseclosedDatabasedismounted.ORACLEinstanceshutdown.1.4冷备份数据库系统利用系统操作系统命令对oracledatabase10g和$ORACLE_HOME整体备份1.5升级OracleTimeZoneDefinitions（比较繁琐，需要注意）1.5.1查看Oracle当前时区定义版本：SQL>conn/assysdbaConnected.SQL>SELECTversionFROMv$timezone_file;VERSION----------21)Ifthisqueryreportsversion4,noactionisrequired;2)Ifthisreportsaversionlower,actionisfollowed:1.5.2查看是否(user)TZdata可能被影响1.5.2.1TIMESTAMPWITHLOCALTIMEZONE(TSLTZ)Thisneedstobecheckedmanually.Thereisnoautomatedwaytodiscoveraffecteddata.selectc.owner||'.'||c.table_name||'('||c.column_name||')-'||c.data_type||''colfromdba_tab_colsc,dba_objectsowherec.data_typelike'%LOCALTIMEZONE'andc.owner=o.ownerandc.table_name=o.object_nameando.object_type='TABLE'orderbycol/COL--------------------------------------------------------------OE.ORDERS(ORDER_DATE)-TIMESTAMP(6)WITHLOCALTIMEZONE进行备份1.5.2.2TIMESTAMPWITHTIMEZONE(TSTZ)1)查看是否有用户自己...