exists ora oracle,[已解决]！！！ORA-08103: object no longer exists

最新推荐文章于 2023-10-24 07:30:00 发布

转载最新推荐文章于 2023-10-24 07:30:00 发布 · 923 阅读

标签

#exists ora oracle

本文记录了Oracle数据库中出现的一系列错误，包括ORA-00600内部错误、ORA-00604递归SQL级别错误及ORA-08103对象不存在等，并涉及多个后台进程和定时任务触发的异常。

开发板推荐：天空星STM32F407VET6开发板

超高性价比 STM32主控 | 超高主频 | 一板兼容百芯 | 比赛神器 | 沉金彩色丝印

点击查看

alter.log:

ORA-00604: error occurred at recursive SQL level 1

ORA-08103: object no longer exists

Sat Oct 25 08:02:35 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j003_26775.trc:

ORA-12012: error on auto execute of job 184

ORA-08103: object no longer exists

Sat Oct 25 08:02:35 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j003_26775.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-08103: object no longer exists

Sat Oct 25 08:02:48 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j003_26775.trc:

ORA-12012: error on auto execute of job 205

ORA-08103: object no longer exists

Sat Oct 25 08:02:48 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j003_26775.trc:

ORA-12012: error on auto execute of job 208

ORA-08103: object no longer exists

Sat Oct 25 08:02:49 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j006_26781.trc:

ORA-12012: error on auto execute of job 183

ORA-08103: object no longer exists

Sat Oct 25 08:02:49 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j006_26781.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-08103: object no longer exists

Sat Oct 25 08:04:46 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j000_26037.trc:

ORA-00600: internal error code, arguments: [4042], [136], [], [], [], [], [], []

Sat Oct 25 08:04:47 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j000_26037.trc:

ORA-00600: internal error code, arguments: [4042], [136], [], [], [], [], [], []

Sat Oct 25 08:04:48 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j000_26037.trc:

ORA-00600: internal error code, arguments: [4042], [136], [], [], [], [], [], []

Sat Oct 25 08:04:50 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j000_26037.trc:

ORA-00600: internal error code, arguments: [4042], [136], [], [], [], [], [], []

Sat Oct 25 08:04:51 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j003_26775.trc:

ORA-12012: error on auto execute of job 182

ORA-08103: object no longer exists

Sat Oct 25 08:04:51 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j001_26773.trc:

ORA-12012: error on auto execute of job 210

ORA-08103: object no longer exists

Sat Oct 25 08:04:51 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j001_26773.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-08103: object no longer exists

Sat Oct 25 08:04:51 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j000_26037.trc:

ORA-00600: internal error code, arguments: [4042], [136], [], [], [], [], [], []

Sat Oct 25 08:04:52 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j000_26037.trc:

ORA-00600: internal error code, arguments: [4042], [136], [], [], [], [], [], []

Sat Oct 25 08:04:54 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j000_26037.trc:

ORA-00600: internal error code, arguments: [4042], [136], [], [], [], [], [], []

Sat Oct 25 08:04:55 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j000_26037.trc:

ORA-00600: internal error code, arguments: [4042], [136], [], [], [], [], [], []

Sat Oct 25 08:04:56 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j000_26037.trc:

ORA-00600: internal error code, arguments: [4042], [136], [], [], [], [], [], []

Sat Oct 25 08:04:58 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j000_26037.trc:

ORA-00600: internal error code, arguments: [4042], [136], [], [], [], [], [], []

Sat Oct 25 08:04:59 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j000_26037.trc:

ORA-00600: internal error code, arguments: [4042], [136], [], [], [], [], [], []

Sat Oct 25 08:06:28 2008

Restarting dead background process QMN0

QMN0 started with pid=15

Sat Oct 25 08:06:54 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j005_26924.trc:

ORA-12012: error on auto execute of job 183

ORA-08103: object no longer exists

Sat Oct 25 08:06:54 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j005_26924.trc:

ORA-12012: error on auto execute of job 101

ORA-08103: object no longer exists

