Oracle GoldenGate Monitor Server & Agent Configration

Step 1: Configure OGG Monitor Server on separate machine

Step 2: Configure OGG Monitor Agent on all DB servers where GG is running

Prerequisites

For Monitor Server

1. jdk1.7.0_79.zip

2. wls_fmw_12.1.3.0.0_infrastructure_Disk1_1of1.zip

3. fmw_12.1.3.0.0_ogg_Disk1_1of1.zip

For Monitor Agent

1. jdk1.7.0_79.zip

2. fmw_12.1.3.0.0_ogg_Disk1_1of1.zip

This section provides for OGG Monitor Server Configuration

Step 1: Set JAVA environment ready

Move jdk file to /opt folder for setting java path

Login as root

# cd /home/oracle

# ls

jdk1.7.0_79.zip

#cpjdk1.7.0_79.zip /opt

# cd /opt

# unzip  jdk1.7.0_79.zip

#java –version

“1.6.------”

#cd /etc/alternatives

Take backup of old java link

# mv java java.old

Create new java link for 1.7 version

# ln –s  /opt/jdk1.7.0_79/bin/java

#java -version

java version "1.7.0_79"

Java(TM) SE Runtime Environment (build 1.7.0_79-b15)

Java HotSpot(TM) 64-Bit Server VM (build 24.79-b02, mixed mode)

Set PATH, JAVA_HOME, JDK_HOME in bash profile of rootuser

# cd

# vim .bash_profile

Add this to existing

exportPATH=$PATH:/opt/jdk1.7.0_79/bin

exportJAVA_HOME=/opt/jdk1.7.0_79

exportJDK_HOME=/opt/jdk1.7.0_79

Run the bash profile

# .  .bash_profile

Login as oracle

# su - oracle

Set PATH, JAVA_HOME, JDK_HOME in bash profile of oracle user

$ cd

$ vim .bash_profile

Add this to existing

export PATH=$PATH:/opt/jdk1.7.0_79/bin

export JAVA_HOME=/opt/jdk1.7.0_79

export JDK_HOME=/opt/jdk1.7.0_79

Run the bash profile

$ .  .bash_profile

$ cd

$ ls

wls_fmw_12.1.3.0.0_infrastructure_Disk1_1of1.zip

$ unzip wls_fmw_12.1.3.0.0_infrastructure_Disk1_1of1.zip

$ ls

wls_fmw_12.1.3.0.0_infrastructure_Disk1_1of1.zip

fmw_12.1.3.0.0_infrastructure.jar

$ java –version

$ echo $JAVA_HOME

Step 2: Fusion Middleware 12c Infrastructure Installation

$ java –jar fmw_12.1.3.0.0_infrastructure.jar

Set the oracle installation location. This can be an existing Oracle Home or a new Oracle Home

ORACLE_HOME=/home/oracle/Oracle/Middleware/Oracle_Home

Installation Type selectFusion Middleware Infrastructure

Security Updates: Uncheck and Install.

Or

Silent mode installation

$ java –jar fmw_12.1.3.0.0_infrastructure.jar –silent –responseFile /home/oracle/FusionMiddleware.rsp (Annexure-A)

Check the installation

$ cd /home/oracle/Oracle/Middleware/Oracle_Home/oracle_common/bin

$ env

Step 3: Fusion Middleware 12c GG Monitor &Veridata Installation

$ pwd

/home/oracle

$ ls

fmw_12.1.3.0.0_ogg_Disk1_1of1.zip

$ unzip fmw_12.1.3.0.0_ogg_Disk1_1of1.zip

$ ls

fmw_12.1.3.0.0_ogg_Disk1_1of1.zip

fmw_12.1.3.0.0_ogg.jar

$ java –jar Xmx1024M fmw_12.1.3.0.0_ogg.jar

Set the oracle installation location

ORACLE HOME :/home/oracle/Oracle/Middleware

Installation Type : Oracle GoldenGate Monitor Server

Click on Finish.

Silent Mode Installation

$ java –jar Xmx1024M fmw_12.1.3.0.0_ogg.jar –sient –responseFile /home/oracle/GGMonitorInstall.rsp               Annexure-B

Step 4: Create Repository for an Oracle Database

