goldengate 12c monitor agent 安装测试（配置ogg studio 12c 附加操作）
# rpm -ivh jdk-8u73-linux-x64.rpmPreparing... ###########################################
1:jdk1.8.0_73 ###########################################
Unpacking JAR files...
tools.jar...
plugin.jar...
javaws.jar...
deploy.jar...
rt.jar...
jsse.jar...
charsets.jar...
localedata.jar...
jfxrt.jar...
# cd /usr/java
# ls
defaultjdk1.8.0_73latest
# cd jdk1.8.0_73/
# cd bin
# ./java -version
java version "1.8.0_73"
Java(TM) SE Runtime Environment (build 1.8.0_73-b02)
Java HotSpot(TM) 64-Bit Server VM (build 25.73-b02, mixed mode)
-rw-r--r--1 root root 430166267 Aug 21 11:19 V78177-01.zip -----fmw_12.2.1.0.0_ogg.jarogg monitor 软件包
-rw-r--r--1 root root 160148266 Aug 21 11:25 jdk-8u73-linux-x64.rpm
$ vi .bash_profile
$ source .bash_profile
$ cat .bash_profile
# ---------------------------------------------------
# OS User: oracle
# Application:Oracle Database Software Owner
# Version: Oracle 11g release 2
# ---------------------------------------------------
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
JAVA_HOME=/usr/java/jdk1.8.0_73
ORACLE_SID=orcc1; export ORACLE_SID #another is dgh2
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
GGHOME=/u01/goldengate; export GGHOME
NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"; export NLS_DATE_FORMAT
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
PATH=${PATH}:/u01/app/common/oracle/bin
export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export CLASSPATH
THREADS_FLAG=native; export THREADS_FLAG
export TEMP=/tmp
export TMPDIR=/tmp
# ---------------------------------------------------
# UMASK
# ---------------------------------------------------
# Set the default file mode creation mask
# (umask) to 022 to ensure that the user performing
# the Oracle software installation creates files
# with 644 permissions.
# ---------------------------------------------------
umask 022
$ java -version
java version "1.8.0_73"
Java(TM) SE Runtime Environment (build 1.8.0_73-b02)
Java HotSpot(TM) 64-Bit Server VM (build 25.73-b02, mixed mode)
$ export DISPLAY=192.168.1.1:0.0
$ xhost +
access control disabled, clients can connect from any host
xhost:must be on local machine to enable or disable access control.
$ pwd
/home/oracle
$ cd $GGHOME
$
$ java -jar fmw_12.2.1.0.0_ogg.jar
Launcher log file is /tmp/OraInstall2016-08-21_11-38-41AM/launcher2016-08-21_11-38-41AM.log.
Extracting files......
Starting Oracle Universal Installer
Checking if CPU speed is above 300 MHz. Actual 2494.370 MHz Passed
Checking monitor: must be configured to display at least 256 colors.Actual unknown. Failed <<<<
Checking swap space: must be greater than 512 MB. Actual 1999 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 5681 MB Passed
Some system prerequisite checks failed.
You must fulfill these requirements before continuing with the installation.
Continue? (yes / no )
y
You have confirmed that the product can be installed on this platform.
Continuing with the installation.
>>> Ignoring failure(s) of required prerequisite checks.Continuing...
Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2016-08-21_11-38-41AM
Log: /tmp/OraInstall2016-08-21_11-38-41AM/install2016-08-21_11-38-41AM.log
---截图-------------
>>> Ignoring failure(s) of required prerequisite checks.Continuing...
Preparing to launch the Oracle Universal Installer from /tmp/OraInstall2016-08-21_11-38-41AM
Log: /tmp/OraInstall2016-08-21_11-38-41AM/install2016-08-21_11-38-41AM.log
Logs successfully copied to /u01/oraInventory/logs.
$ ls -l
total 44
drwxr-x--- 2 oracle oinstall 4096 Aug 21 11:43 cfg_templates
-rwxr-x--- 1 oracle oinstall161 Oct 122015 createMonitorAgentInstance.bat
-rwxr-x--- 1 oracle oinstall152 Oct 122015 createMonitorAgentInstance.sh
drwxr-x--- 2 oracle oinstall 4096 Aug 21 11:43 dirjar
drwxr-x--- 2 oracle oinstall 4096 Aug 21 11:43 dirprm_templates
-rwxr-x--- 1 oracle oinstall320 Oct 122015 displayMonitorAgentVersion.bat
-rwxr-x--- 1 oracle oinstall388 Oct 122015 displayMonitorAgentVersion.sh
-rwxr-x--- 1 oracle oinstall357 Oct 122015 pw_agent_util.bat
-rwxr-x--- 1 oracle oinstall 1197 Oct 122015 pw_agent_util.sh
-rwxr-x--- 1 oracle oinstall161 Oct 122015 upgradeToMonitorAgent1221.bat
-rwxr-x--- 1 oracle oinstall150 Oct 122015 upgradeToMonitorAgent1221.sh
$ which java
/usr/java/jdk1.8.0_73/bin/java
$ echo $JAVA_HOME
/usr/java/jdk1.8.0_73
$ export JAVA_HOME=/usr/java/jdk1.8.0_73
$ ./createMonitorAgentInstance.sh
Please enter absolute path of Oracle GoldenGate home directory : /u01/goldengate
Please enter absolute path of OGG Agent instance : /u01/goldengate/oggmon/agent1
Please enter unique name to replace timestamp in startMonitorAgent script (startMonitorAgentInstance_20160821115608.sh) : abc
Sucessfully created OGG Agent instance.
$ cd /u01/goldengate/oggmon/agent1/
$ pwd
/u01/goldengate/oggmon/agent1
$ ls
backupbincfgdirchkdircrtdirprmdirwltlogs
$ cd cfg
$ ls -l
total 64
-rw-r--r-- 1 oracle oinstall8538 Aug 21 11:56 Config.properties
-rw-r--r-- 1 oracle oinstall1483 Aug 21 11:56 jps-config-jse.xml
-rw-r--r-- 1 oracle oinstall 874 Aug 21 11:56 logging-config.xml
-rw-r--r-- 1 oracle oinstall 13791 Aug 21 11:56 mpmetadata-em.xml
-rw-r--r-- 1 oracle oinstall4623 Aug 21 11:56 mpmetadata-new.xml
-rw-r--r-- 1 oracle oinstall3526 Aug 21 11:56 MPMetadataSchema.xsd
-rw-r--r-- 1 oracle oinstall 12138 Aug 21 11:56 mpmetadata.xml
-rw-r--r-- 1 oracle oinstall1327 Aug 21 11:56 password.properties
$ cat Config.properties
####################################################################
## jagent.host: Host name of the machine where jAgent is running ###
## Note: This host name has to be reachable from Monitor Server###
####################################################################
#change to node1-------------------
jagent.host=localhost
####################################################################
## 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 ###
####################################################################
#change to monitor host hostname-----
monitor.host=localhost
####################################################################
## 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 #############################
####################################################################
## jagent restful web service timeout (in millisecond) ###
####################################################################
jagent.restful.ws.timeout=15000
####################################################################
## jagent GGSCI timeout (in second) ###
######################################################哦##############
jagent.ggsci.timeout=30
$ grep -v ^# Config.properties
[$ more Config.properties
jagent.host = node1
jagent.jmx.port = 5555
interval.regular = 60
interval.quick = 30
monitor.host = ogg-studio
jagent.rmi.port = 5559
agent.type.enabled = OEM
jagent.username=oggmsjmxusr
monitor.jmx.username=oggmajmxusr
jagent.backward.compatibility=true
Review and set the properties for one of the following modes:
Oracle GoldenGate Monitor (OGGMON):
jagent.host=
Use the default or change to the complete hostname or IP of the machine where Oracle GoldenGate Monitor Agent (jagent) is running.
jagent.jmx.port=
Use the default or change to your preferred port.
monitor.host=
Set to the hostname you set during your Oracle GoldenGate Monitor Server installation in monitor.properties.
monitor.jmx.port=
Set to the port you set during your Oracle GoldenGate Monitor Server installation in monitor.properties.
monitor.jmx.username=
Set to the user name you provided during your Oracle GoldenGate Monitor Agent installation
jagent.username=
Set a jagent user name.
agent.type.enabled=
Ensure it is set to OGGMON.
jagent.backward.compatibility=
Ensure it is set to false.
jagent.ssl=
Ensure it is set to false.
$ pwd
/u01/goldengate/oggmon/agent1/bin
$ ./pw_agent_util.sh -jagentonly
输入密码:oracle
Please create a password for Java Agent:
Please confirm password for Java Agent:
Aug 21, 2016 12:05:59 PM oracle.security.jps.JpsStartup start
INFO: Jps initializing.
Aug 21, 2016 12:06:00 PM oracle.security.jps.JpsStartup start
INFO: Jps started.
Wallet is created successfully.
$ cd $GGHOME
$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (node1) 1> edit params ./GLOBALS
GGSCI (node1) 2> view params ./GLOBALS
ggschema ogg
ENABLEMONITORING
GGSCI (node1) 2> view params ./GLOBALS
ggschema ogg
ENABLEMONITORING
GGSCI (node1) 3> INFO ALL
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER STOPPED
JAGENT STOPPED
EXTRACT STOPPED CLASS_EX 00:00:00 01:32:16
EXTRACT STOPPED CLASS_PU 00:00:00 01:32:11
EXTRACT STOPPED EFORMAT 00:00:00 56:38:27
EXTRACT STOPPED EGGTEST1 00:00:00 07:35:31
EXTRACT STOPPED EOLTP01 00:00:00 60:55:31
EXTRACT STOPPED EPUMP01 00:00:00 60:55:30
EXTRACT STOPPED HREXT 00:00:09 60:55:47
EXTRACT STOPPED HRPUMP 00:00:00 60:55:47
EXTRACT STOPPED MYDP1 00:00:00 60:56:07
EXTRACT STOPPED MYEXT1 00:00:02 60:56:06
EXTRACT STOPPED PGGTEST1 00:00:00 07:35:30
GGSCI (node1) 4> start mgr
Manager started.
GGSCI (node1) 5> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT STOPPED CLASS_EX 00:00:00 01:32:32
EXTRACT STOPPED CLASS_PU 00:00:00 01:32:27
EXTRACT STOPPED EFORMAT 00:00:00 56:38:43
EXTRACT STOPPED EGGTEST1 00:00:00 07:35:47
EXTRACT STOPPED EOLTP01 00:00:00 60:55:48
EXTRACT STOPPED EPUMP01 00:00:00 60:55:46
EXTRACT STOPPED HREXT 00:00:09 60:56:03
EXTRACT STOPPED HRPUMP 00:00:00 60:56:03
EXTRACT STOPPED MYDP1 00:00:00 60:56:23
EXTRACT STOPPED MYEXT1 00:00:02 60:56:22
EXTRACT STOPPED PGGTEST1 00:00:00 07:35:46
GGSCI (node1) 6> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT STOPPED CLASS_EX 00:00:00 01:33:11
EXTRACT STOPPED CLASS_PU 00:00:00 01:33:06
EXTRACT STOPPED EFORMAT 00:00:00 56:39:22
EXTRACT STOPPED EGGTEST1 00:00:00 07:36:26
EXTRACT STOPPED EOLTP01 00:00:00 60:56:26
EXTRACT STOPPED EPUMP01 00:00:00 60:56:25
EXTRACT STOPPED HREXT 00:00:09 60:56:42
EXTRACT STOPPED HRPUMP 00:00:00 60:56:42
EXTRACT STOPPED MYDP1 00:00:00 60:57:02
EXTRACT STOPPED MYEXT1 00:00:02 60:57:01
EXTRACT STOPPED PGGTEST1 00:00:00 07:36:25
GGSCI (node1) 7> start jagent
Sending START request to MANAGER ...
GGCMD JAGENT starting
GGSCI (node1) 8> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
JAGENT RUNNING
EXTRACT STOPPED CLASS_EX 00:00:00 01:33:16
EXTRACT STOPPED CLASS_PU 00:00:00 01:33:10
EXTRACT STOPPED EFORMAT 00:00:00 56:39:26
EXTRACT STOPPED EGGTEST1 00:00:00 07:36:31
EXTRACT STOPPED EOLTP01 00:00:00 60:56:31
EXTRACT STOPPED EPUMP01 00:00:00 60:56:29
EXTRACT STOPPED HREXT 00:00:09 60:56:47
EXTRACT STOPPED HRPUMP 00:00:00 60:56:47
EXTRACT STOPPED MYDP1 00:00:00 60:57:06
EXTRACT STOPPED MYEXT1 00:00:02 60:57:05
EXTRACT STOPPED PGGTEST1 00:00:00 07:36:30
GGSCI (node1) 9>
2016-08-21 12:38:20INFO OGG-00978Oracle GoldenGate Command Tool for Oracle, jagent.prm:GGCMD JAGENT is running.
2016-08-21 12:38:20INFO OGG-01927Oracle GoldenGate Command Tool for Oracle, jagent.prm:Child process started, process ID 4207, command line '/usr/java/jdk1.8.0_73/bin/java -Dconfig.dir=/u01/goldengate/oggmon/agent1/cfg -Djava.util.logging.config.class=oracle.core.ojdl.logging.LoggingConfiguration -Doracle.core.ojdl.logging.config.file=/u01/goldengate/oggmon/agent1/cfg/logging-config.xml -Doracle.core.ojdl.logging.componentId=JAGENT -jar -Xms512m -Xmx1024m /u01/goldengate/oggmon/oggmon/ogg_agent/dirjar/jagent.jar'.
2016-08-21 12:38:24INFO OGG-01928Oracle GoldenGate Command Tool for Oracle, jagent.prm:Child process terminated successfully.
2016-08-21 12:38:24INFO OGG-00979Oracle GoldenGate Command Tool for Oracle, jagent.prm:GGCMD JAGENT is down (gracefully).
2016-08-21 12:38:25INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oracle): info all.
iTT2000001,0] Error Initializing JAgent. JAgent will not be initialized and about to return. , [[
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'agentBootstrapper': Injection of resource dependencies failed; nested e
xception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mBeansContainer': Injection of resource dependencies failed
; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'notificationSender': Injection of resource depend
encies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'agentInfo': Invocation of init metho
d failed; nested exception is java.lang.Exception: One ore more Java Agent properties in Config.properties file are not defined properly. Check ggserr.log file
for more detail. Correct the error in the Config.properties file and restart the Manager.
at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:307)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1185)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:703)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:760)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83)
at com.goldengate.monitor.jagent.JAgentWSMain.initContext(JAgentWSMain.java:166)
at com.goldengate.monitor.jagent.JAgentWSMain.main(JAgentWSMain.java:102)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'mBeansContainer': Injection of resource dependencies failed;
nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'notificationSender': Injection of resource depende
ncies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'agentInfo': Invocation of init method
failed; nested exception is java.lang.Exception: One ore more Java Agent properties in Config.properties file are not defined properly. Check ggserr.log file
for more detail. Correct the error in the Config.properties file and restart the Manager.
at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:307)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1185)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)
at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:445)
at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:419)
at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:
处理：
GGSCI (node2) 5> stop mgr
Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)?y
Sending STOP request to MANAGER ...
Request processed.
Manager stopped.
GGSCI (node2) 6> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER STOPPED
JAGENT STOPPED
REPLICAT STOPPED CLASS_RE 00:00:00 02:36:00
REPLICAT STOPPED HRREP 00:00:00 61:59:07
REPLICAT STOPPED REP1 00:00:00 61:59:05
REPLICAT STOPPED RGGTEST1 00:00:00 08:39:50
GGSCI (node2) 7> delete datastore
Are you sure you want to delete the datastore? y
2016-08-21T17:12:44ZINFO OGG-06492Datastore deleted
GGSCI (node2) 8> exit
$ cd oggmon/bin
-bash: cd: oggmon/bin: No such file or directory
$ cd oggmon/agent1/bin
$ ls
displayMonitorAgentVersion.shpw_agent_util.shstartMonitorAgentInstance_abc.sh
$ ./pw_agent_util.sh -jagentonly
Wallet is already created. Please use either -updateAgentJMX or -updateServerJMX to update existing passwords.
$ ./pw_agent_util.sh -updateAgentJMX
Please enter new password for Java Agent:
Please confirm password for Java Agent:
Aug 21, 2016 1:13:59 PM oracle.security.jps.JpsStartup start
INFO: Jps initializing.
Aug 21, 2016 1:14:00 PM oracle.security.jps.JpsStartup start
INFO: Jps started.
Password for Java Agent is updated successfully.
$ ./pw_agent_util.sh -updateServerJMX
Please enter Monitor Server JMX password:
Please confirm Monitor Server JMX password:
Aug 21, 2016 1:14:17 PM oracle.security.jps.JpsStartup start
INFO: Jps initializing.
Aug 21, 2016 1:14:18 PM oracle.security.jps.JpsStartup start
INFO: Jps started.
Monitor Server JMX password is updated successfully.
$ cd $GGHOME
$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (node2) 1> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER STOPPED
JAGENT STOPPED
REPLICAT STOPPED CLASS_RE 00:00:00 02:37:50
REPLICAT STOPPED HRREP 00:00:00 62:00:57
REPLICAT STOPPED REP1 00:00:00 62:00:55
REPLICAT STOPPED RGGTEST1 00:00:00 08:41:40
GGSCI (node2) 2> start mgr
Manager started.
GGSCI (node2) 3> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
REPLICAT STOPPED CLASS_RE 00:00:00 02:37:54
REPLICAT STOPPED HRREP 00:00:00 62:01:01
REPLICAT STOPPED REP1 00:00:00 62:00:59
REPLICAT STOPPED RGGTEST1 00:00:00 08:41:44
GGSCI (node2) 4> start jagent
Sending START request to MANAGER ...
GGCMD JAGENT starting
GGSCI (node2) 5> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
JAGENT RUNNING
REPLICAT STOPPED CLASS_RE 00:00:00 02:37:59
REPLICAT STOPPED HRREP 00:00:00 62:01:06
REPLICAT STOPPED REP1 00:00:00 62:01:04
REPLICAT STOPPED RGGTEST1 00:00:00 08:41:49
GGSCI (node2) 6> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
JAGENT RUNNING
REPLICAT STOPPED CLASS_RE 00:00:00 02:38:02
REPLICAT STOPPED HRREP 00:00:00 62:01:09
REPLICAT STOPPED REP1 00:00:00 62:01:07
REPLICAT STOPPED RGGTEST1 00:00:00 08:41:51
GGSCI (node2) 7> info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
JAGENT RUNNING
REPLICAT STOPPED CLASS_RE 00:00:00 02:38:04
REPLICAT STOPPED HRREP 00:00:00 62:01:11
REPLICAT STOPPED REP1 00:00:00 62:01:09
REPLICAT STOPPED RGGTEST1 00:00:00 08:41:54
GGSCI (node2) 8>
问题：
t what you want.
Property {} is not defined.,jagent.backward.compatibility
Metadata initialized
Runtime exception starting jAgent Server. Jagent Host=node1, Jagent JMX Port=5555, Jagent Config Dir=/u01/goldengate/oggmon/agent1/cfg, Monitor Host=ogg-studio, Monitor Port=5559, [[
java.lang.NullPointerException
at com.goldengate.monitor.jagent.config.impl.AgentInfoImpl.isSslFlag(AgentInfoImpl.java:762)
at com.goldengate.monitor.jagent.jmx.JAgentRmiJmxFactory.isSslFlag(JAgentRmiJmxFactory.java:64)
at com.goldengate.monitor.jagent.jmx.JAgentRmiJmxFactory.isSslFlag(JAgentRmiJmxFactory.java:26)
at com.goldengate.monitor.jmx.impl.AbstractJmxFactoryAdapter.startNewJmxServer(AbstractJmxFactoryAdapter.java:59)
at com.goldengate.monitor.jagent.jmx.MBeansContainerImpl.startServer(MBeansContainerImpl.java:810)
at com.goldengate.monitor.jagent.JAgentBootstrapper.init(JAgentBootstrapper.java:73)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleElement.invoke(InitDestroyAnnotationBeanPostProcessor.java:349)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor$LifecycleMetadata.invokeInitMethods(InitDestroyAnnotationBeanPostProcessor.java:300)
at org.springframework.beans.factory.annotation.InitDestroyAnnotationBeanPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProcessor.java:133)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:407)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1545)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:703)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:760)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83)
at com.goldengate.monitor.jagent.JAgentWSMain.initContext(JAgentWSMain.java:166)
at com.goldengate.monitor.jagent.JAgentWSMain.main(JAgentWSMain.java:102)
处理
jagent.backward.compatibility=true
问题：
ogg studio 添加ogg instance connection 测试时报错如下：
oracle.oggstudio.deploy.exception.ConnectionException: GGSTU-60006: Unable to connect to OGG Instance.
java.lang.SecurityException: Authentication failed. Invalid username/password.
at oracle.oggstudio.deploy.OggJagentInteraction.openConnection(OggJagentInteraction.java:172)
at oracle.oggstudio.deploy.DeploymentService.testOgg(DeploymentService.java:1034)
at oracle.oggstudio.resources.navigator.ogginstance.dialogs.OggInstanceWizardModel.executeTestOgg(OggInstanceWizardModel.java:399)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at oracle.cef.ui.component.model.binder.ModelActionBinder.execute(ModelActionBinder.java:60)
at oracle.cef.ui.component.Button$1.performAction(Button.java:104)
at oracle.cef.ui.component.listener.AbsSafeActionListener.actionPerformed(AbsSafeActionListener.java:70)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6535)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6300)
at java.awt.Container.processEvent(Container.java:2236)
at java.awt.Component.dispatchEventImpl(Component.java:4891)
at java.awt.Container.dispatchEventImpl(Container.java:2294)
at java.awt.Component.dispatchEvent(Component.java:4713)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
at java.awt.Container.dispatchEventImpl(Container.java:2280)
at java.awt.Window.dispatchEventImpl(Window.java:2750)
at java.awt.Component.dispatchEvent(Component.java:4713)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.awt.EventQueue$4.run(EventQueue.java:729)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)
at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:109)
at java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:184)
at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:229)
at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:227)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:227)
at java.awt.Dialog.show(Dialog.java:1084)
at java.awt.Component.show(Component.java:1673)
at java.awt.Component.setVisible(Component.java:1625)
at java.awt.Window.setVisible(Window.java:1014)
at java.awt.Dialog.setVisible(Dialog.java:1005)
at oracle.bali.ewt.wizard.WizardDialog.runDialog(WizardDialog.java:382)
at oracle.bali.ewt.wizard.WizardDialog.runDialog(WizardDialog.java:298)
at oracle.cef.ui.adapter.WizardAdapterImpl.displayWizard(WizardAdapterImpl.java:89)
at oracle.cef.ui.Framework.displayWizard(Framework.java:270)
at oracle.oggstudio.resources.navigator.ogginstance.dialogs.OggInstanceWizard.invoke(OggInstanceWizard.java:58)
at oracle.jdeveloper.rescat2.model.util.ConnectionUtil.showWizard(ConnectionUtil.java:91)
at oracle.jdeveloper.rescat2.model.util.ConnectionUtil.showWizard(ConnectionUtil.java:68)
at oracle.jdeveloper.rescat2.model.nodes.RepositoryRootNode.whenProperties(RepositoryRootNode.java:246)
at oracle.jdevimpl.rescat2.ResCatControllerImpl.onProperties(ResCatControllerImpl.java:631)
at oracle.jdevimpl.rescat2.ResCatControllerImpl.propertiesEventHandled(ResCatControllerImpl.java:274)
at oracle.jdevimpl.rescat2.ResCatControllerImpl.handleEvent(ResCatControllerImpl.java:234)
at oracle.jdeveloper.rescat2.dockable.AbstractBaseTreeView$ControllerImpl.handleEvent(AbstractBaseTreeView.java:118)
at oracle.jdeveloper.rescat2.dockable.AbstractConnView$ControllerImpl.handleEvent(AbstractConnView.java:35)
at oracle.ide.controller.IdeAction.performAction(IdeAction.java:663)
at oracle.ide.controller.IdeAction.actionPerformedImpl(IdeAction.java:1155)
at oracle.ide.controller.IdeAction.actionPerformed(IdeAction.java:618)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.AbstractButton.doClick(AbstractButton.java:376)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:833)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:877)
at java.awt.Component.processMouseEvent(Component.java:6535)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6300)
at java.awt.Container.processEvent(Container.java:2236)
at java.awt.Component.dispatchEventImpl(Component.java:4891)
at java.awt.Container.dispatchEventImpl(Container.java:2294)
at java.awt.Component.dispatchEvent(Component.java:4713)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
at java.awt.Container.dispatchEventImpl(Container.java:2280)
at java.awt.Window.dispatchEventImpl(Window.java:2750)
at java.awt.Component.dispatchEvent(Component.java:4713)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.awt.EventQueue$4.run(EventQueue.java:729)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)
at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
处理：
调整
[$ more Config.properties
jagent.host = node1
jagent.jmx.port = 5555
interval.regular = 60
interval.quick = 30
monitor.host = ogg-studio
jagent.rmi.port = 5559
agent.type.enabled = OGGMON ---------此处调整为OEM
jagent.username=oggmsjmxusr
monitor.jmx.username=oggmajmxusr
jagent.backward.compatibility=true
重启jagent ,问题解决
页:
[1]