Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

Oracle GoldenGate Director 11gR2 (Server, Administrator, Client and Web) 11.2.1 installation and deployment

Oracle GoldenGate Director 11gR2 (Server, Administrator, Client and Web) 11.2.1 installation and deployment

In the article you will look at the steps for deploying Oracle Goldengate (OGG) Director on OEL 5.X using Oracle RDBMS as a repository. OGG Director consists of the following components:

  • OGG Director Server
  • OGG Director Admin
  • OGG Director Client
  • OGG Director Web

All of the above components will be installed and configured for you to monitor and manage the OGG environment.

The following software will be used.

  • OGG Director 11gR2 11.2.1.0 Server – download from here. OGG Director Client comes with the OGG Director Server and can be downloaded from the OGG Server or installed separately.
  • Oracle WebLogic Server (OWLS) 12c 12.1.1 – download from here
  • JDK 1.6.0_20 or later – download from here

After downloading the software execute the following steps

  1. Install JDK
  2. Install Oracle Weblogic Server 12c
  3. Install OGG Director Server 11gR2 11.2.1
  4. Start OGG Director Server
  5. Download OGG Director Client
  6. Install OGG Director Client
  7. Start OGG Director Admin and configure users and Data Source
  8. Start OGG Director Client
  9. Start OGG Director WEB

For all the GUI tools to launch successfully as root user execute xhost +.

  1. Install JDK

    The JDK includes the JRE. Download the JDK.

    sh ./jdk-6u37-linux-x64.bin

    Take a note that 6u37 is the latest JDK 1.6 as of the time I wrote the article. The installation creates the following directory structure.

    [oracle@raclinux1 bin]$ pwd

    /u02/ogg_director/jdk1.6.0_37/bin

    [oracle@raclinux1 bin]$

  2. Install Oracle Web Logic Server 12c

    Launch the OWLS installer by executing the downloaded bin file

    sh ./oepe-indigo-installer-12.1.1.0.1.201203120349-12.1.1-linux32.bin

    Follow the screens as indicated. Press Next.


    Enter the OWLS installation location. Press Next.


    Press Next.


    Select an Install type and press Next.


    Select product installation directories. I left the default. Press Next.


    Review the installation summary and press Next.


    Wait for the installation to complete. Press Done button after selecting Run Quickstart checkbox.


    Wait for Quickstart to pop up and press Getting Started with WebLogic Server 12.1.1.


    Select create new domain option.


    Select first option.


    Enter a domain name and domain location.


    Enter credentials.


    Enter the location of the JDK installed. You can also use the default that comes with OWLS.


    Select Administration Server checkbox.


    Specify ports. I use non-default ports.


    Review the summary and press Create button.


    Wait for the installation to complete.


    Verify the OWLS installation by loging into the server.


    And finally…


    This concludes the OWLS 12c 12.1.1 installation

  3. Install OGG Director Server 11.2.1

    Unzip the downloaded OGG Director Server 11.2.1

    [oracle@raclinux1 ogg_director]$ unzip -o ogg_director_srv.zip

    Archive: ogg_director_srv.zip

    inflating: gg-director-serversetup_unix_v11_2_1_0_0_000.sh

    inflating: OGG_Dir_Rel_Notes_11.2.1.0.0.doc

    inflating: OGG_Dir_Rel_Notes_11.2.1.0.0.pdf

    inflating: README.txt

    [oracle@raclinux1 ogg_director]$ pwd

    /u02/ogg_director

    [oracle@raclinux1 ogg_director]$

    Start the OGG Director Server installation by executing

    ./gg-director-serversetup_unix_v11_2_1_0_0_000.sh

    Once the GUI pops up press Next.


    Select OGG Director Server installation location directory. In my case it is /u02/ogg_director/oggd.


    Select OWLS location. In my case it is /u02/wls/oracle/Oracle/Middleware


    Press Next after reviewing the OWLS location and installation details.


    Specify http port. I use 7004.


    Select the option for an Oracle database.


    Specify the details for JDBC connection to the Oracle database.


    Specify the credentials for the user schema of the OGG Director repository. Make sure that a user is created in the database to host the repository. Press Next.


    Review and press Next.


    The installation begins and wait until completes. If you see an error like Unable to run run-cdc-tool script file cat the content of the log

    Canonicaly: /u02/ogg_director

    Testing connection with: jdbc:oracle:thin:@rac-scan:1521:RACD

    Execption while processing db setup. Cannot continue. Exception follows…

    java.sql.SQLRecoverableException: ORA-01034: ORACLE not available

    ORA-27101: shared memory realm does not exist

    Linux-x86_64 Error: 2: No such file or directory

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)

    at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:441)

    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)

    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)

    at oracle.jdbc.driver.T4CTTIoauthenticate.doOSESSKEY(T4CTTIoauthenticate.java:404)

    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:385)

    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)

    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)

    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)

    at com.goldengate.gdsc.util.ConfigDirectorServer.startDBSetup(ConfigDirectorServer.java:670)

    at com.goldengate.gdsc.util.ConfigDirectorServer.main(ConfigDirectorServer.java:922)

    [oracle@raclinux1 GGDirectorgg-director]


    Fix the JDBC details and retry.

    At the end of the installation click Finish.


    This concludes the OGG Director Server installation.

  4. Start OGG Director Server

    Execute the following command in order to stats the server.

    [oracle@raclinux1 bin]$ pwd

    /u02/ogg_director/oggd/domain/bin

    [oracle@raclinux1 bin]$ ls

    directorControl.sh setDomainEnv.sh stopManagedWebLogic.sh

    nodemanager startManagedWebLogic.sh stopWebLogic.sh

    server_migration startPointBaseConsole.sh

    service_migration startWebLogic.sh

    [oracle@raclinux1 bin]$

    [oracle@raclinux1 bin]$ ./directorControl.sh

    ——————————————————————

    USAGE:

    ./directorControl.sh start : to start in foreground

    ./directorControl.sh stop : to stop

    ./directorControl.sh -b start : to start in background.

    ./directorControl.sh -b start <out_file> : to start in background, redirect to a file.

    ——————————————————————

    [oracle@raclinux1 bin]$

    [oracle@raclinux1 bin]$ ./directorControl.sh -b start /tmp/oggdirser.out &

  5. Download OGG Director Client

    Download the OGG Director Client for Unix, I am on OEL 5.X,


  6. Install OGG Director Client

    Execute the downloaded in Step 5 shell script.

    [oracle@raclinux1 u02]$ ./gg-director-clientsetup_unix_v11_2_1_0_0_000.sh

    Starting Installer …

    Nov 14, 2012 4:23:39 PM java.util.prefs.FileSystemPreferences$3 run

    WARNING: Could not create system preferences directory. System preferences are unusable.

    Once the GUI pops up press Next.


    Select directory for the OGG Director Client.


    Specify a directory for Symbolic links.


    Review the summary.


    Wait for the installation to complete and exit the installer by pressing Finish.


    After successful installation there will be two scripts:

  • run-admin.sh : for starting OGG Director Administrator
  • run-director.sh : for starting OGG Director Client

