My Oracle Support Banner

EM 12c, EM 13c: Unable to set EM Context: java.sql.SQLException: ORA-04063: package body "SYSMAN.EM_USER_MODEL" has errors (Doc ID 2588797.1)

Last updated on NOVEMBER 05, 2019

Applies to:

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

Symptoms


OMS start up failing after applying patches 29835388 & 29699309 on OMS & Repository DB simultaneously:

<EM_MW_HOME>/cfgtoollogs/omspatcher/opatch<timestamp>_1.log

Some error occurred during RCU update. Please refer individual log file(s) for details.
Log file location: <MiddleWare_Home>/oms/cfgtoollogs/opatch/<TimeStamp>_SystemPatch_29835388_1/rcu_applypatch_original_patch_<TimeStamp>.log
[Sep 14, 2019 6:05:40 PM] Stack Description: java.lang.RuntimeException: OPatchauto failed to execute some of the OMS operations. Please refer log file(s) for details.
[Sep 14, 2019 6:05:40 PM] StackTrace: oracle.opatchauto.oms.OMSApplySession.process(OMSApplySession.java:1150)
[Sep 14, 2019 6:05:40 PM] StackTrace: oracle.opatchauto.oms.OMSPatchingSession.main(OMSPatchingSession.java:650)
[Sep 14, 2019 6:05:40 PM] StackTrace: oracle.opatchauto.oms.OPatchAuto.main(OPatchAuto.java:801)
[Sep 14, 2019 6:05:40 PM] Deployment summary:
[Sep 14, 2019 6:05:40 PM] -------------------
[Sep 14, 2019 6:05:40 PM] OPatchauto failed to execute some of the patching steps. Please check the Patching summary,individual logs and
try to resolve the issue. Once the issue is resolved,Please execute below script to complete patching session:
"<MiddleWare_Home>/oms/.opatchauto_patch_storage/oms_session/scripts_<TimeStamp>/run_script_singleoms_resume.sh"

------------------------------------------------------------------------------------------------
OPatchauto wont allow any other patching operations unless the script is executed successfully
------------------------------------------------------------------------------------------------

 

 

.../gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS1/logs/EMGC_OMS1.out

Fetched repository credentials from Credential Store
Invalid Connection Pool. ERROR = Unable to set EM Context: java.sql.SQLException: ORA-04063: package body "SYSMAN.EM_USER_MODEL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYSMAN.EM_USER_MODEL"
ORA-06512: at "SYSMAN.MGMT_USER", line 12027
ORA-06512: at "SYSMAN.SETEMUSERCONTEXT", line 52
ORA-06512: at line 1

<Sep 14, 2019 9:04:00 PM EDT> <Alert> <WebLogicServer> <BEA-000396> <Server shutdown has been requested by weblogic>
<Sep 14, 2019 9:04:01 PM EDT> <Warning> <HTTP> <BEA-101162> <User defined listener oracle.sysman.eml.app.ContextInitializer failed: java.lang.NullPointerException.
java.lang.NullPointerException
at oracle.sysman.core.common.trace.Tracer.destroy(Tracer.java:468)
at oracle.sysman.eml.app.EMConsoleServer.onShutdown(EMConsoleServer.java:239)
at oracle.sysman.eml.app.ContextInitializer.contextDestroyed(ContextInitializer.java:194)
at weblogic.servlet.internal.EventsManager$FireContextListenerAction.run(EventsManager.java:482)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
Truncated. see log file for complete stacktrace

 

 

 

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


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