Remote_login_passwordfile

SQL> connect sys/oracle@192.168.0.11:1524/oracle as sysdba
ERROR:
ORA-01031: insufficient privileges

when you get this error .. it simply means that your password file is non existent in the DB to which you wanna connect..PHYSICALLY it does not exist...

When you create password file using ORAPWD then you would get the connection made...

SQL> connect sys/oracle@192.168.0.11:1524/oracle as sysdba
Connected........

This is done when remote_login_passwordfile is set to exclusive and PRESENT physically ...
*************************************************************
**************************************************************

Lets say the password file is physically present and you have set remote_login_passwordfile to NONE... you get the following error...

SQL> connect sys/oracle@192.168.0.11:1524/oracle as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied

Now.. if you set it to exclusive like this...

SQL> alter system set remote_login_passwordfile=exclusive scope=spfile;

SQL> connect sys/oracle@192.168.0.11:1524/oracle as sysdba
Connected.

Then it would work again... :-)...