--转载
一、11g口令文件11g 命令orapwd有参数ingnorecase，控制口令文件密码大小写是否敏感：
[oracle@shanxi ~]$ orapwd
Usage: orapwd file=
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=
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博客 ” ，链接：https://blog.itpub.net/196700/viewspace-759103/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
11g内存的设定
请登录后发表评论
登录
全部评论
