Oracle GoldenGate – Installing GoldenGate Director Server and Client

GoldenGate Director is a multi tier client server application that enables the configuration and management of the GoldenGate environment from a remote client which includes a web browser based client.

There are a number of different components which go to make up the GoldenGate Director product. Let us briefly describe each one of them.

GoldenGate Director Server – It is installed in a Weblogic server domain and enables the management of the different instances of GoldenGate which run in our environment.

GoldenGate Director Database – it is the central repository which is housed in a database (SQL Server/MySQL/Oracle) which contains information about the users, graphical diagrams which are created and other information related to user preferences.

GoldenGate Director Client – it is a GUI tool for managing the GoldenGate instances and runs on any platform which supports Java providing a menu driven interface with standard drag and drop functionality.

GoldenGate Director Web – web application that is hosted in the Director Server which provided browser based access to the GoldenGate environment.

GoldenGate Director Administrator – another client of the Director Server which enables us to carry out admin tasks like creating and modifying the admin user accounts, creating and modifying data sources which can be then used in the Director Client.

Before installing the Director Server we need to ensure that the JRE version 1.6 is already installed on the platform where we are going to install Director Server and also that Oracle 11g Weblogic Server (10.3.1) is available and running.

The following files were used for installation on Red Hat Linux RHEL 5 ….

oepe11_wls1031_linux32.bin – Oracle 11g Weblogic Server 10.3.1.
V19134-01.zip – GoldenGate Director Server
V19136-01.zip – GoldenGate Director Client

Let us look at the screen shots of an Oracle Weblogic Server installation.

Director Server Installation

In addition to the JRE 1.6.x requirement and the providing the location of the Weblogic Server software installation, we need to ensure that a database user has been created in the database which is going to serve as a repository for the Director Server. This database user needs standard privileges to create, alter and drop tables and indexes in it’s own schema. We will provide details of this user account in the course of the GoldenGate Director Server installation.

[oracle@redhat346 bin]$ export PATH=/u01/oracle/jre1.6.0_18/bin:$PATH
[oracle@redhat346 bin]$ java -version
java version “1.6.0_18”
Java(TM) SE Runtime Environment (build 1.6.0_18-b07)
Java HotSpot(TM) 64-Bit Server VM (build 16.0-b13, mixed mode)

[oracle@redhat346 ~]$ ./gg-director-serversetup_unix_v2_0_0_3_007.sh
Starting Installer …

Director Client Installation

[oracle@redhat346 ~]$ ./gg-director-clientsetup_unix_v2_0_0_3_007.sh
Starting Installer …