Authenticate with REMOTE LOGIN PASSWORDFILE Parameter in Oracle

Remote login passwordfile is specify that need to verify from the password file or OS authentication for login into the Oracle Server.
Default value of parameter is exclusive. For modify the value need to reboot the Oracle Database Server.

Values:EXCLUSIVE: Password file can be used by only one database and having sys or non sys users.SHARED: In this one or more database can used the same Password file and having sys or non sys users.NONE: Oracle use OS authentication. it not consider password file.

3. Change the value of parameter to NONE.
SQL> alter system set remote_login_passwordfile=NONE scope=both;
alter system set remote_login_passwordfile=NONE scope=both
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

SQL> alter system set remote_login_passwordfile=NONE scope=spfile;
System altered.

Note: Check also the parameter NTS or NONE in SQLNET.ora if you are on windows server.
NTS means window authentication
NONE means password file authentication
Otherwise got ERROR:ORA-01031: insufficient privileges
Solution: On Windows if you change remote login passwordfile parameter to NONE then for login you have sqlnet.ora parameter set as NTS value.

Error: “ORA-01031: insufficient privileges”
Invalid username and password from Server or Client Side connectivity issue
One of our customer says he is able to connect from Server side but when he tried to connect from client side he is getting error of “ORA-01031: insufficient privileges”Solution:
1. If you are connecting on Server SQLPLUS then it use SQLNET value as NTS. If you provide sys user name and password on same server
then it connected but if you tried to connect from client side then it give you error.
2. Remote_login_passwordfile parameter to have ‘exclusive’
3. Password file present for the instance where you try to connect it.