Impact of enabling REMOTE_LOGIN_PASSWORDFILE

[Former Member]

Dear Experts,

We have configured the onlite split mirror backup in our production system and it is getting completed with a warning message that pfile cannot be created from spfile in remote OPS$ connect mode in unix platform and for this we need to enable the parameter remote_login_passwordfile to exclusive.

Just want to know what would be the impact of enabling this parameter in live production system. Will there be any security breaches and side effects.

Please let me know asap as we need to enable and appreciate the quick response.

Regards

Sharath

[stefan_koehler]

Hello Sharath,

which database version?

Oracle 10g Documentation:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams179.htm#CHDICDHE

>Note:

>The value EXCLUSIVE is supported for backward compatibility. It now has the same behavior as the value SHARED.

And here the documentation about the password file:

http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/dba.htm#sthref167

Regards

Stefan