安装完oracle后,创建数据库,总是出现TNS包写入错误ORA-12571。在google上搜了半天都没有解决。
后来想起查看一下日值文件,对oracle也不熟,找了半天,终于在D:\oracle\ora92\network\log下找到了相关的日志。打开sqlnet.log,发现了真正的错误
***********************************************************************
Fatal NI connect error 12631, connecting to:
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
Time: 31-12月-2005 08:56:41
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12631
TNS-12631: TNS: 用户名检索失败
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
原来是TNS-12631: TNS: 用户名检索失败,还是去google。这回运气好,在oracle论坛上找到了一篇帖子:
problem has been solved by changing
sqlnet.authentication_services=(NTS)
to
sqlnet.authentication_services=(none)
BUT: I still don't know why our two servers and my personal oracle got derailed all on the same weekend. I'd still appreciate some suggestions.
按图索骥,在D:\oracle\ora92\network\admin\sqlnet.ora文件中,果然发现了这一行,改之。至于是什么原因,俺今天真的没时间了,先记在这儿,以后再查查文档。