Windows Server 2003 上安装 Oracle10g(10.2.0.1)并升级 至补丁(

Windows Server 2003 上安装 Oracle10g(10.2.0.1)并升级

至补丁(10.2.0.4) 图解

Windows Server 2003 上安装 Oracle10g(10.2.0.1)并升级 至补丁(10.2.0.4) 图解 第一部分：安装 Oracle 10.2.0.1

1、选择安装方法2、选择安装类型3、指定安装目录4、检查先决条件5、选择配置选项6、选择数据库配置7、指定数据库配置选项8、选择数据库管理选项9、指定数据库数据存储目录10、指定备份和恢复选项11、概要（检查安装配置，是否需要重新设定）12、安装（等待安装进度…）13、安装完成，启动 DBCA 创建数据库也完成了14、数据库内置用户口令管理15、安装结束提示信息（记住）16、结束确认17、打开浏览器登录 EM（Enterprise Manager 10g）第二部分：安装补丁 Oracle Patch 10.2.0.4

一、Oracle 10.2.0.4 Patch 安装 for Windows 32bit 环境要求

硬件要求： Intel Pentium or AMD 32 bit 处理器 系统要求： Windows Server 2003 Windows Server 2003 R2 Windows 2000 (Service Pack 2 or later) Windows XP Professional Windows Vista with Service Pack 1 or later 数据库版本要求： Oracle Database 10g (10.2.0.1) or later

二、升级安装前的准备工作 1、关闭数据库

SQL> CONNECT SYS AS SYSDBA Enter password: {sys_password} 已连接。

SQL> SHUTDOWN2、停止所有服务

1、关闭所有可能访问数据库的工具软件和服务进程，例如：Oracle Enterprise Manager Database Control or iSQL*Plus、PL/SQL 等等。 2、执行：

D:\\>F:\\2003\\oracle\\product\\10.2.0\\db_1\\bin\\emctl stop dbconsole 3、执行：

D:\\>F:\\2003\\oracle\\product\\10.2.0\\db_1\\bin\\isqlplusctl stop 4、执行： D:\\> lsnrctl stop 5、关闭：

D:\\> sqlplus /NOLOG

SQL> CONNECT SYS AS SYSDBA Enter password: {sys_password} 已连接。

SQL> SHUTDOWN

6、 “控制面板” “管理工具”? ? “服务” 中关闭服务： Oracle Database service \identifier of the database)。其实，最好是关闭所有 oracle 有关的服务进程。三、备份

备份内容包括： Oracle Inventory Oracle 10g home Oracle 10g Database四、安装升级补丁

1、停止 Oracle 服务进程，并设置为手动启动2、运行补丁安装程序，进入欢迎界面3、指定安装目录（注意：覆盖已装数据库）4、检查先决条件5、OCM（即：Oracle Configuration Manager 注册）6、概要（确认安装设置）7、进行安装（等待进度……）8、报错：msvcr71.dll 正在被使用……9、排查错误 第一种情况：

MSVCR71.DLL is in use during Oracle patch installation. If you are trying to upgrade the Oracle Client and an error message is displayed telling you that msvcr71.dll is in use, try the following: 1) Verify that all Oracle services are stopped. 2) Stop the Distributed Transaction Coordinator – In most cases this will solve the issue. 3) Run Process Explorer a) In the Find menu, click on “Find Handle or DLL” (CTRL F) b) Type msvcr71.dll and click on Search c) Go through the list and close the listed applications

第二种情况：

\602568.1] In this

Document-------------------------------------------------Applies to: Oracle Warehouse Builder - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]Information in this document applies to any platform. Symptoms While applying an OWB 10.2.0.x patch for Oracle Warehouse Builder, the following error occurs: msvcr71.dll is in use. Cause msvcr71.dll is a module containing standard C library functions such as printf, memcpy etc. It is a part of the Microsoft C Runtime Library. It might be possible that there are some other process(related to Oracle or not) that are using this file when this file is needed by the OWB Patch for

installation.Solution To identify which process is actually using the file, please do the following: 1. 2. 3. 4. 5. 6. 7. 8. Open the following link in your Internet browser:

http://technet.microsoft.com/hi-in/sysinternals/bb896642(en-us).aspx#top Download and install the FileMon for Windows tool. Run the Filemon.exe program. In the Filemon pop-up window, \Section, add the value \

Ok . Monitor the Filemon window for the msvcr71.dll process. Search for the msvcr71.dll file under the column \file and terminate those processes (stop Oracle and Non-Oracle Processes also that are using this file). Try applying the 10.2.0.X patch again to see if the install goes well.10、杀死 msdtc.exe，以终止其对 msvcr71.dll 的占用11、排除错误后， “重试”继续安装……12、安装结束13、结束确认14、恢复 msdtc.exe 服务进程15、恢复 Oralce 服务进程五、运行补丁升级脚本

如果只安装了升级包，没有进行数据库字典信息升级，启动数据库将报 ORA-01092 ORACLE 例程终止。强 行断开连接。 （这和 Oracle9i 有点不同，对 Oracle9i 做了升级后，不升级数据库字典信息，仍然可以启动数 据库使用，但对 exp/imp,RMAN 之类的工具不能使用） 。

1、运行数据库预升级检查( Pre-Upgrade Information Tool) SQL> Conn / as sysdba SQL> STARTUP UPGRADE SQL> SPOOL upgrade_info.log SQL> @?\\rdbms\\admin\%utlu102i.sql SQL> SPOOL OFF

2、进行数据库字典信息升级（Upgrading a Release 10.2

本文来源：https://www.bwwdw.com/article/sel3.html