(Note: Character set must be AL32UTF8. This is because the default character set is not supported by RCU.)

$ echo $JAVA_HOME

/opt/jdk1.7.0_79

$ cd/home/oracle/Oracle/Middleware/Oracle_Home/oracle_common/bin

$ ./rcu

Create Repository selectSystem Load and Product Load

Database Connection Details

Database Type: Oracle Database

Host Name: 155.0.5.57

Port: 1521

Service Name: oggmondb.iaf.in

User Name: sys

Password: oracle

Role: SYSDBA

Select Components

Create new prefix: DEV

Oracle AS Repository Components

  AS Common Schemas

Component                         Schema Owner

     Metadata Services                 DEV_MDS

     Audit Services                    DEV_IAU

     AuditServices Append              DEV_IAU_APPEND

     AuditServices Viewer              DEV_IAU_VIEWER

     Oracle Platform Security Services DEV_OPSS

     User Messaging Services           DEV_UMS

     WebLogic Services                 DEV_WLS

  Oracle GoldenGate

     Monitor Server                    DEV_OGGMON

Schema Passwords

Use same passwords for all users

Password: oracle123

Map Tablespaces

Click on NEXT and OK to create Tablespaces

Check the summary and click on Create to create repository

Check the rcu log

Step 5: Configuring OGG Monitor Server  for Oracle Database

Launching the Configuration Wizard

$ cd u01/app/oracle

$ mkdir domains

$ cd /home/oracle/Oracle/Middleware/Oracle_Home/oracle_common/common/bin

$ ./config.sh

Create Domain

Select Create a new domainoption

Domain Location: /u01/app/oracle/domains

Templates

Select Oracle GoldenGate Monitor Server

Rest all will automatically get selected-Basic WebLogic Server Domain, Oracle JRF, WebLogic Coherence Cluster Extension

Administrator Account

Name: weblogic

Password: oracle123

Domain Mode and JDK

Domain Mode: select Production

JDK: Auto dectected Oracle Hotspot 1.7.0_79/opt/jdk1.7.0_79

Domain Configuration Type

Specify AutoConfiguration Options Using: RCU Data

Vendor: Oracle

Owner: Oracle’s Driver(Thin) for Service connections

DBMS/Service: oggmondb.iaf.in

Host Name: mcc-vm-oggmon.iaf.in

Port: 1521

Schema Owner: DEV_STB

Schema Password: oracle123

Click on Get RCU Configuration and check the status.

Component Datasources

Click on Next

JDBC Test

Check the status and click on Next

Credentials

Key Name	Username	Password	Store Name
WEB.JMX.PASSWORD	jmx	oracle123	OGGMONITOR
MONITOR.KEYSTORE.PASSWORD	keystore	oracle123	OGGMONITOR
MONITOR.TRUSTSTORE.PASSWORD	truststore	oracle123	OGGMONITOR
WEB.SMTP.EMAIL.PASSWORD	smtp	oracle123	OGGMONITOR

Advanced Configuration

Select Administration Server

       Managed Servers, Clusters and Coherence

Administration Servers

Server Name: AdminServer

Listen Address: 155.0.5.57

Listen Port: 7001

Server Groups: JRF_MAN_SRV

              RRF_WS_CORE_MAN_SRV

              MONITORSERVER_MANAGED_SERVICES

WSM_CACHE_SVR

Managed Servers

Server Name: MONITORSERVER_airpex

Listen Address: 155.0.5.57

Listen Port: 7003

Server Groups: MONITORSERVER_MANAGED_SERVICES

Clusters

Coherence Clusters

Machines

Configuration Summary

Check the statuson final page

$ cd /u01/app/oracle/domains

$ ls

Step 6: Start WebLogic Servers

Start WebLogicServer

$ cd /u01/app/oracle/domains/bin

$ ./startWebLogic.sh

Check the WebLogic Server

http://155.0.5.57:7001/console

Login withweblogicuser(password:oracle123)

Select Security Realms under Domain Structureàdomains

Select myrealm to create new user for OGGMonitor login

Select User and Groups tab and create new user(oggmonadmin)

Fill all relevant details and Click OK

Go to User and Groups tab and select new user(oggmonadmin)

Select all groups from Parent Groups Available and click on Save.

