EM13C: Fleet UPDATE_DB/UPDATE_RACDB Fails In Step "Start standby database instance" With Error "sh: ${data.STANDBY_START_OPTION}: bad substitution"
(Doc ID 2646755.1)
Last updated on SEPTEMBER 14, 2021
Applies to:
Enterprise Manager for Oracle Database - Version 13.2.2.0.0 and laterInformation in this document applies to any platform.
Symptoms
In Enterprise Manager (EM) Cloud Control, while running UPDATE_DB/UPDATE_RACDB using Fleet Maintenance in case of non-rolling applicable patches such as OJVM, Starting the standby database from a patched home fails with error "sh: ${data.STANDBY_START_OPTION}: bad substitution"
$ emcli db_software_maintenance -performOperation -name="OH" -purpose=UPDATE_DB -target_type=oracle_database
-target_list="<STANDBY_HOSTNAME>.<DOMAIN_NAME>" -normal_credential="DATAGUARD:SYSMAN" -privilege_credential="DATAGUARDROOT:SYSMAN" -dataguard_role=standby
-startupDatabase=true -skipSwitchDatabase=true -input_file="data:/scratch/karththi/inputfiles/deploy_OH.prop"
Job Steps Log for Job :Start standby database instance:
-------------------------------------------------------------
Final command line to execute is $PERL_HOME/perl
"/tmp/JOB_8F4F20BA21CF1EF0E05388947B0A496C/startDBInstance.pl" -debug false -oh /<PATH> -os standby -startupdbsids -startuplisteners-startupdbcontrol -startupisqlplus -homeVersion 12.2.0.1.0 -tns_admin <PATH>/network/admin,<PATH>/network/admin ${from_rac} -parallel false -primaryDBSids -physicalStdySids standby -agent_db_plugin_home <PATH2>/agent_13.4.0.0.0/plugins/oracle.sysman.db.agent.plugin_13.4.1.0.0 -cdbPdbList ${cdbPdbList} -switch_home <PATH> -switchbackMode -db_tns_admin <PATH>/network/admin -startManagedRecovery -standbyStartOption ${data.STANDBY_START_OPTION}
-target_list="<STANDBY_HOSTNAME>.<DOMAIN_NAME>" -normal_credential="DATAGUARD:SYSMAN" -privilege_credential="DATAGUARDROOT:SYSMAN" -dataguard_role=standby
-startupDatabase=true -skipSwitchDatabase=true -input_file="data:/scratch/karththi/inputfiles/deploy_OH.prop"
Job Steps Log for Job :Start standby database instance:
-------------------------------------------------------------
Final command line to execute is $PERL_HOME/perl
"/tmp/JOB_8F4F20BA21CF1EF0E05388947B0A496C/startDBInstance.pl" -debug false -oh /<PATH> -os standby -startupdbsids -startuplisteners-startupdbcontrol -startupisqlplus -homeVersion 12.2.0.1.0 -tns_admin <PATH>/network/admin,<PATH>/network/admin ${from_rac} -parallel false -primaryDBSids -physicalStdySids standby -agent_db_plugin_home <PATH2>/agent_13.4.0.0.0/plugins/oracle.sysman.db.agent.plugin_13.4.1.0.0 -cdbPdbList ${cdbPdbList} -switch_home <PATH> -switchbackMode -db_tns_admin <PATH>/network/admin -startManagedRecovery -standbyStartOption ${data.STANDBY_START_OPTION}
The output of the directive is:
sh: ${data.STANDBY_START_OPTION}: bad substitution
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 |