Password File Authentication
Dear All,
In case of three data base and password file authentication I have following confusion.
1. If remote_login_passwordfile=EXCLUSIVE.
We have to create two password file for 3 database. How Oracle identified through which password file SYS's password will be authenticated? i.e. based on orapwd ? (file name of password file).
Will it always look at $ORACLE_HOME/dbs directory ? can we change that location ?
2. If remote_login_passwordfile=SHARED
Only one password files for multiple instances. If there are three instances are there. In two instances I am using remote_login_passwordfile=SHARED and in one instance remote_login_passwordfile=EXCLUSIVE. So there will be two password files. One for Shared and second will be for only one instance. How oracle will identify?
Thanks in advance.
Nirav