Database Link 10g 11g Fails ORA-01017
When I was testing a database link between a 10g database and an 11g databaase, i got ORA-01017: invalid username/password; logon denied followed by ORA-02063: preceding line from dblink11g.
A database link is a schema object in one database that enables you to access objects on another database. The other database does not need to be an Oracle Database system. However, to access non-Oracle systems you must use Oracle Heterogeneous Services.
Today I was trying to create a database link between a 10g r2 database on RHEL 5 and a Oracle 11g R1 on RHEL 5.
CREATE DATABASE LINK dblink11g CONNECT TO myuser IDENTIFIED BY MyPass1 USING 'db11.domain.com';
When I was testing it I got this:
SQL> select sysdate from dual@dblink11g; select sysdba from dual@dblink11g; * ERROR at line 1:ORA-01017: invalid username/password; logon denied ORA-02063: preceding line from dblink11g
After a little research I found that 11g R1 passwords are case sensitive by default.
So to solve this in the origin server (10g), I just droped the database link and recreate it using double quotes on the password at the IDENTIFIED BY clause:
SQL> DROP DATABASE LINK dblink11g; SQL> CREATE DATABASE LINK dblink11g SQL> CONNECT TO myuser IDENTIFIED BY "MyPass1" USING 'db11.domain.com';
The other option is to disable password case sensitivity in the destination 11g database by setting SEC_CASE_SENSITIVE_LOGON to FALSE.
SQL> ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE SCOPE=BOTH;
Problem solved… for you too i hope 🙂