KNOWLEDGE BASE

Error "Failover was unable to generate an address for a backup instance" Connecting to Oracle


Published: 19 Jun 2013
Last Modified Date: 08 Jan 2016

Issue

When connecting to an Oracle database, the following error might occur:

Oracle database error 00000: Failover was unable to generate an address for a backup instance.
Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.

Environment

  • Tableau Desktop
  • Oracle

Resolution

Work with your Oracle database administrator or internal IT support team to verify that the Oracle database server is running and correctly configured to use TNSNames.ora. For more information, see Setting an Oracle Connection to Use TNSNames.ora.

Cause

Typically this error indicates that the Oracle database server has failed and is unable to switch over to a fail-over server.
Did this article resolve the issue?