sqlplus连接数据库报ORA-21561: OID Generation Failed

最新推荐文章于 2023-04-19 17:22:17 发布

原创最新推荐文章于 2023-04-19 17:22:17 发布 · 3.1k 阅读

0 ·

CC 4.0 BY-SA版权

oracle 专栏收录该内容

150 篇文章

订阅专栏

本文介绍了一个在升级到Oracle 10.2.0.x版本后使用SQL*Plus连接数据库时出现ORA-21561错误的问题，并提供了详细的解决方案，即检查并修复客户端hosts文件中的本地节点映射。

sqlplus连接数据库报ORA-21561: OID Generation Failed

Symptoms
After upgrading to version 10.2.0.x, SQL*Plus connections fail with the following error:
ORA-21561 : OID generation failed
-bash-2.05b$ sqlplus username/password@tns_connect_string
SQL*Plus: Release 10.2.0.3.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 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning and Data Mining options
SQL>

Cause
Incorrect /etc/hosts mapping for the client machine or no mapping at all.

Solution
Check the client's /.../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.

我遇到问题的原因是由于hosts文件的权限被改了导致的错误，权限改回去，再次连接正常