This post covers overview of Repository Creation Utility(RCU) which is first thing you need to do, if you are planning to implement/install Oracle Fusion Middleware 11g R1 (11.1.1.0).
Metadata Repository - contains metadata for Fusion Middleware Components (SOA, Webcenter, Identity Management) . There are various types of Repository - Metadata Services (MDS), Audit Services (IAU), Oracle Internet Directory (OID), 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), Oracle Identity Federation (OIF) , Discussions (DISCUSSIONS) and Wiki and Blog (WIKI)
Repository could be Database-based or File-based, most component (Webcenter, SOA, OID…) requires Database-based Repository.
.
How to create Database-based repository ?
RCU - Repository Creation Utility is tool to create schema and load repository in existing database for Fusion Middleware components.
Download RCU from here
.
Key points for Repository Creation Utility (RCU) in FMW
1. RCU can be run in two mode - GUI (Graphical User Interface) & CLI (Command Line Interface)
2. For Fusion Middleware 11g R1 (11.1.1.X) , RCU can only load schema in Oracle Database (version 10.2.0.4 and higher or 11.1.0.7 and higher)
3. You can run RCU locally (same machine where Database is running) or Remotely (Database is on remote machine)
4. By default RCU creates default schema and load repository in default tablespaces. RCU provides flexibility to change schema or tablespace name. (Only exception to this is Oracle Internet Directory (OID) schema)
5. You could load multiple repository (like Portal, webcenter, SOAINFRA) in single database. You could also load different version of same repository (like dev_soainfra, test_soainfra for DEV & Test instance resp.) in same database. (This is interesting feature for using single database for multiple Fusion Middleware Instances)
6. You can start RCU (Repository Creation Utility) from $RCU_SOFTWARE/bin/ rcu (for Unix) or rcu.bat (for Windows) ; This will start RCU in GUI mode. For CLI mode use “rcu [-silent | -interactive] {<command> <options>}”
7. RCU log file is written to the RCU_SOFTWARE_DIR/ rcu/ log/ logdir.<date_timestamp>/ rcu.log
8.For step by step Fusion Middleware Repository Creation Utility with screen-shots click here
.
What to do after creating Fusion Middleware Database-based Repository ?
Before you can use Repository for fusion middleware component (soa, webcenter), you need to register Repository with Oracle WebLogic Server domain . (How to register Database-based with WebLogic domain ? coming soon…)
.
References
- RCU Download Link
- FMW Repository Creation Utility Documentation
- RCU Database Requirement
- Managing Oracle Metadata Repository
Related Posts for RCU
- Oracle Fusion Middleware 11g - Repository Creation Utility (RCU)
- How to create FMW 11g schemas (SOA, WebCenter) on Solaris (non Windows/Linux) platform ?
Popularity: 11% [?]




Good hands-on exercises (installation, patching, cloning), very experienced trainer worth every penny
12 users commented in " Oracle Fusion Middleware 11g - Repository Creation Utility (RCU) "
Follow-up comment rss or Leave a Trackback[…] For more information on RCU click here […]
[…] 4.6 Select Create Schema - You can create schema in advance as well (by running RCU more information here) […]
[…] 2. Load/Create schema (webcenter, portlet, ocserver, discussions, wiki) in database using RCU (Repository Creation Utility) more information here […]
[…] fusion, soa, webcenter Print This Post RCU - Repository Creation Utility (more information here ) is certified only on Windows and Linux , then how to create schema on database running on […]
our SOA repository database is always getting full, we dont know how to solve this issue and we dont even testing the production yet. i was try to find it, i found how to reduce it in 10g version of SOA Suite. which is BPEL Performance tuning, we can reduce the growth repository during execution time with some change in bpel.xml (completionPersistPolicy ) i’m sure that i cant find the bpel.xml in SOA Suite 11g. our repository is always full, and if it full, the composite execution will be failed.. may you guys can help me with it?
PS: For testing we use real data in production which triggered into our dummy staging database
thanks
Where can I donwload rcu 11.1.1.0? Its not on the Oracle downloads page
@ Ayesha, Why don;t you use 11.1.3.0 ? You can use 11.1.1.3.0 RCU with 11.1.1.1.0 and 11.1.1.2.0 products as well.
In OEL5.3- I installed oracle 11.1.6.0 patched to 11.1.7.0 .While creating RCU I am getting this
——–
Error : Unable to connect to the database using the provided details. Please enter a valid hostname and port or check if the listener is up and running.
I was assuming RCU does not recognize localhost.localdomain
In etc/hosts :127.1.1.0 localhost.localdomain
I added 174.10.10.10 xyz.com xyz
Also I changed in etc/sysconfig/network
It’s not working
Couldn’t find much in google. Am I missing any post installation steps after installing oracle 11g db.
I gave the port no :1521 and SID:orcl
DB is up and running
Can any one provide me a solution
Hi,
i installed Jdeveloper 11.1.1.3 and also updated SOA Suite. At the time of installation i have oracle 9i. After that i removed and installed oracle 10G database.
when creating weblogc domain i am getting the below errors.
Component Schema=SOA Infrastructure Driver=oracle.jdbc.xa.client.OracleXADataSource URL=jdbc:oracle:thin:@localhost:1521/orcl User=DEV_SOAINFRA Password=************ SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’SOAINFRA’ and version=’11.1.1.3.0′
ORA-01017: invalid username/password; logon denied
CFGFWK-60850: Test Failed!
Component Schema=User Messaging Service Driver=oracle.jdbc.OracleDriver URL=jdbc:oracle:thin:@localhost:1521/orcl User=DEV_ORASDPM Password=************ SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’ORASDPM’ and version=’11.1.1.2.0′
ORA-01017: invalid username/password; logon denied
CFGFWK-60850: Test Failed!
Component Schema=OWSM MDS Schema Driver=oracle.jdbc.OracleDriver URL=jdbc:oracle:thin:@localhost:1521/orcl User=DEV_MDS Password=************ SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’MDS’ and version=’11.1.1.2.0′
ORA-01017: invalid username/password; logon denied
CFGFWK-60850: Test Failed!
Component Schema=SOA MDS Schema Driver=oracle.jdbc.OracleDriver URL=jdbc:oracle:thin:@localhost:1521/orcl User=DEV_MDS Password=************ SQL Test=select 1 from schema_version_registry where owner=(select user from dual) and mr_type=’MDS’ and version=’11.1.1.2.0′
ORA-01017: invalid username/password; logon denied
please do the needful.
Thanks in advance.
Regards,
Purushotham
@ Purushotham,
Either password you are using to connect to database for schemas dev_soainfra, dev_mds …. is not correct or schema itself is not available.
Connect as sys or system or sqlplus “/as sysdba”
and then check if you have schemas related top soa in database
SQL>select username from dba_users where username like ‘DEV%’;
If schemas are in place and you don’t remembre password then reset them using
SQL> alter user [username] identified by [new_password];
[…] RCU - Repository Creation Utility is java based tool (available only for Windows and Linux) to create schema in Database. For basics on RCU (Repository Creation Utility) click here […]
[…] Create OBIEE schema (BIPLATFORM + Metadata Services) using Repository Creation Utility (RCU). More on RCU here […]
Leave A Reply