Oracle® GoldenGate(OGG) 모니터 에이전트(또는 jagent)는 인스턴스에 대한 정보를 수집하고 이를 Oracle GoldenGate용 Oracle GoldenGate 모니터 서버 및 Enterprise Manager 플러그인으로 보냅니다. 이번 포스트에서는 OGG 12c jagent를 업그레이드 하는 방법을 보여드리겠습니다.
기존 OGG 12c jagent 설치 및 업그레이드
-
V44427-01.zip 압축을 풉니다. , 출력 파일 fmw_12.1.3.0.0_ogg.jar을 생성합니다. .
-rwxr-xr-x 1 oracle oinstall 435392820 Jun 18 2014 fmw_12.1.3.0.0_ogg.jar -
$JAVA_HOME 확인 및 $JAVA_HOME/bin 다음 명령을 실행하여 Java 버전이 1.7 이상인지 올바르게 설정되었는지 확인하십시오.
/nbcogg/goldengate <s0931> java -version java version "1.8.0_45" Java(TM) SE Runtime Environment (build 1.8.0_45-b14) Java HotSpot(TM) 64-Bit Server VM (build 25.45-b02, mixed mode) /nbcogg/goldengate <s0931> -
Oracle Universal Installer(OUI) 설치 프로그램을 시작하려면 다음 Java 명령을 실행하십시오.
/nbcogg/goldengate <s0931> java -jar -Xmx1024m /nbcogg/goldengate/fmw_12.1.3.0.0_ogg.jar Launcher log file is /var/tmp/OraInstall2015-07-08_08-17-57AM/launcher2015-07-08_08-17-57AM.log. Extracting files.................................................... Starting Oracle Universal Installer
다음 스크린샷은 OUI를 보여줍니다.
이 단계에서 Oracle 홈 디렉토리의 위치를 지정해야 합니다.
Oracle GoldenGate Monitor Agent를 선택하고 다음을 클릭합니다. :
특정 운영 체제 전제 조건을 확인하십시오.
다음 스크린샷은 설치를 위한 기능 목록과 사용된 디스크 공간을 보여줍니다.
다음 스크린샷은 설치 진행 상황을 추적합니다.
설치가 완료되면 다음 메시지가 표시됩니다.
설치 후 단계
-
다음 명령을 실행하여 jagent를 중지하십시오.
/testogg<s0931> ./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 11.2.1.0.17 17888650 OGGCORE_11.2.1.0.0OGGBP_PLATFORMS_131215.2328_FBO Solaris, sparc, 64bit (optimized), Oracle 11g on Dec 16 2013 16:59:28 Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved. GGSCI (oracle.test.com) 1> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING JAGENT STOPPED EXTRACT RUNNING ETKX01 00:00:00 00:00:01 EXTRACT RUNNING EXTTK01 00:00:00 00:00:06 EXTRACT RUNNING PMPTK01 00:00:00 00:00:07 EXTRACT RUNNING PTKX01 00:00:00 00:00:05 -rwxr-x--- 1 oracle oinstall 152 Jan 8 2014 create_ogg_agent_instance.sh /testogg<s0931> ps -ef |grep jagent oracle 8880 871 0 08:33:42 pts/1 0:00 grep jagent
참고 :kill -9 사용 실행 중인 모든 길잃은 jagent 프로세스를 중지하는 명령입니다.
다음 명령을 실행하여 ogg 에이전트 생성 스크립트를 실행하여 인스턴스를 생성합니다.
/nbcogg/goldengate/GoldenGate/oggmon/ogg_agent <s0931> ./create_ogg_agent_instance.sh
Please enter absolute path of Oracle GoldenGate home directory : /testogg
Please enter absolute path of OGG Agent instance : /testogg
OGG Agent instance directory already exists, do you want to overwrite the contents (yes | no) : yes
Sucessfully created OGG Agent instance.
/nbcogg/goldengate/GoldenGate/oggmon/ogg_agent <s0931>
/testogg/dirjar <s0931> ls -lart *jagent.jar*
-rw-r----- 1 oracle oinstall 255338 Dec 16 2013 jagent.jar
/testogg/dirjar <s0931>
/testogg/cfg <s0931> vi Config.properties
####################################################################
## jagent backward compatibility ###
####################################################################
jagent.backward.compatibility=false
####################################################################
## jagent SSL Enabled property ###
####################################################################
jagent.ssl=false
다음 명령을 실행하여 모든 서비스를 중지합니다.
GGSCI (oracle.test.com) 4> stop ETKX01
Sending STOP request to EXTRACT ETKX01 ...
Request processed.
GGSCI (oracle.test.com) 5> stop EXTTK01
Sending STOP request to EXTRACT EXTTK01 ...
Request processed.
GGSCI (oracle.test.com) 6> stop PMPTK01
Sending STOP request to EXTRACT PMPTK01 ...
Request processed.
GGSCI (oracle.test.com) 7> stop PTKX01
Sending STOP request to EXTRACT PTKX01 ...
Request processed.
GGSCI (oracle.test.com) 8> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER STOPPED
JAGENT STOPPED
EXTRACT STOPPED ETKX01 00:00:00 00:00:18
EXTRACT STOPPED EXTTK01 00:00:00 00:00:13
EXTRACT STOPPED PMPTK01 00:00:00 00:00:08
EXTRACT STOPPED PTKX01 00:00:00 00:00:04
다음 명령을 실행하여 서비스를 시작하고 유효성을 검사하십시오.
참고 :서비스를 여러 번 검증하면 jagent 상태가 중지됨으로 표시됩니다. 이 문제를 해결하려면 구성 속성을 약간 변경해야 합니다.
GGSCI (oracle.test.com) 17> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
JAGENT RUNNING
EXTRACT RUNNING ETKX01 00:00:00 00:00:04
EXTRACT RUNNING EXTTK01 00:00:00 00:00:01
EXTRACT RUNNING PMPTK01 00:00:00 00:00:05
EXTRACT RUNNING PTKX01 00:00:00 00:00:05
GGSCI (oracle.test.com) 18> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
JAGENT STOPPED
EXTRACT RUNNING ETKX01 00:00:00 00:00:08
EXTRACT RUNNING EXTTK01 00:00:00 00:00:04
EXTRACT RUNNING PMPTK01 00:00:00 00:00:08
EXTRACT RUNNING PTKX01 00:00:00 00:00:08
-
jagent 로그에서 오류를 보려면 다음 명령을 실행하십시오.
/testogg/logs <s0931> more ogg_agent.log [2015-07-08T08:48:12.305-07:00] [JAGENT] [NOTIFICATION] [OGGMON-20244] [com.goldengate.monitor.jagent.JAgentWSMain] [tid: main] [ecid: 0000KtiM_kHESOsDCjCCwg1LbKOw000001,0] About to call initialize on the WebService [2015-07-08T08:48:12.475-07:00] [JAGENT] [NOTIFICATION] [OGGMON-20245] [com.goldengate.monitor.jagent.JAgentWSMain] [tid: main] [ecid: 0000KtiM_kHESOsDCjCCwg1LbKOw000001,0] Loading agent-spring-ws.xml ############### [2015-07-08T08:48:15.086-07:00] [JAGENT] [NOTIFICATION] [OGGMON-20593] [com.goldengate.monitor.jagent.config.impl.ConfigFilesHelper] [tid: main] [ecid: 0000KtiM_kHESOsDCjCCwg1LbKOw000001,0] JAgent config.dir system property is set, and the configuration is pointed to /export/home/oracle/testogg/cfg location. [2015-07-08T08:48:15.088-07:00] [JAGENT] [NOTIFICATION] [OGGMON-20594] [com.goldengate.monitor.jagent.config.impl.ConfigFilesHelper] [tid: main] [ecid: 0000KtiM_kHESOsDCjCCwg1LbKOw000001,0] JAgent configuration of checkpoint file absolute path: /export/home/oracle/testogg/cfg/../dirchk/agent.cpm [2015-07-08T08:48:15.088-07:00] [JAGENT] [NOTIFICATION] [OGGMON-20595] [com.goldengate.monitor.jagent.config.impl.ConfigFilesHelper] [tid: main] [ecid: 0000KtiM_kHESOsDCjCCwg1LbKOw000001,0] JAgent default configuration of checkpoint file absolute path: /export/home/oracle/testogg/cfg/../cfg/agent.cpm [2015-07-08T08:48:15.097-07:00] [JAGENT] [NOTIFICATION] [OGGMON-20028] [com.goldengate.monitor.jagent.config.impl.AgentInfoImpl] [tid: main] [ecid: 0000KtiM_kHESOsDCjCCwg1LbKOw000001,0] Using IP address 3.156.4.153 to connect to the Manager Web Service [2015-07-08T08:48:15.099-07:00] [JAGENT] [NOTIFICATION] [OGGMON-20029] [com.goldengate.monitor.jagent.config.impl.AgentInfoImpl] [tid: main] [ecid: 0000KtiM_kHESOsDCjCCwg1LbKOw000001,0] Reading Manager port 7810 from mgr.prm file. [2015-07-08T08:48:17.361-07:00] [JAGENT] [ERROR] [OGGMON-20016] [com.goldengate.monitor.jagent.config.impl.AgentInfoImpl] [tid: main] [ecid: 0000KtiM_kHESOsDCjCCwg1LbKOw000001,0] Monitor Server JMX password is not defined. Please run Wallet Utility to create Monitor Server JMX password. [2015-07-08T08:48:17.372-07:00] [JAGENT] [NOTIFICATION] [OGGMON-20247] [com.goldengate.monitor.jagent.JAgentWSMain] [tid: main] [ecid: 0000KtiM_kHESOsDCjCCwg1LbKOw000001,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 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. -
OEM의 경우 /export/home/oracle/testogg/cfg/Config.properties 업데이트 ,
agent.type.enabled=OGGMON변경agent.type.enabled=OEM으로 . -
완료한 후 관리자를 다시 시작하고 모든 서비스의 유효성을 검사하십시오. 정상적으로 시작되고 실행되어야 합니다.
GGSCI (oracle.test.com) 6> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING JAGENT RUNNING EXTRACT RUNNING ETKX01 00:00:00 00:00:02 EXTRACT RUNNING EXTTK01 00:00:00 00:00:01 EXTRACT RUNNING PMPTK01 00:00:00 00:00:04 EXTRACT RUNNING PTKX01 00:00:00 00:00:04
결론
이전 단계를 따르면 Oracle이 권장하는 OGG 모니터 에이전트를 쉽게 업그레이드할 수 있습니다. 이 프로세스는 업그레이드를 완료하는 가장 쉽고 가장 좋은 방법입니다.
피드백 탭을 사용하여 의견을 작성하거나 질문하십시오. 저희와 대화를 시작할 수도 있습니다.