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