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 [...]

2018-02-20T17:00:32+00:00 February 17th, 2018|Uncategorized|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 [...]

2018-01-18T20:34:36+00:00 January 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 [...]

2018-02-20T16:59:29+00:00 January 7th, 2018|Uncategorized|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 [...]

2018-02-20T19:53:36+00:00 December 17th, 2017|Uncategorized|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 => [...]

2017-11-09T20:27:46+00:00 November 9th, 2017|Database, Uncategorized|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 [...]

2017-11-09T20:27:38+00:00 November 9th, 2017|Database, Uncategorized|Comments Off on Move Oracle Database Audit Trails To A New Tablespace

Case Study: Oracle GoldenGate for AWS – Migrate Oracle on premise to Amazon Web Services (AWS)

Case Study: Oracle GoldenGate for AWS - Migrate Oracle on premise to Amazon Web Services (AWS) A leading content streaming service required the live-migration of its critical 24X7 billing system with near-zero downtime. Performance Tuning Corporation designed a plan based on Oracle GoldenGate 12c to migrate the client’s on premise Oracle RAC database to a [...]

2017-09-20T06:32:05+00:00 May 9th, 2017|Performance Wire|Comments Off on Case Study: Oracle GoldenGate for AWS – Migrate Oracle on premise to Amazon Web Services (AWS)

Database Health Check

Database Health Check Offering at a Glance The PTC Database Health Check Service has been designed and approved by world renowned database experts. The offering is a quick, easy, and targeted service focused on arming you with clear evidence about the status of your database system performance and maintenance strategy.  Services Overview Performance and Maintenance Problems Identified with Recommended [...]

2017-09-20T06:33:04+00:00 April 20th, 2017|Performance Wire|Comments Off on Database Health Check

Oracle RAC Deployment

Oracle RAC Deployment Performance Tuning Corporation has successfully implemented more than 300 Oracle Real Application Cluster (RAC) systems on UNIX, Linux and Windows. Below are some important things to consider before engaging your critical resources. Server, Storage and Network (SAN) Implementation Knowledge. Without these skills, it is impossible to properly configure and tune Oracle [...]

2017-09-20T06:33:14+00:00 April 20th, 2017|Performance Wire|Comments Off on Oracle RAC Deployment

Database Tuning Services

Database Tuning Services Service Overview This service is focused on determining the root cause or causes of existing Oracle or MS SQL Server database performance problems. At the end of this engagement a remediation proposal will be provided. PTC will apply its considerable expertise to determine the best course of action to get your database infrastructure running [...]

2017-09-20T06:33:24+00:00 April 20th, 2017|Performance Wire|Comments Off on Database Tuning Services