[Oracle]最近碰到的几个ORA错误

博客首页 » Oracle最近碰到的几个ORA错误

发布于 28 Aug 2014 08:48
标签 blog
在Oracle上最近碰到的几个ORA错误,先记录下来。

下面的这段alert.log中出现了ORA-01013与ORA-01652接连出现的情况。不过,即使有接连出现的情况,也不能说明有相关性。另外,可以开到第一段log中,ORA-1652与ORA-01652的打印差异,说明这几个错误输出位置并不相同。

Tue Aug 26 16:27:54 2014
Thread 1 advanced to log sequence 3650 (LGWR switch)
  Current log# 2 seq# 3650 mem# 0: /u00/oradata/orcl/redo02_1.log
  Current log# 2 seq# 3650 mem# 1: /u00/oradata/orcl/redo02_2.log
Tue Aug 26 16:45:33 2014
Thread 1 advanced to log sequence 3651 (LGWR switch)
  Current log# 3 seq# 3651 mem# 0: /u00/oradata/orcl/redo03_1.log
  Current log# 3 seq# 3651 mem# 1: /u00/oradata/orcl/redo03_2.log
Tue Aug 26 17:01:56 2014
Thread 1 advanced to log sequence 3652 (LGWR switch)
  Current log# 4 seq# 3652 mem# 0: /u00/oradata/orcl/redo04_1.log
  Current log# 4 seq# 3652 mem# 1: /u00/oradata/orcl/redo04_2.log
Tue Aug 26 17:24:52 2014
Thread 1 advanced to log sequence 3653 (LGWR switch)
  Current log# 5 seq# 3653 mem# 0: /u00/oradata/orcl/redo05_1.log
  Current log# 5 seq# 3653 mem# 1: /u00/oradata/orcl/redo05_2.log
Tue Aug 26 17:33:41 2014
Errors in file /u01/oracle/app/admin/orcl/udump/orcl_ora_10992.trc:
ORA-01013: user requested cancel of current operation
Tue Aug 26 17:41:07 2014
Thread 1 advanced to log sequence 3654 (LGWR switch)
  Current log# 6 seq# 3654 mem# 0: /u00/oradata/orcl/redo06_1.log
  Current log# 6 seq# 3654 mem# 1: /u00/oradata/orcl/redo06_2.log
Tue Aug 26 17:58:40 2014
Thread 1 advanced to log sequence 3655 (LGWR switch)
  Current log# 7 seq# 3655 mem# 0: /u00/oradata/orcl/redo07_1.log
  Current log# 7 seq# 3655 mem# 1: /u00/oradata/orcl/redo07_2.log
Tue Aug 26 18:16:24 2014
Thread 1 advanced to log sequence 3656 (LGWR switch)
  Current log# 8 seq# 3656 mem# 0: /u00/oradata/orcl/redo08_1.log
  Current log# 8 seq# 3656 mem# 1: /u00/oradata/orcl/redo08_2.log
Tue Aug 26 18:32:58 2014
Thread 1 advanced to log sequence 3657 (LGWR switch)
  Current log# 1 seq# 3657 mem# 0: /u00/oradata/orcl/redo01_1.log
  Current log# 1 seq# 3657 mem# 1: /u00/oradata/orcl/redo01_2.log
Tue Aug 26 18:50:31 2014
Thread 1 advanced to log sequence 3658 (LGWR switch)
  Current log# 2 seq# 3658 mem# 0: /u00/oradata/orcl/redo02_1.log
  Current log# 2 seq# 3658 mem# 1: /u00/oradata/orcl/redo02_2.log
Tue Aug 26 19:12:31 2014
Thread 1 advanced to log sequence 3659 (LGWR switch)
  Current log# 3 seq# 3659 mem# 0: /u00/oradata/orcl/redo03_1.log
  Current log# 3 seq# 3659 mem# 1: /u00/oradata/orcl/redo03_2.log
Tue Aug 26 20:31:08 2014
Thread 1 advanced to log sequence 3660 (LGWR switch)
  Current log# 4 seq# 3660 mem# 0: /u00/oradata/orcl/redo04_1.log
  Current log# 4 seq# 3660 mem# 1: /u00/oradata/orcl/redo04_2.log
