My Oracle Support Banner

DB2 z/OS extract: SQL0440N No authorized routine named "OGGIFI0001.OGGINITB" of type "" having compatible arguments was found. SQLSTATE=42884 (Doc ID 2570353.1)

Last updated on JUNE 01, 2020

Applies to:

Oracle GoldenGate - Version 18.1.0.0.0 and later
Information in this document applies to any platform.

Symptoms

User in this case installed OGG 19.1 for Linux for DB2 z/OSand was getting below error:


  Oracle GoldenGate Capture for DB2
  Version 19.1.0.0.1 OGGCORE_19.1.0.0.0_PLATFORMS_190524.2201
  Linux, x64, 64bit (optimized), IBM DB2 z/OS on May 25 2019 05:22:50

2019-07-24T07:02:28.477+0200 ERROR OGG-00551 Oracle GoldenGate Capture for DB2, ext.prm: Database operation failed: init sp - execute. ODBC error: SQLSTATE 42884 native database error -440. [IBM][CLI Driver][DB2] SQL0440N No authorized routine named "OGGIFI0001.OGGINITB" of type "" having compatible arguments was found. SQLSTATE=42884.

Cause

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
Symptoms
Cause
Solution
References


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