My Oracle Support Banner

Connection Via Oracle Net Fails With Error ORA-21561: OID Generation Failed (Doc ID 559981.1)

Last updated on SEPTEMBER 08, 2023

Applies to:

Oracle Net Services - Version 10.2.0.2 to 12.2.0.1 [Release 10.2 to 12.2]
PeopleSoft Cloud Manager - Version 11 to 11 [Release 8.4]
Information in this document applies to any platform.

Symptoms

SQL*Plus connections from a remote client via the listener fail with the following error:

ORA-21561 : OID generation failed

e.g.
-bash-2.05b$ sqlplus username/password@tns_connect_string

Changes

It is likely that a recent upgrade has taken place.
This error is usually the result of a hostname (FQDN or shortname) resolution issue.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

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