Tue Aug 26 20:41:34 2014
Errors in file /u01/oracle/app/admin/orcl/udump/orcl_ora_10992.trc:
ORA-01013: user requested cancel of current operation
Tue Aug 26 20:55:37 2014
ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
Tue Aug 26 20:55:37 2014
Errors in file /u01/oracle/app/admin/orcl/udump/orcl_ora_10992.trc:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Tue Aug 26 20:59:44 2014
ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
Tue Aug 26 20:59:44 2014
Errors in file /u01/oracle/app/admin/orcl/udump/orcl_ora_10992.trc:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Tue Aug 26 21:34:34 2014
ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
Tue Aug 26 21:34:34 2014
Errors in file /u01/oracle/app/admin/orcl/udump/orcl_ora_10992.trc:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Tue Aug 26 23:30:29 2014
Thread 1 advanced to log sequence 3661 (LGWR switch)
  Current log# 5 seq# 3661 mem# 0: /u00/oradata/orcl/redo05_1.log
  Current log# 5 seq# 3661 mem# 1: /u00/oradata/orcl/redo05_2.log
Tue Aug 26 23:31:19 2014
ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
Tue Aug 26 23:31:19 2014
Errors in file /u01/oracle/app/admin/orcl/udump/orcl_ora_10992.trc:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Tue Aug 26 23:46:37 2014
ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
Tue Aug 26 23:46:37 2014
Errors in file /u01/oracle/app/admin/orcl/udump/orcl_ora_10992.trc:
/ora_10992
  Current log# 1 seq# 3705 mem# 0: /u00/oradata/orcl/redo01_1.log
  Current log# 1 seq# 3705 mem# 1: /u00/oradata/orcl/redo01_2.log
Thu Aug 28 01:23:39 2014
Thread 1 advanced to log sequence 3706 (LGWR switch)
  Current log# 2 seq# 3706 mem# 0: /u00/oradata/orcl/redo02_1.log
  Current log# 2 seq# 3706 mem# 1: /u00/oradata/orcl/redo02_2.log
Thu Aug 28 01:23:44 2014
Starting control autobackup
Control autobackup written to DISK device
        handle '/u04/oradata/orcl/rman/current/ctl_c-3890539213-20140828-00.bak'
Thu Aug 28 01:23:46 2014
alter database backup controlfile to '/u04/oradata/orcl/rman/current/control01.bak' reuse
Thu Aug 28 01:23:47 2014
Completed: alter database backup controlfile to '/u04/oradata/orcl/rman/current/control01.bak' reuse
Thu Aug 28 01:24:17 2014
Thread 1 advanced to log sequence 3707 (LGWR switch)
  Current log# 3 seq# 3707 mem# 0: /u00/oradata/orcl/redo03_1.log
  Current log# 3 seq# 3707 mem# 1: /u00/oradata/orcl/redo03_2.log
Thu Aug 28 02:07:12 2014
ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
Thu Aug 28 02:07:12 2014
Errors in file /u01/oracle/app/admin/orcl/udump/orcl_ora_8321.trc:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Thu Aug 28 02:17:59 2014
ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
Thu Aug 28 02:17:59 2014
Errors in file /u01/oracle/app/admin/orcl/udump/orcl_ora_8321.trc:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Thu Aug 28 02:30:29 2014
ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
Thu Aug 28 02:30:29 2014
Errors in file /u01/oracle/app/admin/orcl/udump/orcl_ora_8321.trc:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Thu Aug 28 02:45:04 2014
ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
Thu Aug 28 02:45:04 2014
ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
Thu Aug 28 02:45:04 2014
Errors in file /u01/oracle/app/admin/orcl/udump/orcl_ora_10992.trc:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Thu Aug 28 02:45:04 2014
Errors in file /u01/oracle/app/admin/orcl/udump/orcl_ora_8321.trc:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

在下面的这段log中,能看到间隔时间比较大的情况。

Thu Aug 28 01:24:17 2014
Thread 1 advanced to log sequence 3707 (LGWR switch)
  Current log# 3 seq# 3707 mem# 0: /u00/oradata/orcl/redo03_1.log
  Current log# 3 seq# 3707 mem# 1: /u00/oradata/orcl/redo03_2.log
