SOA – Repository Creation Utility (RCU) Installation


This thread covers overview and installation of Repository Creation Utility(RCU) which is preliminary thing you need to do, if you are planning to implement/install Oracle Fusion Middleware 11g R1 – SOA Suite.
The RCU utility could be run after SOA suite installation or before that .

RCU builds couple of Metadata Repository which contains metadata for Fusion Middleware Components (SOA, Webcenter, Identity Management) .
The various types of Repository are :

Metadata Services (MDS)
Audit Services (IAU)
Oracle Internet Directory (OID)

Oracle Identity Federation (OIF)

Web logic Communication Services
Single Sign-On (SSO)
SOA Infrastructure (SOAINFRA)
Business Activity Monitoring (BAM)
User Messaging (ORASDPM)
Oracle WebCenter (WEBCENTER)
WebCenter Portlets (PORTLETS)
Oracle Content Server (OCSERVER)
Portal (PORTAL)
Discoverer (DISCOVERER)
Discussions (DISCUSSIONS)
Wiki and Blog (WIKI)

The Installation process can be undergone in below steps :

So what we can see is that during Installation process there is couple of RCU related errors have been flagged .To avoid the processes and open_cursor errors first Stop the installation and execute below using SYSDBA account :

sqlplus sys/sys as sysdba
show parameters processes    — This  will show the current value
show parameters open_cursors  — This will show the current value

ALTER SYSTEM SET processes=500 SCOPE=spfile; — Altering the value will remove the RCU : 6107 DB Init Param error from next execution

ALTER SYSTEM SET open_cursors=500 SCOPE=spfile; — Altering the value remove the RCU : 6107 DB Init Param error from next execution

Apart from that , if you don’t have any new tablespace for the repository metadata items it will be created during run-time installation .

NLS_NCHAR_CHARACTERSET AL16UTF16N.B : – If your database characterset is not AL32UT8 unicode format, where your repository is going to build  you could encounter warning message and can ignore this but Oracle strongly recommend of having character set strictsuperset of any DB character set . Otherwise you can perform CSSCAN and CSALTER utility to do the change .Its not that simple believe me ! You could also refer the Ora Doc for Characterset conversion here . However for my case I have kept it as it was before migration i.e below :

SQL> select * from nls_database_parameters;PARAMETER                                                   VALUE
—————————— —————————————-
NLS_CSMIG_SCHEMA_VERSION               5
NLS_NCHAR_CHARACTERSET             AL16UTF16
NLS_LANGUAGE                                         AMERICAN
NLS_TERRITORY                                        AMERICA
NLS_CURRENCY                                                  $
NLS_ISO_CURRENCY                               AMERICA
NLS_NUMERIC_CHARACTERS                      .,
NLS_CHARACTERSET                             WE8MSWIN1252
NLS_CALENDAR                                       GREGORIAN
NLS_DATE_FORMAT                                   DD-MON-RR
NLS_DATE_LANGUAGE                            AMERICAN

For my case , only Portal Configuration Assistant failed during installation and RCU :6135 , 6130 thrown .However , no specific remedy has been found  neither in google and nor in metalink (till now) and hence not be able to document this . If somebody find the reason behind it, I will be happy to accept !

Oracle Fusion Middleware 11g Installation


Download the SOA Suite 11g from OTN FMW Page .

Oracle Fusion Middleware Installation0

Verify the actual JDK/JRE settings from Control Panel Java option i.e. from JNLP Runtime settings of proper Java Platform .

See below how to find it …. Go to Control Panel –) Double click Java .

Oracle Fusion Middleware Installation1Oracle Fusion Middleware Installation2 Oracle Fusion Middleware Installation3

—————————————————————————————-

So in my case , I have copied the actual JDK/JRE path SOA required from System tab , Run the installer and follow the steps one by one .You will be prompted for input of JDK/JRE location in command prompt as below(in yellow) :

Oracle Fusion Middleware Installation4

Oracle Fusion Middleware Installation5Oracle Fusion Middleware Installation6

Oracle Fusion Middleware Installation7Oracle Fusion Middleware Installation8

Oracle Fusion Middleware Installation9Oracle Fusion Middleware Installation10

—————————————————————————————

Simple ! Now we will be installing the Repository using RCU utility in next thread .

Oracle Weblogic 10.3.1.0 Installation


Prior to installing Oracle SOA it is mandatory that it should have underlying Web server act as Middleware . Hence as per pre-requisite I need to install Weblogic as during installation of SOA it will ask to put the location of Middleware Home . Its pretty simple and straightforward . So download the latest Weblogic 10.3.1.0 from OTN FMW page, execute the installer “Oracle Web Logic Server – oepe11_wls1031.exe” and and follow the list of below steps :

Beginning with Oracle Fusion Middleware SOA 11g


Here are some quick steps to start the installation process for Oracle Fusion Middleware software i.e SOA Suite for 11g . Get the SOA , Weblogic and RCU software downloaded from oracle FMW page .In my case “ofm_soa_generic_11.1.1.1.0_disk1_1of1.zip” has been downloaded for SOA . For rest follow the below points . All the below points and any future threads/topics will talk about doing the business in Windows platform (XP SP2) .

Pre-requisite

1) Identifying the System requirements from Oracle FMW Page 1 and 2

2) Install Oracle Database – In my case I upgraded DB from 10g to 11g .

SOA 11g supports both Oracle 10g and 11g database having below versions :
– Oracle Database 10g (10.2.0.4 or later)
– Oracle Database 11g (11.1.0.6 or later)

Changing the NLS_CHARACTERSET to AL32UTF8 / UTF8Note: you should install the DB with AL32UTF8 character set, otherwise you will get a warning when you run RCU(Repository Creation Utility in later steps) .
Oracle strongly recommends using AL32UTF8 as the database character set. Use Metalink Doc Id 260192.1 for “Changing the NLS_CHARACTERSET to AL32UTF8 / UTF8”  to resolve the problem or alternatively you can take help of Character set scan(CSSCAN) and Alter utility. Though you can ignore this as per FMW Requirements .

3) Install Oracle WebLogic Server and Create the Middleware Home . In my case I have downloaded “Oracle Web Logic Server –  oepe11_wls1031.exe” from OTN .

4)  Download Repository Creation Utility (RCU) from OTN in same FMW page as : “ofm_rcu_win32_11.1.1.1.0_disk1_1of1.zip” and execute the rcu.bat from “D:\ofm_rcu_win32_11.1.1.1.0_disk1_1of1\rcuHome\BIN” where “D:\ofm_rcu_win32_11.1.1.1.0_disk1_1of1” is the path where I have un-archived the zipped content .

5) And finally proceed with SOA suite installation .

Watch out more in upcoming threads about the step by step process of how to install Weblogic , RCU and then SOA Suite .