Start ManagedWebLogic  Server

$ cd /u01/app/oracle/domains/bin

$ ./startManagedWebLogic.sh  MONITORSERVER_airpex “http://155.0.5.57:7001”

Check the WebLogic Server

http://155.0.5.57:7003/monitor

Login withoggmonadminuser (password:oracle123)

This section provides for OGG Monitor Agent Configuration
configure this on all DB’s where OGG is running

Step 1: Set JAVA environment ready

Move jdk file to /opt folder for setting java path

Login as root

# cd /home/oracle

# ls

jdk1.7.0_79.zip

# cpjdk1.7.0_79.zip /opt

# cd /opt

# unzip  jdk1.7.0_79.zip

#java –version

“1.6.------”

#cd /etc/alternatives

Take backup of old java link

# mv java java.old

Create new java link for 1.7 version

# ln –s  /opt/jdk1.7.0_79/bin/java

#java -version

java version "1.7.0_79"

Java(TM) SE Runtime Environment (build 1.7.0_79-b15)

Java HotSpot(TM) 64-Bit Server VM (build 24.79-b02, mixed mode)

Set PATH, JAVA_HOME, JDK_HOME in bash profile of root user

# cd

# vim .bash_profile

Add this to existing

export PATH=$PATH:/opt/jdk1.7.0_79/bin

export JAVA_HOME=/opt/jdk1.7.0_79

export JDK_HOME=/opt/jdk1.7.0_79

Run the bash profile

# .  .bash_profile

Login as oracle

# su - oracle

Set PATH, JAVA_HOME, JDK_HOME in bash profile of oracle user

$ cd

$ vim .bash_profile

Add this to existing

export PATH=$PATH:/opt/jdk1.7.0_79/bin

export JAVA_HOME=/opt/jdk1.7.0_79

export JDK_HOME=/opt/jdk1.7.0_79

Run the bash profile

$ .  .bash_profile

$ cd

$ ls

Step 2: Fusion Middleware 12c GG Monitor &Veridata Installation

$ pwd

/home/oracle

$ echo $JAVA_HOME

/opt/jdk1.7.0_79

$ java -version

java version "1.7.0_79"

Java(TM) SE Runtime Environment (build 1.7.0_79-b15)

Java HotSpot(TM) 64-Bit Server VM (build 24.79-b02, mixed mode)

$ls

fmw_12.1.3.0.0_ogg_Disk1_1of1.zip

$ unzip fmw_12.1.3.0.0_ogg_Disk1_1of1.zip

$ ls

fmw_12.1.3.0.0_ogg_Disk1_1of1.zip

fmw_12.1.3.0.0_ogg.jar

$ java –jar Xmx1024M fmw_12.1.3.0.0_ogg.jar

$ cd /u01/app/oracle/fra

$ mkdirggagent

$ mkdirgginstance

Set the oracle installation location

ORACLE HOME :/u01/app/oracle/fra/ggagent

Installation Type :Oracle GoldenGate Monitor Agent

Click on Finish.

Silent Mode Installation

$ java -jar -Xmx1024M fmw_12.1.3.0.0_ogg.jar -silent -responseFile /home/oracle/oggAgentInstall.rsp  Annexure-C

Step 3: Create OGG Instance

$ cd /u01/app/oracle/fra/ggagent/oggmon/ogg_agent

$ ./create_ogg_agent_instance.sh

Please enter absolute path of Oracle GoldenGate home directory :/u01/app/oracle/fra/gg

Please enter absolute path of OGG Agent instance :/u01/app/oracle/fra/gginstance

GG Instance created successfully.

$ /u01/app/oracle/fra/gginstance/cfg

$ vimConfig.properties                Annexure-D

Edit these parameters

     monitor.host=155.0.5.57
     jagent.hot=155.0.36.136

Edit GLOBALS

$ /u01/app/oracle/fra/gg

$ vim GLOBALS

Add this parameter

     ENABLEMONITORING

Step 3: Create Password ----------

$ cd /u01/app/oracle/fra/gginstance/bin

$ ./pw_agent_util.sh –create

Password for Java Agent: oracle123

Password for Monitor Server JMX: oracle123

Go to GG installation directory to run jagent

$ cd /u01/app/oracle/fra/gg

