如何验证oracle 密码是什么,如何使用密码文件验证的方法连接数据库

1)创建密码文件：

[oracle@test dbs]$ orapwd file=orapwtestdb password=admin entries=5

注意：这个file默认的文件名是orapwSID，对于别的文件名是不认的。

同时还须将remote_login_passwordfile的值设成如下：

[oracle@test dbs]$ grep -i remote inittestdb.ora *.remote_login_passwordfile='EXCLUSIVE'

2)先用OS验证的方法连接数据库,并重启数据库才能使密码文件生效。

[oracle@test admin]$ cat sqlnet.ora

# sqlnet.ora Network Configuration File: /u01/app/oracle/oracle/product/10.2.0/db_3/network/admin/sqlnet.ora

# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES=BEQ ----->这样就可以以本地验证的方式连DB。NAMES.DIRECTORY_PATH= (TNSNAMES,hostname)

trace_level_client=16

trace_timestamp_client=true

trace_unique_client=true

[oracle@test admin]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Aug 30 05:12:58 2009

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

SQL> conn testdb as sysdba

Enter password:

Connected.

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area  167772160 bytes

Fixed Size                  1218316 bytes

Variable Size              62916852 bytes

Database Buffers          100663296 bytes

Redo Buffers                2973696 bytes

Database mounted.

Database opened.

3)修改sqlnet.ora 改成不使用OS验证。

[oracle@test admin]$ cat sqlnet.ora

# sqlnet.ora Network Configuration File: /u01/app/oracle/oracle/product/10.2.0/db_3/network/admin/sqlnet.ora

# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES=noneNAMES.DIRECTORY_PATH= (TNSNAMES,hostname)

trace_level_client=16

trace_timestamp_client=true

trace_unique_client=true

4)现在可以用刚才创建的密码来连DB了。

[oracle@test admin]$ sqlplus as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Aug 30 05:21:51 2009

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

Enter password:

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL> select * from V$PWFILE_USERS;

USERNAME                       SYSDB SYSOP

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

SYS                            TRUE  TRUE

SQL> show parameter pass;

NAME                                 TYPE        VALUE

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

remote_login_passwordfile            string      EXCLUSIVE

我们用上面的sql还查出了目前有几个用户可以使用密码文件来连DB。