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

Complete checklist for out-of-place manual upgrade from previous 11.2.0.N version to the latest 11.2.0.N patchset.  You need to perform an out of place upgrade. 1. Install 11.2.0.3 on a different home 2. run the pre-upgrade tool on the existing 11.2.0.1 database 3. peform the pre-requisities mentioned 4. Bring down the database from 11.2.0.1 and start the database in upgrade mode from 11.2.0.3 home by copying the pfile/spfile of 11.2.0.1 database to $11.2.0.3_HOME/dbs path  5. startup upgrade and run the catupgrd.sql Make sure you look out for the invalid objects. Refer *Complete checklist for out-of-place manual upgrade from previous 11.2.0.N version to the latest 11.2.0.N patchset. [ID 1276368.1] and Database Upgrade Path Reference List(Doc ID 730365.1) orhttp://docs.oracle.com/cd/E11882_01/server.112/e23633/toc.htm

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.