Gavinsoorma.com.au



GoldenGate 12c Advanced WorkshopHands-on Lab Exercise 4Install and Configure Oracle GoldenGate Monitor 12.2Download Fusion Middleware 12.2.1.2.0 from Oracle Software Delivery Cloud Download Oracle GoldenGate Monitor and Veridata 12.1.3.0.0Check the current Java version [oracle@host01 admin]$ java -version java version "1.7.0_51"OpenJDK Runtime Environment (rhel-2.4.5.5.0.1.el7-x86_64 u51-b31)OpenJDK 64-Bit Server VM (build 24.51-b03, mixed mode)Note: The requirement for Oracle GoldenGate Monitor is Java SE, JDK 8u40 and greaterDownload and Install Java JDK 8[oracle@host01 sf_software]$ ls jdk-8*jdk-8u131-linux-x64.tar.gz[oracle@host01 sf_software]$ cp jdk-8u131-linux-x64.tar.gz /home/oracle[oracle@host01 ~]$ gunzip jdk-8u131-linux-x64.tar.gz [oracle@host01 ~]$ tar -xvf jdk-8u131-linux-x64.tarAdd the JAVA_HOME variable to the .bash_profile[oracle@host01 ~]$ vi .bash_profileexport JAVA_HOME=/home/oracle/jdk1.8.0_131PATH=$JAVA_HOME/bin:$PATH:$HOME/.local/bin:$HOME/bin [oracle@host01 ~]$ . ./.bash_profile[oracle@host01 ~]$ java -version java version "1.8.0_131"Java(TM) SE Runtime Environment (build 1.8.0_131-b11)Java HotSpot(TM) 64-Bit Server VM (build 25.131-b11, mixed mode)Install Fusion Middleware Infrastructure 12.2.1.2.0[oracle@linux01 fmw_12.2.1.2.0_infrastructure]$ pwd/media/sf_software/fmw_12.2.1.2.0_infrastructure[oracle@linux01 fmw_12.2.1.2.0_infrastructure]$ java -Djava.io.tmpdir=/u01/app/oracle -jar fmw_12.2.1.2.0_infrastructure.jar Launcher log file is /u03/app/oracle/OraInstall2017-05-22_02-59-36PM/launcher2017-05-22_02-59-36PM.log.Extracting the installer . . . . . . . . . . . . . . . . . . . . . DoneChecking if CPU speed is above 300 MHz. Actual 2494.222 MHz PassedChecking monitor: must be configured to display at least 256 colors. Actual 16777216 PassedChecking swap space: must be greater than 512 MB. Actual 2047 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 10324 MB PassedPreparing to launch the Oracle Universal Installer from /u03/app/oracle/OraInstall2017-05-22_02-59-36PMLog: /u03/app/oracle/OraInstall2017-05-22_02-59-36PM/install2017-05-22_02-59-36PM.logInstall GoldenGate Monitor Server 12.2[oracle@rac01 sf_software]$ cd fmw_12.2.1.2.0_ogg[oracle@rac01 fmw_12.2.1.2.0_ogg]$ lsfmw_12.2.1.2.0_ogg.jar fmw_12212_readme.htm [oracle@linux01 fmw_12.2.1.2.0_ogg]$ java -Djava.io.tmpdir=/u01/app/oracle -jar fmw_12.2.1.2.0_ogg.jar Launcher log file is /u03/app/oracle/OraInstall2017-05-22_04-03-41PM/launcher2017-05-22_04-03-41PM.log.Extracting the installer . . . . . . . . . . DoneChecking if CPU speed is above 300 MHz. Actual 2494.222 MHz PassedChecking monitor: must be configured to display at least 256 colors. Actual 16777216 PassedChecking swap space: must be greater than 512 MB. Actual 2047 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 9495 MB PassedPreparing to launch the Oracle Universal Installer from /u03/app/oracle/OraInstall2017-05-22_04-03-41PMLog: /u03/app/oracle/OraInstall2017-05-22_04-03-41PM/install2017-05-22_04-03-41PM.logClick on View Create required schemas using Repository Creation Utility (RCU)[oracle@rac01 fmw_12.2.1.2.0_ogg]$ cd /u01/app/oracle/middleware/oracle_common/bin[oracle@rac01 bin]$ ./rcuCreate the WebLogic Domains[oracle@rac01 bin]$ cd /u01/app/oracle/middleware/oracle_common/common/bin[oracle@rac01 bin]$ ./config.shSelect Oracle GoldenGate Monitor Server templateSelect the option ProductionClick on Get RCU ConfigurationEnter the password for the OS user oracle Select options Administration Server and TopologyNote the Managed Server Name and the port Click Next Click Next Click Next Click Next Click Next Click Create Edit the monitor.properties file [oracle@rac01 bin]$ cd /u01/app/oracle/middleware/user_projects/domains/base_domain/config/monitorserver/cfg[oracle@rac01 cfg]$ vi monitor.properties# underscore in JMX server's hostname is not valid e.g. XXX_YZW is invalid JMX server's host namemonitor.jmx.server.host=host01#Port that is bound by the JMX servermonitor.jmx.server.port=5502#JMX server's usermonitor.jmx.server.user=oracleExecute the updateOGGMonitorConfig.sh script to configure security[oracle@rac01 cfg]$ cd /u01/app/oracle/middleware/oggmon/monitor_server/bin[oracle@rac01 bin]$ ./updateOGGMonitorConfig.sh This script utility is used to update configuration information for monitor server. All feilds are mandatory. Press Ctrl+C to exit.Enter absolute path for oggmon domain: /u01/app/oracle/middleware/user_projects/domains/base_domainYou have entered the domain path as : /u01/app/oracle/middleware/user_projects/domains/base_domainEnter JMX HOST NAME/IP:host01Enter JMX Server Port:5502Enter JMX Server Username:oracleEnter the database type for Monitor Installation.For Oracle Database, Press 1. For SQL Server, Press 2:1Jul 11, 2017 8:33:45 AM oracle.security.jps.JpsStartup startINFO: Jps initializing.Jul 11, 2017 8:33:50 AM org.hibernate.validator.internal.util.Version <clinit>INFO: HV000001: Hibernate Validator 5.1.3.FinalJul 11, 2017 8:34:04 AM oracle.security.jps.JpsStartup startINFO: Jps started.Jul 11, 2017 8:34:06 AM oracle.security.audit.Auditor initWARNING: IAU:IAU-6012: Unable to determine the audit log directory. No log directory specified.Jul 11, 2017 8:34:06 AM oracle.security.jps.util.JpsUtil disableAuditINFO: JpsUtil: isAuditDisabled set to trueJul 11, 2017 8:34:06 AM oracle.security.jps.internal.audit.AuditServiceImpl validateLogPossibleWARNING: No audit log directory is set. Cannot perform audit operations for component JPS.Created Secure Key properties file.Added Secure Key into Monitor Server Oracle Wallet.Install the Oracle GoldenGate Monitor Agent [oracle@host01 bin]$ cd /media/sf_software/fmw_12.2.1.2.0_ogg/[oracle@host01 fmw_12.2.1.2.0_ogg]$ ls -ltotal 435577-rwxrwx---. 1 root vboxsf 446021430 May 22 16:01 fmw_12.2.1.2.0_ogg.jar-rwxrwx---. 1 root vboxsf 8986 May 22 16:01 fmw_12212_readme.htm[oracle@rac01 fmw_12.2.1.2.0_ogg]$ java -jar fmw_12.2.1.2.0_ogg.jar Launcher log file is /tmp/OraInstall2017-07-11_09-22-38AM/launcher2017-07-11_09-22-38AM.log.Extracting the installer . . . . . . . . . . . DoneChecking if CPU speed is above 300 MHz. Actual 2494.234 MHz PassedChecking monitor: must be configured to display at least 256 colors. Actual 16777216 PassedChecking swap space: must be greater than 512 MB. Actual 3071 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 1336 MB PassedPreparing to launch the Oracle Universal Installer from /tmp/OraInstall2017-07-11_09-22-38AMLog: /tmp/OraInstall2017-07-11_09-22-38AM/install2017-07-11_09-22-38AM.logEnter the FMW Oracle Home location and click on the View buttonSelect option Oracle GoldenGate Monitor AgentStart the WebLogic Admin Server [oracle@host01 fmw_12.2.1.2.0_ogg]$ cd /u01/app/oracle/middleware/user_projects/domains/base_domain/[oracle@host01 base_domain]$ cd servers/[oracle@host01 servers]$ cd AdminServer/[oracle@host01 AdminServer]$ mkdir security[oracle@host01 AdminServer]$ cd security [oracle@host01 security]$ vi boot.propertiesusername=weblogicpassword=w3bl0g1c[oracle@host01 bin]$ pwd/u01/app/oracle/middleware/user_projects/domains/base_domain/bin[oracle@host01 base_domain]$ nohup ./startWebLogic.sh &[oracle@host01 base_domain]$ tail -f nohup.out….…..<May 24, 2017, 4:00:00,46 PM AWST> <Notice> <Server> <BEA-002613> <Channel "Default[1]" is now listening on 0:0:0:0:0:0:0:1%lo:7001 for protocols iiop, t3, ldap, snmp, http.> <May 24, 2017, 4:00:00,48 PM AWST> <Notice> <Server> <BEA-002613> <Channel "Default" is now listening on 10.1.1.100:7001 for protocols iiop, t3, ldap, snmp, http.> <May 24, 2017, 4:00:00,57 PM AWST> <Notice> <WebLogicServer> <BEA-000360> <The server started in RUNNING mode.> <May 24, 2017, 4:00:00,116 PM AWST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RUNNING.>Start the WebLogic Managed Server [oracle@host01 MONITORSERVER_server1]$ pwd/u01/app/oracle/middleware/user_projects/domains/base_domain/servers/MONITORSERVER_server1[oracle@host01 MONITORSERVER_server1]$ mkdir security[oracle@host01 MONITORSERVER_server1]$ cd security [oracle@host01 security]$ vi boot.propertiesusername=weblogicpassword=w3bl0g1c[oracle@host01 security]$ cd /u01/app/oracle/middleware/user_projects/domains/base_domain/bin[oracle@linux01 middleware]$ nohup ./startManagedWebLogic.sh MONITORSERVER_server1 &[oracle@linux01 middleware]$ tail -f nohup.out<May 24, 2017, 4:20:56,736 PM AWST> <Notice> <WebLogicServer> <BEA-000330> <Started the WebLogic Server Managed Server "MONITORSERVER_server1" for domain "base_domain" running in production mode.> <May 24, 2017, 4:20:56,750 PM AWST> <Notice> <WebLogicServer> <BEA-000360> <The server started in RUNNING mode.> <May 24, 2017, 4:20:56,857 PM AWST> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to RUNNING.>Create the OGGMON WebLogic User Launch WebLogic Console on Security Realms menu Click on myrealmClick on Users and Groups tab and then the New button Click on oggmon Click on Groups Click on Save Click on Log OutConfigure the GoldenGate Monitor Agent[oracle@linux01 ogg_agent]$ mkdir /u01/app/oracle/ogg_agent_inst[oracle@linux01 ogg_agent]$ cd /u01/app/oracle/middleware/oggmon/ogg_agent [oracle@rac01 ogg_agent]$ ./createMonitorAgentInstance.shPlease enter absolute path of Oracle GoldenGate home directory : /u01/app/oracle/oggPlease enter absolute path of OGG Agent instance : /u01/app/oracle/ogg_agent_instPlease enter unique name to replace timestamp in startMonitorAgent script (startMonitorAgentInstance_20170711095808.sh) : oggmon_holSuccessfully created OGG Agent instance.[oracle@rac01 ogg_agent]$ cp /u01/app/oracle/middleware/user_projects/domains/base_domain/config/monitorserver/cfg/oggmon.properties /u01/app/oracle/ogg_agent_inst/cfg/[oracle@rac01 ogg_agent]$ cd /u01/app/oracle/ogg_agent_inst/cfg/[oracle@rac01 cfg]$ vi Config.properties jagent.host=host01###################################################################### jagent.jmx.port: jAgent's JMX port number #######################################################################jagent.jmx.port=5555####################################################################monitor.host=host01###################################################################### monitor.jmx.port: Monitor Server JMX port number #######################################################################monitor.jmx.port=5502####################################################################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=oracleagent.type.enabled=OGGMONUpdate JAGENT password in the Wallet[oracle@host01 ~]$ cd /u01/app/oracle/ogg_agent_inst/bin [oracle@linux01 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: May 24, 2017 10:19:35 PM oracle.security.jps.JpsStartup startINFO: Jps initializing.May 24, 2017 10:19:36 PM oracle.security.jps.JpsStartup startINFO: Jps started.Wallet is created successfully.Configure and start GoldenGate JAGENT[oracle@rac01 bin]$ cd /u01/app/oracle/ogg[oracle@rac01 ogg]$ ./ggsciGGSCI (rac01.localdomain) 1> edit params ./GLOBALSENABLEMONITORINGGGSCI (host01.localdomain) 2> exit [oracle@rac01 ogg]$ ./ggsciGGSCI (rac01.localdomain) 17> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING JAGENT STOPPED EXTRACT RUNNING EXT1 00:18:00 00:00:00 EXTRACT RUNNING PUMP1 00:00:00 00:00:03 GGSCI (rac01.localdomain) 18> start jagentSending START request to MANAGER ...GGCMD JAGENT startingGGSCI (rac01.localdomain) 19> info jagentJAgent is running.GGSCI (rac01.localdomain) 40> stop mgr!Sending STOP request to MANAGER ...Request processed.Manager stopped.GGSCI (host01.localdomain) 5> stop jagent !Sending STOP request to GGCMD JAGENT ...Request processed.JAgent stopped.GGSCI (host01.localdomain) 6> stop er * Sending STOP request to EXTRACT EXT1 ...Request processed.Sending STOP request to EXTRACT PUMP1 ...Request processed.Sending STOP request to REPLICAT REP1 ...Request processed.GGSCI (rac01.localdomain) 44> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER STOPPED JAGENT STOPPED EXTRACT STOPPED EXT1 00:00:13 00:00:15 EXTRACT STOPPED PUMP1 00:00:00 00:00:14 GGSCI (rac01.localdomain) 45> delete datastoreAre you sure you want to delete the datastore? y2017-07-11T03:09:47Z INFO OGG-06492 Datastore deletedGGSCI (rac01.localdomain) 46> create datastore Profile 'Trace' added.2017-07-11T03:09:52Z INFO OGG-06489 Datastore createdGGSCI (rac01.localdomain) 47> start mgr Manager started.GGSCI (rac01.localdomain) 48> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING JAGENT STOPPED EXTRACT STARTING EXT1 00:00:13 00:00:37 EXTRACT RUNNING PUMP1 00:00:00 00:00:36 GGSCI (rac01.localdomain) 49> start jagent Sending START request to MANAGER ...GGCMD JAGENT startingGGSCI (rac01.localdomain) 50> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING JAGENT RUNNING EXTRACT RUNNING EXT1 00:00:56 00:00:06 EXTRACT RUNNING PUMP1 00:00:00 00:00:10 Launch Oracle GoldenGate Monitor ................
................

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

Google Online Preview   Download