My Oracle Support Banner

OCI DBCS Patching Failed With WARNING::Failed to run the datapatch as db <db_unique_name> is not registered with clusterware, PLS-00323 (Doc ID 2620773.1)

Last updated on MAY 13, 2020

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A to N/A [Release 1.0]
Linux x86-64

Symptoms

Customer was trying to apply the July 2019 DB patch through OCI DBCS console and the job completed without executing datapatch.
Job details are showing-

Job details
----------------------------------------------------------------
ID: <job_id>
Description: DB Home Patching: Home Id is <home_id>
Status: Success
Created: December 12, 2019 4:56:46 PM CST
Message: WARNING::Failed to run the datapatch as db cdb_iad14s is not registered with clusterware

From DCS Agent log:

CRS-2613: Could not find resource 'ora.<db_unique_name>.db'.
............
"message" : "WARNING::Failed to run the datapatch as db <db_unique_name> is not registered with clusterware",
"taskResult" : "WARNING::Failed to run the datapatch as db <db_unique_name> is not registered with clusterware",
2019-12-12 18:39:17,555 DEBUG [dw-354 - GET /jobs/<job_id>] [] c.o.d.c.t.r.ServiceJobReport: Warning will be set : WARNING::Failed to run the datapatch as db <db_unique_name> is not registered with clusterware
"message" : "WARNING::Failed to run the datapatch as db <db_unique_name> is not registered with clusterware",
"taskResult" : "WARNING::Failed to run the datapatch as db <db_unique_name> is not registered with clusterware",

From sqlpatch_invocation.log:

Error at line 2018: Warning: Package Body created with compilation errors.
Error at line 2024: 470/12 PLS-00323: subprogram or cursor 'SESSION_ENABLED_ROLE' is
Error at line 2028: 514/12 PLS-00323: subprogram or cursor 'SESSION_ENABLED_ROLE_VARCHAR' is

From PDB_PLUG_IN_VIOLATIONS:

NAME CAUSE TYPE
------------------------------ ---------------------------------------------------------------- ---------
MESSAGE
------------------------------------------------------------------------------------------------------------------------------------
STATUS
---------
ACTION
------------------------------------------------------------------------------------------------------------------------------------
<pdb> SQL patch error ERROR
SQL patch ID/UID 28710144/22468445 (): ROLLBACK with status WITH ERRORS in the PDB.
PENDING
Call datapatch to reinstall

<pdb> SQL patch error ERROR
SQL patch ID/UID 28710144/22468445 (): ROLLBACK with status WITH ERRORS in the PDB.
PENDING
Call datapatch to reinstall

<pdb> SQL patch error ERROR
SQL patch ID/UID 28710144/22468445 (): ROLLBACK with status WITH ERRORS in the PDB.
PENDING
Call datapatch to reinstall

PDB$SEED SQL patch error ERROR
SQL patch ID/UID 28710144/22468445 (): ROLLBACK with status WITH ERRORS in the PDB.
PENDING
Call datapatch to reinstall

Changes

It seems someone changed the db_unique_name from original name to a new one after provisioning.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.