Database Link from 10g to 11g fails with ORA-1017 & ORA-2063
(Doc ID 473716.1)
Last updated on JANUARY 18, 2025
Applies to:
Oracle Net Services - Version 9.2.0.1.0 to 11.2.0.3 [Release 9.2 to 11.2]Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Oracle Database - Enterprise Edition - Version 19.4.1.0.0 and later
Information in this document applies to any platform.
Symptoms
Originating Server: Oracle10g R2 (10.2.0.x) on HP-UX 11.11
Remote Server: Oracle11g R1 (11.1.0.6) on Linux RedHat5
Testing a newly created Database Link from Oracle10g to Oracle11g R1 (11.1.0.6) fails with the errors below:
ERROR:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from DEV11R1
Just installed 11g
-- Steps To Reproduce:
SQL> select sysdate from dual@dev11r1;
select sysdba from dual@dev11r1;
*
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from DEV11R1
---
11g database link ORA-01017 ORA-02063 password case sensitivity
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |