Creating the Master and Work Repository Schemas
Before you can configure an Oracle Data Integrator domain, you must create the Master and Work Repository (ODI_REPO) schemas on a certified database for use with this release of Oracle Fusion Middleware.
Configuring a Certified Database
Before you begin, make sure you have installed and configured a certified database
Starting the Repository Creation Utility
Navigate to the ORACLE_HOME/oracle_common/bin directory:
Start RCU.
On UNIX operating systems:
./rcu
On Microsoft Windows operating systems:
rcu.bat
Navigating the Repository Creation Utility Screens to Create the Schema
Start RCU - Click Next.
Select a Repository Creation Method.
If you have permission to perform DBA activities on your database, select System Load and Product Load Concurrently.
Provide the database connection details for RCU to connect to your database. Click Next to proceed, then click OK on the dialog window confirming that connection to the database was successful.
Select Create a new prefix, specify a custom prefix, then select the Oracle Data Integrator schema.
If you are running RCU from a Standalone installation, you will see the following:
Select Oracle Data Integrator and click Next to proceed, then click OK on the dialog window confirming that prerequisite checking for schema creation was successful.
Specify how you want to set the schema passwords on your database, then specify and confirm your passwords.
Specify the custom variables for the Master and Work Repository
Navigate through the remainder of the RCU screens to complete schema creation. When you reach the Completion Summary screen, click Close to dismiss RCU.
Steps with screenshots:
For more details: https://docs.oracle.com/middleware/1221/core/ODING/GUID-25AC5AEE-D46D-4E4B-8835-4C1FE32207CC.htm#ODING860
No comments:
Post a Comment