Infrastructure at your Service

Oracle Team

GoldenGate Studio 12.2 – Create repository

In a previous blog I explained you how to install GoldenGate Studio. This time the goal is to describe how to create the repository required by GoldenGate Studio.

Oracle provides a tool to create all the repository data required by GoldenGate Studio. Its name is RCU for Repository Creation Utility.

Create repository

The first step is to go to the folder GOLDENGATESTUDIO_HOME/oracle_common/bin. In this folder there is the RCU executable.

Launch it:

[email protected]:/u04/app/goldengate/product/ggstudio122/oracle_common/bin/ [DB1] ./rcu

The OUI (Oracle Universal Installer) will start. On the first screen just click on the next button.


Leave the option to immediately create the repository and that you have the DBA privileges.


Configure the connection to the database.

Take care about two things:

First: at this step you can obtain an error about timzone not found (ora-01882 timezone region not found). To avoid this, export your timezone before starting the installation.

[email protected]:/u04/app/goldengate/product/ggstudio122/oracle_common/bin/ [DB1] export TZ='CEST'

Second: Oracle advises to use a database on AL32UTF8.


The OUI makes three prerequisite checks.


In this screen, you can define a prefix for all schemas that will be created. In addition choose the option “Oracle GoldenGate Repository”.


The OUI will do two more prerequisite checks.


Choose the password for the different schemas.


Choose a password for the supervisor and the encryption algorithm.


Choose into witch tablespace the schema will be created.


If the tablespaces do not exist, the OUI proposes you to create them.


The tablespaces are created.


Oracle provides a summary of the configuration.


Oracle provides a summary of the installation.


Now GoldenGate Studio can be launched. It is located in GOLDENGATESTUDIO_HOME/oggstudio/bin.

[email protected]:/home/oracle/ [rdbms12102] cd /u04/app/goldengate/product/ggstudio122/oggstudio/bin/
[email protected]:/u04/app/goldengate/product/ggstudio122/oggstudio/bin/ [rdbms12102] ./oggstudio



Now that GoldenGate studio is installed there is one more step before you can use it. GoldenGate Studio needs the Monitor agent to communicate with the GoldenGate instance. It is a mandatory step if you want to configure and deploy your configuration automatically.

One Comment

  • naren says:

    Thanks a lot for the step by step creation of repository. I was able to create repository. How ever I am not able to connect to repository. I get an ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

    login name: repo
    user: sys (I tried other user too)
    pwd: pwd

    user: DEV_OGSREPO
    password: pwd

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Oracle Team
Oracle Team