Pre-installation steps
You have to stop all SAP processes, all Oracle processes. Example of UNIX commands:
stopsap all
lsnrctl stop LISTENER_YDQ
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/runInstaller
Specify home details. Initial values should be correct. Click “Next”.
Now OUI performs prerequisite checks. If any errors occurs you have to repair them before you can continue.
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.
Last check before installation. Click “Install”.
Before end of the patch installation you will be prompted to execute configuration scripts. When done click “OK”.
Execute mentioned configuration script under root user. Example of UNIX commands:
sudo su - install
/oracle/YRS/102_64/root.sh
Click “Exit” to finish the installation.
Post-installation steps
Start the listener. Example of unix command:
lsnrctl start LISTENER_YDQ
Start the database in upgrade mode. Example of SQL command:
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:
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: