My Oracle Support Banner

EM 13c Fleet: UPDATE_RACDB/DB Is Not Updating Srvctl Property Of Spfile With New Oracle Home (Doc ID 2854268.1)

Last updated on DECEMBER 08, 2022

Applies to:

Enterprise Manager for Oracle Database - Version 13.4.1.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 srvctl property of spfile with new Oracle Home

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

Example:
After switching the db home:

$ srvctl config database -d <db_name>
Database unique name: <db_name>
Database name: <db_name>
Oracle home: /u01/app/oracle/product/19.10.0/dbhome_1
Oracle user: oracle
Spfile: /u01/app/oracle/product/19.3.0/dbhome_1/dbs/spfile<db_name>.ora ==> not updated with new oracle home
@ Password file:
Domain: <domain.com>
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA,RECO
Services:<service_name>
OSDBA group: oinstall
OSOPER group: oinstall
Database instance:<db_name>

$ cat init<db_name>.ora
spfile=/u01/app/oracle/product/19.10.0/dbhome_1/dbs/spfile<db_name>.ora

SQL> show parameter spfile

NAME       TYPE                         VALUE
spfile         string                     /u01/app/oracle/product/19.3.0/dbhome_1/dbs/spfile<db_name>.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.