oracle 无法在linux实现操作系统验证问题解决

 配置了sqlora.net文件,配置情况如下:

# sqlnet.ora Network Configuration File: /opt/ora10g/product/10.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (ALL)
  NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

然后登陆数据库:

SQL> conn / as sysdba
ERROR:
ORA-01031: insufficient privileges

SQL>

奇怪了,怎么无法操作系统验证了呢

难道是sqlora.net配置有问题,让我检查了好久,从新修改sqlora.net文件如下:

# sqlnet.ora Network Configuration File: /opt/ora10g/product/10.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (ALL)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT),然后再登陆数据库:
SQL> conn / as sysdba
Connected.
SQL>

登陆成功

难道就是由于sqlora.net的配置文件第一项没有和第二项对齐的原因吗?oracle真有意思