My Oracle Support Banner

HOWTO : Resolve TimesTen Error 8111 CONNECTION NOT PERMITTED. MASTER CATCHUP IN PROGRESS. (Doc ID 1072994.1)

Last updated on MARCH 15, 2021

Applies to:

Oracle TimesTen In-Memory Database - Version 6.0.0 to 11.2.1 [Release 6.0 to 11.2]
Information in this document applies to any platform.

Symptoms



With Return Two Safe replication, in case of a master failure you would  have to recover by duplicating the master from the subscriber. This is because transactions are committed first on the subscriber then confirmation is given to the master.  

 
The "Master Catchup" feature allows for avoiding the duplication by enabling the subscriber to back-ship any missing transactions to the master as part of the master's recovery.

Master catchup is not available for all replication configurations. Using TRANSMIT DURABLE (the default except for RETURN TWOSAFE), there is no need for master catchup since all data sent by replication is also guaranteed recoverable locally (from disk) and so after a master failure one can simply restart the master datastore and everything will sync up without any data loss.

If you attempt to connect to the master data store before the 'master catchup' has completed, you may encounter the following error

Check that the replication agents are started so they can both talk to each other, and hence the "master catchup" can occur.

Changes

 

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.