1. Creating Schemas with the Repository Creation Utility
  2. Troubleshooting Repository Creation Utility

D Troubleshooting Repository Creation Utility

Review this information to help you understand and troubleshoot any errors or issues that you encounter while you run the RCU.

General Troubleshooting Tips

Use these tips to help troubleshoot any errors that you encounter during installation.

  • See Install and Configure in the Release Notes for Oracle Fusion Middleware Infrastructure for the latest updates and issues related to Oracle Fusion Middleware product installation and configuration.

  • Verify that your computer meets the requirements as specified in the Oracle Fusion Middleware System Requirements and Specifications document.

    Select the document that is applicable for your release.

  • Verify that your environment meets the certification requirements for your release and platform, as specified on the Oracle Fusion Middleware Supported System Configurations page.

  • Make sure that your database is up and running.

  • If you entered incorrect information on one of the screens, use the navigation pane on the left most side of the graphical interface to return to that screen.

  • If an error occurred while running RCU:

    1. Note the error and review the installation log files (see RCU Log Files).

    2. Correct the issue that caused the error. Depending on the type of error, you may either continue with your RCU operation, or you are forced to restart RCU.

    3. Continue or restart RCU to complete your desired operation.

Parent topic: Troubleshooting Repository Creation Utility

RCU Log Files

When you run RCU to create or drop your schemas, the main RCU log file is written to the /tmp/RCUdate_timestamp_random_number/logs directory on UNIX operating systems, by default. Review the log files for important information that may help you resolve your issues.

Parent topic: Troubleshooting Repository Creation Utility

SOAINFRA Schema Creation Fails on a Hardened Database

Use this workaround if the RCU schemas for SOAINFRA does not load successfully on an Oracle hardened database.

In case of an Oracle hardened database, when the public grants are revoked for the PL/SQL packages, the schema creation for SOAINFRA fails with the following error:

Received Non-Ignorable Error: ORA-04063: package body "XDB.DBMS_CSX_INT" has errors

Grant the following permission to the user and run the Repository Creation Utility (RCU) again to create the schemas for SOAINFRA.

GRANT EXECUTE ON DBMS_LOB TO XDB;

Parent topic: Troubleshooting Repository Creation Utility

Troubleshooting Tips for Schema Creation on an Autonomous Transaction Processing Database

Use these tips to troubleshoot any errors you encounter during schema creation on an Autonomous Transaction Processing database (both Autonomous Transaction Processing - Dedicated and Autonomous Transaction Processing-Shared).

  • See Issues Pertaining to Product Installation and Configuration with Autonomous Database in the Release Notes for Oracle Fusion Middleware Infrastructure for issues related to installation and configuration for Oracle Fusion Middleware products on an Autonomous Transaction Processing database.

  • In the Database Connection Details screen, when you select the database user role as Normal, the following warning is displayed:

    Sysdba or dba privileges are required to load schema

    You can click Ignore and continue with the schema creation.

  • If you are creating schemas on an Autonomous Transaction Processing - Dedicated database, in the Map Tablespaces screen, if you receive any tablespace creation error due to insufficient privileges or exceeding of maximum number of DB_FILES, you can override the default and temporary tablespaces for the selected components by selecting existing tablespaces from the drop-down list in the Default Tablespace column and Temp Tablespace column.

    For example, to override the default and temporary tablespaces, you can select DATA from the drop-down list in the Default Tablespace column, and TEMP from the drop-down list in the Temp Tablespace column.

    Note:

    If you are creating schemas on an Autonomous Transaction Processing-Shared database, in the Map Tablespaces screen, you must override the default and temporary tablespaces. See Map Tablespaces.

  • During Oracle WebCenter Content schema creation, warnings are displayed in the Summary screen.

    You can click Ignore and continue with the schema creation.

    Example warning messages:

    ORA-01031: insufficient privileges
File:/home/opc/idm/oracle_common/../wcccontent/common/sql/content/sql/oracle/contentserverrole.sql
Statement: GRANT SELECT  ON CTXSYS.DR$PENDING TO contentserver_role
    ORA-01450: maximum key length (6398) exceeded
File:/home/opc/jrf/oracle_common/../wcccontent/common/sql/content/sql/oracle/contentserverrole.sql
Statement: CREATE TABLE RunTimeConfigData
    ORA-01450: maximum key length (6398) exceeded
File:/home/opc/jrf/oracle_common/../wcccontent/common/sql/content/sql/oracle/intradoc.sql
STATEMENT Create table Subscription

    where, /home/opc/idm and /home/opc/jrf are the ORACLE HOME locations.

  • During Oracle Internet Directory schema creation, when the schemas are loading, the warning ORA-28007: the password cannot be reused is displayed in the Summary screen.

    You can click Ignore and continue with the schema creation.

  • During SOAINFRA schema creation, for Oracle Identity Management, the warning ORA-24010: QUEUE DEV24_SOAINFRA.IP_IN_QUEUE does not exist is displayed in the RCU logs. This warning does not have any functional impact and can be ignored.

  • During schema creation of Oracle Enterprise Scheduler and Oracle Managed File Transfer SOA products, in the Summary screen, the following warning "ORA-01031: insufficient privileges" is displayed and the schema creation fails.

    Add the create any job privilege to the ADMIN user, and restart the schema creation.

  • During schema creation of Oracle Enterprise Scheduler and Oracle Managed File Transfer SOA products, even after adding the create any job privilege, in the Summary screen, the warning "ORA-01031: insufficient privileges" is displayed.

    For ATP-D, you can apply the patch 31443286 and restart the schema creation., and for ATP-S, you can apply the patch 33351665 and restart the schema creation.

Parent topic: Troubleshooting Repository Creation Utility

Known Limitation for Oracle WebCenter Sites ATP-S Migration

For Oracle WebCenter Sites, you cannot install and configure FirstSiteII sample site, and therefore, you cannot create new promotion assets, after you migrate an on-premises database to an Oracle Autonomous Transaction Processing (ATP-S) database.

As there is no workaround available, you must exclude FirstSiteII during the installation.

Parent topic: Troubleshooting Repository Creation Utility

Need More Help?

If this guide does not solve the problem that you encountered, try looking for a solution on My Oracle Support (formerly Oracle MetaLink).

https://support.oracle.com/

If you are unable to find a solution for your problem, open a service request.

Parent topic: Troubleshooting Repository Creation Utility