【深度解析】偶遇ORA-02020错误

Error: ORA-04052: 在查找远程对象 IRMS20.T_ORDER_HUIZONG@JIAKELINK 时出错     

       ORA-00604: 递归 SQL 级别 1 出现错误       

       ORA-02020: 过多的数据库链接在使用中

[oracle@sddwdb1 ~]$ oerr ora 202002020, 00000, "too many database links in use"// *

Cause:  The current session has exceeded the INIT.ORA open_links maximum.// *

Action: Increase the open_links limit, or free up some open links by//

committing or rolling back the transaction and canceling open//          

cursors that reference remote databases.

zynx=(DESCRIPTION=
    (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521))
        (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521))
     )
     (CONNECT_DATA =
           (SERVER = DEDICATED)
           (SERVICE_NAME = xxx)
     )
  )

dw =(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521))
    (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = xxx)
     )
  )

kf =(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521))
    (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = xxx)
     )
  )

sms =(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521))
    (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = xxx)
    )
  )

sjfx =(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521))
    (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = xxx)
     )
  )

create user zjtest identified by zj_TEST_0107  account unlock default tablespace users;

grant dba to ZJTEST;

create public database link zynxtest connect to zjtest identified by "zj_TEST_0107" using 'zynx';

create public database link dwtest connect to zjtest identified by "zj_TEST_0107" using 'dw';

create public database link kftest connect to zjtest identified by "zj_TEST_0107" using 'kf';

create public database link smstest connect to zjtest identified by "zj_TEST_0107" using 'sms';

create public database link sjfxtest connect to zjtest identified by "zj_TEST_0107" using 'sjfx';

select table_name from user_tables@zynxtest

union allselect table_name from user_tables@dwtest

union allselect table_name from user_tables@kftest

union allselect table_name from user_tables@smstest

union allselect table_name from user_tables@sjfxtest

drop user ZJTEST cascade;

drop public database link zynxtest;

drop public database link sjfxtest;

drop public database link dwtest;

drop public database link kftest;

drop public database link smstest;