EM 13c: Fleet How to Fix Association Between Target And Oracle Home (Doc ID 2915845.1)

Case 1:
Missing association:If there is no association between target and Oracle home

$emcli db_software_maintenance -performOperation -name=UPDATE_RAC_DB -purpose=UPDATE_RACDB -target_type=rac_database -target_list=<target_name> -normal_credential=SUDO_SSH:SYSMAN -privilege_credential=ROOT_SSH:SYSMAN -database_credential=SYS:SYSMAN -rolling=true
Processing target "<target_name>"...
Checking if target is already running from the current version of the image...
Check Passed.
Checking image subscription...
Check image subscription passed.
Checking if target is in non-default location inside the Oracle Home...
Error in oracle home details. Check OMS logs for more details.

Case 2:
Wrong association: If the association between the target and the Oracle home is wrong

$ emcli db_software_maintenance -performOperation -name="Update SIDB" -purpose=UPDATE_DB -target_type=oracle_database -target_list=s<DB_Name> -normal_credential="NC_HOST:SYSMAN" -privilege_credential="NC_ROOT:SYSMAN" -database_credential="DBSYS:SYSMAN"
Processing target "<DB_Name>"...
Checking if target is already running from the current version of the image...
Check Passed.
Checking image subscription...
Check image subscription passed.
The target has an Oracle Home associated missing/different/extra from the one configured: <DB_Name>
Oracle Home Configured: /u01/app/product/12.1.0/dbhome_1
Oracle Home Target Associated: OraDB12Home1_1_6647

ERROR: Operation could not be completed
Verb performOperation unsuccessful

Case 3:
Extra associations: Some times the targets might have multiple associations and one of them could be wrong but the other is correct.

$ emcli db_software_maintenance -performOperation -name="Update SIDB" -purpose=UPDATE_DB -target_type=oracle_database -target_list=<DB_Name> -normal_credential="NC_HOST:SYSMAN" -privilege_credential="NC_ROOT:SYSMAN" -database_credential="DBSYS:SYSMAN"
Processing target "<DB_Name>"...
Checking if target is already running from the current version of the image...
Check Passed.
Checking image subscription...
Check image subscription passed.
The target has an Oracle Home associated missing/different/extra from the one configured: <DB_Name>
Oracle Home Configured: /u01/app/product/12.1.0/dbhome_1
Oracle Home Target Associated: OraDB12Home1_1_6647

ERROR: Operation could not be completed
Verb performOperation unsuccessful

Case 4:
Could not validate all active instances

$emcli db_software_maintenance -performOperation -name="update_19.17" -purpose='UPDATE_RACDB' -target_type=rac_database -target_list=<DB_Name> -normal_credential="NC_HOST:SYSMAN" -privilege_credential="NC_HOST_ROOT:SYSMAN" -database_credential="DBSYS:SYSMAN"

Processing target "<DB_Name>"...
Checking if target is already running from the current version of the image...
Check Passed.
Checking image subscription...
Check image subscription passed.
Checking if target is in non-default location inside the Oracle Home...
Operation 'update_19.17' created successfully.

JobStepsLog_InitializePatchDBDeploymentProcedure.txt

See the following error:*** Getting instances without dbcreds ***

Oracle home is : /u01/app/product/19.14
Host name : <host_name>
SID is : <DB_Name>
Host Named creds: NC_HOST:SYSMAN
Host creds: oracle.sysman.core.sec.credstore.EMCredentialReferenceForCredNameImpl@2d152e17
Queryng active instances in database...

Could not validate all active instances