Knowledge is Power – share IT



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.7Install Fusion Middleware Infrastructure 12.1.3.0 which will also install Web Logic Server 12.1.3From 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 MonitorEdit the monitor.properties fileConfigure boot.properties file for WebLogic Admin and Managed ServersStart the WebLogic Admin and Managed ServersCreate the GoldenGate Monitor Admin user via the WebLogic Console and grant the user the appropriate rolesInstall the Oracle GoldenGate Monitor Agent on the target hosts with running GoldenGate environments which we want to monitorConfigure the Monitor Agent and edit Config.properties fileCheck 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 -versionjava 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_79Install Fusion Middleware Infrastructure 12.1.3.0Download and unzip V44416-01.zip from edelivery.[oracle@pl-p1-mgmt-con-01 FMW12c]$ $JAVA_HOME/bin/java -jar fmw_12.1.3.0.0_infrastructure.jarGot 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.jarRun 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]$ lscoherence 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]$./rcuAL32UTF8 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.zipArchive: 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.jarLauncher log file is /home/oracle/OraInstall2015-08-25_09-32-01PM/launcher2015-08-25_09-32-01PM.log.Extracting files.....Starting Oracle Universal InstallerChecking if CPU speed is above 300 MHz. Actual 2500.000 MHz PassedChecking monitor: must be configured to display at least 256 colors. Actual 16777216 PassedChecking swap space: must be greater than 512 MB. Actual 33554428 MB PassedChecking 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 PassedPreparing to launch the Oracle Universal Installer from /home/oracle/OraInstall2015-08-25_09-32-01PMLog: /home/oracle/OraInstall2015-08-25_09-32-01PM/install2015-08-25_09-32-01PM.logCreate 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.shNote: 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 usermonitor.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 namemonitor.jmx.server.host=pl-p1-mgmt-con-01#Port that is bound by the JMX servermonitor.jmx.server.port=5502Ensure this line is uncommented #Please use this property value when the Monitor repository database is Oracle.eclipselink.target-database=org.eclipse.persistence.platform.database.OraclePlatformFor SMTP #SMTP server's hostname/ipmonitor.smtp.host=#SMTP server's portmonitor.smtp.port=25#SMTP secure mode flagmonitor.smtp.secure=false#SMTP username for authmonitor.smtp.user=#Whether email alerts are generated or notmonitor.smtp.alerts.enabled=trueConfigure 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]$ lsadr 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.propertiesusername=weblogicpassword=Tmobile1pStart 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 *.shstartWebLogic.shoracle@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 &[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 the GoldenGate Monitor Agent on the target hosts[oracle@p0017 ggs_121210]$ java -jar fmw_12.1.3.0.0_ogg.jarLauncher log file is /tmp/OraInstall2015-08-28_01-29-06AM/launcher2015-08-28_01-29-06AM.log.Extracting files.....Starting Oracle Universal InstallerChecking if CPU speed is above 300 MHz. Actual 1200.000 MHz PassedChecking monitor: must be configured to display at least 256 colors. Actual 16777216 PassedChecking swap space: must be greater than 512 MB. Actual 100663292 MB PassedChecking 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 PassedPreparing to launch the Oracle Universal Installer from /tmp/OraInstall2015-08-28_01-29-06AMLog: /tmp/OraInstall2015-08-28_01-29-06AM/install2015-08-28_01-29-06AM.logConfigure 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.shPlease enter absolute path of Oracle GoldenGate home directory : /orasw/app/ogg12cPlease enter absolute path of OGG Agent instance : /orasw/app/oracle/jagentOGG Agent instance directory already exists, do you want to overwrite the contents (yes | no) : yesSucessfully created OGG Agent instance.[oracle@p0017 bin]$ pwd/orasw/app/oracle/jagent/bin[oracle@p0017 bin]$ ./pw_agent_util.sh -createPlease 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 startINFO: Jps initializing.Aug 28, 2015 4:26:24 PM oracle.security.jps.JpsStartup startINFO: Jps started.Wallet is created successfully.[oracle@p0017 bin]$GGSCI (p0017) 2> edit params ./GLOBALSGGSCHEMA oggsuserCHECKPOINTTABLE oggsuser.ctableENABLEMONITORINGEXIT from GGSCILaunch GGSCI againNote :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 jagentEdit Config.propertiesp0017@oracle:auxdit1>cd /orasw/app/oracle/jagent/cfgp0017@oracle:auxdit1>vi Config.propertiesmonitor.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=oraclep0017@oracle:auxdit1>./ggsciOracle GoldenGate Command Interpreter for OracleVersion 12.1.2.1.7 21031614 OGGCORE_12.1.2.1.0OGGBP_PLATFORMS_150520.1612_FBOLinux, x64, 64bit (optimized), Oracle 12c on May 21 2015 01:37:47Operating system character set identified as UTF-8.Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.GGSCI (p0017) 1> start jagentSending START request to MANAGER ...GGCMD JAGENT startingGGSCI (p0017) 2> info jagentJAgent is running.Note: Check Monitor Agent logs located at:/orasw/app/oracle/jagent/logs/ogg_agent.log ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download