My Oracle Support Banner

Resolve TimesTen Error "8125: The store cannot be dropped from the ACTIVE STANDBY PAIR scheme because it is a MASTER node" When Dropping A Readonly Subscriber (Doc ID 1630095.1)

Last updated on FEBRUARY 14, 2018

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.1 and later
Information in this document applies to any platform.

Symptoms

Observing TimesTen error 8125 when trying to drop a Readonly Subscriber:

set up active standby pair with subscriber node. In this case, the subscriber node is myhost03

When trying to drop the subscriber node on the master node (active node), and get this error:

$ ttIsql -connstr "dsn=myDSN"
Command>call ttrepstop;
Command>ALTER ACTIVE STANDBY PAIR DROP SUBSCRIBER myDSN;
8125: The store cannot be dropped from the ACTIVE STANDBY PAIR scheme because it is a MASTER node
The command failed.

 

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!


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