WARNING: THIS SITE IS A MIRROR OF GITHUB.COM / IT CANNOT LOGIN OR REGISTER ACCOUNTS / THE CONTENTS ARE PROVIDED AS-IS / THIS SITE ASSUMES NO RESPONSIBILITY FOR ANY DISPLAYED CONTENT OR LINKS / IF YOU FOUND SOMETHING MAY NOT GOOD FOR EVERYONE, CONTACT ADMIN AT ilovescratch@foxmail.com
Skip to content

Oracle OID Generation Failed

Jump to bottom
Kyle Hankinson edited this page Feb 1, 2019 · 2 revisions

When connecting to an Oracle database, you may receive the error message:

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.

If you receive this error message, please run the following command from terminal:

echo "127.0.0.1 $(hostname)" | sudo tee -a /etc/hosts

Once the command has been run, relaunch SQLPro and your Oracle connection should succeed.

References:

  1. https://oracle-admin.com/2014/02/04/oracle-ora-21561-oid-generation-failed/
  2. https://kb.tableau.com/articles/issue/error-ora-21561-oid-generation-failed-connecting-to-oracle-from-mac

Clone this wiki locally