Originally posted by pnrdba
Hi Amar/Hrishy,
Thanks a lot for your help. Here i'm pasting the document plan for installing patch on prod box. Kindly go thru this once and can you please tell me any thing i'm missing out or any thing need to be addeed??


1. Take a backup of $ORACLE_HOME , i.e. Oracle Software to disk , Just in case if some thing happens, we can fall back on it.

2. Stop the listener.

3. Shutdown the database and take a cold backup of production database on to tape .

4. Check whether the database backup is successful or not.

5. Download the patch from metalink and apply it on our production box.

6. After sucessful installation of the patch start the database and start the listener.

7. Check whether any errors are notified in alert log or not.

8. Check from the fornt-end application for the successful connectivity by connecting from CMS application from different desktops.

10. Check whether all the functionalities are working in the CMS application or not.
The order of 3 and5 is sort of strange. I would personally first download the patch, FTP it, untar it, and onlt then shutdown the database :-)