To create a password file, you use a very simple command-line utility named orapwd. You run orapwd from the operating system command prompt,
and pass in three pieces of information as arguments to the command. The syntax for orapwd looks like this:
The value for the entries parameter is used to size the password file. Each entry takes up a fixed amount of space. The file is then created large
enough to accommodate the number of entries that you specify. This number represents the maximum number of users to whom you will be able to grant
SYSOPER privileges. Be generous with the number of users you allow for. Password files arent that big to begin
with, so space is not an issue here.
Strictly speaking, the entries parameter is optional, but under most circumstances you should use it. If you leave it off, the password file will
only be large enough to hold passwords for the
INTERNAL users, forcing all remote DBAs to share those passwords.
Thats not a very secure solution.
Click the Quiz link below to test your knowledge of the details of creating a password file.
Creating Password File - Quiz