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.

Create_repository_gg_1

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

Create_repository_gg_2

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.

Create_repository_gg_3

The OUI makes three prerequisite checks.

Create_repository_gg_4

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

Create_repository_gg_5

The OUI will do two more prerequisite checks.

Create_repository_gg_6

Choose the password for the different schemas.

Create_repository_gg_7

Choose a password for the supervisor and the encryption algorithm.

Create_repository_gg_8

Choose into witch tablespace the schema will be created.

Create_repository_gg_9

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

Create_repository_gg_10

The tablespaces are created.

Create_repository_gg_11

Oracle provides a summary of the configuration.

Create_repository_gg_12

Oracle provides a summary of the installation.

Create_repository_gg_13

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

Create_repository_gg_14

 Conclusion

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
    jdbc:oracle:thin:@192.168.56.71:1521:pdb1

Leave a Reply

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

Oracle Team
Oracle Team