EM 13c: Fleet UPDATE_RACDB/DB Does Not Update Spfile Property In Srvctl Config Database
(Doc ID 2714882.1)
Last updated on JULY 13, 2021
Applies to:
Enterprise Manager for Oracle Database - Version 13.3.2.0.0 and laterInformation 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
Changes
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 |