| the Password file state in the password file [message #64476] |
Tue, 01 February 2005 03:53  |
kalpin
Messages: 4
Registered: February 2005
|
Junior Member |
|
|
In oracle 9i's database administrator's Guide, page 1-24,the following paragraph describing the password file can be seen:
The password file state is stored in the password file. When you first create a
password file, its default state is SHARED. You can change the state of the password file by setting the initialization parameter REMOTE_LOGIN_PASSWORDFILE. When you start up an instance, Oracle retrieves the value of this parameter from the parameter file stored on your client machine. When you mount the database, Oracle compares the value of this parameter to the value stored in the password file. If the values do not match, Oracle overwrites the value stored in the file.
If you plan to allow instance start up from multiple clients, each of those clients must have an initialization parameter file, and the value of the parameter REMOTE_LOGIN_PASSWORDFILE must be the same in each of these
files.
What i can't understand is that "Oracle retrieves the value of this parameter from the parameter file stored on your client machine." We know that the parameter file such as pfile or spfile is usually stored on the database server side not on the client side. Am i right ?
By the way how can i allow instance start up from multiple clients ? Why the value of the parameter REMOTE_LOGIN_PASSWORDFILE in the clients' initialization parameter file must be the same ?
|
|
|
|
| Re: the Password file state in the password file [message #64493 is a reply to message #64476] |
Wed, 02 February 2005 05:21  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
SPFILEs (like password files) are server side files. However, INIT.ORA files are client side files. Most DBA's store the INIT.ORA file on the server as well because they use that machine as client to startup and shutdown the database.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
