While working with a customer this week, they were testing some audit functionality on the database. The database version being tested was Oracle 11g (11.2.0.3.5). When the user created a table, the entry in the SYS.AUD$ is registered as … [Read more...]
Installing Oracle GoldenGate 12c (12.1.2) along side Oracle Database 12c (12.1.0.1)
With the announcement of Oracle Golden Gate 12c, there comes a few new features that everyone is going to explore. One new feature is the new way of installing Oracle Golden Gate. In the past, the installation was simple. Just copy … [Read more...]
Oracle GoldenGate 12c (12.1.2) released – Finally!!!!
Back in June, Oracle released Oracle Database 12c and everyone went nuts trying to download and start documenting the many new features. One of the items within the 12c (database) release that I was curious about was how is Oracle Golden Gate … [Read more...]
Add database to Oracle Restart
With Oracle Real Application Clusters the Oracle database can be configured to restart as each node in the cluster is restarted. For single instance databases that are on a standalone server, often times the database is not configured to … [Read more...]
GoldenGate monitoring–command line
Over the last few years I’ve been working with Oracle Golden Gate (OGG) and the one thing that is an interesting topic with OGG is what is the best way to monitor the environment. To be honest, there are a few different ways to monitor OGG; yet … [Read more...]