I. Download patch set p5337014_10203_WINNT.zip
II. To install the Oracle Database 10g patch set interactively:
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 Next
If you are installing the patch set on an Oracle RAC cluster, click Next when the Selected Nodes screen appears.
On the Summary screen, click Install.
When the installation is complete, the End of Installation screen appears.
On the End of Installation screen, click Exit, then click Yes to exit from Oracle Universal Installer.
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
III Start upgrade
1. Start all services
2. Connect sys user
C:\> sqlplus /NOLOG
SQL> CONNECT SYS/SYS_password AS SYSDBA
3. Enter the following SQL*Plus commands:
SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\catupgrd.sql
(Ukoom: It takes a long time to run this script, so have a cup of coffee )
SQL> SPOOL OFF
Review the patch.log file for errors and inspect the list of components that is displayed at the end of catupgrd.sql script.
This list provides the version and status of each SERVER component in the database.
If necessary, rerun the catupgrd.sql script after correcting any problems.
4. Restart the database:
SQL> SHUTDOWN
SQL> STARTUP
5. Compile Invalid Objects
Run the utlrp.sql script to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended.
SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\utlrp.sql
SQL> select * from utl_recomp_errors;
SQL> select * from v$version;
SQL> show user
SQL> select tablespace_name, bytes from dba_data_files
6. Popular data dictionary (it should be optional)
SQL> @ ORACLE_BASE\ORACLE_HOME /rdbms/admin/catalog.sql
SQL>shutdown immediate
SQL>startup
Reference:
http://idbasolutions.com/installing-oem-10g-r4-on-windows/
http://babudba.blogspot.com/2007/11/upgrade-oracle-10202-to-10203.html
http://blog.csdn.net/yjz0065/archive/2008/02/27/2124778.aspx
http://sabdarsyed.blogspot.com/2007/03/upgrading-oracle-database-server-10g.html
http://blog.nominet.org.uk/tech/2007/03/16/some-issues-with-oracle-10203-patchset/