My Oracle Support Banner

OBIA 12c: OGG Parameter Files generated by OBIA procedure fail to load when using databases with multitenant architecture (Doc ID 2847765.1)

Last updated on SEPTEMBER 05, 2023

Applies to:

Business Intelligence Applications Consumer - Version and later
Information in this document applies to any platform.


Data Source: Peoplesoft HRMS PSFT 9.2
Modules implemented: HR
Oracle GoldenGate integration with Oracle GoldenGate version

Both source and target are Oracle databases and are on multitenant architecture with the schemas under underlying pluggable databases.
Customer wants to use Integrated replicat rather than a classic extract.
The GENERATE_SDS_OGG_PARAM_FILES scenario should generate parameter files for multitenant container databases as well.

Steps to be followed for integrating OGG with OBIA 12c:

Issues resolved in this note:

1. After running the 'GENERATE_SDS_OGG_PARAM_FILES' scenario, the parameter files that got generated does not have any table names.

2. Parameter files generated for OGG fail to load with the following error:

Source Context :
  SourceModule : [er.redo.ora]
  SourceID : [er/redo/oracle/redoora.c]
  SourceMethod : [validateConfig]
  SourceLine : [6407]
  ThreadBacktrace : [15] elements
  : [/u0g/ogg194c/]
  : [/u0g/ogg194c/*, unsigned int, ...))]
  : [/u0g/ogg194c/*, int, CMessageFactory::MessageDisposition))]
  : [/u0g/ogg194c/extract()]
  : [/u0g/ogg194c/extract(RedoAPI::createInstance(ggs::gglib::ggdatasource::DataSource*, ggs::gglib::ggapp::ReplicationContext*))]
  : [/u0g/ogg194c/extract(ggs::er::OraTranLogDataSource::setup())]
  : [/u0g/ogg194c/extract(ggs::gglib::ggapp::ReplicationContext::establishStartPoints(char, ggs::gglib::ggdatasource::DataSourceParams const&))]
  : [/u0g/ogg194c/extract(ggs::gglib::ggapp::ReplicationContext::initializeDataSources(ggs::gglib::ggdatasource::DataSourceParams&))]
  : [/u0g/ogg194c/extract()]
  : [/u0g/ogg194c/extract(ggs::gglib::MultiThreading::MainThread::ExecMain())]
  : [/u0g/ogg194c/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*))]
  : [/u0g/ogg194c/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**))]
  : [/u0g/ogg194c/extract(main)]
  : [/lib64/]
  : [/u0g/ogg194c/extract()]

2021-08-23 00:43:08 ERROR OGG-06220 Classic Extract does not support multitenant container databases.

2021-08-23 00:43:08 ERROR OGG-01668 PROCESS ABENDING.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.