How important is the password file in order to connect to an oracle database from the client. How does it get created and what name does it have? How do i create it.
Also, i find the entry in the init.ora file "Remote_password_file=Exclusive" and in some cases
what do they mean?
Sorry, forgot to mention,
i am using oracle 8.0.4 on Win NT with Sp6.
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.
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.