sqlnet.ora

以sysdba身份登陆ORACLE进行管理，有2种验证方式: 操作系统验证及密码文件验证

windows下在sqlnet.ora文件中
authentication_services
=(NTS) 操作系统验证           
=(NONE) 口令验证 
=(NTS,NONE) 操作系统验证(因为操作系统认证比口令认证的安全级别高)

++++++++++++++++++++++++++++++++++++D:\oracle\ora92\network\admin
# SQLNET.ORA Network Configuration File: D:\oracle\ora92\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = asia.ad.flextronics.com

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
++++++++++++++++++++++++++++++++++++

linux/unix下 只要在sqlnet文件中出现 authentication_services就为密码验证,不管其值是NTS,NONE还是2者皆有.

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/550306/viewspace-528621/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/550306/viewspace-528621/