数据库链接-用户名/密码无效

Question

我的计算机上有两个数据库: orcl和orcl1。

在orcl1中，我创建了以下数据库链接：

create public database link remote_connect
connect to system identified by ***
using 'orcl';

然后，我运行以下查询：

SQL> select * from test@remote_connect;
select * from test@remote_connect
                   *
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from REMOTE_CONNECT

当我使用用户名和密码登录orcl时，我已确保它们是正确的。问题出在哪里?我能做些什么来解决它？

编辑：

在orcl1目录中，我的tnsnames.ora文件如下所示：

ORCL1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl1)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl1)
    )
  )

在orcl目录下，我的tnsnames.ora文件如下所示：

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

ORCL1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

Answer 1

您可能会发现使用简单的connect语法比使用TNS别名更简单，因为使用这些别名似乎会使您不清楚您实际连接的是哪个数据库。

你可以这样做：

create public database link remote_connect
connect to system identified by ***
using '//localhost:1521/orcl';