Oracle Step upgrade patchset on Unix.

** Myself
Step upgrade patchset.
1) on the server itself stop all the available databases and the
listener , agents , apache server and all the services for the oracle
server.
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown immediate;
SQL> exit;
$ lsnrctl stop
2) apply the patch <Version>.<patch>.<patchset> to the same oracle home on which the oracle server is installed.
$ ./runInstaller
Follow the steps given below within the installer:
a. On the Welcome screen, click the Next button.
»This will display the File Locations screen.
b. Click the Browse button for the Source... entry field and navigate to the stage directory where
you unpacked the Patch Set tar file.
c. Select the products.jar file.
d. Click OK, then click the Next button
»The products to be loaded will be displayed.
For Solaris: select "Oracle 9i R2 Patch Set 9.2.0.8.0",
For Linux: select "Oracle 9i R2 Patch Set 2 9.2.0.8.0".
e. Click the Next button.
»
f. Verify the products listed and then click on the Install button.
8. Open a new session as a “root” user for the next step.
9. When the installer prompts you to run root.sh, run $ORACLE_HOME/root.sh from the above "root" session.
3) after the patch is applied you need to upgrade all the available
databases.
4) startup the database one by one and open it in "startup migrate"
mode.
$ sqlplus /nolog
SQL> connect / as sysdba
SQL> startup migrate
5) apply the catpatch.sql script present in the oracle home/rdbms/admin
folder to each database.
SQL> spool patch.log
SQL> @rdbms/admin/catpatch.sql
SQL> spool off
6) this script may take around 1 hour appx for each database and Review the patch.log file for errors and re-run the catpatch script after correcting any problems. When the script gets compledted, stop the database and open it again with "
startup" command.
SQL> ! catpatch.log
7) apply the utlrp.sql from oracle_home/rdbms/admin folder so as to
recompile all the invalid objects in the database.
SQL> shutdown
SQL> startup
SQL> @rdbms/admin/utlrp.sql
SQL> shutdown
SQL> startup
$ lsnrctl start
8) to perform these steps for all the databases.
9)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> @?/rdbms/admin/utlrp.sql

10) If you are using the Oracle Recovery Manager catalog, enter the following command:

$ rman catalog username/password@alias

RMAN> UPGRADE CATALOG; 

The products file will be read and the installer will load the product definitions.