Thu Aug 28 02:07:12 2014
ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
Thu Aug 28 02:07:12 2014
Errors in file /u01/oracle/app/admin/orcl/udump/orcl_ora_8321.trc:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Thu Aug 28 02:17:59 2014
ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
Thu Aug 28 02:17:59 2014
Errors in file /u01/oracle/app/admin/orcl/udump/orcl_ora_8321.trc:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Thu Aug 28 02:30:29 2014
ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
Thu Aug 28 02:30:29 2014
Errors in file /u01/oracle/app/admin/orcl/udump/orcl_ora_8321.trc:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Thu Aug 28 02:45:04 2014
ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
Thu Aug 28 02:45:04 2014
ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
Thu Aug 28 02:45:04 2014
Errors in file /u01/oracle/app/admin/orcl/udump/orcl_ora_10992.trc:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Thu Aug 28 02:45:04 2014
Errors in file /u01/oracle/app/admin/orcl/udump/orcl_ora_8321.trc:
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Thu Aug 28 08:46:08 2014
Thread 1 advanced to log sequence 3708 (LGWR switch)
  Current log# 4 seq# 3708 mem# 0: /u00/oradata/orcl/redo04_1.log
  Current log# 4 seq# 3708 mem# 1: /u00/oradata/orcl/redo04_2.log
Thu Aug 28 08:57:11 2014
Errors in file /u01/oracle/app/admin/orcl/udump/orcl_ora_8321.trc:
ORA-01013: user requested cancel of current operation
Thu Aug 28 09:33:31 2014
Thread 1 advanced to log sequence 3709 (LGWR switch)
  Current log# 5 seq# 3709 mem# 0: /u00/oradata/orcl/redo05_1.log
  Current log# 5 seq# 3709 mem# 1: /u00/oradata/orcl/redo05_2.log
Thu Aug 28 09:42:47 2014
Errors in file /u01/oracle/app/admin/orcl/udump/orcl_ora_8321.trc:
ORA-01013: user requested cancel of current operation
Thu Aug 28 09:42:56 2014
Errors in file /u01/oracle/app/admin/orcl/udump/orcl_ora_8321.trc:
ORA-01013: user requested cancel of current operation
Thu Aug 28 09:59:34 2014
Thread 1 advanced to log sequence 3710 (LGWR switch)
  Current log# 6 seq# 3710 mem# 0: /u00/oradata/orcl/redo06_1.log
  Current log# 6 seq# 3710 mem# 1: /u00/oradata/orcl/redo06_2.log
/u01/oracle/app/admin/orcl/udump/orcl_ora_10992.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/oracle/app/oracle/product/10.2.0/db_1
System name:    Linux
Node name:      srv-test
Release:        2.6.18-371.9.1.el5
Version:        #1 SMP Tue May 13 06:52:49 EDT 2014
Machine:        x86_64
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 363
Unix process pid: 10992, image: oracle@srv-test

