Thursday, 4 February 2016

Oracle 12.1.0.2.0 - Applying Patch 21260431: GETTING ORA-4031 AFTER 12C UPGRADE

Oracle 12.1.0.2.0 - Applying Patch 21260431: GETTING ORA-4031 AFTER 12C UPGRADE

- Download Patch 21260431 (p21260431_121020_Linux-x86-64.zip)

- Ensure that Oracle home is Oracle Database 12c Release 12.1.0.2.0

Applying Patch 21260431

- Set environment variables

- Shutdown all services

- Unzip the patch

$ unzip p21260431_121020_Linux-x86-64.zip

$ cd <PATCH_TOP_DIR>/21260431

- Run opatch apply

$ opatch apply

- Verify patch

$ opatch lsinventory |grep 21260431

- Start all services

Rollback Patch 21260431

If any issues after applying the patch and rollback is required

- Stop the services

- Run opatch rollback

$ opatch rollback -id 21260431


- Restart all services

Related Posts:

Oracle Database 12.1.0.2.5 - Applying Patch 19509982: DISABLE FIX FOR RAISING ORA-1792 BY DEFAULT.

No comments:

Post a Comment