今天在使用sqlplus登陆数据库时遇到如下错误:
oracle@host-10-1-234-245:/oravl01/oracle> sqlplus sys/oracle@10.1.234.248:1521/bill_28
SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 30 10:46:48 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-21561: OID generation failed
首先通过oerr ora 21561查看此错误的说明,也没发现说明有价值的信息:
oracle@host-10-1-234-245:/oravl01/oracle> oerr ora 21561
21561, 00000, "OID generation failed"
// *Cause: The handles passed in may not be valid
// *Action: Check the validity of the env, svc handles
最后通过网上搜索该问题是由于没有正确配置hosts文件造成的,解决方法就是将本机ip和主机名配置到hosts文件即可。
oracle@host-10-1-234-245:/oravl01/oracle> sqlplus sys/oracle@10.1.234.248:1521/bill_28
SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 30 10:46:48 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-21561: OID generation failed
首先通过oerr ora 21561查看此错误的说明,也没发现说明有价值的信息:
oracle@host-10-1-234-245:/oravl01/oracle> oerr ora 21561
21561, 00000, "OID generation failed"
// *Cause: The handles passed in may not be valid
// *Action: Check the validity of the env, svc handles
最后通过网上搜索该问题是由于没有正确配置hosts文件造成的,解决方法就是将本机ip和主机名配置到hosts文件即可。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20801486/viewspace-1756332/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/20801486/viewspace-1756332/