官方文档解释
REMOTE_LOGIN_PASSWORDFILE
Property Description
Parameter type String
Syntax REMOTE_LOGIN_PASSWORDFILE=
{NONE | SHARED}
Default value SHARED
Modifiable No
Basic Yes
Real Application Clusters Multiple instances must have the same value.
REMOTE_LOGIN_PASSWORDFILE specifies whether Oracle checks for a password file.
Values:
NONE
Oracle ignores any password file. Therefore, privileged users must be authenticated by the operating system.
SHARED
One or more databases can use the password file. The password file can contain SYS as well as non-SYS users.
Note:
The value EXCLUSIVE is supported for backward compatibility. It now has the same behavior as the value SHARED
[oracle@dw ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jul 12 10:01:30 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter pass
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string EXCLUSIVE
客户端登陆
C:\Users\wen>sqlplus sys/oracle@192.168.67.5:1522/oocc as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 13 14:28:00 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
登陆成功
修改参数remote_login_passwordfile=none;
SQL> alter system set remote_login_passwordfile=none scope=spfile;
System altered.
SQL> startup force;
ORACLE instance started.
Total System Global Area 159383552 bytes
Fixed Size 2082432 bytes
Variable Size 117442944 bytes
Database Buffers 37748736 bytes
Redo Buffers 2109440 bytes
Database mounted.
Database opened.
SQL> show parameter pass
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile string NONE
SQL>
再次在客户端登陆:
C:\Users\wen>sqlplus sys/oracle@192.168.67.5:1522/oocc as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 13 14:29:44 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
Enter user-name:
ERROR:
ORA-12560: TNS:protocol adapter error
修改参数等于none后,只能通过操作系统认证