Use these instructions to obtain and run the Repository Creation Utility (RCU) to create and drop schemas.

Obtaining RCU
In 12c, RCU is available with the Oracle Fusion Middleware Infrastructure distribution.
Starting RCU
After you install Oracle Fusion Middleware Infrastructure and create your Oracle home, you can start RCU from the ORACLE_HOME/oracle_common/bin directory.
Creating Schemas
Follow these instructions to create schemas in the database and verify that they are installed properly.
Dropping Schemas
Follow these instructions to drop schemas from the database.

This article walks you through the process of installing and configuring the tools to develop for Oracle OSB and SOA on a Windows 7 x64. The versions you have to install are very specific and if you mix them something can go wrong later. Note: When you install Oracle Internet Directory, you have the choice of using an existing schema or creating a new one using the Installer. If you want to use an existing schema, you must create it using the Oracle Fusion Middleware Repository Creation Utility (RCU) before you can install Oracle Internet Directory. This Video Tutorial Contain step by step how to install Oracle Repository Creation Utility.

To setup the schema, you can either use RCU or run the scripts manually by referring to the steps in Developer Guide of that component. It is recommended to use RCU as this is a common utility to setup schema for all the Oracle FMW components and this gives the option to select the component and based on which it installs the schema. The repository is created using the Oracle Repository Creation Utility (RCU). Make sure you created a database for storing the Oracle GoldenGate Studio objects before proceeding. Here I already have a database created by the name 'orcldb' which I will be using as a repository.

Obtaining RCU

In 12c, RCU is available with the Oracle Fusion Middleware Infrastructure distribution.

For information about how to install and obtain RCU, see Installing the Infrastructure Software in Installing and Configuring theOracle Fusion Middleware Infrastructure.

Parent topic:Obtaining and Running Repository Creation Utility

Starting RCU

After you install Oracle Fusion Middleware Infrastructure and create your Oracle home, you can start RCU from the ORACLE_HOME/oracle_common/bin directory.

Note:

If you run the RCU by using a non-English database, you will need to set the following language environment variables: LANG, LC_ALL, and NLS_LANG. Use the environment commands that are appropriate for your environment.
For example, for UNIX operating systems running csh run the following:
To start RCU, you do not need to set the JAVA_HOME environment variable. But, in case you want to use a specific JDK, ensure that the JAVA_HOME environment variable is set to the location of a certified JDK on your system.
For example, on UNIX operating systems, if your JDK is located in /home/Oracle/Java/:
Be sure to replace the JDK location in this example with the actual JDK location on your system.

On Linux operating systems:

On Windows operating systems:

RCU provides a command-line interface in situations where Xserver is not available or you have access to telnet terminals without display capabilities. The command-line interface also allows you to embed RCU from command-line scripts or with some Oracle Fusion Middleware components (for example, Enterprise Manager).

For more information about using the Command Line Interface (CLI), see Running Repository Creation Utility from the Command Line.

Parent topic:Obtaining and Running Repository Creation Utility

Creating Schemas

Follow these instructions to create schemas in the database and verify that they are installed properly.

Creating Schemas as a User with Full SYS or SYSDBA Privileges
If you are a user with full SYS or SYSDBA privileges and are able to provide valid authentication credentials for database access, follow these instructions to create schemas.
Creating Schemas as a User With Limited Database Privileges
If you are a user without SYS or SYSDBA privileges, follow these instructions to create schemas.
Verifying Schema Version Numbers
When the schemas are created in your database, RCU creates and maintains a table called schema_version_registry. This table contains schema information such as version number, component name and ID, date of creation and modification, and custom prefix.

Parent topic:Obtaining and Running Repository Creation Utility

Creating Schemas as a User with Full SYS or SYSDBA Privileges

If you are a user with full SYS or SYSDBA privileges and are able to provide valid authentication credentials for database access, follow these instructions to create schemas.

Click the screen name to see detailed information for that screen. Unless otherwise noted, click Next to continue to the next screen.

Table 2-1 Schema Creation Steps for Full-Privilege Users

Screen	Description
This screen introduces you to RCU.
Select Create Repository, then select System Load and Product Load. If you do not have full SYS or SYSDBA privileges on the database, select Prepare Scripts for System Load and follow the schema creation instructions in Creating Schemas as a User With Limited Database Privileges.
Specify your database connection credentials. Remember that if you are creating schemas on an IBM DB2 database, you must have already created one operating system user for each schema that you want to create. See Additional Requirements for IBM DB2 Databases for more information. Click Next when you have specified your credentials. A separate dialog window appears while RCU checks connectivity and the database prerequisites. When the database checking has passed without errors, click OK to dismiss the dialog window and go to the next screen.
Select the components for which you want to create schemas, and specify a prefix to group them together. You must remember the prefix and schema names for the components you are installing; you need this information during the configuration phase of your product installation. Oracle recommends that you write down these values.
Download itunes 11.1 for windows xp vista or windows 7. Specify the passwords for your schema owners. https://yellowninja.amebaownd.com/posts/23207985. You must remember the passwords you enter on this screen; you need this information during the configuration phase of your product installation. Oracle recommends that you write down these values.
Use the Custom Variables screen to specify additional product configuration information. The Custom Variables screen appears only if you selected one or more of the following components on the Select Components screen. You can select a component on the Select Components screen only if the Oracle home in which RCU was started contains that component. If you selected Oracle Data Integrator, the Custom Variables for Oracle Data Integrator are visible. If you selected SOA Suite, the Custom Variables for Oracle SOA Suite are visible. If you selected WebCenter Portal - Analytics, the Custom V

Screen

Description

This screen introduces you to RCU.

Select Create Repository, then select System Load and Product Load.

If you do not have full SYS or SYSDBA privileges on the database, select Prepare Scripts for System Load and follow the schema creation instructions in Creating Schemas as a User With Limited Database Privileges.

Specify your database connection credentials.

Remember that if you are creating schemas on an IBM DB2 database, you must have already created one operating system user for each schema that you want to create. See Additional Requirements for IBM DB2 Databases for more information.

Click Next when you have specified your credentials. A separate dialog window appears while RCU checks connectivity and the database prerequisites. When the database checking has passed without errors, click OK to dismiss the dialog window and go to the next screen.

Select the components for which you want to create schemas, and specify a prefix to group them together.

You must remember the prefix and schema names for the components you are installing; you need this information during the configuration phase of your product installation. Oracle recommends that you write down these values.

Download itunes 11.1 for windows xp vista or windows 7. Specify the passwords for your schema owners.

https://yellowninja.amebaownd.com/posts/23207985. You must remember the passwords you enter on this screen; you need this information during the configuration phase of your product installation. Oracle recommends that you write down these values.

Use the Custom Variables screen to specify additional product configuration information.

The Custom Variables screen appears only if you selected one or more of the following components on the Select Components screen. You can select a component on the Select Components screen only if the Oracle home in which RCU was started contains that component.

If you selected Oracle Data Integrator, the Custom Variables for Oracle Data Integrator are visible.
If you selected SOA Suite, the Custom Variables for Oracle SOA Suite are visible.
If you selected WebCenter Portal - Analytics, the Custom V

Repository Creation Utility Rcu 11.1.1.6.0 Installation On Windows Os