Environment:
Oracle11g
SQL> show parameter remote_login_passwordfile
Name type value
----------------------------------------------------------
Remote_login_passwordfile string exclusive
Win7 system:
When sqlnet. authentication_services = (ETS), the logon is successful.
C: \ Users \ ThinkPad> sqlplus "/As sysdba"
SQL * Plus: Release 11.1.0.7.0-production on Sunday April 15 21:44:35 2012
Copyright (c) 1982,200 8, Oracle. All rights reserved.
Connect:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0-Production
With the partitioning, OLAP, data mining and real application testing options
SQL> show user
User is "sys"
When sqlnet. authentication_services = (none), the logon prompt is insufficient.
SQL> exit
From Oracle Database 11g Enterprise Edition Release 11.1.0.7.0-Production
With the partitioning, OLAP, data mining and real application testing options disconnected
Open
C: \ Users \ ThinkPad> sqlplus "/As sysdba"
SQL * Plus: Release 11.1.0.7.0-production on Sunday April 15 21:51:23 2012
Copyright (c) 1982,200 8, Oracle. All rights reserved.
Error:
ORA-01031: insufficient privileges
When sqlnet. authentication_services = (all), the system prompts that the verification service cannot be initialized.
C: \ Users \ ThinkPad> sqlplus "/As sysdba"
SQL * Plus: Release 11.1.0.7.0-production on Sunday April 15 21:52:21 2012
Copyright (c) 1982,200 8, Oracle. All rights reserved.
Error:
ORA-12641: authentication service cannot be initialized
When this line of sqlnet. authentication_services is commented, the system prompts that the permission is insufficient.
C: \ Users \ ThinkPad> sqlplus "/As sysdba"
SQL * Plus: Release 11.1.0.7.0-production on Sunday April 15 21:53:24 2012
Copyright (c) 1982,200 8, Oracle. All rights reserved.
Error:
ORA-01031: insufficient privileges
Linux system (cemtos5.3)
When sqlnet. authentication_services = (ETS) or sqlnet. authentication_services = (none), the logon prompt is insufficient.
[Oracle @ localhost ~] $ Sqlplus "/As sysdba"
SQL * Plus: Release 11.2.0.1.0 production on Sun Apr 15 22:08:12 2012
Copyright (c) 1982,200 9, Oracle. All rights reserved.
Error:
ORA-01031: insufficient privileges
When sqlnet. authentication_services = (CNT) annotation or sqlnet. authentication_services = (all), login successful
[Oracle @ localhost ~] $ Sqlplus "/As sysdba"
SQL * Plus: Release 11.2.0.1.0 production on Sun Apr 15 22:08:39 2012
Copyright (c) 1982,200 9, Oracle. All rights reserved.
Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the partitioning, OLAP, data mining and real application testing options
Note:
1.
2. It seems that it is only feasible to authenticate the XP system.
3. Operating System Authentication
None: Password File Authentication