Create Database Schema for BAM and SOA Servers with RCU

Repository Creation Utility (RCU) is only available on Windows and Linux. It can connect to databases running on other operating systems such as Solaris.

– Oracle Fusion Middleware Repository Creation Utility 11g (11.1.1.4.0) for Microsoft Windows (32-bit): V24312-01.zip

* Unzip rcu zip file (ofm_rcu_win_11.1.1.4.0_disk1_1of1.zip) onto a local directory (e.g. C:\Oracle\Middleware).

* Double click rcuHome\BIN\rcu.bat
* Click ‘Next’ at Welcome screen
* Click ‘Create’ then ‘Next’
* Enter database connectoin details:

Database Type: Oracle Database
Host Name: localhost
Port: 1521
Service Name: orcl.world   # SID does NOT work.
Username: sys
Password: orcl
Role: SYSDBA

* Enter
– Create a new Prefix: DEV
– Select SOA and BPM Infrastructure
– Click Next
* Use same passwords for all schemas
– Password: welcome1
* Review Tablespace mappings and Click Next

Metadata services/DEV_MDS/DEV_MDS/DEV_IAS_TEMP
SOA Infrastructure/DEV_SOAINFRA/DEV_SOAINFRA/DEV_IAS_TEMP
Business Activity Monitoring/DEV_ORABAM/DEV_ORABAM/DEV_IAS_TEMP
User Messaging Service/DEV_ORASDPM/DEV_IAS_ORASDPM/DEV_IAS_TEMP

* Review summary and click Create

* Double click rcuHome\BIN\rcu.bat
* Click ‘Next’ at Welcome screen
* Click ‘Drop’
* Enter database connectoin details:

Database Type: Oracle Database
Host Name: localhost
Port: 1521
Service Name: orcl.world   # SID does not work.
Username: sys
Password: orcl
Role: SYSDBA

* Click Next on Select Components screen.
– Click OK on popup warning screen.
– Click OK on Checking Prerequisites screen.
* Click Drop.
* Click Close when done.