Preparing to Use Password File Authentication with ORAPWD:
The syntax of the ORAPWD command is as follows:
ORAPWD FILE=filename [ENTRIES= numusers ] [FORCE={Y|N}] [IGNORECASE={Y|N}]
PS:UNIX and Linux: orapwORACLE_SID ORACLE_HOME/dbs
Windows: PWDORACLE_SID .ora ORACLE_HOME\database
For example: 1. mv orapwda orapwda.bak
2.shutdown database
3.$ orapwd file=orapwda entries=100
4.restart database
ENTRIES(Optional): Maximum number of entries (user accounts) to permit in the file.
FORCE (Optional):If y, permits overwriting an existing password file.
IGNORECASE (Optional):If y, passwords are treated as case-insensitive