EM 12c : Agent Upgrade Failed With 'Java.sql.SQLException: Error Retrieving Archive: Archive Not Found: Archives' (Doc ID 1966043.1)

Last updated on NOVEMBER 08, 2019

Applies to:

Symptoms

Multi OMS fronted with Loader Balancer (SLB). Agent upgrade failed with following exception

Upgradable plugin details : pluginId=oracle.sysman.oh : pluginversion=12.1.0.2.0 : oldversion=12.1.0.1.0
Plugin archive /u01/app/oracle/12cR2/Middleware1/oms//sysman/install/plugins/oracle.sysman.oh/12.1.0.2.0/12.1.0.2.0_Discovery_2000_0.zip is copied to the agent at
/tmp/EMStage/tmp_AGENTUPGRADE_2015_01_28_06_31_12_448/oracle.sysman.oh_12.1.0.2.0_DISCOVERY.zip

Upgradable plugin details : pluginId=oracle.sysman.oh : pluginversion=12.1.0.2.0 : oldversion=12.1.0.1.0
Plugin archive /u01/app/oracle/12cR2/Middleware1/oms//sysman/install/plugins/oracle.sysman.oh/12.1.0.2.0/12.1.0.2.0_Agent_2000_0.zip is copied to the agent at
/tmp/EMStage/tmp_AGENTUPGRADE_2015_01_28_06_31_12_448/oracle.sysman.oh_12.1.0.2.0_AGENT.zip

Upgradable plugin details : pluginId=oracle.sysman.db : pluginversion=12.1.0.3.0 : oldversion=12.1.0.2.0
Plugin archive /oem12c/software_library/26/DED697E5BED26C59E0433C23B70ACE6D is copied to the agent at
/tmp/EMStage/tmp_AGENTUPGRADE_2015_01_28_06_31_12_448/oracle.sysman.db_12.1.0.3.0_DISCOVERY.zip

Upgradable plugin details : pluginId=oracle.sysman.db : pluginversion=12.1.0.3.0 : oldversion=12.1.0.2.0
Plugin archive /oem12c/software_library/36/DED697E5BECF6C59E0433C23B70ACE6D is copied to the agent at
/tmp/EMStage/tmp_AGENTUPGRADE_2015_01_28_06_31_12_448/oracle.sysman.db_12.1.0.3.0_AGENT.zip

Upgradable plugin details : pluginId=oracle.fmw.gg : pluginversion=12.1.0.1.0 : oldversion=
Plugin archive /oem12c/software_library/40/DED586EDFD72684BE0433C23B70AAFE1 is copied to the agent at
/tmp/EMStage/tmp_AGENTUPGRADE_2015_01_28_06_31_12_448/oracle.fmw.gg_12.1.0.1.0_DISCOVERY.zip

Upgradable plugin details : pluginId=oracle.sysman.emas : pluginversion=12.1.0.3.0 : oldversion=java.sql.SQLException: Error retrieving archive: Archive not found: Archives not found in local storejava.sql.SQLException: Error retrieving archive: Archive not found: Archives not found in local store
The plugin archives have been pushed successfully

/gc_inst/em/EMGC_OMS1/sysman/log/emoms.log reports following error

2015-01-28 07:42:14,982 [RemoteJobWorker 16336162] ERROR jobs.UpgradeAgent logp.251 -
oracle.sysman.emSDK.agent.comm.exception.DisconnectedException: connection to the agent has been lost and the cause is java.security.PrivilegedActionException: oracle.sysman.emSDK.agent.comm.exception.DisconnectedException: connection to the agent has been lost
2015-01-28 08:02:15,637 [EMUI_08_02_13_/console/cli] WARN model.EntityImpl logp.251 - Archive not found in OMS Oracle Home, will check next in Software library
2015-01-28 08:02:15,693 [EMUI_08_02_13_/console/cli] WARN model.EntityImpl logp.251 - Archive not found in OMS Oracle Home, will check next in Software library

Agent Upgrade Console (AUC) page exception

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.