Was trying to setup a simple db link between a 10gR2(10.2.0.3) db and a 11gR2 db and the select query fails with
SQL> select sysdate from dual@linka;
select sysdate from dual@linka
*
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from LINKA
The credentials work fine on the target 11g db from sqlplus, so no typo issue.
A quick fix that worked is to enclose the db link password in "double quotes".
So the solution is to
- drop the db link
- recreate using 'create database link LINKA connect to username identified by "xxxx" using 'connect string';
and the select query worked just fine.
A quick search on metalink revealed (note:473716.1) this behaviour is due to the case sensitive logon feature enabled on the 11g side using SEC_CASE_SENSITIVE_LOGON parameter set to TRUE.
