1、REMOTE_LOGIN_PASSWORDFILE=none
SQLNET.AUTHENTICATION_SERVICES= none
oracle安装用户本地sqlplus “/ as sysdba”无法登录
非oracle安装用户本机sqlplus “sys/change_on_install as sysdba”无法登录
非oracle安装用户远程sqlplus “/ assysdba_on_install@sidas sysdba”无法登录
2、REMOTE_LOGIN_PASSWORDFILE=exclusive
SQLNET.AUTHENTICATION_SERVICES= none
oracle安装用户本地sqlplus “/ as sysdba”无法登录
非oracle安装用户本机sqlplus “sys/change_on_install as sysdba”能登录
非oracle安装用户远程sqlplus “/ assysdba_on_install@sidas sysdba”能登录
3、REMOTE_LOGIN_PASSWORDFILE=none
SQLNET.AUTHENTICATION_SERVICES= (NTS)
oracle安装用户本地sqlplus “/ as sysdba”能登录
非oracle安装用户本机sqlplus “sys/change_on_install as sysdba”无法登录
非oracle安装用户远程sqlplus “/ assysdba_on_install@sidas sysdba”无法登录
4、REMOTE_LOGIN_PASSWORDFILE=exclusive
SQLNET.AUTHENTICATION_SERVICES= (NTS)
oracle安装用户本地sqlplus “/ as sysdba”能登录
非oracle安装用户本机sqlplus “sys/change_on_install as sysdba”能登录
非oracle安装用户远程sqlplus “/ assysdba_on_install@sidas sysdba”能登录