Boune database in middle of a patch

[satish]

Dear erman,

We are applying a patch and it failed after 2 hours.Solution was to set a database parameter and bounce the database.Is it possible to bounce the database and restart the patch from where it failed.

My concern is if we bounce the database,the worker database sessions may be gone right?

Thank you

[ErmanArslansOracleBlog]

You can continue with your previous session, even after a database restart.

Check this MOS note -> R12.0 / R12.1 / R12.2 : Patch seems to hang in adobjcmp.sql or appostimportaad.sql or fapostimportaad.sql (Doc ID 748501.1)

In this note, you will find a similar scenario, where the database must be restarted during a patch application, and there you will see the following instruction ->

**Using option 4 in adctrl, fail the worker(s) that are running adobjcmp.sql or appostimportaad.sql or fapostimportaad.sql
**Restart the database
**Start adpatch again and have it continue with its previous session