10g、11g口令文件密码大小写敏感

--转载

一、 11g 口令文件
11g 命令orapwd 有参数ingnorecase ，控制口令文件密码大小写是否敏感：

[oracle@shanxi ~]$ orapwd
Usage: orapwd file= entries= force= ignorecase= nosysdba=

  where
    file - name of password file (required),
    password - password for SYS will be prompted if not specified at command line,
    entries - maximum number of distinct DBA (optional),
    force - whether to overwrite existing file (optional),
    ignorecase - passwords are case-insensitive (optional),
    nosysdba - whether to shut out the SYSDBA logon (optional Database Vault only).
   
  There must be no spaces around the equal-to (=) character.

（1）大小写敏感： ignorecase = n（也是缺省情况）
orapwd file=orapwPROD password=YITAi entries=3 force=y     nosysdba=n
等效于：
orapwd file=orapwPROD password=YITAi entries=3 force=y    ignorecase=n  nosysdba=n
[oracle@shanxi ~]$  sqlplus sys/ yitai @221.XXX.XXX.XXX/PROD as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 15 11:47:39 2013

Copyright (c) 1982, 2009,  Oracle .  All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied


Enter user-name:


[oracle@shanxi ~]$  sqlplus sys/YITAi@221.XXX.XXX.XXX/PROD as sysdba      

SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 15 11:48:13 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

11:48:13  SQL [ SYS ] >

也就是11g缺省情况下，口令文件密码是大小写敏感的。


(2) 大小写不敏感： ignorecase=y
必须显式控制，因为缺省是ingnorecase=n

[oracle@shanxi ~]$  sqlplus sys/ yitai @221.204.237.110/PROD as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 15 11:51:16 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

11:51:16 SQL[ SYS ] >


[oracle@shanxi ~]$  sqlplus sys/ YITAi @221.XXX.XXX.XXX/PROD as sysdba    

SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 15 11:51:46 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

11:51:47 SQL[ SYS ] >


(2) 10g :

10g 命令orapwd 没有 可以控制大小写敏感的参数，因此口令文件密码大小写是不敏感的：

[oracle@center-rac1 ~]$orapwd
Usage: orapwd file= password= entries= force= nosysdba=

  where
    file - name of password file (mand),
    password - password for SYS (mand),
    entries - maximum number of distinct DBA,
    force - whether to overwrite existing file (opt),
    nosysdba - whether to shut out the SYSDBA logon (opt for Database Vault only).
  There are no spaces around the equal-to (=) character

[oracle@center-rac1 ~]$sqlplus sys/ YITAI @192.XXX.XXX.XXX/wxxridx as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Mon Apr 15 11:56:44 2013

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


[oracle@center-rac1 ~]$sqlplus sys/ yitai @192.XXX.XXX.XXX/wxxridx as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Mon Apr 15 11:57:53 2013

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>     
SQL>


10g中，没有大小写敏感参数控制，所以密码无论大小写都能登陆。

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

转载于:http://blog.itpub.net/196700/viewspace-759103/