Advertisements

Posts Tagged 'rcu'

SOA Suite 12c Installation

By this time, you might already know that SOA Suite12c released last week. The twitter world is abuzz with the most awaited SOA Suite release and gave a welcome in great fashion. I too was equally excited to get a glimpse of it and try out some hands-on the same. In this post, we will quickly go through the SOA Suite 12c installation.

We can say that installation is quite streamlined and made simple with single installer that includes JDeveloper, JDev SOA Extension, RCU, Standalone WLS and Service Bus (formerly Oracle Service Bus). The installer can be downloaded from here.

I tried this installation in Windows 7, 64-bit machine. Make sure you installed JDK and JAVA_HOME environment variable is set before  proceeding with the  installation.

Unzip the installer and start the installation as shown below.

javac

This brings up the welcome screen.

1

Click Next and set Oracle Home to your desired location.

2

Click Next to finish Prerequisites check.

3

Click Next. Here you can review the installation summary and click Install.

4

5

Click Finish to complete the installation.

6

RCU Installation

You need to create the required schemas using RCU before proceeding with domain creation. As I mentioned earlier, no separate installer is required for RCU and comes by default with SOA Suite.

Navigate to $MW_HOME/oracle_common/bin. Locate file rcu.bat and select ‘Run as Administrator’ on right click to bring up the following welcome screen. Make sure that you installed a supported database before proceeding.

rcu2

Click Next and choose default options for creating the repository.

rcu3

Click Next and enter your database information with sys credentials.

rcu4

Click on Next and you can Ignore the warning related to Oracle XE database as you are going to use this domain for development purpose.

rcu5

RCU will perform some prerequisite checks.

rcu6

Click OK to bring up following screen. Enter prefix as you desired and select SOA Infrastructure schema. This will automatically select all other dependent schemas as shown.

rcu7

Click Next and enter the password for all schemas.

rcu9

Click Next and proceed to next screen by accepting the defaults.

rcu11

rcu12

rcu13

rcu14

Click on Close to finish RCU installation.

Domain Creation

Navigate to $MW_HOME/oracle_common/common/bin and locate the file config.cmd. Right click and select ‘Run as Administrator’ to bring up the following screen. Enter your desired domain name.

domain1

Click Next and select the products that your domain want to support.

domain3

Click Next and proceed further by accepting the defaults.

domain4

Click Next and enter the credentials.

domain5

Click Next and choose Domain Mode. You may want to retain Development as Domain Mode. You can accept defaults for JDK or you can select any other location.

domain6

Click Next. Enter STB schema information as shown below and click Get RCU Configuration.

domain8

Once schema retrieving is successfully done, click Next.

domain9

Click Next and verify that connection test is successful for all the schemas. If not, you can go back to previous screen and modify individual schema connection information.

domain10

Once testing is done, Click Next and accept the defaults.

domain11

Click Next and in this screen you verify the domain configuration the wizard is going to create.

domain13

Click Create to start the domain creation.

domain14

Once the the domain creation is successful, Click Next.

domain15

Remember Domain Location and Admin Server URL and click Finish to exit the configuration wizard.

Start the Admin and Managed Servers by executing startWebLogic.cmd, startManagedWeblogic.cmd respectively from bin folder of Domain Location (shown above).

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

Pages

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

Join 374 other followers

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

Advertisements