刚开发反馈使用dblink报账号被锁定,第一次听说。
SQL> CREATE shared DATABASE LINK db_link_t_031
CONNECT TO itzc_gd identified by itzc_gdauthenticated 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