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
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
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
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
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
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 #############################