$ ./ggsci

./ggsci

GGSCI (knh-11-c3n1-db1.iaf.in) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
JAGENT      STOPPED

GGSCI (knh-11-c3n1-db1.iaf.in) 1>start jagent

GGSCI (knh-11-c3n1-db1.iaf.in) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
JAGENT      RUNNING                                          

In the other window check the logs for processes of jagent

$ tailf/u01/app/oracle/fra/gginstance/logs/ogg_agent.log

Deinstall

$ cd /u01/app/oracle/fra/ggagent/oui/bin

$ ./deinstall

Annexure-A

FusionMiddleware.rsp

[ENGINE]

#DO NOT CHANGE THIS.

Response File Version=1.0.0.0.0

[GENERIC]

#The oracle home location. This can be an existing Oracle Home or a new Oracle Home

ORACLE_HOME=/home/oracle/Oracle/Middleware/Oracle_Home

#Set this variable value to the Installation Type selected. e.g. Fusion Middleware Infrastructure, Fusion Middleware Infrastructure With Examples.

INSTALL_TYPE=Fusion Middleware Infrastructure

#Provide the My Oracle Support Username. If you wish to ignore Oracle Configuration Manager configuration provide empty string for user name.

MYORACLESUPPORT_USERNAME=

#Provide the My Oracle Support Password

MYORACLESUPPORT_PASSWORD=<SECURE VALUE>

#Set this to true if you wish to decline the security updates. Setting this to true and providing empty string for My Oracle Support username will ignore the Oracle Configuration Manager configuration

DECLINE_SECURITY_UPDATES=true

#Set this to true if My Oracle Support Password is specified

SECURITY_UPDATES_VIA_MYORACLESUPPORT=false

#Provide the Proxy Host

PROXY_HOST=

#Provide the Proxy Port

PROXY_PORT=

#Provide the Proxy Username

PROXY_USER=

#Provide the Proxy Password

PROXY_PWD=<SECURE VALUE>

#Type String (URL format) Indicates the OCM Repeater URL which should be of the format [scheme[Http/Https]]://[repeater host]:[repeater port]

COLLECTOR_SUPPORTHUB_URL=

Annexure-B

GGMonitorInstall.rsp

[ENGINE]

#DO NOT CHANGE THIS.

Response File Version=1.0.0.0.0

[GENERIC]

#The oracle home location. This can be an existing Oracle Home or a new Oracle Home

ORACLE_HOME=/home/oracle/Oracle/Middleware/Oracle_Home

#Set this variable value to the Installation Type selected. e.g. Complete, GoldenGate Veridata Web Server Installation, GoldenGate Veridata Agent Installation, GoldenGate Veridata Web Server and Agent Installation, GoldenGate Monitor Web Server Installation, GoldenGate Monitor Agent Installation, GoldenGate Monitor Web Server and Agent Installation.

INSTALL_TYPE=GoldenGate Monitor Web Server Installation

Annexure-C

oggAgentInstall.rsp

[ENGINE]

#DO NOT CHANGE THIS.

Response File Version=1.0.0.0.0

[GENERIC]

#The oracle home location. This can be an existing Oracle Home or a new Oracle Home

ORACLE_HOME=/u01/app/oracle/fra/ggagent

#Set this variable value to the Installation Type selected. e.g. Complete, GoldenGate Veridata Web Server Installation, GoldenGate Veridata Agent Installation, GoldenGate Veridata Web Server and Agent Installation, GoldenGate Monitor Web Server Installation, GoldenGate Monitor Agent Installation, GoldenGate Monitor Web Server and Agent Installation.

INSTALL_TYPE=GoldenGate Monitor Agent Installation

Annexure-D

Config.properties

####################################################################

## jagent.host: Host name of the machine where jAgent is running ###

## Note: This host name has to be reachable from Monitor Server  ###

####################################################################

jagent.host=155.0.36.136

####################################################################

## jagent.jmx.port: jAgent's JMX port number                     ###

####################################################################

jagent.jmx.port=5555

####################################################################

## interval.regular, interval.quick:                             ###

## jAgent's regular and quick polling interval for new           ###

## Monitoring Point values.                                         ###

## Default values are 60 and 30 seconds                          ###