*** 2014-08-26 17:33:41.855
*** ACTION NAME:() 2014-08-26 17:33:41.854
*** MODULE NAME:(SQL Developer) 2014-08-26 17:33:41.854
*** SERVICE NAME:(SYS$USERS) 2014-08-26 17:33:41.854
*** SESSION ID:(712.55632) 2014-08-26 17:33:41.854
ORA-01013: user requested cancel of current operation
Dump of memory from 0x000000045C687220 to 0x000000045C689B90
45C687220 68746977 2020200A 545F5620 20313030  [with.    V_T001 ]
45C687230 28207361 530A0D0A 43454C45 2A2F2054  [as (...SELECT /*]
45C687240 4C41202B 4F525F4C 2A205357 2A20202F  [+ ALL_ROWS */  *]
45C687250 4F524620 0A28204D 20202020 20202020  [ FROM (.        ]
45C687260 20202020 20202020 656C6573 2F207463  [        select /]
45C687270 41202B2A 525F4C4C 2053574F 20202F2A  [*+ ALL_ROWS */  ]
45C687280 5E832720 93834583 5B817983 20275783  [ '.^.E...y.[.W' ]
45C687290 5453494C 4D414E5F 414E5F45 0A2C454D  [LIST_NAME_NAME,.]
45C6872A0 20202020 20202020 20202020 20202020  [                ]
45C6872B0 31303054 5A49422E 0A44495F 20202020  [T001.BIZ_ID.    ]
45C6872C0 20202020 20202020 20202020 20202020  [                ]
45C6872D0 4D2C2020 2E313030 54535543 0A44495F  [  ,M001.CUST_ID.]
45C6872E0 20202020 20202020 20202020 20202020  [                ]
45C6872F0 20202020 4D2C2020 2E313030 444E4946  [      ,M001.FIND]
45C687300 4C45545F 0A4F4E5F 20202020 20202020  [_TEL_NO.        ]
45C687310 20202020 20202020 20202020 542C2020  [              ,T]
45C687320 2E313030 4C4C4143 5453525F 0A44495F  [001.CALL_RST_ID.]
45C687330 20202020 20202020 20202020 20202020  [                ]
45C687340 20202020 542C2020 2E313030 4C4C4143  [      ,T001.CALL]
45C687350 0A54445F 20202020 20202020 20202020  [_DT.            ]
45C687360 20202020 20202020 542C2020 2E313030  [          ,T001.]
45C687370 4C4C4143 4553555F 44495F52 2020200A  [CALL_USER_ID.   ]
45C687380 20202020 20202020 20202020 20202020  [                ]
45C687390 2C202020 3130304D 444E492E 425F5453  [   ,M001.INDST_B]
45C6873A0 5F455341 200A4449 20202020 20202020  [ASE_ID.         ]
45C6873B0 20202020 20202020 20202020 304D2C20  [             ,M0]
45C6873C0 492E3130 5453444E 5445445F 5F4C4941  [01.INDST_DETAIL_]
45C6873D0 200A4449 20202020 20202020 20202020  [ID.             ]
45C6873E0 20202020 20202020 304D2C20 492E3332  [         ,M023.I]
45C6873F0 5453444E 5445445F 5F4C4941 454D414E  [NDST_DETAIL_NAME]
45C687400 54414420 554B5F41 0A4E5542 20202020  [ DATA_KUBUN.    ]
45C687410 20202020 20202020 20202020 20202020  [                ]
45C687420 742C2020 2E313030 5F505247 200A4449  [  ,t001.GRP_ID. ]
45C687430 20202020 20202020 20202020 20202020  [                ]
45C687440 20202020 30742C20 522E3130 33565345  [     ,t001.RESV3]
45C687450 45522036 36335653 200A315F 20202020  [6 RESV36_1.     ]
45C687460 20202020 20202020 20202020 20202020  [                ]
45C687470 30742C20 522E3130 34565345 45522033  [ ,t001.RESV43 RE]
45C687480 33345653 200A315F 20202020 20202020  [SV43_1.         ]
45C687490 20202020 20202020 20202020 30742C20  [             ,t0]
45C6874A0 522E3130 31565345 52203130 31565345  [01.RESV101 RESV1]
45C6874B0 315F3130 2020200A 20202020 20202020  [01_1.           ]
45C6874C0 20202020 20202020 2C202020 31303074  [           ,t001]
45C6874D0 5345522E 20363956 56534552 200A3639  [.RESV96 RESV96. ]
45C6874E0 20202020 20202020 20202020 20202020  [                ]
45C6874F0 20202020 306D2C20 522E3130 31565345  [     ,m001.RESV1]
45C687500 52203030 31565345 200A3030 20202020  [00 RESV100.     ]
45C687510 20202020 20202020 20202020 4F524620  [             FRO]
45C687520 3054204D 425F3130 435F5A49 20545355  [M T001_BIZ_CUST ]
45C687530 31303054 2020200A 20202020 20202020  [T001.           ]
45C687540 20202020 2C202020 3130304D 5355435F  [       ,M001_CUS]
45C687550 304D2054 200A3130 20202020 20202020  [T M001.         ]
45C687560 20202020 20202020 53282C20 43454C45  [         ,(SELEC]
45C687570 4E492054 5F545344 41544544 495F4C49  [T INDST_DETAIL_I]
45C687580 4E492C44 5F545344 41544544 4E5F4C49  [D,INDST_DETAIL_N]
45C687590 0A454D41 20202020 20202020 20202020  [AME.            ]
*** 2014-08-26 20:55:37.582
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Dump of memory from 0x0000000416FE4AC0 to 0x0000000416FFFFFC
416FE4AC0 68746977 2020200A 545F5620 20313030  [with.    V_T001 ]
416FE4AD0 28207361 530A0D0A 43454C45 2A2F2054  [as (...SELECT /*]
416FE4AE0 4C41202B 4F525F4C 2A205357 2A20202F  [+ ALL_ROWS */  *]
416FE4AF0 4F524620 0A28204D 20202020 20202020  [ FROM (.        ]
416FE4B00 20202020 20202020 656C6573 2F207463  [        select /]
416FE4B10 41202B2A 525F4C4C 2053574F 20202F2A  [*+ ALL_ROWS */  ]
416FE4B20 2E312720 8A534753 8DBE936C 8CDD82CF  [ '1.SGS.l.......]
416FE4B30 27718BDA 53494C20 414E5F54 4E5F454D  [..q' LIST_NAME_N]
416FE4B40 2C454D41 2020200A 20202020 20202020  [AME,.           ]
416FE4B50 20202020 30305420 49422E31 44495F5A  [     T001.BIZ_ID]
416FE4B60 2020200A 20202020 20202020 20202020  [.               ]
416FE4B70 20202020 2C202020 3130304D 5355432E  [       ,M001.CUS]
416FE4B80 44495F54 2020200A 20202020 20202020  [T_ID.           ]
416FE4B90 20202020 20202020 2C202020 3130304D  [           ,M001]
416FE4BA0 4E49462E 45545F44 4F4E5F4C 2020200A  [.FIND_TEL_NO.   ]
416FE4BB0 20202020 20202020 20202020 20202020  [                ]
416FE4BC0 2C202020 31303054 4C41432E 53525F4C  [   ,T001.CALL_RS]
416FE4BD0 44495F54 2020200A 20202020 20202020  [T_ID.           ]
416FE4BE0 20202020 20202020 2C202020 31303054  [           ,T001]
416FE4BF0 4C41432E 54445F4C 2020200A 20202020  [.CALL_DT.       ]
416FE4C00 20202020 20202020 20202020 2C202020  [               ,]
416FE4C10 31303054 4C41432E 53555F4C 495F5245  [T001.CALL_USER_I]
416FE4C20 20200A44 20202020 20202020 20202020  [D.              ]
416FE4C30 20202020 20202020 30304D2C 4E492E31  [        ,M001.IN]
416FE4C40 5F545344 45534142 0A44495F 20202020  [DST_BASE_ID.    ]
416FE4C50 20202020 20202020 20202020 20202020  [                ]
416FE4C60 4D2C2020 2E313030 53444E49 45445F54  [  ,M001.INDST_DE]
416FE4C70 4C494154 0A44495F 20202020 20202020  [TAIL_ID.        ]
416FE4C80 20202020 20202020 20202020 4D2C2020  [              ,M]
416FE4C90 2E313030 52444441 4552505F 44435F46  [001.ADDR_PREF_CD]
416FE4CA0 2020200A 20202020 20202020 20202020  [.               ]
416FE4CB0 20202020 2C202020 412E3027 20274C4C  [       ,'0.ALL' ]
416FE4CC0 41544144 42554B5F 200A4E55 20202020  [DATA_KUBUN.     ]
416FE4CD0 20202020 20202020 20202020 20202020  [                ]
416FE4CE0 30742C20 472E3130 495F5052 20200A44  [ ,t001.GRP_ID.  ]
416FE4CF0 20202020 20202020 20202020 20202020  [                ]
416FE4D00 20202020 3030742C 45522E31 36335653  [    ,t001.RESV36]
416FE4D10 53455220 5F363356 20200A31 20202020  [ RESV36_1.      ]

本页面的文字允许在知识共享 署名-相同方式共享 3.0协议和GNU自由文档许可证下修改和再使用,仅有一个特殊要求,请用链接方式注明文章引用出处及作者。请协助维护作者合法权益。


系列文章

文章列表

  • Oracle最近碰到的几个ORA错误

这篇文章对你有帮助吗,投个票吧?

rating: 0+x

留下你的评论

Add a New Comment
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License