Installation 10g – Patchset 3 (10.2.0.4)

Pre-installation steps

You have to stop all SAP processes, all Oracle processes. Example of UNIX commands:

stopsap all
lsnrctl stop LISTENER_YDQ
wiki oracle installation 10g patchset 3
wiki oracle installation 10g patchset 3

Check if every process was finished and if not kill it. Example of UNIX commands:

ps -ef | grep orayrs
ps -ef | grep yrsadm
kill 23456

Backup your binaries by coping $ORACLE_HOME directory. Example of UNIX command:

cp /oracle/YRS/102_64 /oracle/YRS/102_64_old

Backup Oracle inventory settings by copying oraInventory directory. Example of UNIX commands:

cp /oracle/YRS/oraInventory /oracle/YRS/oraInventory_old

Set DISPLAY variable. If you are using remote x-windows you have to set properly environment DISPLAY variable. Example of UNIX commands:

#example of C shell (csh) command
setenv DISPLAY a-700s504.ag.eu.jci.com:12.0
#example of Korn shell (ksh) and Bourne shell (sh) command
export DISPLAY=a-700s504.ag.eu.jci.com:12.0

Installation steps

Run installer by executing runInstaller inside patchset directory. Example of UNIX command:

/oracle/stage/Patchset_10204_HPUX-IA64/Disk1/runInstallerwiki oracle installation 10g patchset 3

Specify home details. Initial values should be correct. Click “Next”.

wiki oracle installation 10g patchset 3

Now OUI performs prerequisite checks. If any errors occurs you have to repair them before you can continue.

wiki oracle installation 10g patchset 3

You can skip Oracle Configuration Manager Registration step as it is not required. If you want you can enter data to connect this database with your metalink ID.

wiki oracle installation 10g patchset 3

Last check before installation. Click “Install”.

wiki oracle installation 10g patchset 3

Before end of the patch installation you will be prompted to execute configuration scripts. When done click “OK”.

wiki oracle installation 10g patchset 3

Execute mentioned configuration script under root user. Example of UNIX commands:

sudo su - install
/oracle/YRS/102_64/root.sh
wiki oracle installation 10g patchset 3

Click “Exit” to finish the installation.

wiki oracle installation 10g patchset 3
wiki oracle installation 10g patchset 3

Post-installation steps

Start the listener. Example of unix command:

lsnrctl start LISTENER_YDQ

Start the database in upgrade mode. Example of SQL command:

wiki oracle installation 10g patchset 3
STARTUP UPGRADE

Define file where to spool output first. Then start the catupgrd.sql SQL script. Example of SQL command:

SPOOL patch.log
@?/rdbms/admin/catupgrd.sql

Turn off spool to file. Then review the file for errors and inspect the list of components that is displayed at the end. Example of SQL command:

SPOOL OFF

Restart the database to normal operations. Example of SQL commands:

SHUTDOWN IMMEDIATE
STARTUP

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. Example of SQL command:

@?/rdbms/admin/utlrp.sqlwiki oracle installation 10g patchset 3

If any issues are detected during compilation try to resolve them (check document Object compilation) and rerun the script afterwards.

Check status of all components. Example of SQL command:

SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;wiki oracle installation 10g patchset 3

Leave a Reply