I got ” ORA-21561: OID generation failed ” error in Oracle database.
ORA-21561: OID generation failed
Details of error are as follows.
ORA-21561: OID generation failed Cause: The handles passed in may not be valid Action: Check the validity of the env, svc handles 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/[email protected]_connect_string SQL*Plus: Release 220.127.116.11.0 - Production on Fri Mar 7 16:15:10 2008 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. ERROR: ORA-21561 : OID generation failed Enter user-name: <username>/<password>@<tns connect string> Connected to: Oracle Database 11g Enterprise Edition Release 18.104.22.168.0 - 64bit Production With the Partitioning and Data Mining options SQL>
OID generation failed
This ORA-21561 errors are related with the handles passed in may not be valid.
Check the validity of the env, svc handles.
Incorrect /etc/hosts mapping for the client machine or no mapping at all.
To solve this error, Check the client’s /etc /…/hosts file and verify that the local node is correctly identified with a mapping for both the short and fully qualified name of the host.
Check your /etc/hosts file.
127.0.0.1 localhost localhost.localdomain
You should change it as follows.
127.0.0.1 localhost localhost.localdomain hostname
263 views last month, 3 views today