Installing and Configuring Oracle GoldenGate Monitor 12c (12.1.3.0)

-

Installing and Configuring Oracle GoldenGate Monitor 12c (12.1.3.0)

GoldenGate Monitor is a web-based monitoring console that provides a real-time graphical overview of all the Oracle GoldenGate instances in our enterprise.
We can view statistics and alerts as well as monitor the performance of all the related GoldenGate components in all environments in our enterprise from a single console.
GoldenGate Monitor can also send alert messages to e-mail and SNMP clients.
This note describes the steps involved in installing and configuring the Oracle GoldenGate 12c Monitor Server and Monitor Agent.
At a high level, these are the different steps:
·     Install JDK 1.7
·     Install Fusion Middleware Infrastructure 12.1.3.0 which will also install Web Logic Server 12.1.3
·     From the Fusion Middleware Infrastructure home run the Repository Creation Utility (RCU) to create an Oracle GoldenGate Monitor-specific repository in an Oracle database.
·     Install Oracle GoldenGate Monitor Server (and optionally Monitor Agent)
·     Create the WebLogic Domain for GoldenGate Monitor
·     Edit the monitor.properties file
·     Configure boot.properties file for WebLogic Admin and Managed Servers
·     Start the WebLogic Admin and Managed Servers
·     Create the GoldenGate Monitor Admin user via the WebLogic Console and grant the user the appropriate roles
·     Install the Oracle GoldenGate Monitor Agent on the target hosts with running GoldenGate environments which we want to monitor
·     Configure the Monitor Agent and edit Config.properties file

Check  JDK 1.7 installed and configure environment variable JAVA_HOME

[oracle@pl-p1-mgmt-con-01 ~]$ cd java_1.7/jdk1.7.0_79/

[oracle@pl-p1-mgmt-con-01 jdk1.7.0_79]$ cd bin

[oracle@pl-p1-mgmt-con-01 bin]$ ./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)

[oracle@pl-p1-mgmt-con-01 bin]$ export JAVA_HOME=/home/oracle/java_1.7/jdk1.7.0_79


Install Fusion Middleware Infrastructure 12.1.3.0
Download and unzip V44416-01.zip from edelivery.oracle.com
[oracle@pl-p1-mgmt-con-01 FMW12c]$ $JAVA_HOME/bin/java -jar fmw_12.1.3.0.0_infrastructure.jar

Got errors related to permissions so had to use a different location for the TEMP directory location

[oracle@pl-p1-mgmt-con-01 FMW12c]$ java -Djava.io.tmpdir=/home/oracle -jar fmw_12.1.3.0.0_infrastructure.jar

Run the Repository Creation Utility


[oracle@pl-p1-mgmt-con-01 FMW12c]$ cd /orasw/app/oracle/middleware_12c/

[oracle@pl-p1-mgmt-con-01 middleware_12c]$ ls
coherence  em  install  inventory  OPatch  oracle_common  oraInst.loc  oui  wlserver

[oracle@pl-p1-mgmt-con-01 middleware_12c]$ cd oracle_common/

[oracle@pl-p1-mgmt-con-01 oracle_common]$ cd bin

[oracle@pl-p1-mgmt-con-01 bin]$ ls -l rcu
-rwxr-x---. 1 oracle oinstall 12876 Feb  5  2014 rcu

[oracle@pl-p1-mgmt-con-01 bin]$./rcu





























AL32UTF8 warning











































Install Oracle GoldenGate Monitor Server

Download V44427-01.zip Oracle Fusion Middleware 12c (12.1.3.0.0) GoldenGate Monitor and Veridata

[oracle@pl-p1-mgmt-con-01 FMW12c]$ unzip V44427-01.zip
Archive:  V44427-01.zip
  inflating: fmw_12.1.3.0.0_ogg.jar
[oracle@pl-p1-mgmt-con-01 FMW12c]$

[oracle@pl-p1-mgmt-con-01 FMW12c]$ java -Djava.io.tmpdir=/home/oracle -jar fmw_12.1.3.0.0_ogg.jar
Launcher log file is /home/oracle/OraInstall2015-08-25_09-32-01PM/launcher2015-08-25_09-32-01PM.log.
Extracting files.....
Starting Oracle Universal Installer