Your configuration will look similr to

[oracle@raclinux1 bin]$ pwd

/u02/ogg_director/GoldenGateDirector/bin

[oracle@raclinux1 bin]$ ls

run-admin.sh run-director.sh

[oracle@raclinux1 bin]$

  1. Start OGG Director Admin and configure users and Data Source

    Execute the following command

    ./run-admin.sh

    Login as admin/admin


    Create OGG Director account (Optional)


    Create a data source in order to monitor an existing OGG environment.


    Setup Agent Settings. Start an Agent.


  2. Start OGG Director Client

    Start the OGG Director Client by executing the following shell script.

    [oracle@raclinux1 bin]$ ./run-director.sh

    Wait for the OGG Director Client to launch.


    Login


    Assuming a started OGG instance

    GGSCI (raclinux1.gj.com) 2> info mgr

    Manager is running (IP port raclinux1.gj.com.7809).

    GGSCI (raclinux1.gj.com) 3>

    GGSCI (raclinux1.gj.com) 4> info all

    Program Status Group Lag at Chkpt Time Since Chkpt

    MANAGER RUNNING

    EXTRACT RUNNING EXTBI1 00:00:00 44:29:22

    EXTRACT RUNNING EXTBI2 00:00:00 44:29:27

    EXTRACT RUNNING EXTCDC 00:00:00 231:38:54

    EXTRACT ABENDED EXTDOWN 00:00:00 44:29:23

    EXTRACT RUNNING EXTINT 00:00:00 44:29:32

    EXTRACT RUNNING EXTINTBI 00:00:00 44:29:28

    EXTRACT RUNNING EXTREV 00:00:00 00:00:07

    EXTRACT RUNNING EXTSALE 00:00:00 231:38:53

    EXTRACT RUNNING EXTSHHR 00:00:00 231:24:01

    EXTRACT RUNNING EXTT1 00:00:00 231:38:58

    EXTRACT RUNNING PREV 00:00:00 44:14:19

    EXTRACT RUNNING PSHHR 00:00:00 44:14:17

    EXTRACT RUNNING PUMPSALE 00:00:00 44:14:19

    REPLICAT RUNNING REPBI1 00:00:00 00:00:04

    REPLICAT RUNNING REPBI2 00:00:00 00:00:05

    REPLICAT RUNNING REPCDC1 00:00:00 00:00:02

    REPLICAT RUNNING REPCDC2 00:00:00 00:00:03

    REPLICAT RUNNING REPCDC3 00:00:00 00:00:05

    REPLICAT RUNNING REPCUST 00:00:00 00:00:04

    REPLICAT RUNNING REPDOWN 00:00:00 00:00:05

    REPLICAT RUNNING REPINT 00:00:00 00:00:05

    REPLICAT RUNNING REPINTBI 00:00:00 00:00:03

    REPLICAT ABENDED REPREV 00:00:00 00:02:54

    REPLICAT RUNNING REPSALE 00:00:00 00:00:05

    REPLICAT RUNNING REPSHHR 00:00:00 00:00:05

    REPLICAT RUNNING REPT1 00:00:00 00:00:01

    GGSCI (raclinux1.gj.com) 5>

    After adding the RACD, or whatever data source you have, you will have something like this.


  3. Start OGG Director WEB

Login to the OGG Director WEB


You will see the same setup


Summary:

In the article you had a look at the steps to install and configure the different OGG Director components for managing and monitoring OGG environment.

Reference

  1. Oracle® GoldenGate Director Administrator’s Guide 11g Release 2 (11.2.1)


November 14, 2012 - Posted by | oracle

2 Comments »

  1. [...] online from here or download Oracle GoldenGate Director 11.2.1 installation and [...]

    Pingback by Oracle GoldenGate Director 11gR2 (Server, Administrator, Client and Web) 11.2.1 installation and deployment – Download « Guenadi N Jilevski's Oracle BLOG | November 14, 2012 | Reply

  2. Hi – good note! – much appreciated

    Comment by gavin | May 9, 2014 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 779 other followers

%d bloggers like this: