连接数据库时报错ORA-01031: insufficient privileges
$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 30 23:48:57 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-01031: insufficient privileges
Enter user-name:
后来上网查找了一下,是sqlnet.ora的问题
$ cat sqlnet.ora.bk
# sqlnet.ora Network Configuration File: /home/oracle/database/product/10.2.0/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
$
多了一行SQLNET.AUTHENTICATION_SERVICES= (NTS)
后来注释掉就没问题了
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27146953/viewspace-735387/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27146953/viewspace-735387/