配置了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真有意思