My Oracle Support Banner

EM 13c: Fleet UPDATE_RACDB/DB Does Not Update Spfile Property In Srvctl Config Database (Doc ID 2714882.1)

Last updated on MARCH 12, 2021

Applies to:

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

Symptoms

In Enterprise Manager (EM) Cloud Control, Fleet UPDATE_RACDB/DB is not updating Spfile property in srvctl config database

$ emcli db_software_maintenance -performOperation -name="UPDATE 19C Home” -purpose="UPDATE_DB" -target_type=oracle_database -target_list="<target_name>"
-normal_credential="ORACLE:SYSMAN" -privilege_credential="ORACLE_ROOT:SYSMAN"

Example:
srvctl config database -d <dbname>
Database unique name: <dbname>
Database name:<dbname>
Oracle home: /u01/app/oracle/product/12.1.0.2/db_5
Oracle user: <dbuser>
Spfile: /u01/app/oracle/12.1.0.2/db_2/dbs/spfile<dbname>.ora

This shows /u01/app/oracle/12.1.0.2/db_2/dbs/spfile<dbname>.ora instead of the correct value which can be seen in Sqlplus

SQL> show parameter pfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /u01/app/oracle/product/12.1.0.2/db_5/dbs/spfile<dbname>.ora

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.