奇怪的ORA－03113错误！

来源：互联网发布：程序员star法则简历编辑：程序博客网时间：2024/05/01 18:12

今天一个同事连接ORACLE服务器的时候出现了问题，使用net manager创建本地服务命名的时候，测试连接总是出现错误： ORA-03113 通讯通道的文件结束

解决办法：将sqlnet.ora文件中的： SQLNET.AUTHENTICATION_SERVICES=(NTS)行删除

metalink上的解释：

If you log on to a winNT or win2000 machine as a domain user but there is
currently no network connection, you will still be logged on to the machine
if you've been logged on before. Windows will use cached credentials to check your username/password etc.

If you've got SQLNET.AUTHENTICATION_SERVICES=(NTS) set in your sqlnet.ora you're asking oracle to authenticate you with the domain server when you log on to oracle.

This combination of things can lead to oracle trying to ask the NT domain
controler to validate you when there is no actual network connection, the
result is an ORA-3113 error.