Repository Creation Utility (RCU) - Creation of DB Schemas for SOA 12.2.1

Many of the Oracle Fusion Middleware components require the existence of schemas in a database prior to installation. These schemas are created and loaded in your database using the Repository Creation Utility (RCU).

Here I am going to explain steps for Running RCU and Creating Schemas for Oracle SOA 12.2.1

Step 1:
Navigate to oracle_common/bin in your installation directory.
e.g.
D:\Oracle_Home\SOA12c_Home\oracle_common\bin

Here you will see below, files

Step 2:
Locate rcu.bat, Double click on it, it will a new window in some time as below. Then click on Next button.

Step 3:
Now you need to have SYSDBA credentials of your DB, Select 'System Load & Product Load' then Click next.
If you do not have SYSDBA credentials, select other options as suitable.

Step 4:
Enter details of your DB and click on Next button.

Step 5:
It will try to connect to your DB, the Click on OK Button.

Step 6:
Enter the Prefix of your Schemas, then click Next

Step 7:
It will check for Pre requisite, once completed click on OK button

Step 8:
Enter the Password for the Schemas, you can either keep the same password across schemas or different for each schema. Then Click on Next button

Step 9:
Select space requirement for your schema, then click Next

Step 10:
It will show you Temp table against each schema, Click on Next Button

Step 11:
It will show you a warning that, tablespaces will  be created, Click on Ok

Step 12:
It will create Tablespace, once completed click on Next Button

Step 13 :
Here you will see a summary screen, make note of the Schema names, then click Create.

Step 14 :
You will see a completion summary screen, Click on Close button.

Voila !
You have successfully completed creation of new Schemas for SOA 12.2.1






Here are few related posts, which may interest you

1.Oracle SOA Suite 12c 12.2.1 - Installation for Windows

http://osb-dheeraj.blogspot.in/2016/02/oracle-soa-suite-12c-1221-installation.html

2. Repository Creation Utility (RCU) - Creation of DB Schemas for SOA 12.2.1

http://osb-dheeraj.blogspot.in/2016/02/repository-creation-utility-rcu.html

3. Oracle SOA Suite 12c - SOA Domain Configuration

http://osb-dheeraj.blogspot.in/2016/02/oracle-soa-suite-12c-soa-domain.html

Oracle Service Bus 11g - Domain Configuration for Windows

Here I am gonna discuss Domain Configuration for Oracle Service Bus 11g for windows PC.

As we have already installed Oracle Service Bus 11g
For Details visit

Oracle Service Bus 11g - Installation for Windows 32 bit

http://osb-dheeraj.blogspot.in/2013/07/oracle-service-bus-11g-installation-for.html

now we will be moving forward with Domain Configuration.

Step 1 : 

Locate the OSB Home directory Inside Middleware Home, and move to directory:  \Oracle\Middleware\OSB_Home\common\bin

Inside the Bin Directory, you will find config.cmd file. Open it either by Double clicking on or by using command Prompt.

Choose the Option "Create new WebLogic Domain" Then click next


Step 2 :

Choose Oracle service Bus , it will also select few other required products.
You can also select other products as per your requirement.

Click next

Step 3 :

Provide name of Domain and Location of Domain Directory.
Oracle Recommend a separate Domain Directory from Fusion Middleware installation Directory.

Click next

Step 4 :

Provide Username and Password for Domain administrator

Click next


Step 5 :

Choose your JDK version available. For production environment JRockit is reccomended.

Click next

Step 6 : 

Select the "OSB JMS Reporting Provider "
It will choose default derby evaluation Database included with Weblogic.

if you want your separate database, then you need to install any Oracle DB compatible database and create schemas using Repository Creation utility (RCU), and Provide those details here.
I will Discuss the steps for running RCU in separate Post.

Click next

Step 7 :

Configuration utility will verify Connection with Schema as provided in next screen and will show the status here.
Since we have chosen Derby Evaulation DB and it is not running now, So the test result will be Failed.
When we start the Admin server later it will automatically start the Derby DB.

Click next, it will show you an error Popup, click Ok to byepass the test.

Step 8 :

Now choose Adinistration Server and Managed server, in this screen.

Click next

Step 9 :

Give name to Admin server and Port no. (Please check the port is not assigned to any other service in your PC).

Click next

Step 10 :

Provide name and port no. for the Managed server here

Click next

Step 11 :

Since our installtion is on single physical machine, so we need not to configure cluster.
Leave default and click next

Step 12 :

Click on 'add machine'
Provide details of machine eg name and address.

Click next


Step 13 :

Assign servers to Machine by clicking arrow button available on centre column. This will be used by NodeManager to start and stop servers remotedly.

Click next


Step 14 :

Verify the summary details for this new Domain. Then click Create.

 This will start domain configuration.

Make note of admin server URL and click Done.

This will finish the Domain Configuration of OSB 11g.
Now in order to start development, we need to start the Admin and managed server, which we have created here.

The process of starting and stopping Admin and Managed server, I will discuss in my next Post.