EM 12c: Enterprise Manager Cloud Control Upgrade to 12.1.0.5 Fails in the OMS Configuration Assistant with Error: java.lang.Exception: Failed during upgradeOpss

(Doc ID 2341063.1)

Last updated on JANUARY 02, 2018

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.5.0 to 12.1.0.5.0 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Enterprise Manager (EM) 12.1.0.3 Cloud Control upgrade to 12.1.0.5, fails in the OMS configuration with the following logged errors:

From <OMS Oracle Home>/cfgtooollogs/cfgfw/CfmLogger_<Timestamp>.log:

INFO: oracle.sysman.top.oms:Deploying EM ......
INFO: oracle.sysman.top.oms:Deployment of EM completed successfully.
INFO: oracle.sysman.top.oms:
INFO: oracle.sysman.top.oms:Configuring webtier ......
INFO: oracle.sysman.top.oms:Configuring webTier completed successfully.
INFO: oracle.sysman.top.oms:
INFO: oracle.sysman.top.oms:Securing OMS ......
INFO: oracle.sysman.top.oms:EM Key is secured and is backed up at <OMS_HOME>/sysman/config/emkey.ora
INFO: oracle.sysman.top.oms:java.lang.Exception: Failed during upgradeOpss
INFO: oracle.sysman.top.oms: at oracle.sysman.omsca.adapter.wls.OMSWLSAdapter.adapterPostDeployAndReposSetup(OMSWLSAdapter.java:3123)
INFO: oracle.sysman.top.oms: at oracle.sysman.omsca.framework.OMSGenericAdapter.postDeployAndReposSetup(OMSGenericAdapter.java:330)
INFO: oracle.sysman.top.oms: at oracle.sysman.omsca.framework.OMSCAUpgradeInstall.execute(OMSCAUpgradeInstall.java:431)
INFO: oracle.sysman.top.oms: at oracle.sysman.omsca.framework.OMSConfigAssistantDriver.main(OMSConfigAssistantDriver.java:240)
INFO: oracle.sysman.top.oms:OMSCA-ERR:Securing of OMS failed
INFO: oracle.sysman.top.oms:
INFO: oracle.sysman.top.oms:OMSCA-ERR:Post "Deploy and Repos Setup" operations failed. Check the trace file:<OMS_HOME>/cfgtoollogs/omsca/omsca_20171218150926.log
INFO: oracle.sysman.top.oms:
Check the OMS Configuration Assistant logs at: <OMS_HOME>/oms/cfgtoollogs/omsca

 

From <OMS Oracle Home>/cfgtoollogs/omsca/logs<Timestamp>/emLogs/sysman/log/secure.log:

JPS config: ../gc_inst/em/EMGC_OMS1/../../user_projects/domains/GCDomain/config/fmwconfig/jps-config.xml
jazn data: ../gc_inst/user_projects/domains/GCDomain/config/fmwconfig/system-jazn-data.xml
audit store: ../gc_inst/user_projects/domains/GCDomain/config/fmwconfig/audit-store.xml
jdbc url: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oeclgrid.intranetcl.corp)(PORT=1569)))(CONNECT_DATA=(SID=oeclgrid)))
Mon Dec 18 16:17:56 CLST 2017
Calling upgradeOpss in offline mode
{upgradeJseStoreType=null, auditStore=../gc_inst/user_projects/domains/GCDomain/config/fmwconfig/audit-store.xml, password=vamp0712, user=SYSMAN_OPSS, url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oeclgrid.intranetcl.corp)(PORT=1569)))(CONNECT_DATA=(SID=oeclgrid))), jdbcDriver=oracle.jdbc.driver.OracleDriver, jaznData=../gc_inst/user_projects/domains/GCDomain/config/fmwconfig/system-jazn-data.xml, jpsConfig=../gc_inst/em/EMGC_OMS1/../../user_projects/domains/GCDomain/config/fmwconfig/jps-config.xml}
Starting upgrade of opss configuration and security stores.
Command FAILED, Reason: JPS-10000: There was an internal error in the policy store.
oracle.security.jps.service.policystore.PolicyStoreConnectivityException: JPS-10000: There was an internal error in the policy store.
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.handleRollbackException(JpsDBDataManager.java:1345)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.internalCommitTxn(JpsDBDataManager.java:1508)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.modifyJpsPolicyObjectInDoAs(JpsDBDataManager.java:2163)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.modifyJpsPolicyObject(JpsDBDataManager.java:2020)
at oracle.security.jps.internal.policystore.entitymanager.impl.ApplicationManagerImpl.upgradeApplicationContainersInTransaction(ApplicationManagerImpl.java:929)
at oracle.security.jps.internal.policystore.entitymanager.impl.ApplicationManagerImpl.upgradeApplication(ApplicationManagerImpl.java:1283)
at oracle.security.jps.internal.policystore.ldap.LdapPolicyStore.upgradeApplicationPolicy(LdapPolicyStore.java:1635)
at oracle.security.jps.internal.policystore.ldap.LdapPolicyStore.upgradeApplicationDIT(LdapPolicyStore.java:1618)
at oracle.security.jps.upgrade.tools.DBPolicyStoreUpgrade.upgradeApplicationDIT(DBPolicyStoreUpgrade.java:145)
at oracle.security.jps.upgrade.tools.DBPolicyStoreUpgrade.upgrade(DBPolicyStoreUpgrade.java:178)
at oracle.security.jps.upgrade.tools.utility.Upgrade.upgrade(Upgrade.java:327)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.python.core.PyReflectedFunction.__call__(Unknown Source)
at org.python.core.PyReflectedFunction.__call__(Unknown Source)
at org.python.core.PyObject.__call__(Unknown Source)
at org.python.core.PyObject.invoke(Unknown Source)
at org.python.pycode._pyx30.upgradeOpss$73(<OMS_HOME>/oracle_common/common/wlst/jpsWlstCmd.py:1749)
at org.python.pycode._pyx30.call_function(<OMS_HOME>/oracle_common/common/wlst/jpsWlstCmd.py)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyFunction.__call__(Unknown Source)
at org.python.pycode._pyx50.f$0(<OMS_HOME>/sysman/omsca/scripts/wls/upgradeOpss.py:31)
at org.python.pycode._pyx50.call_function(<OMS_HOME>/sysman/omsca/scripts/wls/upgradeOpss.py)
at org.python.core.PyTableCode.call(Unknown Source)
at org.python.core.PyCode.call(Unknown Source)
at org.python.core.Py.runCode(Unknown Source)
at org.python.util.PythonInterpreter.execfile(Unknown Source)
at weblogic.management.scripting.WLST.main(WLST.java:139)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at weblogic.WLST.main(WLST.java:29)
Caused by: javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-01950: no privileges on tablespace 'MGMT_TABLESPACE'

Error Code: 1950
Call: INSERT INTO JPS_ATTRS (JPS_ATTRS_ID, ATTRNAME, ATTRVAL, JPS_DN_ENTRYID) VALUES (?, ?, ?, ?)
bind => [4 parameters bound]
Query: InsertObjectQuery(EntryId = 9112:Attribute RowId = 35566
orcldistributionversion = 23965)
at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commitInternal(EntityTransactionImpl.java:102)
at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:63)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager$8.run(JpsDBDataManager.java:1487)
at oracle.security.jps.internal.policystore.rdbms.JpsDBDataManager.internalCommitTxn(JpsDBDataManager.java:1492)
... 34 more
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-01950: no privileges on tablespace 'MGMT_TABLESPACE'

 

 

 

Changes

 

Cause

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 hundreds of Community platforms