Checking if CPU speed is above 300 MHz.   Actual 2500.000 MHz    Passed
Checking monitor: must be configured to display at least 256 colors.   Actual 16777216    Passed
Checking swap space: must be greater than 512 MB.   Actual 33554428 MB    Passed
Checking if this platform requires a 64-bit JVM.   Actual 64    Passed (64-bit not required)
Checking temp space: must be greater than 300 MB.   Actual 14738 MB    Passed


Preparing to launch the Oracle Universal Installer from /home/oracle/OraInstall2015-08-25_09-32-01PM
Log: /home/oracle/OraInstall2015-08-25_09-32-01PM/install2015-08-25_09-32-01PM.log

Create the WebLogic Domain

[oracle@pl-p1-mgmt-con-01 FMW12c]$ cd /orasw/app/oracle/middleware_12c/wlserver/

 [oracle@pl-p1-mgmt-con-01 wlserver]$ cd common/bin

[oracle@pl-p1-mgmt-con-01 bin]$ ./config.sh


















Note: specify the password for the Linux ‘oracle’ OS user account. Passwords with an ‘!’ or ‘#” seem to cause configuration errors.






Note: Changed Admin Server listen port to 7002 (not 7001 as shown in figure above)

Edit the monitor.properties file

[oracle@pl-p1-mgmt-con-01 cfg]$ pwd
/orasw/app/oracle/middleware_12c/user_projects/domains/oggmon_domain/config/monitorserver/cfg

[oracle@pl-p1-mgmt-con-01 cfg]$ vi monitor.properties

#JMX server's user
monitor.jmx.server.user=oracle

#JMX server's host name
# underscore in JMX server's hostname is not valid e.g. XXX_YZW is invalid JMX server's host name
monitor.jmx.server.host=pl-p1-mgmt-con-01

#Port that is bound by the JMX server
monitor.jmx.server.port=5502

Ensure this line is uncommented

#Please use this property value when the Monitor repository database is Oracle.
eclipselink.target-database=org.eclipse.persistence.platform.database.OraclePlatform

For SMTP


#SMTP server's hostname/ip
monitor.smtp.host=

#SMTP server's port
monitor.smtp.port=25

#SMTP secure mode flag
monitor.smtp.secure=false

#SMTP username for auth
monitor.smtp.user=

#Whether email alerts are generated or not
monitor.smtp.alerts.enabled=true

Configure boot.properties file for Admin and Managed Servers

[oracle@pl-p1-mgmt-con-01 ~]$ cd /orasw/app/oracle/middleware_12c/user_projects/domains/oggmon_domain/

[oracle@pl-p1-mgmt-con-01 oggmon_domain]$ cd servers/AdminServer

[oracle@pl-p1-mgmt-con-01 AdminServer]$ ls
adr  cache  data  logs  sysman  tmp

[oracle@pl-p1-mgmt-con-01 AdminServer]$ mkdir security

[oracle@pl-p1-mgmt-con-01 AdminServer]$ cd security/

[oracle@pl-p1-mgmt-con-01 security]$ pwd
/orasw/app/oracle/middleware_12c/user_projects/domains/oggmon_domain/servers/AdminServer/security

[oracle@pl-p1-mgmt-con-01 security]$ vi boot.properties

 [oracle@pl-p1-mgmt-con-01 security]$ cd /orasw/app/oracle/middleware_12c/user_projects/domains/oggmon_domain

[oracle@pl-p1-mgmt-con-01 oggmon_domain]$ cd servers/

 [oracle@pl-p1-mgmt-con-01 servers]$ cd MONITORSERVER_server1/

 [oracle@pl-p1-mgmt-con-01 MONITORSERVER_server1]$ mkdir security

[oracle@pl-p1-mgmt-con-01 MONITORSERVER_server1]$ cd security/

[oracle@pl-p1-mgmt-con-01 security]$ pwd
/orasw/app/oracle/middleware_12c/user_projects/domains/oggmon_domain/servers/MONITORSERVER_server1/security

[oracle@pl-p1-mgmt-con-01 security]$ vi boot.properties


[oracle@pl-p1-mgmt-con-01 security]$ cat boot.properties
username=weblogic
password=Tmobile1p

