ORA-01031 ORA-47410 Errors Trying To Create Metadata Schemas For Oracle Webcenter With RCU (Doc ID 1932414.1)

Last updated on APRIL 06, 2023

Applies to:

Symptoms

Installation of the MDS schema for WebCenter Portal 11.1.1.8 fails in an Oracle RDBMS 12.1.0.2 database. In the RCU tool, the following warning is shown :

ORA-01031: insuffient privileges
File:/rcuHome/rcu/integration/mds/sql/mds_user.sql
Statement: CREATE USER &&1 IDENTIFIED BY ****** DEFAULT TABLESPACE &&3 TEMPORARY TABLESPACE &&4

Within the rcu.log, the following errors are seen:

2014-09-29 16:18:54.459 ERROR rcu: oracle.sysman.assistants.rcu.backend.action.AbstractAction::handleNonIgnorableError: Received Non-Ignorable Error: ORA-01031: insufficient privileges
File:/rcuHome/rcu/integration//mds/sql/mds_user.sql
Statement:CREATE USER &&1 IDENTIFIED BY ****** DEFAULT TABLESPACE &&3 TEMPORARY TABLESPACE &&4


2014-09-29 16:19:09.586 ERROR rcu: oracle.sysman.assistants.rcu.backend.action.AbstractAction::handleNonIgnorableError: Received Non-Ignorable Error: ORA-47410: Realm violation for GRANT on CONNECT
File:/rcuHome/rcu/integration//mds/sql/mds_user.sql
Statement:GRANT connect TO &&1
The connection to the database is made as SYS with SYSDBA privilege :
2014-09-29 16:18:54.195 NOTIFICATION rcu: oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine::connect: Connecting to database: user:<USERNAME>, role:SYSDBA, connectString:(description=(address=(host=<IP ADD>)(protocol=tcp)(port=<DBPORT>))(connect_data=(service_name=STE)(server=dedicated)))

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.