Oracle Database Link连接错误

案例环境：

NODE1：

操作系统： Linux EL5

Oracle：   Oracle 10gR2

NODE2：

操作系统： Linux EL5

Oracle：   Oracle 11gR2

案例：

    在node1创建到node的database link：

[oracle@rh55 admin]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 8 16:45:01 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

16:45:02 SYS@ test1asm>create public database link prod

16:45:15   2  connect to scott identified by tiger using 'prod2';

Database link created.

   在连接node2时出现以下错误：

17:32:00 SYS@ test1asm>select * from emp@prod;

select * from emp@prod

                  *

ERROR at line 1:

ORA-01017: invalid username/password; logon denied

ORA-02063: preceding line from PROD

--用户名和密码连接错误

1、确认在node2上的用户名、密码没有问题。

2、tnsnames配置没有问题

PROD2 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.8.24)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = prod)

    )

  )

解决方法：

在创建db-link时，将用户密码用“”引起！

17:37:21 SYS@ test1asm>create public database link prod

17:38:12   2  connect to scott identified by "tiger" using 'prod2';

Database link created.

17:38:23 SYS@ test1asm>select * from emp@prod;

 @至此，问题得以解决！