Start WebLogic Admin and Managed Servers


 [oracle@pl-p1-mgmt-con-01 cfg]$ cd /orasw/app/oracle/middleware_12c/user_projects/domains/oggmon_domain

[oracle@pl-p1-mgmt-con-01 oggmon_domain]$ ls *.sh
startWebLogic.sh

oracle@pl-p1-mgmt-con-01 oggmon_domain]$ nohup ./startWebLogic.sh &
[1] 11044
[oracle@pl-p1-mgmt-con-01 oggmon_domain]$ nohup: ignoring input and appending output to `nohup.out'

[oracle@pl-p1-mgmt-con-01 oggmon_domain]$ tail -f nohup.out
…
…
…

<Aug 26, 2015 5:45:31 AM PDT> <Notice> <WebLogicServer> <BEA-000360> <The server started in RUNNING mode.>
<Aug 26, 2015 5:45:31 AM PDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RUNNING.>


[oracle@pl-p1-mgmt-con-01 domains]$ pwd
/orasw/app/oracle/middleware_12c/user_projects/domains

[oracle@pl-p1-mgmt-con-01 domains]$ cd oggmon_domain/

[oracle@pl-p1-mgmt-con-01 oggmon_domain]$ cd bin


[oracle@pl-p1-mgmt-con-01 bin]$ nohup ./startManagedWebLogic.sh MONITORSERVER_server1 http://pl-p1-mgmt-con-01:7002 &
[2] 12188
[oracle@pl-p1-mgmt-con-01 bin]$ nohup: ignoring input and appending output to `nohup.out'

[oracle@pl-p1-mgmt-con-01 bin]$ tail -f nohup.out

…
…
…

<Aug 26, 2015 5:50:57 AM PDT> <Notice> <WebLogicServer> <BEA-000330> <Started the WebLogic Server Managed Server "MONITORSERVER_server1" for domain "oggmon_domain" running in production mode.>
<Aug 26, 2015 5:50:57 AM PDT> <Notice> <WebLogicServer> <BEA-000360> <The server started in RUNNING mode.>
<Aug 26, 2015 5:50:57 AM PDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RUNNING.>







Create the GoldenGate Monitor Admin User (OGGMON)













Launch Oracle GoldenGate Monitor

http://10.253.8.189:7003/monitor/faces/loginPage.jspx

Install the GoldenGate Monitor Agent on the target hosts



[oracle@p0017 ggs_121210]$ java -jar fmw_12.1.3.0.0_ogg.jar
Launcher log file is /tmp/OraInstall2015-08-28_01-29-06AM/launcher2015-08-28_01-29-06AM.log.
Extracting files.....
Starting Oracle Universal Installer

Checking if CPU speed is above 300 MHz.   Actual 1200.000 MHz    Passed
Checking monitor: must be configured to display at least 256 colors.   Actual 16777216    Passed
Checking swap space: must be greater than 512 MB.   Actual 100663292 MB    Passed
Checking if this platform requires a 64-bit JVM.   Actual 64    Passed (64-bit not required)
Checking temp space: must be greater than 300 MB.   Actual 18073 MB    Passed


Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2015-08-28_01-29-06AM
Log: /tmp/OraInstall2015-08-28_01-29-06AM/install2015-08-28_01-29-06AM.log

Configure the Monitor Agent (JAGENT)

[oracle@p0017 ggs_121210]$ which java
/usr/bin/java

[oracle@p0017 ggs_121210]$ export JAVA_HOME=/usr

[oracle@p0017 ggs_121210]$ cd /orasw/app/oracle/jagent/oggmon/ogg_agent/

[oracle@p0017 ogg_agent]$ ./create_ogg_agent_instance.sh
Please enter absolute path of Oracle GoldenGate home directory : /orasw/app/ogg12c
Please enter absolute path of OGG Agent instance : /orasw/app/oracle/jagent
OGG Agent instance directory already exists, do you want to overwrite the contents (yes | no) : yes
Sucessfully created OGG Agent instance.


[oracle@p0017 bin]$ pwd
/orasw/app/oracle/jagent/bin

