Loading

Error "ORA-21561: OID generation failed" Connecting to Oracle with a Mac

Дата публикации: Mar 14, 2025
Описание

When you try to connect to Oracle from Tableau Desktop on a Mac, the following error might occur:
 

An error occurred while communicating with the Oracle Database data source '<data source name>'.
Oracle database error 21561: ORA-21561: OID generation failed
Unable to connect to the server "<server name>". Check that the server is running and that you have access privileges to the requested database.

 

Cause

The local computer name and the name associated with the 127.0.0.1 IP address are not the same. 

 

Решение

Option 1

Edit the hosts file on the Mac to include local computer name by adding the computer name to the end of the 127.0.0.1 line. For example, the last line of the hosts file would read:

127.0.0.1 localhost <local computer name>

For more information, see How to edit your Mac's Hosts file... on iMore.
 

Option 2

As an alternative workaround, ensure that no security software or antivirus is interfering with Tableau Desktop or Oracle. 
 

Номер статьи базы знаний

001474048

 
Загрузка
Salesforce Help | Article