"ORA_00059:maximum number of DB_FILES exceeded" Signalled when Creating Tablespaces with the Repository Configuration Utility (RCU)

(Doc ID 2397373.1)

Last updated on MAY 17, 2018

Applies to:

Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Oracle Data Integrator - Version 11.1.1.7.0 and later
Data Integration Platform Cloud - Version 17.3.5 and later
Information in this document applies to any platform.

Symptoms

When The Oracle Data Integrator (ODI) Repository Creation Utility (RCU) is executed to create Repositories a Warning Message is seen

At Repository Creation Utility Screens -->Map Tablespaces

Warning Message:

ORA_00059:maximum number of DB_FILES exceeded

And In the RCU logs, the below error is seen

java.sql.SQLSyntaxErrorException: ORA-01917: user or role 'XXXXX_OPSS' does not exist
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)

 

 

 

Changes

 

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