Oracle Password File: Oracle cipher file

One: File path location

[[Email protected] db_1]$ CD $ORACLE _home/dbs[[email protected] dbs]$ lsdbsorapwPROD1   hc_orcl.dat   Initneworcl.ora  initorcl.ora   lkneworcl  lkPROD1  orapwneworcl  spfileorcl.ora   tem.dbfhc_ Neworcl.dat  hc_prod1.dat  init.ora         initprod1.ora  lkorcl     my.dbf   orapworcl     Spfileprod1.ora[[email protected] dbs]$ Pwd/u01/app/oracle/product/11.2.0/db_1/dbs[[email protected] dbs]$

Second, the password file naming rules

Orapw+sid such as: ORAPWORCL

Third, the password file is stored in the SYS

The key is to store the password information of the administrative user

Select *from v$pwfile_users;

[Email protected]> select * from V$pwfile_users; USERNAME                       sysdb SYSOP sysas---------------------------------------------SYS                            true  true  False[email protected]>

Four: experimental operation

1) when Remote_login_passwordfile is EXCLUSIVE

No Sqlnet.ora files   sqlplus sys/oracle as Sysdba    sqlplus/as sysdba    sqlplus sys/[email protected] as sysdba< c12/> and above are successful

2) when Remote_login_passwordfile is EXCLUSIVE

    Sqlnet.ora file parameter     sqlnet. Authentication_services=none    sqlplus sys/oracle as Sysdba  success   sqlplus/as           sysdba   unsuccessful Sqlplus sys/ [email protected] as SYSDBA   success

3) when Remote_login_passwordfile is EXCLUSIVE

   Sqlnet.ora file parameter     sqlnet. Authentication_services=all    sqlplus sys/oracle as Sysdba  success Sqlplus/as sysdba           Success   Sqlplus Sys/[email protected] as SYSDBA   unsuccessful

4) When Remote_login_passwordfile is none no Sqlnet.ora file

   Sqlplus Sys/oracle as Sysdba  success   sqlplus/as sysdba           success   sqlplus Sys/[email protected] as SYSDBA   unsuccessful

5) When Remote_login_passwordfile is None

   Sqlnet.ora file parameter     sqlnet. Authentication_services=none   Sqlplus sys/oracle as sysdba unsuccessful   sqlplus/as sysdba   unsuccessful Sqlplus Sys/[email protected] as SYSDBA   unsuccessful

6) When Remote_login_passwordfile is None

   Sqlnet.ora file parameter     sqlnet. Authentication_services=all    sqlplus sys/oracle as Sysdba  success Sqlplus/as sysdba           success   Sqlplus sys/[ Email protected] as SYSDBA unsuccessful   

V. Create a password file

Orapwd file= Password file name password= user password

——————————————————————————————————————————————————————————————————

Oracle Password File: Oracle cipher file