oracle 密码文件 01017,Oracle 密码文件与用户密码的关系

创建一个密码文件然后测试远程登录

#创建一个与SYS用户密码相同的密码文件

[oracle@rhel6 dbs]$ cd $ORACLE_HOME/dbs

[oracle@rhel6 dbs]$ orapwd file=orapworcl entries=3 password=zhaoxu

[oracle@rhel6 dbs]$ ls -l orapworcl

-rw-r----- 1 oracle oinstall 1536 Dec 26 21:32 orapworcl

#测试连接成功

[c:\~]$ sqlplus sys/zhaoxu@192.168.56.2/orcl as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on 星期一 12月 26 21:34:22 2016

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

连接到:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select password from user$ where name='SYS';

PASSWORD

------------------------------------------------------------

C53B64BC84353309

#密码的HASH值没有变化

#创建一个与SYS密码不同的密码文件

[oracle@rhel6 dbs]$ orapwd file=orapworcl entries=3 password=luoxi force=y

[oracle@rhel6 dbs]$ ls -l orapworcl

-rw-r----- 1 oracle oinstall 1536 Dec 26 21:36 orapworcl

#测试连接，使用原密码文件的密码登录不成功，使用新密码文件的密码登录成功，但是SYS用户的密码HASH值仍没有变

[c:\~]$ sqlplus sys/zhaoxu@192.168.56.2/orcl as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on 星期一 12月 26 21:36:20 2016

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

ERROR:

ORA-01017: invalid username/password; logon denied

[c:\~]$ sqlplus sys/luoxi@192.168.56.2/orcl as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on 星期一 12月 26 21:36:30 2016

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

连接到:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select password from user$ where name='SYS';

PASSWORD

------------------------------------------------------------

C53B64BC84353309