oracle 10g 单实例升级方案文档

下载后可任意编辑 WINXP 32bit从10.2.0.1升级到10.2.0.4（单实例） 1、安装前的工作 1.1、下载升级包地址：ftp:// 利用迅雷下载并作一个HASH认证，确保其正确下载文件: O:\ROOT\ROOT\ORACLE\p6810189_10204_Win32.zip 大小: 1034621834 字节修改时间: 2024年11月10日, 11:56:50 MD5: AF8818947E1903D008973B9F7CF3DF5B SHA1: 97EDE71B760438411022B57A60A897E5911EC8BA CRC32: BD7783A9 1.2 检查系统状态检查dba_registry 查看oracle组件状态 Column comp_name at a40 Column version at a12 Column status at a6 Select comp_name, version, status from sys.dba_registry; COMP_NAME ---------------------------------------------------- VERSION STATUS ------------------------------ --------------------- Oracle Database Catalog Views 10.2.0.1.0 VALID Oracle Database Packages and Types 10.2.0.1.0 VALID Oracle Workspace Manager 10.2.0.1.0 VALID JServer JAVA Virtual Machine 10.2.0.1.0 VALID Oracle XDK 10.2.0.1.0 VALID Oracle Database Java Packages 10.2.0.1.0 VALID Oracle Expression Filter 10.2.0.1.0 VALID Oracle Data Mining 10.2.0.1.0 VALID Oracle Text 10.2.0.1.0 VALID Oracle XML Database 10.2.0.1.0 VALID Oracle Rules Manager 10.2.0.1.0 VALID Oracle interMedia 10.2.0.1.0 VALID OLAP Analytic Workspace 10.2.0.1.0 VALID Oracle OLAP API 10.2.0.1.0 VALID OLAP Catalog 10.2.0.1.0 VALID Spatial 10.2.0.1.0 VALID Oracle Enterprise Manager 10.2.0.1.0 VALID 已选择17行。检查v$version 查看系统版本 SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod PL/SQL Release 10.2.0.1.0 - Production CORE 10.2.0.1.0 Production TNS for 32-bit Windows: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production 假如存在invalid的组件执行如下脚本： SQL> c utl_recomp.recomp_serial (); 1.3停止oracle的所有服务 (可以在控制面板->性能与维护->管理工具->服务中停止所有和 oracle相关的服务）如：命令方式： C:\> emctl stop dbconsole Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 Copyright (c) 1996, 2024 Oracle Corporation. All rights reserved. http://localhost:1158/em/console/aboutApplication OracleDBConsoleorcl 服务正在停止 OracleDBConsoleorcl 服务已成功停止 C:\> isqlplusctl stop iSQL*Plus 10.2.0.1.0 Copyright (c) 2024, 2024, Oracle. All rights reserved. Stopping iSQL*Plus . iSQL*Plus stopped. C:\> lsnrctl stop LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 11-11月-2024 11 6:46 Copyright (c) 1991, 2024, Oracle. All rights reserved. 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cxj)(PORT=1521))) 命令执行成功 C:\> sqlplus / as sysdba SQL> shutdown immediate Database closed Data