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 22.214.171.124.0 and later
Microsoft Windows x64 (64-bit)
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.
This issue typically occurs when the number of active sessions is relatively higher at the current primary before performing the switchover.
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