ORA-06512: at "SYS.DBMS_LOCK", line 209

ORA-06512: at "SYS.DBMS_LOCK", line 214

ORA-06512: at "SYS.DBMS_DEFER_SYS", line 2810

ORA-06512: at line 1

Sat Oct 25 08:06:54 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j005_26924.trc:

ORA-12012: error on auto execute of job 185

ORA-08103: object no longer exists

Sat Oct 25 08:06:54 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j005_26924.trc:

ORA-12012: error on auto execute of job 182

ORA-08103: object no longer exists

Sat Oct 25 08:06:54 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j015_26940.trc:

ORA-12012: error on auto execute of job 212

ORA-08103: object no longer exists

Sat Oct 25 08:06:54 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j015_26940.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-08103: object no longer exists

Sat Oct 25 08:06:57 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j011_26934.trc:

ORA-12012: error on auto execute of job 208

ORA-08103: object no longer exists

Sat Oct 25 08:06:57 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j011_26934.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-08103: object no longer exists

Sat Oct 25 08:07:07 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_smon_8557.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-08103: object no longer exists

Sat Oct 25 08:07:44 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j010_26932.trc:

ORA-12012: error on auto execute of job 181

ORA-08103: object no longer exists

Sat Oct 25 08:07:44 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j010_26932.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-08103: object no longer exists

Sat Oct 25 08:07:55 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j016_26942.trc:

ORA-12012: error on auto execute of job 182

ORA-08103: object no longer exists

Sat Oct 25 08:07:55 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j008_26928.trc:

ORA-12012: error on auto execute of job 185

ORA-08103: object no longer exists

Sat Oct 25 08:07:55 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j008_26928.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-08103: object no longer exists

Sat Oct 25 08:07:55 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j011_26934.trc:

ORA-12012: error on auto execute of job 201

ORA-08103: object no longer exists

Sat Oct 25 08:07:55 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j011_26934.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-08103: object no longer exists

Sat Oct 25 08:07:55 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j015_26940.trc:

ORA-12012: error on auto execute of job 210

ORA-08103: object no longer exists

Sat Oct 25 08:07:55 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j015_26940.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-08103: object no longer exists

Sat Oct 25 08:07:56 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j005_26924.trc:

ORA-12012: error on auto execute of job 205

ORA-08103: object no longer exists

Sat Oct 25 08:07:56 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j005_26924.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-08103: object no longer exists

Sat Oct 25 08:07:56 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j010_26932.trc:

ORA-12012: error on auto execute of job 183

ORA-08103: object no longer exists

Sat Oct 25 08:07:56 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j010_26932.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-08103: object no longer exists

Sat Oct 25 08:08:57 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j000_26918.trc:

ORA-12012: error on auto execute of job 101

ORA-08103: object no longer exists

ORA-06512: at "SYS.DBMS_DEFER_SYS", line 2863

ORA-06512: at line 1

Sat Oct 25 08:08:57 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j000_26918.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-08103: object no longer exists

Sat Oct 25 08:08:57 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j004_26922.trc:

ORA-12012: error on auto execute of job 184

ORA-08103: object no longer exists

Sat Oct 25 08:09:59 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j000_26918.trc:

ORA-12012: error on auto execute of job 206

ORA-08103: object no longer exists

Sat Oct 25 08:10:00 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j004_26922.trc:

ORA-12012: error on auto execute of job 184

ORA-08103: object no longer exists

Sat Oct 25 08:10:00 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j004_26922.trc:

ORA-00604: error occurred at recursive SQL level 1

ORA-08103: object no longer exists

Sat Oct 25 08:10:14 2008

Errors in file /data/oracle9/admin/GDBNAME/bdump/orcljl_j000_26918.trc:

ORA-12012: error on auto execute of job 207

ORA-08103: object no longer exists

Sat Oct 25 08:10:44 2008

Shutting down instance (abort)

开发板推荐：天空星STM32F407VET6开发板

超高性价比 STM32主控 | 超高主频 | 一板兼容百芯 | 比赛神器 | 沉金彩色丝印

点击查看