[Password File loss-restore-1], password loss-1

[Password File loss-restore-1], password loss-1

Use oracle10g as the test version to delete the 10g password file:

[Oracle @ oracle ~] $ Rm/u01/oracle/10g/dbs/orapwjadl10g

Log on to the database remotely, and the password file will only take effect during Remote Logon: (Remote logon cannot connect to the database at this time)

[Oracle @ oracle ~] $ Sqlplus sys/123456@192.168.1.187: 1521/jadl10g as sysdba


SQL * Plus: Release 10.2.0.5.0-Production on Thu Nov 6 09:11:13 2014


Copyright (c) 1982,201 0, Oracle. All Rights Reserved.


ERROR:
ORA-01031: insufficient privileges

Enter user-name:

Run the following command to create a 10 Gb password file:

[Oracle @ oracle ~] $10g

[Oracle @ oracle ~] $ Orapwd file = $ ORACLE_HOME/dbs/orapwjadl10g password = 123456 force = y;

After the database is created, log on to the database remotely and find that the database can be connected:

[Oracle @ oracle ~] $ Sqlplus sys/123456@192.168.1.187: 1521/jadl10g as sysdba


SQL * Plus: Release 10.2.0.5.0-Production on Thu Nov 6 09:13:07 2014


Copyright (c) 1982,201 0, Oracle. All Rights Reserved.




Connected:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engine
And Real Application Testing options


SQL>


11g added an ignorecase to determine whether to distinguish uppercase;
Orapwd file = $ ORACLE_HOME/dbs/orapwjadl10g password = 123456 force = y ignorecase = true/false;
12c
Orapwd file = $ ORACLE_HOME/dbs/orapwjadl10g password = 123456 force = y format = 12 sysbackup = y syskm = y sysdg = y;
Set three passwords. Note that 12c has several more privileged users. You can execute the following SQL statement to compare the differences between the three versions of 10g/11g/12c:

Select * from v $ pwfile_users;

The pdb of 12c does not have a password file, and only cdb has a password file.