EM 12c and 13c : OMS Installation with Repository in a 12.1.0.2 Database Fails at Repository Configuration Assistant (47%) with ORA-1031 Error (Doc ID 2089892.1)

Last updated on JULY 02, 2017

Applies to:

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

Symptoms

Installing 12.1.0.5 OMS on Linux x86-64 bit OS with repository in a 12.1.0.2 database on the same machine.
The repository configuration assistant failed at 47%.

The <OMS_HOME>/cfgtoollogs/cfgfw/CfmLogger_2015-12-14_07-22-51-PM.log shows

INFO: oracle.sysman.top.oms:The transx action failed, Run the RepManager with -action transx
INFO: oracle.sysman.top.oms:process_id:1jhe6rija7607
INFO: oracle.sysman.top.oms:Failure...
INFO: oracle.sysman.top.oms:1 error(s) happened in performing the action:
INFO: oracle.sysman.top.oms:1):
ORA-01031: insufficient privileges
File:/u00/app/oracle/Middleware/oms/12.1.0.5/oms/sysman/admin/emdrep/sql/core/latest/admin/admin_create_repos_user.sql
Statement:CREATE USER SYSMAN IDENTIFIED BY ****** DEFAULT TABLESPACE MGMT_TABLESPACE QUOTA UNLIMITED ON MGMT_TABLESPACE TEMPORARY TABLESPACE TEMP
INFO: oracle.sysman.top.oms:The plug-in Repository Configuration has failed its perform method
INFO: Cfm.save() was called
INFO: Cfm.save(): 6 aggregate instances saved
INFO: done waiting for Action from 19:35:31.464

The <OMS_HOME>/sysman/log/schemamanager/m_121415_0735_PM/m_121415_0735_PM.CREATE shows that SYSMAN user creation failed with ORA-1031:

INFO: passing secured variable : EM_VIEW_PASSWORD to RCU
Dec 14, 2015 7:36:12 PM oracle.sysman.emdrep.schemamanager.EMSchemaLogger error
SEVERE: ERROR:ORA-01031: insufficient privileges
File:/u00/app/oracle/Middleware/oms/12.1.0.5/oms/sysman/admin/emdrep/sql/core/latest/admin/admin_create_repos_user.sql
Statement:CREATE USER SYSMAN IDENTIFIED BY ****** DEFAULT TABLESPACE MGMT_TABLESPACE QUOTA UNLIMITED ON MGMT_TABLESPACE TEMPORARY TABLESPACE TEMP
Dec 14, 2015 7:36:12 PM oracle.sysman.emdrep.schemamanager.EMSchemaLogger debug
FINE: RCU Method completed
Dec 14, 2015 7:36:12 PM oracle.sysman.emdrep.schemamanager.SchemaAction log
INFO: Trying to update last status to error

The <OMS_HOME>/sysman/log/schemamanager/m_121415_0735_PM/rcu.log also reports:

Mon Dec 14 19:36:12.955 PST 2015 ERROR rcu: oracle.sysman.assistants.rcu.backend.action.AbstractAction::handleNonIgnorableError: Received Non-Ignorable Error: ORA-01031: insufficient privileges
File:/u00/app/oracle/Middleware/oms/12.1.0.5/oms/sysman/admin/emdrep/sql/core/latest/admin/admin_create_repos_user.sql
Statement:CREATE USER SYSMAN IDENTIFIED BY ****** DEFAULT TABLESPACE MGMT_TABLESPACE QUOTA UNLIMITED ON MGMT_TABLESPACE TEMPORARY TABLESPACE TEMP
Mon Dec 14 19:36:12.955 PST 2015 TRACE rcu: oracle.sysman.assistants.rcu.backend.action.AbstractAction::handleNonIgnorableError: Delegating to caller ErrorListener
Mon Dec 14 19:36:12.958 PST 2015 ERROR rcu: oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine::onException: SQLException: ORA-01031: insufficient privileges
java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1009)

-  Mandatory patches as per <Note 1987905.1> have been applied to the database.
-  This can occur for an EM 13c installation as well.

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