ORA-02065 using remote_login_passwordfile=EXCLUSIVE

If you are trying to setup an Oracle instance for running OWB then you will need to set the remote_login_passwordfile to EXCLUSIVE in order for that to work. Using SQLPLUS connect to the instance and change the setting like this:

> sqlplus /nolog

SQL> connect / as sysdba

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

that should do the trick although you will need to bounce the instance before it will take effect.

You may also need to re-generate the sys password file like this:

SQL> orapwd file=orapwinst password=pwd123 force=y