Thursday 25 July 2013

Complete checklist for out-of-place manual upgrade from previous 11.2.0.N version to the latest 11.2.0.N patchset




Tuesday 23 July 2013

Oracle GoldenGate database Schema Profile check script for Oracle DB

Oracle GoldenGate database Schema Profile check script for Oracle DB (Doc ID 1296168.1)


PURPOSE

This script is intended to query the database by schema to identify current configuration and identify any unsupported data types or types that may need special considerations for Oracle GoldenGate in an Oracle environment. This is the Oracle database profile script.  Added check for deferred constraints. Deferred constraints may cause ADD TRANDATA to select the wrong column for logging. Use KEYCOLS for tables with deferred constraints.

REQUIREMENTS

This script is to be run in sqlplus by a user that has DBA privliges.

CONFIGURING

Download or Save script file as full-schemaCheckOracle_12072011.sql

INSTRUCTIONS

Log into sqlplus as sysdba
run the script -
SQL> @full-schemaCheckOracle_12072011.sql
Review output.