Advertisements



Using Repository Creation Utility (RCU)

This post is in continuation to the previous post that talked out the OSB installation and setup of Dev environment  in Eclipse IDE. In this post, we will see the database dependency of OSB.

Much of the functionality provided with Oracle Service Bus (OSB) does not have any database dependency. Refer to the oracle blog post here that talks about the same. But there are 2 reasons why we need to look into database as well:

  • OSB Reporting functionality which is provided as one of the service monitoring features, needs database tables to store reporting data. By default, derby internal database is used for this purpose or we can configure to use any other schema during WLS domain creation.
  • And one of the major features included in OSB11g is integration with the Oracle Web Services Manager (OWSM). OWSM provides policy based security solution to secure the proxy services. These out of the box OWSM policies are provided in the metadata store (MDS) that requires a database. Refer to this link for more information on OWSM and FAQs at this link.

These required schemas can be installed into database using repository creation utility provided by oracle. Since we are using OSB11g (11.1.1.3) download the RCU 11.1.1.3.3 from think link. Different schemas that can be created using RCU can be found here. Since we are planning to use OWSM with our OSB installation, we will see  how to install this MDS using RCU.

If we want to use Oracle XE as a database, then we should update the database parameters once after the installation. Set the processes parameter to >=200 using the following instructions.
sqlplus sys/<your password>@XE as sysdba

SQL> show parameter session
SQL> show parameter processes
SQL> alter system reset sessions scope=spfile sid=’*’;
SQL> alter system set processes=200 scope=spfile;
SQL> shutdown immediate
SQL> startup
SQL> show parameter session
SQL> show parameter processes

Unzip the downloaded RCU zip file to any folder in the file system and call this as $RCUHOME. Run the file $RCUHOME/rcuHome/rcu.bat that brings up the below screen with options Create and Drop. We can use same utility to drop the existing schemas as well.

          image

Click on Next to bring up the next screen and give the installed database details.

           image

Click on Next. At this stage the database compatibility check will happen and the following error will be shown if the database is incompatible. As we can the database version should be equal to or higher than 10.2.0.4.0 in 10g or 11.1.0.7.0 in 11g.

            image

If the compatibility check is successful, we will get the following screen with successful message after checking the prerequisites.

            image

Click OK on check prerequisites and proceed to next screen where different schema components can be selected. Give the new prefix as DEV (or some other value you are comfortable with) and select metadata services if we just want OWSM. And select SOA Infrastructure component if you are planning to install SOA Suite as well. So select all these and observe the schema owner column.

            image

Click Next and click on OK, once another prerequisites step is also over. Proceed to the next screen where we can mention the password for each schema that we want to create. Based on preference, we can give the same password to all the schemas or different password for each different schema.

            image

Click on Next and where we can create the required tablespaces for all the schemas that we selected including default and temporary table spaces. We can click on Manage tablespaces if we want to modify any of the default properties.

             image

Click on Next and click on OK in the popup that comes up to create all the tablesapces as mentioned in the previous step. Click on Create in this screen to create all the table spaces.

             image

Once everything is successfully completed, we can see the following screen with completion details.

             image

To verify the successful schema installation, we can go to sql plus screen and login with the respective schema user name and password. For example, the following screen shows the login is successful to DEV_MDS schema and also able to see all the tables.

             image

Advertisements

4 Responses to “Using Repository Creation Utility (RCU)”


  1. 1 punit porwal January 10, 2017 at 2:48 PM

    Hi, I am getting some pl/sql error while creating rcu for SOA, may I know the possible reason for pl/sql error, what is causing this kind of errors

  2. 4 Deb Mukherjee October 23, 2013 at 10:12 AM

    Sir,
    I express my gratitude to you for this brilliant article.It was of great help to me.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




Advertisements

Pages

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 341 other followers

Enter your email address to follow this blog and receive notifications of new posts by email.