My Oracle Support Banner

Switchover using DG Broker reports "ORA-12518" if Shutdown of Old Primary is Slow (> 60 seconds) (Doc ID 2764648.1)

Last updated on DECEMBER 30, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 19.8.0.0.0 and later
Microsoft Windows x64 (64-bit)

Symptoms

This issue is relevant to switchover in a Microsoft Windows environment using DG Broker.

Role reversal completes, but when old primary takes more then 60 seconds to shutdown and restart (as the standby role), the broker reports "ORA-12518: TNS:listener could not hand off client connection".

The old primary (now the standby) has to be manually started up.

Changes

This issue typically occurs when the number of active sessions is relatively higher at the current primary before performing the switchover.

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.