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

Last updated on OCTOBER 31, 2022

Applies to:

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

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