3 Creating the Oracle GoldenGate Studio Repository Schema

The repository for Oracle GoldenGate Studio contains all of the replication design and deployment details. Therefore, you must install the repository schema on a certified database before using Oracle GoldenGate Studio. You create the repository using the Oracle Repository Creation Utility (RCU).

Before you begin creating the schema, ensure that you have completed installing the Oracle GoldenGate Studio software in a new, empty Oracle home as described in Installing the Oracle GoldenGate Studio Software.

Follow the instructions in this section to install the schema:

• Installing and Configuring a Certified Database
  Before you create the database schemas, you must install and configure a certified database, and verify that the database is up and running.
• Starting the Repository Creation Utility
  Start the Repository Creation Utility (RCU) after you verify that a certified JDK is installed on your system.
• Navigating the Repository Creation Utility Screens to Create Schemas
  Enter required information in the RCU screens to create the database schemas.
• Verifying the Installation
  After completing the installation steps, verify that Oracle GoldenGate Studio is installed properly.

Installing and Configuring a Certified Database

Before you create the database schemas, you must install and configure a certified database, and verify that the database is up and running.

See About Database Requirements for an Oracle Fusion Middleware Installation.

Starting the Repository Creation Utility

Start the Repository Creation Utility (RCU) after you verify that a certified JDK is installed on your system.

To start the RCU:

1. Verify that a certified JDK already exists on your system by running java -version from the command line. For 12c (12.2.1.4.0), the certified JDK is 1.8.0_211 and later.

   See About JDK Requirements for an Oracle Fusion Middleware Installation.

2. Ensure that the JAVA_HOME environment variable is set to the location of the certified JDK. For example:
   • (UNIX) setenv JAVA_HOME /home/Oracle/Java/jdk1.8.0_211
   • (Windows) set JAVA_HOME=C:\home\Oracle\Java\jdk1.8.0_211
3. Change to the following directory:
   • (UNIX) ORACLE_HOME/oracle_common/bin
   • (Windows) ORACLE_HOME\oracle_common\bin
4. Enter the following command:
   • (UNIX) ./rcu
   • (Windows) rcu.bat

Navigating the Repository Creation Utility Screens to Create Schemas

Enter required information in the RCU screens to create the database schemas.

• Introducing the RCU
  The Welcome screen is the first screen that appears when you start the RCU.
• Selecting a Method of Schema Creation
  Use the Create Repository screen to select a method to create and load component schemas into the database.
• Providing Database Connection Details
  On the Database Connection Details screen, provide the database connection details for the RCU to connect to your database.
• Specifying a Custom Prefix and Selecting the Oracle GoldenGate Repository Schema
  On the Select Components screen, select Create new prefix, specify a custom prefix, then select the Oracle GoldenGate - Repository schema.
• Specifying Schema Passwords
  On the Schema Passwords screen, specify how you want to set the schema passwords on your database, then enter and confirm your passwords.
• Specifying Custom Variables
  Use the Custom Variables screen to specify a password for the supervisor user and to select the encryption algorithm for the Oracle GoldenGate Studio Repository schema.
• Completing Schema Creation
  Navigate through the remaining RCU screens to complete schema creation.

Introducing the RCU

The Welcome screen is the first screen that appears when you start the RCU.

Click Next.

Selecting a Method of Schema Creation

Use the Create Repository screen to select a method to create and load component schemas into the database.

On the Create Repository screen:

• If you have the necessary permissions and privileges to perform DBA activities on your database, select System Load and Product Load. This procedure assumes that you have SYSDBA privileges.

• If you do not have the necessary permissions or privileges to perform DBA activities in the database, you must select Prepare Scripts for System Load on this screen. This option generates a SQL script that you can give to your database administrator. See About System Load and Product Load in Oracle Fusion Middleware Creating Schemas with the Repository Creation Utility.

• If the DBA has already run the SQL script for System Load, select Perform Product Load.

Providing Database Connection Details

On the Database Connection Details screen, provide the database connection details for the RCU to connect to your database.

Note:

If you are unsure of the service name for your database, you can obtain it from the SERVICE_NAMES parameter in the initialization parameter file of the database. If the initialization parameter file does not contain the SERVICE_NAMES parameter, then the service name is the same as the global database name, which is specified in the DB_NAME and DB_DOMAIN parameters.

For example:

• Database Type: Oracle Database
• Connection String Format: Connection Parameters or Connection String
• Connection String: examplehost.exampledomain.com:1521:Orcl.exampledomain.com
• Host Name: examplehost.exampledomain.com
• Port: 1521
• Service Name: Orcl.exampledomain.com
• User Name: sys
• Password: ******
• Role: SYSDBA

Click Next to proceed, then click OK in the dialog window that confirms a successful database connection.

Specifying a Custom Prefix and Selecting the Oracle GoldenGate Repository Schema

On the Select Components screen, select Create new prefix, specify a custom prefix, then select the Oracle GoldenGate - Repository schema.

The schema Common Infrastructure Services is also automatically created. This schema is dimmed; you cannot select or deselect it. For more information, see About the Service Table Schema in Oracle Fusion Middleware Creating Schemas with the Repository Creation Utility.

A custom prefix is required to logically group the schemas together. Note the custom prefix that you specify here as you will need it later.

Tip:

For more information about organizing schemas, see Planning Your Schema Creation in Oracle Fusion Middleware Creating Schemas with the Repository Creation Utility.

For more information about custom prefixes, see About Custom Prefixes in Oracle Fusion Middleware Creating Schemas with the Repository Creation Utility.

Click Next to proceed, then click OK on the dialog window confirming that prerequisite checking for schema creation was successful.

Specifying Schema Passwords

On the Schema Passwords screen, specify how you want to set the schema passwords on your database, then enter and confirm your passwords.

Tip:

You must make a note of the passwords you set on this screen; you will need them later on when providing your database connection information to connect to the repository after you start Oracle GoldenGate Studio.

Specifying Custom Variables

Use the Custom Variables screen to specify a password for the supervisor user and to select the encryption algorithm for the Oracle GoldenGate Studio Repository schema.

The custom variables for Oracle GoldenGate Studio are described in the following table:

Variable	Description
Supervisor Password	Password of the supervisor user. You must confirm this password on the following line. You must enter a password for the Supervisor Password and Confirm Supervisor Password fields. These fields are required before you can continue. The password should be between 6 and 12 characters. Make a note of the password you set on this screen; you will need it later on when providing your Oracle GoldenGate Studio connection information to connect to the repository after you start Oracle GoldenGate Studio.
Encryption Algorithm	Select the encryption algorithm, AES-128. This field is optional. If this field is left blank, the default value is AES-128.

Completing Schema Creation

Navigate through the remaining RCU screens to complete schema creation.

On the Map Tablespaces screen, the Encrypt Tablespace check box appears only if you enabled Transparent Data Encryption (TDE) in the database (Oracle or Oracle EBR) when you start the RCU. Select the Encrypt Tablespace check box if you want to encrypt all new tablespaces that the RCU creates.

When you reach the Completion Summary screen, click Close to dismiss the RCU.

Verifying the Installation

After completing the installation steps, verify that Oracle GoldenGate Studio is installed properly.

To verify that Oracle GoldenGate Studio is installed properly, see Performing additional tasks with the Oracle GoldenGate Studio. You should familiarize yourself with the tasks that this section describes and perform them to verify that Oracle GoldenGate Studio is installed properly.