今天一同事发来远程说Oracle客户端连不上服务器端。远程看了一下报


SQL> conn system/oracle@xxxx
ERROR:
ORA-21561: OID generation failed


出现该错误后,查看metalink

Connection Via 10.2.0.3 SQL*Net Fails With Error ORA-21561: OID Generation Failed [ID 559981.1]

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.

同时检查自己的/etc/hosts文件,确实存在这个问题,修改/etc/hosts后问题解决


注意是修改client端的hosts文件,添加client的IP 和主机名!!!不是在client端添加服务器的!