My Oracle Support Banner

EM13c: OEM Shows A SQL Server Clustered Instance Database Target Down Once It Is Failed Over (Doc ID 2799617.1)

Last updated on AUGUST 29, 2021

Applies to:

Enterprise Manager for Miscellaneous Plug-ins - Version 13.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

SQL Server clustered instance MSSQLDBCLUSTER with two nodes NODE1(active node) NODE2(passive node).
EM agent has been installed on both the nodes. SQL Server instance MSSQLDBCLUSTER has been added to EM as MS SQL Database target with its virtual server name monitored by the OEM agent on NODE1. When there is a fail over of the clustered instance MSSQLDBCLUSTER from NODE1 to NODE2, OEM shows the target MSSQLDBCLUSTER as down.

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


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