####################################################################

interval.regular=60

interval.quick=30

####################################################################

## monitor.host: Monitor Server host name.                        ###

## Note: This property has to be the same with the property:     ###

## monitor.jmx.server.host in monitor.properties file            ###

## on Monitor Server side                                        ###

####################################################################

monitor.host=155.0.5.57

####################################################################

## monitor.jmx.port: Monitor Server JMX port number              ###

####################################################################

monitor.jmx.port=5502

####################################################################

## monitor.jmx.username: Monitor Server JMX username             ###

## This is the JMX username defined during Monitor Installation  ###

####################################################################

monitor.jmx.username=oggmsjmxusr

####################################################################

## jagent.username: jAgent username                              ###

## It can be any name. This jAgent username will be passed to    ###

## Monitor Server during jAgent registration.                    ###

####################################################################

jagent.username=oggmajmxusr

####################################################################

## reg.retry.interval: jAgent incremental registration           ###

## retry interval in seconds; when connection exception          ###

## occurs while jAgent is connecting to Monitor Server for the   ###

## first time                                                    ###

## Default value is 60 seconds                                   ###

####################################################################

reg.retry.interval=10

####################################################################

## instance.query.initial.interval:                              ###

## If only manager process is running, jAgent will wait for      ###

## 15 seconds by default before starting to register             ###

## to Monitor Server. After this waiting period of time,         ###

## if there are still no other running processes such as         ###

## extract and replicat beside the manager process, JAgent will  ###

## go ahead and register to Monitor Server.                      ###

####################################################################

instance.query.initial.interval=5

####################################################################

## incremental.registration.quiet.interval:                      ###

## jAgent will incrementally register to Monitor Server after    ###

## a new process is configured. However, jAgent will wait for    ###

## a period of 5 seconds by default before each                  ###

## incremental registration started.                             ###

####################################################################

incremental.registration.quiet.interval=5

###################################################################

## maximum.message.retrieval:                                    ###

## Maximum number of message to retrieve from cagent/core when   ###

## jagent starts                                                 ###

####################################################################

maximum.message.retrieval=500

####################################################################

## mgr.host: Host name of the machine where Manager is running   ###

## Note: This host name has to be reachable from JAgent          ###

## There is no need to define this property if JAgent is         ###

## running on the same machine with OGG Deployment               ###

####################################################################

#mgr.host=localhost

####################################################################

## mgr.port: Manager port number                                 ###

## There is no need to define this property if JAgent is         ###

## running on the same machine with OGG Deployment               ###

####################################################################

#mgr.port=7089

####################################################################

## jagent.rmi.port                                               ###

## RMI Port which EM Agent will use to connect to JAgent         ###

## RMI Port will only be used if agent.type.enabled=OEM          ###

####################################################################

jagent.rmi.port=5559

####################################################################

## agent.type.enabled : Choose either OEM or OGGMON              ###

## Choosing OGGMON will allow JAgent to register to              ###

## Monitor Server and JMX RMI connector will not be enabled.     ###

## Choosing OEM will enable JMX RMI connector which will be used ###

## by EM Agent to connect to JAgent and JAgent will not register ###

## to Monitor Server.                                            ###

####################################################################

agent.type.enabled=OGGMON

####################################################################

## status.polling.interval: polling interval for status changes  ###

## in second. Newly added process will be detected based on this ###

## polling interval.Default is 5 seconds.                        ###

####################################################################

status.polling.interval=5

####################################################################

## message.polling.interval: polling interval for message        ###

## changes in second. Default is 5 seconds.                      ###

####################################################################

message.polling.interval=5

## This property is not being used at the moment

reg.retry.times=-1

####################################################################

## jagent backward compatibility                                 ###

####################################################################

jagent.backward.compatibility=false

################## Start SSL Properties ############################

####################################################################

## jagent SSL Enabled property                                   ###

####################################################################

jagent.ssl=false

####################################################################

## keystore file - value for SSL property javax.net.ssl.keyStore ###                                 

####################################################################

jagent.keystore.file=jagentKeyStore

####################################################################

## truststore file-value for SSL property javax.net.ssl.trustStore #                       

####################################################################

jagent.truststore.file=jagentKeyStore

################### End SSL Properties #############################