GoldenGate 12.2 Object Exclude

1.8 Details of Support for Objects and Operations in Oracle DDL

The following tables are excluded by default.

  "*.AQ$*", // advanced queues
  "*.DR$*$*", // oracle text
  "*.M*_*$$", // Spatial index
  "*.MLOG$*", // materialized views
  "*.OGG$*", // AQ OGG queue table
  "*.ET$*", // Data Pump external tables
  "*.RUPD$*", // materialized views
  "*.SYS_C*", // constraints
  "*.MDR*_*$", // Spatial Sequence and Table
  "*.CMP*$*",  (more...)


I was faced with a very strange situation.

When using SETENV (ORACLE_SID = db01), replicat ABEND with  OGG-00664  OCI Error beginning session (status = 1034-ORA-01034: ORACLE not available

When using SETENV (ORACLE_HOME=/u01/app/oracle/product/, replicat starts without any issues.

I know what you are thinking, why not set both ORACLE_SID and ORACLE_HOME and you are correct since this is best practices.

The client already knows this and wanted to troubleshoot why it was failing?

Any ideas? (more...)

Different names for 12c CDB

Truthfully, I am feeling a little lazy to write a nice blog.

Configuring listener.ora and tnsnames.ora, varying names for database, connecting to database.


db_name                              string      tmnt
db_unique_name                       string      tmnt_a
instance_name                        string      tmnt01

ADR Home /u01/app/oracle/diag/rdbms/tmnt_a/tmnt

Services Summary...
Service "april" has 1 instance(s).
  Instance "tmnt01", status READY, has 1 handler(s) for this service...
Service "tmnt" has 1 instance(s).
  Instance "tmnt", status UNKNOWN, has 1 handler(s) for this service...
Service "tmnt_a" has 1 instance(s).

Data Guard Broker : 11g and 12c

vault-154023_640I’ve been using standby databases, on and off, since Oracle 8i. I first wrote about Data Guard for Oracle 9i. I’ve had an article on 11gR2 Data Guard for ages, but up until recently I’ve always used the manual setup.

We’ve got a project coming up that *may* use Data Guard and *may* be installed by a 3rd party, so I figured I better get up to speed with the Data Guard Broker, in case they (more...)

Announcing OBI Remote Training

Since the release of OBIEE 12c in 2015, we have received countless inquiries about how we would be offering our training. Our customers are familiar with our ability to provide on-site private training for a team and we are well known for hosting training classes in our offices in the UK and the US. But what most people aren’t aware of is that we now offer OBI remote training.

Our public training schedule offers a (more...) New Features

Just a quick note as I play with CDB/PDB.

No more triggers!

PDB State Management Across CDB

select con_name, instance_name, state from DBA_PDB_SAVED_STATES;
alter pluggable database PDB1 SAVE STATE;
alter pluggable database ALL SAVE STATE;
alter pluggable database ALL DISCARD STATE;
alter pluggable database ALL OPEN;

startup force mount exclusive restrict;
drop database;

Drop database still does not clean up ADR.

$ sysdba

SQL*Plus: Release Production  (more...)

Create 12c CDB using dbca or sqlplus ???

How do you typically create database, using dbca or sqlplus?

I am still surprised with all the bloatware added for creating database using dbca.

Also, is there a reason to prefix PDB with pdb?

$ ll
total 28
-rw-r--r--. 1 oracle oinstall  801 Jul 19 12:59 cr_cdb.sql
-rw-rw----. 1 oracle oinstall 1544 Jul 19 13:06 hc_tmnt.dat
-rw-r--r--. 1 oracle oinstall  216 Jul 19 12:48 inittmnt.ora
-rw-r-----. 1 oracle  (more...)

Setting a Session Parameter Overrides OFE

I received an email recently that demonstrated something the author considered strange when the init.ora parameter optimizer_feature_enable (OFE) is set in a database session. I thought I'd mention it here because the behavior he spotted is expected, but I don't think that it is entirely obvious. Let's assume that... [Read More]

Connecting Oracle Data Visualization Desktop to OBIEE

Recently at Rittman Mead we have been asked a lot of questions surrounding Oracle’s new Data Visualization Desktop tool and how it integrates with OBIEE. Rather than referring people to the Oracle docs on DVD, I decided to share with you my experience connecting to an OBIEE 12c instance and take you through some of the things I learned through the process.

In a previous blog, I went though database connections with Data Visualization (more...)

How To Configure Exadata Database Machine in Enterprise Manager Cloud Control 13c (OEM13c)

I have followed the steps in Oracle Documentation link: to configure Exadata Database Machine in OEM13c. If you want to configure your Exadata in OEM13c you have to follow the above mentioned link. In this post I will share the mandatory steps for configuration, and some of the issues which I faced while configuring the Exadata…

BPM 12c Subprocesses (Part 3 of 3): Event Subprocess by Antonis Antoniou


In this third and last part of a three part series on subprocesses we will explore a special type of subprocess referred to as an “Event” subprocess.
This type of subprocess is triggered by an event that can occur anytime during the execution of a process flow that allows you to interrupt the normal flow of an instance.
Such capability can be applicable in various use cases. For example, an error might occur in the (more...)

Learn About Exadata Database Machine 12 c through Oracle Training

Oracle Exadata provides the highest-performing and most-available infrastructure for running Oracle Database, whether it’s in the Oracle Cloud, on premises, or a combination of both.

Oracle Exadata architecture features a scale-out design with industry-standard servers and intelligent storage, including state-of-the-art flash technology and a high-speed InfiniBand internal fabric.

This architecture provides 100 percent Oracle Database portability from on premises to Oracle Public Cloud and back.

Oracle (more...)

SOA Suite download available

imageThis new release includes bug fixes as well as new features including:

  • New Cloud Adapters for Oracle and 3rd-party applications
  • Operational Enhancements
  • BAM and Real-Time Integration Business Insight Enhancements
  • Major expansion of MFT functionality

For a list of new features in this release, please check the list of new features in SOA Suite and Managed File Transfer Get SOA Suite here

SOA & BPM Partner Community



This is probably not a 12.2 specific features and since I only tested for 12.2, I am not going to vouch for other versions.

Be careful when qualifying schema with DDL replication especially when the source and target schemas are not the same.

Example: Source schema is DEMO and Target schema is DEMO_REP

What happens to DDL replication when the following is used?

alter table demo.t add constraint t_pk primary key(id) using (more...)

OTN Middleware & Java Summit July 2016

This is a series of 8 short videos explaining how to create a BPM application using Oracle Process Cloud Services. Part 1 will show how to login and create a new application:

clip_image002Part 1

Part 2

Part 3

Part 4

Part 5

Part 6

Part 7

Part 8

The tutorial is also available at our Community blog Business Process Modelling and Business Activity Monitoring by Stefan Wörmcke

SOA & BPM Partner Community

For regular information (more...)

Invisible Bug

At this Wednesday’s Oracle Midlands event someone asked me if Oracle would use the statistics on invisible indexes for the index sanity check. I answered that there had been a bug in the very early days of invisible indexes when the distinct_key statistic on the index could be used even though the index itself would not be considered as a candidate in the plan (and the invisible index is still used to avoid foreign key (more...)

Global Temporary Tables – Change in Oracle 12c

A few weeks back I was copied on an email conversation about a important change with Global Temporary Tables (GTT) in Oracle Database 12c.  Something you need to be aware of when using GTTs in Oracle Database to this release GTTs shared statistics between sessions. Statistics were SHARED between... [Read More]

Outer Join with OR and Lateral View Decorrelation

Use of ANSI SQL is a personal thing.

Historically I have not been a fan apart from where it makes things easier/possible.

This reticence was mainly due to optimizer bugs and limitations in the earlier days.

Recently I have been using it much more because I find that the developers I interact with prefer it / understand it better.

You might/should be aware that Oracle will rewrite ANSI SQL to an Oracle syntax representation, this (more...)

Pharma and Automotive BPM Solutions by OpRiskSolutions International Ltd


Our partner OpRiskSolutions developed two solutions based on BPM Suite 12c:

Aria4Automotive Aria4Automotive is a comprehensive solution, designed to address the specific requirements of Project Schedule Management in the Automotive Industry. The solution supports specific automotive industry planning concepts, such as enterprise-wide scheduling.
Aria4Pharma Aria4Pharma is a comprehensive enterprise solution that addresses the specific needs, planning concepts and processes of drug development in the pharmaceutical industry.

For more information about the Solutions Catalog & Cloud (more...)

Speed up Upgrade Phase 65 with a new catuposb.sql

Credits to Chris Smids from Proximus in Belgium Thanks, Chris!!! Upgrade to Oracle is slow in phase: #65 ? You are wondering why phase: #65 of the database upgrade to Oracle Database takes quite a while. You dig down into the catupgrd0.log and recognized this statement taking a... [Read More]