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