Yes, 1. Do a clean install of a new oracle home to be the site for testing your upgrade. Upgrade it to whatever patch level you currently run. Have it owner by another OS account 2. Make a copy of your database. It is easiest to do this as a cold copy or use rman to do it hot. 3. Start it in the new Oracle home using a copied initora. 4. Do your patch 5. test test test Allan -----Original Message----- =46rom: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Josh Collier Sent: Friday, September 03, 2004 1:14 PM To: oracle-l@xxxxxxxxxxxxx Subject: patch set testing Greetings, =20 Is there a routine you follow for testing patch sets, such as an upgrade =66rom 9.2.0.3 to 9.2.0.5=3F =20 thanks, =20 Josh C.=20 -- To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=3Dunsubscribe=20 To search the archives - //www.freelists.org/archives/oracle-l/ ___________________________________________________________________________= ___ This email is intended solely for the person or entity to which it is = addressed and may contain confidential and/or privileged information. = Copying, forwarding or distributing this message by persons or entities = other than the addressee is prohibited. If you have received this email in = error, please contact the sender immediately and delete the material from = any computer. This email may have been monitored for policy compliance. = [021216] -- To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe To search the archives - //www.freelists.org/archives/oracle-l/