We attempted to configure data connection from Tableau 8.0.2 server. When we are using service name (other than default <DBNAME>), we are receiving following error.
An error occurred when publishing the workbook.
Oracle database error 00000: Failover was unable to generate an address for a backup instance.
Unable to connect to the server "*Host*Name*". Check that the server is running and that you have access privileges to the requested database.
On the other hand, if we use default service name(i.e. DB Name), database connection is successful with the same username and password.
Has anyone noticed that in Tableau or any other application environment?
What is the version of the database?
Refer to the below mentioned document, it could be matching your issue
Ref: EZCONNECT Connections Error with SP2-0642: Sql*Plus Internal Error State 2130 (Doc ID 855965.1)
Vandana - Oracle