oracle dblink ora-28000

   刚开发反馈使用dblink报账号被锁定，第一次听说。

SQL> CREATE  shared  DATABASE LINK db_link_t_031

CONNECT TO itzc_gd identified by itzc_gd
authenticated by l_developer identified by l_developer
USING '10.10.5.55:1521/oradb10';

SQL> select * from dual@db_link_t_031;
select * from dual@db_link_t_031
                   *
第 1 行出现错误:
ORA-28000: 帐户已被锁定

是authenticated by的用户弄错了，这个需要远程库的用户。

SQL> drop  DATABASE LINK db_link_t_031;

SQL> CREATE  shared  DATABASE LINK db_link_t_031
CONNECT TO itzc_gd identified by itzc_gd
authenticated by itzc_gd identified by itzc_gd
USING '10.10.5.55:1521/oradb10';


SQL> select * from dual@db_link_t_031;
D
-
X