FMW - Repository Creation Utility (RCU) schemas - for Oracle Forms

Versao Portuguesa

This post is about how to create database schema for Oracle Fusion Middleware, using the Repository Creation Utility (RCU).
In Command line - This bellow reproach can be used for automation

Export the database connection details

In this case I've already a database, Vendor Oracle, Database Oracle 12c

[weblogic@wls1 bin]$ export MWDB=wls1.mydomain:1521/ORCL

Create a file with passwords

The first line is for SYS user, the remain are for the Oracle Fusion Middleware components

[weblogic@wls1 bin]$ echo "oracle
componentSTB1
componentPSS1
componentIAU1
componentIAU1
componentIAU1"> $ORACLE_HOME/fusion.passwords

[weblogic@wls1 bin]$ cat $ORACLE_HOME/fusion.passwords
oracle
componentSTB1
componentPSS1
componentIAU1
componentIAU1
componentIAU1

Run the RCU in silent mode

I will pass as parameters the database connectionstring, the prefix for the database schemas
The components for Forms and as input the password file

[weblogic@wls1 bin]$ cd $ORACLE_HOME/oracle_common/bin

[weblogic@wls1 bin]$ ./rcu -silent -createRepository -connectString $MWDB \
-dbUser sys -dbRole sysdba -lockSchemas false -schemaPrefix RA \
-component STB -component OPSS -component IAU -component IAU_APPEND -component IAU_VIEWER < $ORACLE_HOME/fusion.passwords

RCU Logfile: /tmp/RCU2018-12-14_19-16_144421421/logs/rcu.log

Enter the database password(User:sys):

Processing command line ....
Repository Creation Utility - Checking Prerequisites
Checking Global Prerequisites
The selected Oracle database is not configured to use the AL32UTF8 character set.
Oracle strongly recommends using the AL32UTF8 character set for databases that support Oracle Fusion Middleware.

Enter the schema password for [RA_STB]:
Enter the schema password for [RA_OPSS]:
Enter the schema password for [RA_IAU]:
Enter the schema password for [RA_IAU_APPEND]:
Enter the schema password for [RA_IAU_VIEWER]:

Repository Creation Utility - Checking Prerequisites
Checking Component Prerequisites
Repository Creation Utility - Creating Tablespaces
Validating and Creating Tablespaces
Repository Creation Utility - Create
Repository Create in progress.
Percent Complete: 25
Percent Complete: 25
Percent Complete: 27
Percent Complete: 29
Percent Complete: 31
Percent Complete: 31
Percent Complete: 31
Percent Complete: 42
Percent Complete: 42
Percent Complete: 54
Percent Complete: 54
Percent Complete: 54
Percent Complete: 63
Percent Complete: 63
Percent Complete: 75
Percent Complete: 75
Percent Complete: 75
Percent Complete: 84
Percent Complete: 84
Percent Complete: 89
Percent Complete: 89
Percent Complete: 100
Repository Creation Utility: Create - Completion Summary

Database details:
-----------------------------
Host Name : wls1.mydomain
Port : 1521
Service Name : MW_PDB.MYDOMAIN
Connected As : sys
Prefix for (prefixable) Schema Owners : RA
RCU Logfile : /tmp/RCU2018-12-14_19-16_144421421/logs/rcu.log

Component schemas created:
-----------------------------
Component Status Logfile
Common Infrastructure Services Success /tmp/RCU2018-12-14_19-16_144421421/logs/stb.log
Oracle Platform Security Services Success /tmp/RCU2018-12-14_19-16_144421421/logs/opss.log
Audit Services Success /tmp/RCU2018-12-14_19-16_144421421/logs/iau.log
Audit Services Append Success /tmp/RCU2018-12-14_19-16_144421421/logs/iau_append.log
Audit Services Viewer Success /tmp/RCU2018-12-14_19-16_144421421/logs/iau_viewer.log

Repository Creation Utility - Create : Operation Completed

Reference and Further Reading

RCU | FORMS

Thank you for reading, hope this post was helpful.
Rogerio