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 and later
Information in this document applies to any platform.


 Insufficient privileges error when running RCU during upgrade of OAM from to

I examine the rcu log

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

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. 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.
Component schemas created:
Component Status Logfile
Oracle Mobile Security Manager Success /var/tmp/oam/RCU_11.


2015-12-16 09:34:33.230 rcu:Extracting Statement from File Name: '/var/tmp/oam/RCU_11.'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

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


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


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