My Oracle Support Banner

GoldenGate and Amazon RDS PostgreSQL Database Upgrade - OGG-25374 The replication slot 'XXXXX' for group '<Ext name>' does not exist in the database (Doc ID 2910075.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

After a Amazon RDS PostgreSQL upgrade, the extract abend with the following error


ERROR OGG-25374 The replication slot 'XXXXX' for group '<Ext name>' does not exist in the database '<Db name>'.
ERROR OGG-00145 Call to VAMInitialize returned with error status 16002.

Changes

As part of step 4 in the AWS documentation
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.PostgreSQL.html

Before upgrading, make sure you know the purpose of any logical replication
slots that are in use, and confirm that it's okay to delete them. If the
logical replication slots are still being used, you shouldn't delete them,
and you can't proceed with the upgrade.

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
Changes
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.