deploying the oracle goldengate plug-in on oem 12c...
TRANSCRIPT
![Page 1: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/1.jpg)
This note describes the procedure of implementing the GoldenGate plug-in for Oracle Cloud Control 12c.
These versions are required for installing the plug-in:
Enterprise Manager Cloud Control 12c Bundle Patch 1 (12.1.0.1) and later Oracle GoldenGate 11g Release 2 (11.2.1.0.1) and later
Install Java 1.6 (or later) JDK on the servers where the GoldenGate instances will be running.
Set the JAVA_HOME variable to the location of the JDK installation and ensure that the PATH variable includes the $JAVA_HOME/jre/bin/server directory location.
For example:
$ export JAVA_HOME=/home/oracle/jdk1.6.0_38
Create the Oracle Wallet
Add the password that the Oracle Management Agent will use to connect to the Oracle GoldenGate agent .
Navigate to the Oracle GoldenGate installation directory and run the pw_agent_util.sh script
This command specifies that we will be using the Java Agent (JAgent) and not the Oracle GoldenGate Monitor Server
[oracle@kens-racnode1 goldengate]$ ./pw_agent_util.sh -jagentonlyPlease create a password for Java Agent:Please confirm password for Java Agent:Wallet is created successfully.
Configure the GoldenGate instance for OEM 12c
Navigate to the Oracle GoldenGate installation directory
Edit the \cfg\Config.properties file.
![Page 2: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/2.jpg)
In our case we have changed these values:
agent.type.enabled=OEM
jagent.rmi.port=5559
jagent.host=kens-racnode-1jagent.jmx.port=5555jagent.username=oracle
Edit the GLOBALS file and add the parameter ENABLEMONITORING
edit params ./GLOBALS
GGSCHEMA ggs_ownerCHECKPOINTTABLE ggs_owner.chkptENABLEMONITORING
Stop and Start the Manager process
Create the Datastore
GGSCI (kens-racnode1) 1> CREATE DATASTOREDatastore created
Start the Oracle GoldenGate Agent:
GGSCI (kens-racnode1) 4> start jagent
GGCMD JAGENT started
Downloading and deploying the plug-in
![Page 3: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/3.jpg)
Navigation: Setup - Extensibility - Self Update
From the Type column select Plug-in
From the Plug-in Updates page we can see that an update for Oracle GoldenGate is available
![Page 4: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/4.jpg)
Select Oracle GoldenGate under the Plug-in Name column and click the Download button
After the download is completed, the status will change from Available to Downloaded
Navigation: Setup > Extensibility > Plug-ins
![Page 5: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/5.jpg)
We now have to deploy the plug-in first on the management server and then the servers where the management agents are running.
![Page 6: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/6.jpg)
![Page 7: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/7.jpg)
![Page 8: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/8.jpg)
![Page 9: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/9.jpg)
Note – deployment of the Plug-in on the OMS will close our session on the 12c OEM console and the OMS will be down briefly while the Plug-In is deployed.
![Page 10: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/10.jpg)
If we query the status of the OMS, we can see that it is showing that the management server is down while the Oracle GoldenGate 12.1.0.1.0 Plug-in is deployed.
![Page 11: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/11.jpg)
We can monitor the status of the deployment job via the command ‘emctl status oms –details’
We can see that the status of the job is Deploying and the stage at present is Configure Repository
![Page 12: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/12.jpg)
After the deployment job is complete, the OMS is started up again automatically.
![Page 13: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/13.jpg)
When we connect back to the OEM 12c and go to Plug-ins page, we can now see that the GoldenGate Plug-in has now been deployed on the OMS.
![Page 14: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/14.jpg)
The next step is to deploy the Plug-in on both the nodes of the RAC cluster where the GoldenGate instances are going to be running.
![Page 15: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/15.jpg)
![Page 16: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/16.jpg)
![Page 17: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/17.jpg)
![Page 18: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/18.jpg)
![Page 19: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/19.jpg)
![Page 20: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/20.jpg)
![Page 21: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/21.jpg)
We can now see that the Plug-in has been deployed on both the OMS as well as it is showing that there are 2 Management Agents where the Plug-in has been deployed.
![Page 22: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/22.jpg)
We can now see that under the Targets menu, a GoldenGate target is now visible.
![Page 23: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/23.jpg)
Navigation: Setup > Configure Auto Discovery > All Discovery Modules
![Page 24: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/24.jpg)
Select the Agent Host Name and click Run Discovery Now
![Page 25: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/25.jpg)
Select the Agent Host Name – in this case we select 2 hosts where GoldenGate instances will be running
We can see that it needs the parameters to be entered for the JAgent user name and password
![Page 26: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/26.jpg)
We provide the password for the JAgent and also enter the JAgent user name
![Page 27: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/27.jpg)
![Page 28: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/28.jpg)
We will now see two rows with the Target Type as Oracle GoldenGate
Select the Target Name and click on the Promote button
![Page 29: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/29.jpg)
![Page 30: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/30.jpg)
From the Targets menu, select GoldenGate and that will take us to the GoldenGate home page.
We can see the status of the processes as well as drill down and obtain further information.
![Page 31: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/31.jpg)
![Page 32: Deploying the Oracle GoldenGate Plug-in on OEM 12c …gavinsoorma.com/.../uploads/2013/04/GoldenGate-plug-in.docx · Web viewThis command specifies that we will be using the Java](https://reader031.vdocuments.us/reader031/viewer/2022030417/5aa32ab47f8b9a84398e0605/html5/thumbnails/32.jpg)