My Oracle Support Banner

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

Last updated on AUGUST 09, 2018

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

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
Changes
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.