Using Repository Creation Utility (RCU) to create SOA Schemas

The Repository Creation Utility (RCU) is used to create schemas to support Oracle Enterprise Performance Management System Java web applications.. This process requires sys DBA credentials.

To create schemas using the Repository Creation Utility:

Note:

Before you start the RCU:

• Verify that a certified JDK already exists on your system by running java -version from the command line. For Oracle SOA Suite 12c (12.2.1.4.0), the certified JDK is1.8.0_211 and later. See About JDK Requirements for an Oracle Middleware Installation for more details.
• Ensure that the JAVA_HOME environment variable is set to the location of the certified JDK. For example:
  • (UNIX) setenv JAVA_HOME /home/Oracle/Java/jdk1.8.0_211
  • (Windows) set JAVA_HOME=<Local Drive>:\home\Oracle\Java\jdk1.8.0_211

1. Navigate to Middleware home/oracle_common/bin/.
2. Launch rcu.bat.

   For Linux, run ./rcu

3. The Welcome page is the first screen that appears when you start the RCU. On the Welcome page, click Next.
4. Use the Create Repository screen to select a method to create and load component schemas into the database. On the Create Repository page, select System Load and Product Load. This procedure assumes that you have SYSDBA privileges.
5. Click Next.
6. On the Database Connection Details page , specify a user with DBA or SYSDBA privileges, such as sys, provide the fully qualified host name, service name, and then click Next to proceed.
   For example:

   
       Database Type: Oracle Database
       Host Name: examplehost.exampledomain.com
       Port: 1521
       Service Name: Orcl.exampledomain.com
       User Name: sys
       Password: ******
       Role: SYSDBA
   

7. On the Select Components page, perform these tasks, and then click Next:
   • Select Select existing prefix and then select SOA Suite schema. This will automatically select SOA Infrastructure along with the following schemas as dependencies.
     • Common Infrastructure services
     • Oracle Platform Security Services
     • User Messaging Service
     • Audit Services
     • Audit Services Append
     • Audit Services Viewer
     • Metadata Saervices
     • Weblogic Services
   • Make a note of the Schema Owner names for all the components because you need them to configure Oracle Web Services Manager.
8. On the Schema Passwords page, you must select Use same passwords for all schemas. Enter a password, make a note of it, and then click Next.

   The maximum password length is 16 characters.

   The password can contain alphabets, numbers, and the following special characters: $, #, _. Password should not start with a number or special character.

9. On the Custom Variables page, specify the custom variables for the SOA Infrastructure schema. For the Oracle SOA Suite, accept both default values for Database Profile (Small) and Healthcare Integration (No).
10. On the Map Tablespaces page, click Next, and then click OK to create tablespaces.
11. On the Summary page, review the selections, and then click Create.
12. On the Completion Summary page, click Close.