In a few weeks I’ll be talking about monitoring Oracle GoldenGolden using Oracle Enterprise Manager 12c at IOUG Collaborate in Las Vegas. This is one of the few presentations I will be giving that week (going to be a busy week). Although this posting, kinda mirrors a previous post on how to configure the Oracle GoldenGate JAgent, it is relevant because:
1. Oracle changed the name of the JAgent to Oracle Monitor Agent
2. Steps (more...)
In an earlier post, I mentioned that Oracle has finally, offcially supported the Oracle Management Repository (OMR) on Database 12c (22.214.171.124). As I’ve been working on a DBaaS project, I built a new Oracle Enterprise Manager (OEM) enivornment to test out a few things. Since I was rebuilding, I decided to try out the PDB as an OMR (afterall I’ve been asking about this approach). In the past, installation would fail around (more...)
Last October (2014), at Oracle Open World 2014, I posted about a discussion where there was confusion on if Oracle Database 12c was supported as the Oracle Management Repository (OMR). At the time, Oracle had put a temporary suspension on support for the OMR running on Oracle Database 12c.
Over the last week or so, in discussions with some friends I heard that there may be an announcement on this topic soon. As of (more...)
Ever get tired of typing commands? Ever wish there was a way to recall commands from GGSCI? Well, you are in luck! There are two ways this can be done (listed below).
2. ! (command)
The first option, History, is a command that allows you to view a list of the most recent commands executed in the GGSCI interface since the session started.
GGSCI Command History
With Oracle “merging” Oracle GoldenGate into Oracle Streams (or vise-versa), capturing statitics on the intergrated extract (capture) or integrated replicat (happy) will be needed. In order to do this, the Streams Performance Advisor (UTL_SPADV) can be used. Before using the Stream Performance Advisor, it needs to be configured under the Streams Administrator, i.e. Oracle GoldenGate user. In my test lab, I use a user named GGATE for all my Oracle GoldenGate work.
The replicat process is the apply process within the Oracle GoldenGate environment. The replicat is responsible for reading the remote trail files and applying the data found in cronilogical order. This ensures that the data is applied in the same order it was captured.
Until recently there was only one version of a replicat, that version was the classic version. As of 126.96.36.199, there are now three distinct versions of a (more...)
The Data Pump group is an secondary extract group that is used to help send data over a network. Although a data pump is another extract group, don’t confuse it with the primary extrat group. The main purpose of the data pump extract is to write the captured data over the network to the remote trail files on the target system.
Note: if the data pump is not confgured then the primary extract group (more...)
The extract process of Oracle GoldenGate is used to perform change data capture from the source database. The extract can be used to read the online transaction log (in Oracle the online redo logs) or the associated archive logs. The data that is extracted from the source database is then placed into an trail file (another topic for a post) for shipping to the apply sided.
To configure an extract process there needs to (more...)
Oracle GoldenGate is made up of processes that are used to ensure replication. These processes include a manager process, an extract and a replicat process. The primise of this post is to focus on the manager process.
In order to configure and run an Oracle GoldenGate enviornment, a manager process must be running on all the source, target, and intermediary servers in the configuration. This is due to the manager process being the controller process (more...)
There are many different ways of monitoirng Oracle GoldenGate; I have posted about many of these in earlier blog posts. Additionally, I have talked about the different ways of monitoring Oracle GoldenGate at a few conferences as well. (The slides can be found on my slideshare site if wanted). In both my blog and presentations I highlight many different approaches; yet I forgot one that I think is really cool! This one was shown to (more...)
In order to upgrade out OEM environment from 188.8.131.52 to 184.108.40.206 we need to download the latest version of OEM from either http://otn.oracle.com or from http://edelivery.oracle.com. Once we have the files needed to upgrade, we need to stage them in (more…)