Fleet: UPDATE_GI Failed with "undefined symbol: XS_KFODCLNT_kfodListDGs" or "ORA-17503: ksfdopn:10 Failed to open file spfileABC.ora" or "The source oracle home location is :/u01 ExpressionEvaluationException"
(Doc ID 2660871.1)
Last updated on SEPTEMBER 01, 2021
Applies to:
Enterprise Manager Base Platform - Version 13.3.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
In Enterprise Manager (EM) Cloud Control using Fleet Maintenance, when running the UPDATE command in RAC cluster environment, the process fails on the switch Clusterware step with the following error:
CASE 1:
Command Snippet:
$ emcli db_software_maintenance -performOperation -name="Update GI" -purpose=UPDATE_GI -target_type=cluster -target_list="<TARGET_NAME>" -normal_credential="ORACLE:SYSMAN" -privilege_credential="ROOT:SYSMAN"
Job Steps Log for Job :Switch Clusterware Instance
2020-03-17 09:59:22: ASM is running on <node1>,<node2>
2020-03-17 09:59:22: Current node is <Node1_name>
2020-03-17 09:59:22: Installing xsub XS_KFODCLNT_kfodListDGs for function KFODkfodListDGs
2020-03-17 09:59:22: shared library to load is libasmperl19.so
2020-03-17 09:59:22: libpath found is /opt/gridhome/19.6.0.0.200114/lib and /opt/gridhome/19.6.0.0.200114/rdbms/lib
2020-03-17 09:59:22: DynaLoader:dl_find_symbol failed with: /opt/gridhome/19.6.0.0.200114/perl/bin/perl: undefined symbol: XS_KFODCLNT_kfodListDGs at /opt/gridhome/19.6.0.0.200114/crs/install/oraasm.pm line 1825.
CASE 2:
Command Snippet:
$ emcli db_software_maintenance -performOperation -name="Update GI" -purpose=ROLLBACK_GI -target_type=cluster -target_list="<TARGET_NAME>" -normal_credential="ORACLE:SYSMAN" -privilege_credential="ROOT:SYSMAN"
Job Steps Log for Job :Switch Clusterware Instance
PRCR-1079 : Failed to start resource ora.<db_name>.db
CRS-5017: The resource action "ora.<db_name>.db start" encountered the following error:
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/<db_name>/spfile<sid>.ora'
ORA-17503: ksfdopn:10 Failed to open file +<db_name>_DATA/<db_name>/spfile<sid>.ora
ORA-01034: ORACLE not available
ORA-27121: unable to determine size of shared memory segment
Linux-x86_64 Error: 13: Permission denied
Additional information: 6659
Additional information: 91619335
. For details refer to "(:CLSN00107:)" in "/opt/grid/app/grid/diag/crs/<cluster_name>/crs/trace/crsd_oraagent_oracle.trc".
CASE 3:
Command Snippet:
$ emcli db_software_maintenance -performOperation -name="Update GI" -purpose=UPDATE_GI -target_type=cluster -target_list="<TARGET_NAME>" -normal_credential="ORACLE:SYSMAN" -privilege_credential="ROOT:SYSMAN"
Job Steps Log for Job : Initialize Deployment Procedure
purpose | UPDATE_GItarget_list | <cluster_name>
Loading DP variables values using inpu data complete.
Setting version ID...
Timestamp variable to uniquely identify this session is set to: MASSDB-<session_id>
dispatch loc set to /tmp/4931063907934343/
dispatchLoc is :/tmp
workdirLoc is :/tmp/4931063907934343/
sessionTSLoc is :MASSDB-<session_id>
root script loc set to /tmp/4931063907934343//MASSDB-<session_id>
dispatch loc set to /tmp/4931063907934343//4931064487838116/
The source oracle home location is :/u01 ExpressionEvaluationException: Below error message was returned while executing this Computational step.
----------------------------------------------------------
Error occured in the execute funtions. Check OMS logs for detailsnull
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 |