If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

A password file is used to connect a user as sysdba to the database using server manager or to connect internal using svrmgrl. It is not used on client side connections only on server side connections.

The exectuable is ORAPWD, if you open a DOS session and type ORAPWD or ORAPWD80, not sure which is for Win NT it will show you the syntax that must be needed to create a password file and what each switch means.

Password files aren't that important unless yuo have users that can access Server Manager that you don't want to have access because all the needs to be done is for them to type connect internal and they are in with rights to shutdown the database or make major changes.

If you are going to set up a password file you must set Remote_password_file=Exclusive in your inti file and shutdown and restart the database for it to take effect. If not set Remote_password_file=none.

Don't be afraid to try something new. Amateurs built the Ark, professionals built the Titanic

REMOTE_LOGIN_PASSWORDFILE specifies whether Oracle checks for a password file and how many databases can use the password file. Setting the parameter to NONE signifies that Oracle should ignore any password file (and therefore privileged users must be authenticated by the operating system). Setting the parameter to EXCLUSIVE signifies that the password file can be used by only one database and the password file can contain names other than SYS and
INTERNAL. Setting the parameter to SHARED allows more than one database to use a password file. However, the only users recognized by the password file are SYS and INTERNAL.