Drop Active Standby returns error: 908: Key not found in table or index (Doc ID 1949642.1)

Last updated on APRIL 14, 2022

Applies to:

Goal

User was trying to drop active standby pair.

When they ran the command they got this error:

Command> DROP ACTIVE STANDBY PAIR;
 908: Key not found in table or index

Reviewing the ttmesg.log or .inval file revealed that "DROP ACTIVE STANDBY PAIR" resulted in an invalidation:

Assertion failed: ( (((((tableHeaderp)))->tblType) == ((sbNodeTag_t) 11)) || (((((tableHeaderp)))->tblType) == ((sbNodeTag_t) 12))) [repDDL.c:/main/172:sbSysTableRepOptions():13934]

Solution

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