1）REMOTE_LOGIN_PASSWORDFILE=none且SQLNET.AUTHENTICATION_SERVICES= none： 

oracle安装用户本地sqlplus “/ as sysdba”无法登录 

非oracle安装用户本机sqlplus “sys/change_on_install as sysdba”无法登录 

非oracle安装用户远程sqlplus “/ as sysdba_on_install@sid as sysdba”无法登录 

 

（2）REMOTE_LOGIN_PASSWORDFILE=exclusive且SQLNET.AUTHENTICATION_SERVICES= none： 

oracle安装用户本地sqlplus “/ as sysdba”无法登录 

非oracle安装用户本机sqlplus “sys/change_on_install as sysdba”能登录 

非oracle安装用户远程sqlplus “/ as sysdba_on_install@sid as sysdba”能登录 

 

（3）REMOTE_LOGIN_PASSWORDFILE=none且SQLNET.AUTHENTICATION_SERVICES= (NTS)： 

oracle安装用户本地sqlplus “/ as sysdba”能登录 

非oracle安装用户本机sqlplus “sys/change_on_install as sysdba”无法登录 

非oracle安装用户远程sqlplus “/ as sysdba_on_install@sid as sysdba”无法登录 

 

（4）REMOTE_LOGIN_PASSWORDFILE=exclusive且SQLNET.AUTHENTICATION_SERVICES= (NTS)： 

oracle安装用户本地sqlplus “/ as sysdba”能登录 

非oracle安装用户本机sqlplus “sys/change_on_install as sysdba”能登录 

非oracle安装用户远程sqlplus “/ as sysdba_on_install@sid as sysdba”能登录