[oracle@p0017 bin]$ ./pw_agent_util.sh -create
Please create a password for Java Agent:
Please confirm password for Java Agent:
Please enter Monitor Server JMX password:
Please confirm Monitor Server JMX password:
Aug 28, 2015 4:26:23 PM oracle.security.jps.JpsStartup start
INFO: Jps initializing.
Aug 28, 2015 4:26:24 PM oracle.security.jps.JpsStartup start
INFO: Jps started.
Wallet is created successfully.
[oracle@p0017 bin]$



GGSCI (p0017) 2> edit params ./GLOBALS
GGSCHEMA oggsuser
CHECKPOINTTABLE oggsuser.ctable
ENABLEMONITORING


EXIT from GGSCI

Launch GGSCI again


Note :

log4j:WARN No appenders could be found for logger (org.springframework.core.env.StandardEnvironment).

cannot have a ! or _ in password for the OS user for the monitor as well as jagent


Edit Config.properties

p0017@oracle:auxdit1>cd /orasw/app/oracle/jagent/cfg

p0017@oracle:auxdit1>vi Config.properties

monitor.host=pl-p1-mgmt-con-01

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



####################################################################
## jagent.username: jAgent username                              ###
## It can be any name. This jAgent username will be passed to    ###
## Monitor Server during jAgent registration.                    ###
####################################################################
jagent.username=oracle


p0017@oracle:auxdit1>./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.1.2.1.7 21031614 OGGCORE_12.1.2.1.0OGGBP_PLATFORMS_150520.1612_FBO
Linux, x64, 64bit (optimized), Oracle 12c on May 21 2015 01:37:47
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.



GGSCI (p0017) 1> start jagent

Sending START request to MANAGER ...
GGCMD JAGENT starting


GGSCI (p0017) 2> info jagent

JAgent is running.


Note: Check Monitor Agent logs located at:

/orasw/app/oracle/jagent/logs/ogg_agent.log

Comments

Post a Comment

Popular posts from this blog

Oracle Golden Gate FAQ

-
Image
                                                      Oracle Golden Gate FAQ Q. What type of Topology does Goldengate support? GoldenGate supports the following topologies. 1. Unidirectional 2. Bidirectional 3. Peer-to-peer 4. Broadcast 5. Consolidation 6. Cascasding Q. What are the main components of the Goldengate replication? The replication configuration consists of the following processes. 1. Manager 2. Extract 3. Pump 4. Replicate Q. What transaction types does Goldengate support for Replication? Goldengate supports both DML and DDL Replication from the source to target. Q. What are the supplemental logging pre-requisites? The following supplemental logging is required. 1. Database supplemental logging 2. Object level logging Q. Why is Supplemental logging required for Replication? Integrated Capture (IC): 1. In the...
Read more

Oracle Golden gate - Long running transactions while stopping an extract

-
Oracle Golden gate  - Long running transactions while stopping an extract ? Below is how you can find it out and kill if needed. GGSCI (ggnode1) 7>send extract EXRAJ, showtrans duration 20 MIN Sending showtrans request to EXTRACT EXRAJ ... Oldest redo log files necessary to restart Extract are: Redo Thread 1, Redo Log Sequence Number 74058, SCN 1586.3900894393 (6815719025849), RBA 104066064 Redo Thread 2, Redo Log Sequence Number 79546, SCN 1586.3894494112 (6815712625568), RBA 1458358288 ------------------------------------------------------------ XID:                  1630.17.201166 Items:                1        Extract:              EXRAJ    Redo Thread:          1      Start Time:           2013-05-10:21:43:50  SCN:      ...
Read more

FAQ on Oracle Golden gate for unix & windows

-
                                        FAQ on Oracle Golden gate for unix & windows 1.What is the purpose of running   the Reverse utility • To restore a test database to its original state before the test run. Because the Reverse utility only backs out changes, a test database can be restored in a matter of minutes, much more efficiently than a complete database restore, which can take hours. • To reverse errors caused by corrupt data or accidental deletions. For example, if an UPDATE or DELETE command is issued without a WHERE clause, the Reverse utility reverses the operation. 2.What needs to do for using the Reverse utility • Run Extract to extract the before data. • Run the Reverse utility to perform the reversal of the transactions. • Run Replicat to apply the restored data to the target database. 3.How the Reverse utility reverses the fo...
Read more