My Oracle Support Banner

13c EM Fleet: UPDATE_DB Failing With Error "CRS-0245: User doesn't have enough privilege to perform the operation" When GI (SIHA) Is Running As A Different User (Doc ID 2615920.1)

Last updated on JUNE 13, 2023

Applies to:

Enterprise Manager for Oracle Database - Version 13.2.2.0.0 and later
Information in this document applies to any platform.

Symptoms

In Enterprise Manager Cloud Control using Fleet Maintenance, when performing the following UPDATE_DB command operation on SIHA target. ( GI is running as grid user and Database is running as oracle user )

Command Snippet

$ emcli db_software_maintenance -performOperation -name="Update DB" -purpose=UPDATE_DB -target_type="oracle_database" -target_list="<DB_Name>" -normal_credential="ORACLE:SYSMAN" -privilege_credential="ROOT:SYSMAN"  -input_file="data:/home/oracle/update.txt"

It fails with either of the below error messages mentioned in the following use cases.

Case:1

Recommended Patch was not applied.

Job Steps Log for Job :Migrate DB Instances for Patching

 Copying /u01/oracle/product/12.2.0.1_home1/dbs/orapw<sid>20190314094650....
Tue Mar 19 08:34:12 2019 - Checking if <db_name> is HA Managed or not

Tue Mar 19 08:34:15 2019 - <db_name> is HA Managed

Tue Mar 19 08:34:15 2019 - Running command /u01/oracle/product/12.2.0.1_home1/bin/srvctl modify database -d <db_name> -o /u01/oracle/product/12.2.0.1_a_home1 to update the New Oracle Home location

/u01/oracle/product/12.2.0.1_home1/bin/srvctl modify database -d <db_name> -o /u01/oracle/product/12.2.0.1_a_home1
PRCD-1163 : Failed to modify database <db_name>
PRCR-1071 : Failed to register or update resource ora.<db_name>.db
CRS-0245:  User doesn't have enough privilege to perform the operation

Tue Mar 19 08:34:23 2019 - ERROR: Could not update the New Oracle Home location: /u01/oracle/product/12.2.0.1_a_home1 for database <db_name> in Oracle High Availability Services

---------- Error Message ----------
Error: 001
Failed to update New Oracle Home Location /u01/oracle/product/12.2.0.1_a_home1 for database <db_name> in Oracle High Availability Services -oh failed
----------- End Message -----------

 Case: 2

Applied recommended patch still it fails with below error:

$ /u01/grid/product/12.2.0.1_a_grid/bin/crsctl modify resource ora.<db_name>.db -attr ORACLE_HOME=/u01/oracle/product/12.2.0.1_a_home1 -unsupported
CRS-0245:  User doesn't have enough privilege to perform the operation
CRS-4000: Command Modify failed, or completed with errors.

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
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.