OMSM: ORA-01031: insufficient privileges running RCU to create schema (Doc ID 2095050.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Access Manager - Version 11.1.2.3.0 and later
Information in this document applies to any platform.

Symptoms

 Insufficient privileges error when running RCU 11.1.1.9 during upgrade of OAM from 11.1.1.2 to 11.1.2.3.

I examine the rcu log

QA EnvironmentUpgrade\logdir.2015-12-15_11-02\rcu.logdi
r=========

2015-12-15 11:18:16.319 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.xmldata.handlers.RepositoryConfigHandler::startElement: Curently Parsing Repository Config data for Component : OMSM
2015-12-15 11:18:16.322 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.xmldata.RepositoryConfigManager::parseRepositoryConfigData: XML Document: /var/tmp/oam/RCU_11.1.2.3.0/rcuHome/rcu/integration//omsm/omsm.xml is valid

2015-12-16 09:34:38.870 NOTIFICATION rcu: oracle.sysman.assistants.rcu.ui.InteractiveRCUModel::showCompletionMessage: Repository Creation Utility: Create - Completion Summary
Database details:
Host Name : area51database
Port : 1521
Service Name : 51ServiceNAME
Connected As : sqladminuser
Prefix for (prefixable) Schema Owners : BJCTEST
RCU Logfile : /var/tmp/oam/RCU_11.1.2.3.0/rcuHome/rcu/log/logdir.2015-12-16_09-31/rcu.log
Component schemas created:
Component Status Logfile
Oracle Mobile Security Manager Success /var/tmp/oam/RCU_11.1.2.3.0/rcuHome/rcu/log/logdir.2015-12-16_09-31/omsm.log

omsmlog

2015-12-16 09:34:33.230 rcu:Extracting Statement from File Name: '/var/tmp/oam/RCU_11.1.2.3.0/rcuHome/rcu/integration//omsm/sql/omsm.sql'Line Number: 32
2015-12-16 09:34:33.231 rcu:Extracted SQL Statement: [CREATE USER &&1 identified by "&&2" default tablespace &&3 temporary
tablespace &&4]
2015-12-16 09:34:33.231 rcu:Statement Type: 'DDL Statement'
JDBC SQLException - ErrorCode: 1920SQLState:42000 Message: ORA-01920: user name 'BJCTEST_OMSM' conflicts with another user or role name

JDBC SQLException handled by error handler

2015-09-23 13:46:01.183 NOTIFICATION rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::perform: current user=sqladminuser
Connected As : sqladminuser

JDBC SQLException - ErrorCode: 1920SQLState:42000 Message: ORA-01920: user name 'BJCDEVT_OMSM' conflicts with another user or role name

Caused By: oracle.adf.share.ADFShareException: oracle.mds.exception.MDSRuntimeException: ORA-01031: insufficient privileges
ORA-06512: at "BJCDEVT_MDS.MDS_INTERNAL_COMMON", line 226
ORA-06512: at "BJCDEVT_MDS.MDS_INTERNAL_COMMON", line 1710

What could cause this error? How can I work around it?

Changes

 DBA user had SYSDBA privileges but data dictionary views caused insufficient privilege error

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