EM 13c: Fleet UPDATE_RACDB Job Fails at Initialize Step With Error "Could Not Validate All Active Instances and Oracle Error ORA-12650"
(Doc ID 2897698.1)
Last updated on OCTOBER 03, 2022
Applies to:
Enterprise Manager for Oracle Database - Version 13.5.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
In Enterprise Manager (EM) Cloud Control, Fleet Maintenance UPDATE_RACDB job fails With below error:
$ emcli db_software_maintenance -performOperation -name="update" -purpose=UPDATE_RACDB -target_type=rac_database -target_list='<TARGET_NAME>' -dataguard_role=primary -normal_credential="ORACLE:SYSMAN" -privilege_credential="ROOT:SYSMAN" -database_credential="SYSDBA_DB:SYSMAN" -input_file="data:/u01/app/UPDATE_DB.txt"
purpose | UPDATE_RACDB
target_list | <TARGET_NAME>
Loading DP variables values using input data complete.
Passed parameters are:
Initialize migrate database deployment procedure
Target Name:<TARGET_NAME>
Target type:rac_database
Named credentials:oracle:sysman
Destination Oracle home:/u01/app/oracle/product/1915/db_1
Working directory:/u01/app/oracle/tmpfleetmaint/4420532253362107
Drain Timeout:
Non rolling mode: false
Dataguard role is primary
Validating all nodes are up and running...
Getting instances from database...
Could not validate all active instances
Oracle Error ORA-12650
The Connect Descriptor was (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = tcp)(HOST = <HOST_NAME>)(PORT = <PORTNO>))(ADDRESS = (PROTOCOL = tcp)(HOST = <HOSTNAME>)(PORT = <PORTNO>)))(CONNECT_DATA = (SERVICE_NAME = <SERVICE_NAME>)))
Error Setting the Computed Variables
Exception Occurred due there is no active instances for the RAC DB '<TARGET_NAME>'
ExpressionEvaluationException: Below error message was returned while executing this Computational step.
----------------------------------------------------------
Error Setting the Computed Variables
----------------------------------------------------------
purpose | UPDATE_RACDB
target_list | <TARGET_NAME>
Loading DP variables values using input data complete.
Passed parameters are:
Initialize migrate database deployment procedure
Target Name:<TARGET_NAME>
Target type:rac_database
Named credentials:oracle:sysman
Destination Oracle home:/u01/app/oracle/product/1915/db_1
Working directory:/u01/app/oracle/tmpfleetmaint/4420532253362107
Drain Timeout:
Non rolling mode: false
Dataguard role is primary
Validating all nodes are up and running...
Getting instances from database...
Could not validate all active instances
Oracle Error ORA-12650
The Connect Descriptor was (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = tcp)(HOST = <HOST_NAME>)(PORT = <PORTNO>))(ADDRESS = (PROTOCOL = tcp)(HOST = <HOSTNAME>)(PORT = <PORTNO>)))(CONNECT_DATA = (SERVICE_NAME = <SERVICE_NAME>)))
Error Setting the Computed Variables
Exception Occurred due there is no active instances for the RAC DB '<TARGET_NAME>'
ExpressionEvaluationException: Below error message was returned while executing this Computational step.
----------------------------------------------------------
Error Setting the Computed Variables
----------------------------------------------------------
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 |