Oracle Create Dblink Error: ORA-01017, ORA-02063 resolution

Oracle Environment: The public dblink that Oracle 10.2.0.1 creates connects Oracle 11.2.0.3

Ora-01017:invalid Username/password; Logon denied ora-02063:preceding line from

I. Creating Dblink

Create Public database link dmz63

Connect to XYY identified by XYY

Using ' (DESCRIPTION = (Address_list = (address = (PROTOCOL = 10.0.0.1) (HOST = 192.xxx.xxx.xxx) (PORT = 2261)) (Connect_data = (service_name = XYY))) ';

Two. When you create a dblink, you are prompted with the following error:

SELECT * FROM dual@dmz63

The error is as follows:

Ora-01017:invalid Username/password; Logon denied

Ora-02063:preceding Line from

Third, the problem analysis:

According to ORA-01017 's prompt is connected to the other side of the user password error, so directly using the configured user password (LSXY/LSXY) login database to find normal login, further view the established Dblink statements, where the user names converted to uppercase, This guesses whether the password has also been converted to uppercase, resulting in a password error.

According to the speculation Baidu, there is indeed such a situation. When a 9i or 10g version of the Oracle database is connected to the 11g version, the password is automatically converted to uppercase.

Iv. Solutions:

We'll rewrite the Dblink creation statement slightly, as follows:

Enclose the password in double quotes

Create Public database link dmz63

Connect to XYY identified by "XYY"

Using ' (DESCRIPTION = (Address_list = (address = (PROTOCOL = TCP) (HOST = 10.0.0.1) (PORT = 2261)) (Connect_data = (service_na ME = XYY)) ';