Oracle10201升级10204-windows 2003平台.docxVIP

ORACLE数据库升级1.Oracle软件升级1.1升级官方步骤1 Shut down all services in the Oracle home that might be accessing a database, for example Oracle Enterprise Manager Database Control or iSQL*Plus:Set ORACLE_SID=orclC:\ ORACLE_BASE\ORACLE_HOME\bin\emctl stop dbconsoleC:\ ORACLE_BASE\ORACLE_HOME\bin\isqlplusctl stop2 Shut down all listeners running in the Oracle home directory, where you need to install the patch set:C:\ lsnrctl stopUse the Control Panel to stop the listener service OracleHOME_NAMETNSListenerLISTENER_nodename.3 Set the values for ORACLE_HOME and ORACLE_SID and then shut down all database instances running in the Oracle home directory, where you need to install the patch set by entering the following command:C:\ sqlplus /NOLOGSQL CONNECT SYS AS SYSDBAEnter password:SYS_PasswordSQL SHUTDOWN4 点击p6810189_10204_Win32\Disk1\setup.exe进行升级Log on as a member of the Administrators group to the computer on which you are going to install Oracle components. If you are installing on a Primary Domain Controller or a Backup Domain Controller, log on as a member of the Domain Administrators group.Start Oracle Universal Installer located in the unzipped area of the patch set. For example, Oracle_patch\setup.exe.On the Welcome screen, click Next.In the Specify Home Details screen, select the name of the Oracle home that you want to update, or select the Path that you want to update from the list, then click Next1.2实际升级界面点击下一步点击下一步检查都是成功的，点击下一步点击下一步点击安装，弹出如下界面，进行升级安装完成后界面如下点击退出，Oracle软件升级结束。2.Oracle数据库升级2.1升级官方步骤Log in with administrator privileges.Set the values for the environment variables ORACLE_HOME, ORACLE_SID and PATH.For single-instance installations, if you are using Automatic Storage Management, start the Automatic Storage Management instance.For Oracle single-instance installations, start the listener as follows:C:\ lsnrctl startEnsure the Oracle RAC database is up before running Oracle Database Upgrade Assistant by entering the following command:C:\ ORACLE_BASE\ORACLE_HOME\