My Oracle Support Banner

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

Last updated on APRIL 28, 2018

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.1.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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