datapatch : Database 12c Post Patch(Opatch) SQL Automation

Datapatch:

Database release 12c extends patch install automation for patches that contain post-patch SQL instructions.
Prior to Oracle 12c such patches required manual intervention to complete the post-patch SQL instructions after restarting the database.

Datapatch is the new tool that enables automation of post-patch SQL actions for RDBMS patches.

Datapatch usage:

All arguments are optional, if there are no arguments then datapatch will automatically determine which SQL scripts need to be run in order to complete the installation of any patches that contain post-patch SQL instructions.

Optional arguments:

-db <sid>
Use the specified database's SID rather than $ORACLE_SID

-apply <patch1,patch2,...,patchn>
Only consider the specified patch list for apply operations

-rollback <patch1,patch2,...,patchn>
Only consider the specified patch list for rollback operations

-force
Run the apply and/or rollback scripts even if not necessary per the SQL registry

-prereq
Run prerequisite checks only, do not actually run any scripts

-oh <oracle_home value>
Use the specified directory to determine what patches are installed

-verbose
Output additional information used for debugging

-help
Output usage information and exit

-version
Output build information and exit

Invoke datapatch:

$ cd $ORACLE_HOME/OPatch
$ datapatch