Oracle CPU/PSU/BP/RU/RUR : Loading Modified SQL Files into Database

After applied Oracle CPU/PSU/BP/RU/RUR patch sets, one post installation task is “Loading Modified SQL Files Into the Database”.

For RAC and non-RAC, Exadata including ExaCC, ExaCS and non-Exadata, OJVM and non-OJVM, before 12c and after 12c versions, the way to execute SQL files are different from version to version. This post will demonstrate how to run it under different circumstances.

Subscribe to get access

Read more of this content when you subscribe today.

Advertisement

How to Install and deinstall Oracle Text in 12.1.0.2

This post demonstrates how to deinstall / install Oracle Text in 12.1.0.2. Before doing so, DBA should make sure and understand the component dependencies as below.

Subscribe to get access

Read more of this content when you subscribe today.

How to Install and deinstall Oracle Text in 11.2.0.4

This post demonstrates how to deinstall / install Oracle Text in 11.2.0.4. Before doing so, DBA should make sure and understand the component dependency as below.

Subscribe to get access

Read more of this content when you subscribe today.

When Do You Need Startup Upgrade For OJVM PSU/RU Patches

While applying Combo of OJVM and Database Release Update 19.9.0.0.201020, something comes to my mind that when and why “startup upgrade” is needed ? Is it possible to startup database in normal mode before running datapatch command for post-installation step?

Subscribe to get access

Read more of this content when you subscribe today.

opatchauto : Unable to create patchObject

SYMPTOMS

When applying 19c GI JULY 2020 RU ( 19.8.0.0), opatchauto failed with following errors:

#opatchauto apply /tmp/31305339/
...
..
.

Patch: /tmp/31305339/31281355
Log:
Reason: Failed during Patching: oracle.opatch.opatchsdk.OPatchException: Unable to create patchObject
Possible causes are:
ORACLE_HOME/inventory/oneoffs/31281355 is corrupted. PatchObject constructor: Input file "/u01/app/19.0.0/grid/inventory/oneoffs/31281355/etc/config/actions" or "/u01/app/19.0.0/grid/inventory/oneoffs/31281355/etc/config/inventory" does not exist.
After fixing the cause of failure Run opatchauto resume
]
OPATCHAUTO-68061: The orchestration engine failed.
OPATCHAUTO-68061: The orchestration engine failed with return code 1
OPATCHAUTO-68061: Check the log for more details.
OPatchAuto failed.
OPatchauto session completed at Mon Aug 3 21:06:44 2020
Time taken to complete the session 0 minute, 35 seconds
opatchauto failed with error code 42

Subscribe to get access

Read more of this content when you subscribe today.