Every once in awhile I do something in my test environments to test something else, then I go back to test core functions of the product; in this case I was testing a feature of Oracle GoldenGate 12c. Earlier in the day, I had set the $ORACLE_HOME enviornment variable to reference the Oracle GoldenGate home. Instead of closing my session and restarting, I just started GGSCI and the associated manager. To my surprise, the extracts (more...)
Recently on I was strolling the OTN message boards and came across a question about identifying the version of Oracle GoldenGate using OPatch. This was the second time I came across this question; with that I decided to take a look and see if Oracle GoldenGate information could be retrieved using opatch.
Initially I thought that identifing the Oracle GoldenGate version could only be done by logging into GGSCI and reviewing the header information. To (more...)
Ok Folks, I’ve been here are Oracle Open World for a few days now. In that time, I’ve had numerous conversations about running Oracle Enterprise Manager 12c on Oracle Database 12c. I will be honest and say that I’ve enjoyed these conversations; however, after about the fourth time I decided I need to write a quick post on the explanation discussed in these conversations.
Early this year (August) I wrote a post about the (more...)
This week I’ve been enjoying spending some time at Oracle Open World in San Francisco, CA. While here, I’ve been talking with everyone, friends old and new, and it came to my attention that it would be a good idea to have some useful templates for Oracle GoldenGate parameter files. With this in mind, I decided to create some generic templates with comments for Oracle GoldenGate processes. These templates can be found on my Scripts (more...)
When I normally start work on a new EM 12c environment, I would request to have a userid created; however, I don’t have a userid in this environment and I need access EM 12c as SYSMAN. Without knowing the password for SYSMAN, how can I access the EM 12c interface? The short answer is that I can change the SYSMAN password from the OS where EM 12c is running.
Before changing the SYSMAN password (more...)
One question I get asked a lot is “how can I add additional agent software to OEM 12c”? The answer is pretty easy; just download and apply to the software library. Now what does that mean? In this post, I’ll explain how to download additional agents for later deployments to other platforms.
After logging into OEM 12c, go to the Setup -> Extensibility -> Self Update (Image 1).
Last year, I wrote a post on how to setup Oracle Enterprise Manger 12c (220.127.116.11) with Oracle Database 12c (18.104.22.168) and what you could expect. At the time the configuration was not supported by Oracle and I only did it to see if it could be done. If you would like to read that post it can be found here.
This past May (2014), I attended the Oracle Customer (more...)
This year I’ll be presenting at Oracle Open World with many of the best in the industry. If you are going to be in the San Francisco area between September 28 thru October 2 2014, stop by and check out the conference. Registration information can be found here.
The topics which I’ll be presenting or assisting with this year are:
- OTN RAC Attack – Sunday, September 28, 2014 – 9 am – 3 pm PST (more...)
Over the last two weeks I’ve been working on a heartbeat monitoring solution for a client. This is not the normal heartbeat solution provided by Oracle as described in note 1299679.1; yet very similar. The approach that I configured is similar to a traditional heartbeat setup but uses the same extract and replicats already being used by the database/application. For simplicity reasons, I like to call this approach an Integrated Application Heartbeat.
In order (more...)
Normally, I don’t mind errors when I’m working with Oracle GoldenGate (OGG); I actually like getting errors, keeps me on my toes and gives me something to solve. Clients on the other hand do not like errors…LOL. Solving errors in OGG is normally pretty straight forward with the help of the documentation. Although today I can almost disagree with the docs.
Today, as I’ve been working on implementing a solution with OGG 11.1.x (more...)