暂无图片
job运行失败
我来答
分享
许玉冲
2020-06-30
job运行失败

tail -50 alert_orcl1.log
Tue Jun 30 10:01:47 2020
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_cjq0_101763.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_cjq0_101763.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
Tue Jun 30 10:01:57 2020
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_cjq0_101763.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_cjq0_101763.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
Tue Jun 30 10:02:07 2020
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_cjq0_101763.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_cjq0_101763.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
Tue Jun 30 10:02:17 2020
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_cjq0_101763.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
ORA-21780: Maximum number of object durations exceeded.
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_cjq0_101763.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
Tue Jun 30 10:02:27 2020
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_cjq0_101763.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_cjq0_101763.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
Tue Jun 30 10:02:38 2020
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_cjq0_101763.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_cjq0_101763.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
Tue Jun 30 10:02:48 2020
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_cjq0_101763.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_cjq0_101763.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

我来答
添加附件
收藏
分享
问题补充
7条回答
默认
最新
许玉冲

tail -100 /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_cjq0_101763.trc:
tail: cannot open `/u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_cjq0_101763.trc:’ for reading: No such file or directory
[oracle@rac01 trace]$ tail -100 /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_cjq0_101763.tr
orcl1_cjq0_101763.trc orcl1_cjq0_101763.trm
[oracle@rac01 trace]$ tail -100 /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_cjq0_101763.trc
SCHED 2020-06-30 10:02:12.791 1 101763 CJQ0 : RLB: Error during duration begin
SCHED 2020-06-30 10:02:12.791 1 101763 CJQ0 : RLB: Error is 21780, message is ORA-21780: Maximum number of object durations exceeded.
SCHED 2020-06-30 10:02:12.791 1 101763 CJQ0 : Scheduler Load Balance Check: error 21780 was raised

*** 2020-06-30 10:02:17.838
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-30 10:02:22.886
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-30 10:02:27.934
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-30 10:02:32.982
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-30 10:02:38.029
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-30 10:02:43.073
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-30 10:02:48.117
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-30 10:02:53.165
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-30 10:02:58.212
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-30 10:03:03.260
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-30 10:03:08.307
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-30 10:03:08.339
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-30 10:03:13.387
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
SCHED 2020-06-30 10:03:13.387 1 101763 CJQ0 : RLB: Error during duration begin
SCHED 2020-06-30 10:03:13.387 1 101763 CJQ0 : RLB: Error is 21780, message is ORA-21780: Maximum number of object durations exceeded.
SCHED 2020-06-30 10:03:13.387 1 101763 CJQ0 : Scheduler Load Balance Check: error 21780 was raised

*** 2020-06-30 10:03:18.550
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-30 10:03:23.599
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-30 10:03:28.646
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-30 10:03:33.691
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-30 10:03:38.738
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-30 10:03:43.786
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-30 10:03:48.835
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-30 10:03:53.882
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-30 10:03:58.930
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-30 10:04:03.979
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

暂无图片 评论
暂无图片 有用 0
许玉冲

/u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_cjq0_101763.trc
Trace file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_cjq0_101763.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1
System name: Linux
Node name: rac01
Release: 2.6.32-504.el6.x86_64
Version: #1 SMP Tue Oct 14 01:47:47 PDT 2014
Machine: x86_64
Instance name: orcl1
Redo thread mounted by this instance: 1
Oracle process number: 120
Unix process pid: 101763, image: oracle@rac01 (CJQ0)

*** 2020-06-29 16:10:59.505
*** SESSION ID:(2162.49579) 2020-06-29 16:10:59.505
*** CLIENT ID:() 2020-06-29 16:10:59.505
*** SERVICE NAME:(SYS$BACKGROUND) 2020-06-29 16:10:59.505
*** MODULE NAME:() 2020-06-29 16:10:59.505
*** ACTION NAME:() 2020-06-29 16:10:59.505

*** TRACE FILE RECREATED AFTER BEING REMOVED ***

*** 2020-06-29 16:10:59.505
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:11:04.541
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:11:09.576
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:11:14.611
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:11:19.646
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:11:24.681
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:11:29.717
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:11:34.752
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
SCHED 2020-06-29 16:11:34.752 1 101763 CJQ0 : RLB: Error during duration begin
SCHED 2020-06-29 16:11:34.752 1 101763 CJQ0 : RLB: Error is 21780, message is ORA-21780: Maximum number of object durations exceeded.
SCHED 2020-06-29 16:11:34.752 1 101763 CJQ0 : Scheduler Load Balance Check: error 21780 was raised

*** 2020-06-29 16:11:39.787
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:11:44.822
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:11:49.857
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:11:54.892
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:11:54.917
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:11:59.952
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:12:04.987
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:12:10.022
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:12:15.118
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:12:20.156
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:12:25.192
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:12:30.228
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:12:35.264
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
SCHED 2020-06-29 16:12:35.265 1 101763 CJQ0 : RLB: Error during duration begin
SCHED 2020-06-29 16:12:35.265 1 101763 CJQ0 : RLB: Error is 21780, message is ORA-21780: Maximum number of object durations exceeded.
SCHED 2020-06-29 16:12:35.265 1 101763 CJQ0 : Scheduler Load Balance Check: error 21780 was raised

*** 2020-06-29 16:12:40.302
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:12:45.337
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:12:50.373
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:12:55.409
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:13:00.445
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:13:05.480
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:13:10.517
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:13:15.552
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:13:20.588
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:13:25.624
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:13:30.660
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:13:35.696
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:13:35.721
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
SCHED 2020-06-29 16:13:35.721 1 101763 CJQ0 : RLB: Error during duration begin
SCHED 2020-06-29 16:13:35.721 1 101763 CJQ0 : RLB: Error is 21780, message is ORA-21780: Maximum number of object durations exceeded.
SCHED 2020-06-29 16:13:35.721 1 101763 CJQ0 : Scheduler Load Balance Check: error 21780 was raised

*** 2020-06-29 16:13:40.757
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:13:45.793
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:13:50.830
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:13:55.866
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:14:00.902
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:14:05.938
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:14:10.974
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:14:16.011
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:14:21.047
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:14:26.083
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:14:31.119
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:14:36.155
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
SCHED 2020-06-29 16:14:36.156 1 101763 CJQ0 : RLB: Error during duration begin
SCHED 2020-06-29 16:14:36.156 1 101763 CJQ0 : RLB: Error is 21780, message is ORA-21780: Maximum number of object durations exceeded.
SCHED 2020-06-29 16:14:36.156 1 101763 CJQ0 : Scheduler Load Balance Check: error 21780 was raised

*** 2020-06-29 16:14:41.193
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:14:46.229
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:14:51.265
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:14:56.301
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:15:01.337
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:15:06.374
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:15:11.410
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:15:16.446
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:15:16.470
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:15:21.505
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:15:26.541
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:15:31.576
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:15:36.612
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
SCHED 2020-06-29 16:15:36.613 1 101763 CJQ0 : RLB: Error during duration begin
SCHED 2020-06-29 16:15:36.613 1 101763 CJQ0 : RLB: Error is 21780, message is ORA-21780: Maximum number of object durations exceeded.
SCHED 2020-06-29 16:15:36.613 1 101763 CJQ0 : Scheduler Load Balance Check: error 21780 was raised

*** 2020-06-29 16:15:41.649
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:15:46.686
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

*** 2020-06-29 16:15:51.722
ORA-00604: error occurred at recursive SQL level 1
ORA-21780: Maximum number of object durations exceeded.

暂无图片 评论
暂无图片 有用 0
肖杰

把job内容贴出来啊,写了死循环了吧?

暂无图片 评论
暂无图片 有用 0
文成

可以在墨天轮搜索一下,相关的文章有很多
Troubleshooting ORA-21780 during SMON to clean transient type

暂无图片 评论
暂无图片 有用 0
沈宏

找到job对应的PL/SQL代码,进行代码审查

暂无图片 评论
暂无图片 有用 0
许玉冲

批注 20200630 170640.png

暂无图片 评论
暂无图片 有用 0
许玉冲

用户相关jOB,和schedul 已经停止运行。

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