My Oracle Support Banner

ORA-12514 and Slow Start of Managed Servers After a Database Failover (Doc ID 2793222.1)

Last updated on JULY 21, 2021

Applies to:

JDBC - Version 12.2.0.0.0 and later
Information in this document applies to any platform.

Symptoms

When trying to start a managed server after a database failover, the following error is reported:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

Environment:
Fusion Middleware Infrastructure Domain (12.2.1.3) configured in cluster mode with 4 Managed Server; each Managed Server is configured on dedicated hostnames.
The Infrastructure Domain has the Product and Business Schemas created in a 19c Database configured in an ACTIVE-STANDBY Topology:

  • Active Data Guard with FSFO (Fast-Start Failover Observer) and observer;
  • Oracle Multitenant architecture;
  • Oracle RAC capabilities.

In order to connect to the Database, for the Middleware and custom apps datasources, the below failover string is used, where the first scan is the primary database and the second scan is the standby:

jdbc:oracle:thin:@(DESCRIPTION_LIST=(LOAD_BALANCE=off)(FAILOVER=on)(DESCRIPTION=(CONNECT_TIMEOUT=10)(TRANSPORT_CONNECT_TIMEOUT=3000)(RETRY_COUNT=3)(ENABLE=BROKEN)
(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=<primary scan>)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=<SERVICE_NAME>)))(DESCRIPTION=(CONNECT_TIMEOUT=10)(TRANSPORT_CONNECT_TIMEOUT=3000)(RETRY_COUNT=3)(ENABLE=BROKEN)
(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=<standby scan>)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=<SERVICE_NAME>))))
 
With the primary database down and the standby running, the managed servers were unable to start.
If a manual database failover is executed, instead of isolating the RAC Database via networking and allowing the "observer" to initiate the failover, the managed server can be re-started. However, it takes 20 minutes for each managed server to start.
The issue occurs only when the RAC database is isolated from the network.

Changes

 

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.