今天打开连接数据库报错ORA-12638,如下:
SQL> conn / as sysdba
ERROR:
ORA-12638: Credential retrieval failedSQL> conn scott/tiger
ERROR:
ORA-12638: Credential retrieval failed
在网上搜索了一下,说是修改sqlnet.ora文件。
将SQLNET.AUTHENTICATION_SERVICES= (NTS)
改为SQLNET.AUTHENTICATION_SERVICES= (NONE)或者注释掉这一行,可是这样做就无法使用操作系统方式连接数据库了。报错,如下:SQL> conn scott/tiger
Connected.
SQL> conn / as sysdba
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.我的操作系统是Windows xp我该怎么办好呢?请各位支招,谢谢。∩_∩
SQL> conn / as sysdba
ERROR:
ORA-12638: Credential retrieval failedSQL> conn scott/tiger
ERROR:
ORA-12638: Credential retrieval failed
在网上搜索了一下,说是修改sqlnet.ora文件。
将SQLNET.AUTHENTICATION_SERVICES= (NTS)
改为SQLNET.AUTHENTICATION_SERVICES= (NONE)或者注释掉这一行,可是这样做就无法使用操作系统方式连接数据库了。报错,如下:SQL> conn scott/tiger
Connected.
SQL> conn / as sysdba
ERROR:
ORA-01031: insufficient privileges
Warning: You are no longer connected to ORACLE.我的操作系统是Windows xp我该怎么办好呢?请各位支招,谢谢。∩_∩
你conn sys/passwd as sysdba才是密码认证
只要OS用户属于OSDBA OR OROPER组,并且使用connect as sysdba / sysoper登录,则可以忽略输入的username/password
所以conn sys/passwd as sysdba 跟conn / as sysdba 一样的