Using the GoldenGate Hub with Timezone differences

Deploying a GoldenGate Hub with Timezone differences requires attention to detail.  I ran into this problem several months ago where the timezone of the Server Farm was US Central Time and the timezone of the database being extracted from was in Pacific time.  This issue is that whenever I would look at the Extract [...]

By |2018-05-18T16:39:34+00:00April 17th, 2018|GoldenGate|Comments Off on Using the GoldenGate Hub with Timezone differences

Monitoring GoldenGate

Monitoring GoldenGate is one of the most commonly overlooked components of real-time data integration.   Running GoldenGate is frequently critical to an entities business operations. Identifying and responding to performance issues and outages can impact the bottom line of any organizations operations. How you handle errors will depend on what you are using GoldenGate [...]

By |2018-05-18T16:39:43+00:00April 17th, 2018|GoldenGate|Comments Off on Monitoring GoldenGate

Performance of the GoldenGate Hub Architecture

As a quick review, the GoldenGate Hub Architecture is an architecture where GoldenGate extracts and replicats run; extracting from and replicating to other servers.  The processing of GoldenGate is offloaded from the database servers.  Only the database portion of GoldenGate processing is running on the database servers. Those of you who have been using [...]

By |2018-05-18T16:39:52+00:00March 19th, 2018|GoldenGate|Comments Off on Performance of the GoldenGate Hub Architecture

Direct Path Reads in Oracle Database 11gR2 page 2

Direct Path Reads Solution Explained: So, how do you solve the “ direct path reads ” problem (where the same data is being constantly re-read from disk)?  There are a couple of suggestions. Put the table in question in the KEEP buffer cache.  This is a two-step process.  First allocate memory for the KEEP [...]

By |2018-05-18T16:40:00+00:00February 23rd, 2018|Database, Oracle|Comments Off on Direct Path Reads in Oracle Database 11gR2 page 2

Using the GoldenGate Hub Architecture

Using the GoldenGate Server Hub Architecture is almost identical to the local GoldenGate installation.  The GoldenGate Hub extracts and replicats are configured using the TNS string that you would use to connect to the source and target databases. Qualify for a FREE GoldenGate Health Check Here! I prefer to use the GoldenGate credential store [...]

By |2018-05-18T16:40:13+00:00February 17th, 2018|GoldenGate|Comments Off on Using the GoldenGate Hub Architecture

Move Oracle DB Audit Trails To A New Tablespace

There are times when it is necessary to move Oracle DB audit trails to a new table space.  Auditing is the monitoring and recording of selected user database actions. In standard auditing, you use initialization parameters and the AUDIT and NOAUDIT SQL statements to audit SQL statements, privileges, and schema objects, and network and [...]

By |2018-01-18T20:34:36+00:00January 18th, 2018|Database|Comments Off on Move Oracle DB Audit Trails To A New Tablespace

Configuring the Oracle GoldenGate Hub

Configuring the GoldenGate Hub is done in the same way you would configure GoldenGate in a stand-alone system, with the exception that only the Oracle Client pieces need be installed.  Once the Oracle Client software has been installed on the GoldenGate Hub, install GoldenGate as you would normally.  Point the Oracle Home location to [...]

By |2018-05-18T16:40:28+00:00January 7th, 2018|GoldenGate|Comments Off on Configuring the Oracle GoldenGate Hub

Overview of the Oracle GoldenGate Hub Architecture

The next few blogs will be related to the design, implantation and operation of the Oracle GoldenGate hub architecture.  The Oracle GoldenGate hub architecture is where Oracle GoldenGate is installed and configured on a different server from the database server.  This is not the same as downstream processing, since you are accessing the database [...]

By |2018-05-18T16:40:47+00:00December 17th, 2017|GoldenGate|Comments Off on Overview of the Oracle GoldenGate Hub Architecture

Move Oracle Database Audit Trails To A New Tablespace Continued

  Create a new tablespace and size it large enough to hold the audit data:   SQL> CREATE tablespace "SYSAUD" datafile size 1G autoextend on;   Tablespace created.     Move the audit trail tables using procedure DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION.   -- -- Move the SYS.AUD$ table -- SQL> exec DBMS_AUDIT_MGMT.set_audit_trail_location( audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_AUD_STD, audit_trail_location_value => [...]

By |2018-05-18T16:40:56+00:00November 9th, 2017|Database|Comments Off on Move Oracle Database Audit Trails To A New Tablespace Continued

Move Oracle Database Audit Trails To A New Tablespace

Move Oracle Database Audit Trails To A New Tablespace Auditing is the monitoring and recording of selected user database actions. For Oracle Database, the Oracle Database Audit Trails assist in the auditing process.  In standard auditing, you use initialization parameters and the AUDIT and NOAUDIT SQL statements to audit SQL statements, privileges, and schema [...]

By |2018-05-18T16:41:04+00:00November 9th, 2017|Database|Comments Off on Move Oracle Database Audit Trails To A New Tablespace