ITPub博客

首页 > Linux操作系统 > Linux操作系统 > about job and MATERIALIZED VIEW issue

about job and MATERIALIZED VIEW issue

原创 Linux操作系统 作者:lorikyo 时间:2019-05-21 16:24:05 0 删除 编辑

ORA-12012: error on auto execute of job 5717
ORA-12537: TNS:connection closed~
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2254
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2460
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2429
ORA-06512: at line 1

SQL> select SCHEMA_USER,WHAT from dba_jobs where job=5717 AND BROKEN='N';

SCHEMA_USER WHAT
-------------------- ----------------------------------------
ACNTV dbms_mview.refresh('CREDIT_CARD','F');


select OWNER, OBJECT_NAME ,OBJECT_TYPE from dba_objects WHERE OBJECT_NAME='CREDIT_CARD';


OWNER OBJECT_NAME OBJECT_TYPE
-------------------- ------------------------------ -------------------
WNOUR CREDIT_CARD TABLE
ACNTV CREDIT_CARD TABLE
ACNTV CREDIT_CARD MATERIALIZED VIEW

 

SQL> set long 32767
SQL> SELECT MVIEW_NAME, QUERY FROM dba_MVIEWS WHERE MVIEW_NAME='CREDIT_CARD';

MVIEW_NAME
------------------------------
QUERY
--------------------------------------------------------------------------------
CREDIT_CARD
SELECT "NOLOGGING"."MOP_ID" "MOP_ID","NOLOGGING"."CARD_TYPE" "CARD_TYPE","NOLOGG
ING"."CARD_NUMBER" "CARD_NUMBER","NOLOGGING"."LAST4_DISPLAY" "LAST4_DISPLAY",
"NOLOGGING"."EXP_DATE" "EXP_DATE","NOLOGGING"."CC_PHONE" "CC_PHONE",
"NOLOGGING"."IS_DEFAULT" "IS_DEFAULT"
FROM "MOP"."CREDIT_CARD"@XX.XXX.COM "NOLOGGING"

We found this job is auto refresh MATERIALIZED VIEW "CREDIT_CARD" depend CONNECT remote database XX.XXXX.COM
 ORA-12537: TNS:connection closed
SO I think it maybe network error caused of this problem. If this error occured only once, we maybe able to ignore it.
if this frequent occurrence, we need check the communications network between two database OR do further research !

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/92530/viewspace-374374/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: AGENT IS UNREACHABLE
请登录后发表评论 登录
全部评论

注册时间:2004-07-18

  • 博文量
    211
  • 访问量
    189699