ORA-01017/ORA-02063 DbLink build Error Problem Analysis and Solution

Fault description:

The following error occurs when I establish a DBLINK verification connection to 11.2.0.3 in Oracle10.2.0.4:

ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from

Analysis Error:

According to the error message, the user name and password are incorrect, but I am sure there is no problem with the user name and password. I can access the database using the password.

The detailed review and troubleshooting ideas are as follows:

The user/password used to create dblink is correct.

SQL> conn prudent/woo @ woo
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.3.0
Connected as woo
Create the dblink database version:

SQL> select * from V $ VERSION;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0-64bi
PL/SQL Release 10.2.0.4.0-Production
CORE 10.2.0.4.0 Production

TNS for Linux: Version 10.2.0.4.0-Production
NLSRTL Version 10.2.0.4.0-Production

 

DBLINK of ORACLE 11.2.0.3.0 is created in Oracle 10.2.0.4.

SQL> create database link woo_100
2 connect to prudent
3 identified by woo
4 using '(DESCRIPTION =
5 (ADDRESS_LIST =
6 (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.0.100) (PORT = 1521 ))
7)
8 (CONNECT_DATA =
9 (SERVER = DEDICATED)
10 (SID = woo)
11)
12 )';

However, an error occurred while using dblink to access the target database.
QL> select sysdate from dual @ woo;
Select sysdate from dual @ woo

ORA-01017: invalid username/password; logondenied
ORA-02063: preceding line from woo_100

1 2 Next Page