Over the last few months, I’ve been working a project where I’ve started to dive into EM CLI and the value that EM CLI brings to cutting down on doing things like creating Enterprise Manager users. Hence the reason for this post.
This post is meant to be more of a note for me to refer to later, but it is also good to share knowledge so here you go.
Note: Hostnames are blacked out for a reason. Commands are the same though.
Recently, I just installed an em agent using the silent install method I blogged about earlier (here). After installing the agent, everything was working fine and the agent could upload to the (more...)
The Oracle Database Appliance (ODA) has been around for a few years now. It is a great, compact, and powerful machine for running at two-node Oracle Real Application Cluster (RAC). The adoption of the ODA has been mostly seen in medium sized organizations that need a work horse but cannot afford the sticker price of an Oracle Exadata.
Just like all the appliances that Oracle puts out, there is a need to monitor these appliances (more...)
Like many other Oracle professionals and speakers I will be attending IOUG Collaborate 2015 this year in Las Vegas. I’m not a big fan of Las Vegas, but hey cannot turn down an opportunity to speak, especially when IOUG asked me to do more than one session.
This year my schedule is going to keep me busy; yet full of good topics that cover both EM12c and GoldenGate. If you are going to be (more...)
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 (18.104.22.168). 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.
Configure user (more...)
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 22.214.171.124, there are now three distinct versions of a (more...)