Rebuilding the Oracle password file on Linux

In many cases, the Oracle password file needs to be rebuilt. ORACLE has strict requirements on the password file, such as the file name and file name case. Once the ORACLE_SID was case-insensitive for a long time, the record is as follows:

Linux platform:

Orapwd file = $ ORACLE_HOME/dbs/orapw $ ORACLE_SID password = ''entries = n

Note that $ ORACLE_SID is case sensitive.

Sysdba permissions are recorded in the v $ pwfile_users view, and ORA-01994 errors are returned if the password file does not exist

Win platform: orapwd file = $ ORACLE_HOME \ database \ pwd $ ORACLE_SID.ora password = ''entries = n

$ ORACLE_SID is the environment variable. Note the case sensitivity. The password must be consistent with the Database sys password. n indicates the maximum number of users with SYSDBA permissions.