@OracleIMC Partner Resources & Training: Discover your Modernization options + Reach new potential through Innovation

Getting Started with RCU 12c for SOA 12c

The simplicity is the key ingredient for SOA 12c, This is why Oracle SOA Suite 12c was developed: to simplify IT by
unifying the disparate requirements of mobile, cloud, and IoT
integration into one unified and standards-based platform.

Even the installation of SOA suite 12c is quite streamlined and made simple with
single installer that includes JDeveloper, JDev SOA Extension, RCU,
Standalone WebLogic and Service Bus (formerly Oracle Service Bus). Check here how you can install SOA 12c

What is RCU?
Some of Oracle Fusion Middleware products like SOA Suite, BI, etc. require the existence of certain schema in a database prior to installation and configuration. These schema are created and loaded in your database using the Repository Creation Utility (RCU). In previous versions, RCU is available as a separate download, but in 12c it is bundled with the product.Let's see how you can get started with RCU.

Before you start configuring a domain for SOA, firstly you need to start creating the database schema for SOA, BAM and other components using the RCU.

Repository Creation Utility (RCU) Steps:

  1. Running the RCU: RCU comes bundled with Oracle SOA Suite 12c installation and
    can be run from the $MIDDLEWARE_HOME/oracle_common/bin folder. For
    windows its rcu.bat and for Linux its rcu.sh.
  2. Create Schemas: There are more options compared to the previous version 11g.
    • Select a Method of Schema Creation
      • System Load and Product Load: Use this option if you have SYSDBA credentials.
      • Prepare Scripts for System Load: This option will generate an SQL script, which can be provided to your database administrator.
      • Perform Product Load: Select this option to load and
        create procedures, functions, tables, indexes and other objects within
        schema and run any action if you have a user with limited database privileges.
    • Drop Schema: Drop Schemas that are already created in the database.

    create repository

  3. Provide Database Connection Details:
    Provide the database connection details for RCU to connect to your database.
    • Database Type: Type of database used,It can be Oracle, SQL Server, IBM DB2, etc.
    • Host Name: Host name or IP of the box where the database is running.
    • Port: Port where the database is listening.
    • Service Name: Service name of the database. in my case I am using Oracle XE, it is “XE”.
    • Username: SYS or SYSDBA username
    • Password: username’s password.
    • Role: Either Normal or SYSDBA. Always good to provide a user with SYSDBA role.
    DB Details

  4. Select components
      • Now you need to specify a prefix for the new schemas, such as DEV, so you can access them easily when you are configuring your domain.
      • Select the SOA Suite components and by default the AS Common Schemes will be selected and all of their dependencies.
    SOA Schemas

    Click OK to continue when the prerequisites are checked off.

  5. Set Schemas Password

    you can select the first option to use same passwords for all schemas.

    Schema Password

  6. Custom Variables: accept the default and click Next
    • Remember: you can use this screen for
      • The Database Profiles custom variable SMALL or MEDIUM and LARGE.

      • If you enter SMALL or MEDIUM as the database profile, that means the RCU performs no special actions when the schema is created. this options should be selected for informational purposes only.
      • If you enter LARGE as the database profile,
        that means the RCU creates the SOA Infrastructure schema using an Oracle database
        feature called Interval Partitioning. which  improves the
        efficiency of the database when large numbers of composite applications
        must be processed.
      • If you have Healthcare Integration set the value to Yes. If you do not set this value now, the Healthcare Integration user interface will not work properly 

  7. Map Tablespaces

    Click Next after you review the temporary tablespaces for the components

    Click OK for the next two confirmation dialogues. Then click Next again

  8. Summary

Click Create to begin schema creation. the schema creation is complete. When you click Close.

Create Schemas

For more information please check the documentation for further details click here

Facebook Google+ Twitter LinkedIn Pinterest Delicious Digg Addthis

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha

Integrated Cloud Applications & Platform Services