yangtingkun

关闭数据库出现PMON failed to acquire latch信息

Posted on 2012/11/19 by yangtingkun

很常见的一个信息，以前并没有太在意，不过即使是这种异常信息，Oracle也认为是bug。
关闭数据库时，信息如下：

Tue Aug 16 15:38:06 2011
Shutting down archive processes
Tue Aug 16 15:38:11 2011
ARCH shutting down
ARC2: Archival stopped
Tue Aug 16 15:43:41 2011
Starting background process EMN0
EMN0 started WITH pid=28, OS id=1294500
Tue Aug 16 15:43:41 2011
Shutting down instance: further logons disabled
Tue Aug 16 15:43:41 2011
Stopping background process QMNC
Tue Aug 16 15:43:41 2011
Stopping background process CJQ0
Tue Aug 16 15:43:44 2011
Stopping background process MMNL
Tue Aug 16 15:43:45 2011
Stopping background process MMON
Tue Aug 16 15:43:46 2011
Shutting down instance (immediate)
License high water mark = 10
Tue Aug 16 15:43:46 2011
Stopping Job queue slave processes
Tue Aug 16 15:43:51 2011
Process OS id : 1474740 alive after KILL
Errors IN file 
Tue Aug 16 15:43:51 2011
Job queue slave processes stopped
Tue Aug 16 15:44:01 2011
PMON failed TO acquire latch, see PMON dump
PMON failed TO acquire latch, see PMON dump
PMON failed TO acquire latch, see PMON dump
PMON failed TO acquire latch, see PMON dump
PMON failed TO acquire latch, see PMON dump
Tue Aug 16 15:44:11 2011
PMON failed TO acquire latch, see PMON dump
PMON failed TO acquire latch, see PMON dump
PMON failed TO acquire latch, see PMON dump
PMON failed TO acquire latch, see PMON dump
PMON failed TO acquire latch, see PMON dump
Tue Aug 16 15:44:22 2011
PMON failed TO acquire latch, see PMON dump
PMON failed TO acquire latch, see PMON dump
PMON failed TO acquire latch, see PMON dump
PMON failed TO acquire latch, see PMON dump
PMON failed TO acquire latch, see PMON dump
Tue Aug 16 15:44:32 2011
PMON failed TO acquire latch, see PMON dump
PMON failed TO acquire latch, see PMON dump
Tue Aug 16 15:44:37 2011
ALTER DATABASE CLOSE NORMAL
Tue Aug 16 15:44:37 2011
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Aug 16 15:44:37 2011
Shutting down archive processes
Archiving IS disabled
Tue Aug 16 15:44:42 2011
ARCH shutting down
ARC1: Archival stopped
Tue Aug 16 15:44:47 2011
ARCH shutting down
ARC0: Archival stopped
Tue Aug 16 15:44:49 2011
Thread 1 closed at log SEQUENCE 9371
Successful close OF redo thread 1
Tue Aug 16 15:44:49 2011
Completed: ALTER DATABASE CLOSE NORMAL
Tue Aug 16 15:44:49 2011
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due TO shutdown: 1089
Shutting down archive processes
Archiving IS disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due TO shutdown: 1089
Shutting down archive processes
Archiving IS disabled
Archive process shutdown avoided: 0 active

Tue Aug 16 15:38:06 2011 Shutting down archive processes Tue Aug 16 15:38:11 2011 ARCH shutting down ARC2: Archival stopped Tue Aug 16 15:43:41 2011 Starting background process EMN0 EMN0 started with pid=28, OS id=1294500 Tue Aug 16 15:43:41 2011 Shutting down instance: further logons disabled Tue Aug 16 15:43:41 2011 Stopping background process QMNC Tue Aug 16 15:43:41 2011 Stopping background process CJQ0 Tue Aug 16 15:43:44 2011 Stopping background process MMNL Tue Aug 16 15:43:45 2011 Stopping background process MMON Tue Aug 16 15:43:46 2011 Shutting down instance (immediate) License high water mark = 10 Tue Aug 16 15:43:46 2011 Stopping Job queue slave processes Tue Aug 16 15:43:51 2011 Process OS id : 1474740 alive after kill Errors in file Tue Aug 16 15:43:51 2011 Job queue slave processes stopped Tue Aug 16 15:44:01 2011 PMON failed to acquire latch, see PMON dump PMON failed to acquire latch, see PMON dump PMON failed to acquire latch, see PMON dump PMON failed to acquire latch, see PMON dump PMON failed to acquire latch, see PMON dump Tue Aug 16 15:44:11 2011 PMON failed to acquire latch, see PMON dump PMON failed to acquire latch, see PMON dump PMON failed to acquire latch, see PMON dump PMON failed to acquire latch, see PMON dump PMON failed to acquire latch, see PMON dump Tue Aug 16 15:44:22 2011 PMON failed to acquire latch, see PMON dump PMON failed to acquire latch, see PMON dump PMON failed to acquire latch, see PMON dump PMON failed to acquire latch, see PMON dump PMON failed to acquire latch, see PMON dump Tue Aug 16 15:44:32 2011 PMON failed to acquire latch, see PMON dump PMON failed to acquire latch, see PMON dump Tue Aug 16 15:44:37 2011 ALTER DATABASE CLOSE NORMAL Tue Aug 16 15:44:37 2011 SMON: disabling tx recovery SMON: disabling cache recovery Tue Aug 16 15:44:37 2011 Shutting down archive processes Archiving is disabled Tue Aug 16 15:44:42 2011 ARCH shutting down ARC1: Archival stopped Tue Aug 16 15:44:47 2011 ARCH shutting down ARC0: Archival stopped Tue Aug 16 15:44:49 2011 Thread 1 closed at log sequence 9371 Successful close of redo thread 1 Tue Aug 16 15:44:49 2011 Completed: ALTER DATABASE CLOSE NORMAL Tue Aug 16 15:44:49 2011 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active ARCH: Archival disabled due to shutdown: 1089 Shutting down archive processes Archiving is disabled Archive process shutdown avoided: 0 active

Oracle在MOS文档Bug 4632780 – PMON “failed to acquire latch” during shutdown [ID 4632780.8]专门介绍了这个信息，确认影响的版本包括9.2.0.7、10.1.0.5和10.2.0.1，Oracle在9.2.0.8、10.2.0.2和11.1.0.6中进行了修复。

Posted in BUG | Tagged PMON failed to acquire latch, SHUTDOWN | Leave a comment

ORA-600(kocgor077)错误

Posted on 2012/11/18 by yangtingkun

客户数据库出现ORA-600[kocgor077]错误。
数据库版本为10.2.0.1，详细错误信息为：

Thu Oct 22 22:00:36 2009
ORA-0 encountered WHEN generating server alert SMG-3503
Thu Oct 22 22:10:40 2009
ORA-0 encountered WHEN generating server alert SMG-3503
Thu Oct 22 22:20:44 2009
ORA-0 encountered WHEN generating server alert SMG-3503
Thu Oct 22 22:24:44 2009
Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_606440.trc:
ORA-00600: internal error code, arguments: [kocgor077], [], [], [], [], [], [], []
Thu Oct 22 22:24:46 2009
Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_606440.trc:
ORA-00600: internal error code, arguments: [kocgor077], [], [], [], [], [], [], []
Thu Oct 22 22:25:44 2009
Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_606440.trc:
ORA-00600: internal error code, arguments: [kocgor077], [], [], [], [], [], [], []
Thu Oct 22 22:25:45 2009
Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_606440.trc:
ORA-00600: internal error code, arguments: [kocgor077], [], [], [], [], [], [], []
Thu Oct 22 22:26:46 2009
Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_606440.trc:
ORA-00600: internal error code, arguments: [kocgor077], [], [], [], [], [], [], []
Thu Oct 22 22:27:47 2009
Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_606440.trc:
ORA-00600: internal error code, arguments: [kocgor077], [], [], [], [], [], [], []
Thu Oct 22 22:27:48 2009
Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_606440.trc:
ORA-00600: internal error code, arguments: [kocgor077], [], [], [], [], [], [], []
Thu Oct 22 22:28:49 2009
Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_606440.trc:
ORA-00600: internal error code, arguments: [kocgor077], [], [], [], [], [], [], []
Thu Oct 22 22:28:50 2009
Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_606440.trc:
ORA-00600: internal error code, arguments: [kocgor077], [], [], [], [], [], [], []
Thu Oct 22 22:28:52 2009
Restarting dead background process MMON
MMON started WITH pid=11, OS id=303192

问题发生在MMON进程，且600错误之前出现了频繁了ALERT告警，因此根据MOS文档Bug 8540420 : ORA-600 [KOCGOR077] OCCUR，判断问题属于为公布的BUG 4515374。
Oracle在10.2.0.2中解决了这个问题。

Posted in BUG | Tagged kocgor077, mmon, ORA-0, ORA-600, SMG-3503 | Leave a comment

ORA-21780、ORA-4030、ORA-600(keltenq)、SMG-3000、SMG-3503错误

Posted on 2012/11/17 by yangtingkun

客户Oracle 10.2.0.1数据库告警日志出现大量的ORA-21780错误，并包含SMG-3000和SMG-3503信息，紧接着出现了ORA-4030和ORA-600(keltenq)错误。
错误信息如下：

Mon Aug 17 10:37:48 2009
ORA-21780 encountered WHEN generating server alert SMG-3000
Mon Aug 17 10:38:27 2009
ORA-21780 encountered WHEN generating server alert SMG-3503
Mon Aug 17 10:47:48 2009
ORA-21780 encountered WHEN generating server alert SMG-3000
Mon Aug 17 10:48:42 2009
ORA-21780 encountered WHEN generating server alert SMG-3503
Mon Aug 17 10:57:48 2009
ORA-21780 encountered WHEN generating server alert SMG-3000
ORA-21780 encountered WHEN generating server alert SMG-3503
Mon Aug 17 11:07:48 2009
ORA-21780 encountered WHEN generating server alert SMG-3000
Mon Aug 17 11:08:12 2009
ORA-21780 encountered WHEN generating server alert SMG-3503
Mon Aug 17 11:09:12 2009
Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc:
ORA-00600: internal error code, arguments: [keltenq-22], [4030], [ORA-04030: OUT OF process memory WHEN trying TO allocate 16408 bytes (koh-kghu sessi,kol vstring)
], [], [], [], [], []
Mon Aug 17 11:10:12 2009
Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc:
ORA-00600: internal error code, arguments: [keltenq-5], [4030], [ORA-04030: OUT OF process memory WHEN trying TO allocate 16408 bytes (koh-kghu sessi,kol vstring)
], [], [], [], [], []
Mon Aug 17 11:11:12 2009
Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc:
ORA-00600: internal error code, arguments: [keltenq-5], [4030], [ORA-04030: OUT OF process memory WHEN trying TO allocate 16408 bytes (koh-kghu sessi,kol vstring)
], [], [], [], [], []
Mon Aug 17 11:14:19 2009
Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc:
ORA-00600: internal error code, arguments: [keltenq-5], [4030], [ORA-04030: OUT OF process memory WHEN trying TO allocate 16408 bytes (koh-kghu sessi,kol vstring)
], [], [], [], [], []
Mon Aug 17 11:17:49 2009
Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc:
ORA-00600: internal error code, arguments: [keltenq-5], [4030], [ORA-04030: OUT OF process memory WHEN trying TO allocate 16408 bytes (koh-kghu sessi,kol vstring)
], [], [], [], [], []
Mon Aug 17 11:17:49 2009
ORA-4030 encountered WHEN generating server alert SMG-3000
Mon Aug 17 11:18:22 2009
ORA-4030 encountered WHEN generating server alert SMG-3503
Mon Aug 17 11:26:37 2009
Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc:
ORA-00600: internal error code, arguments: [keltenq-5], [4030], [ORA-04030: OUT OF process memory WHEN trying TO allocate 16408 bytes (koh-kghu sessi,kol vstring)
], [], [], [], [], []
Mon Aug 17 11:27:49 2009
Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc:
ORA-00600: internal error code, arguments: [keltenq-5], [4030], [ORA-04030: OUT OF process memory WHEN trying TO allocate 16408 bytes (koh-kghu sessi,kol vstring)
], [], [], [], [], []
Mon Aug 17 11:27:50 2009
ORA-4030 encountered WHEN generating server alert SMG-3000
Mon Aug 17 11:28:38 2009
ORA-4030 encountered WHEN generating server alert SMG-3503
Mon Aug 17 11:35:50 2009
Errors IN file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc:
ORA-00600: internal error code, arguments: [keltenq-5], [4030], [ORA-04030: OUT OF process memory WHEN trying TO allocate 16408 bytes (koh-kghu sessi,kol vstring)
], [], [], [], [], []
Mon Aug 17 11:38:24 2009
Restarting dead background process MMON
MMON started WITH pid=11, OS id=606440

Mon Aug 17 10:37:48 2009 ORA-21780 encountered when generating server alert SMG-3000 Mon Aug 17 10:38:27 2009 ORA-21780 encountered when generating server alert SMG-3503 Mon Aug 17 10:47:48 2009 ORA-21780 encountered when generating server alert SMG-3000 Mon Aug 17 10:48:42 2009 ORA-21780 encountered when generating server alert SMG-3503 Mon Aug 17 10:57:48 2009 ORA-21780 encountered when generating server alert SMG-3000 ORA-21780 encountered when generating server alert SMG-3503 Mon Aug 17 11:07:48 2009 ORA-21780 encountered when generating server alert SMG-3000 Mon Aug 17 11:08:12 2009 ORA-21780 encountered when generating server alert SMG-3503 Mon Aug 17 11:09:12 2009 Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc: ORA-00600: internal error code, arguments: [keltenq-22], [4030], [ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu sessi,kol vstring) ], [], [], [], [], [] Mon Aug 17 11:10:12 2009 Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc: ORA-00600: internal error code, arguments: [keltenq-5], [4030], [ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu sessi,kol vstring) ], [], [], [], [], [] Mon Aug 17 11:11:12 2009 Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc: ORA-00600: internal error code, arguments: [keltenq-5], [4030], [ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu sessi,kol vstring) ], [], [], [], [], [] Mon Aug 17 11:14:19 2009 Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc: ORA-00600: internal error code, arguments: [keltenq-5], [4030], [ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu sessi,kol vstring) ], [], [], [], [], [] Mon Aug 17 11:17:49 2009 Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc: ORA-00600: internal error code, arguments: [keltenq-5], [4030], [ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu sessi,kol vstring) ], [], [], [], [], [] Mon Aug 17 11:17:49 2009 ORA-4030 encountered when generating server alert SMG-3000 Mon Aug 17 11:18:22 2009 ORA-4030 encountered when generating server alert SMG-3503 Mon Aug 17 11:26:37 2009 Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc: ORA-00600: internal error code, arguments: [keltenq-5], [4030], [ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu sessi,kol vstring) ], [], [], [], [], [] Mon Aug 17 11:27:49 2009 Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc: ORA-00600: internal error code, arguments: [keltenq-5], [4030], [ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu sessi,kol vstring) ], [], [], [], [], [] Mon Aug 17 11:27:50 2009 ORA-4030 encountered when generating server alert SMG-3000 Mon Aug 17 11:28:38 2009 ORA-4030 encountered when generating server alert SMG-3503 Mon Aug 17 11:35:50 2009 Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_mmon_385212.trc: ORA-00600: internal error code, arguments: [keltenq-5], [4030], [ORA-04030: out of process memory when trying to allocate 16408 bytes (koh-kghu sessi,kol vstring) ], [], [], [], [], [] Mon Aug 17 11:38:24 2009 Restarting dead background process MMON MMON started with pid=11, OS id=606440

显然问题直接和ORA-4030错误有关。ORA-600和部分SMG错误都是ORA-4030直接导致的。
根据文档Bug 6061892 – Memory Leak on ‘PLS non-lib hp’ by recursive PLSQL calls / ORA-4030 AND ORA-21780 [ID 6061892.8]，ORA-4030是内存泄漏导致的，当应用删除或重建正在被调用的PL/SQL包、过程和函数时，可能引发这个错误。
这个问题影响的版本包括10.2.0.1、10.2.0.2和10.2.0.3，Oracle在10.2.0.4和11.1.0.6中解决了这个问题。

Posted in BUG | Tagged 4030, keltenq, keltenq-22, keltenq-5, ORA-21780, ORA-4030, ORA-600, SMG-3000, SMG-3503 | Leave a comment

控制文件自动备份报错并产生TRACE文件

Posted on 2012/11/16 by yangtingkun

客户10.2.0.1数据库在控制文件自动备份过程中出现错误信息。
错误信息为：

Thu Jun 30 02:15:46 2011
Starting control autobackup
Thu Jun 30 02:15:47 2011
Errors IN file /u01/app/oracle/admin/orcl/udump/orcl_ora_1167402.trc:
Thu Jun 30 02:15:47 2011
Errors IN file /u01/app/oracle/admin/orcl/udump/orcl_ora_1167402.trc:
Thu Jun 30 02:15:47 2011
Errors IN file /u01/app/oracle/admin/orcl/udump/orcl_ora_1167402.trc:
Control autobackup written TO DISK device
	handle '/orch1/rmanbak/c-737336038-20110630-00'

这个错误信息很奇怪，首先没有明确的ORA-错误显示，而且最终控制文件的备份也成功了，看起来像是误报。
如果检查对应的TRACE文件，会发现文件中同样没有记录任何错误信息，检查MOS确认为10.2.0.1上的BUG 4596065，文档Trace File Created when RMAN issues the Controlfile Autobackup [ID 335731.1]描述了这个问题。
这个问题在10.2.0.2上被解决。在当前版本可以直接忽略这个问题。

Posted in BUG | Tagged Error in file, rman, Starting control autobackup, trace file create | Leave a comment

ORA-600(ktspfnsb-1)错误

Posted on 2012/11/15 by yangtingkun

Exadata环境在收集统计信息时出现这个错误。
客户数据库11.2.0.2 RAC on Exadata在收集统计信息是出现的错误：

Sun Feb 05 22:22:44 2012
Errors IN file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_j002_21084.trc  (incident=255085):
ORA-00600: internal error code, arguments: [ktspfnsb-1], [1], [1], [], [], [], [], [], [], [], [], []
Incident details IN: /u01/app/oracle/diag/rdbms/orcl/orcl2/incident/incdir_255085/orcl2_j002_21084_i255085.trc
Sun Feb 05 22:22:56 2012
Thread 2 advanced TO log SEQUENCE 6225 (LGWR switch)
  CURRENT log# 4 seq# 6225 mem# 0: +RECO_ORCL/orcl/onlinelog/group_4.683.768858471
.
.
.
Sun Feb 05 22:36:32 2012
Dumping diagnostic DATA IN directory=[cdmp_20120205223632], requested BY (instance=2, osid=21084 (J002)), summary=[incident=255085].
Sun Feb 05 22:36:32 2012
USE ADRCI OR Support Workbench TO package the incident.
See Note 411.1 at My Oracle Support FOR error AND packaging details.
Sun Feb 05 22:36:32 2012
Sweep [inc][255085]: completed
Sweep [inc2][255085]: completed
Errors IN file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_j002_21084.trc:
ORA-12012: error ON auto EXECUTE OF job "SYS"."ORA$AT_OS_OPT_SY_2878"
ORA-20011: Approximate NDV failed: ORA-00600: internal error code, arguments: [ktspfnsb-1], [1], [1], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_STATS", line 29628

根据错误信息，导致ORA-600[ktspfnsb-1]的是统计信息收集的JOB，这个问题毫无疑问属于Oracle的bug，查询MOS发现这个BUG虽然已经确认，但是还没有给出最终的解决方案：Bug 14694342 : DBMS_STATS.GATHER_TABLE_STATS FAILED WITH ORA-00600[KTSPFNSB-1][1][1]。
这个问题目前出现的概率很低，且问题发生在收集统计信息的过程中，对系统影响不大，且可以通过其他手段绕过，对系统影响不大，可以后期关注Oracle的解决方案。

Posted in BUG | Tagged DBMS_STATS, exadata, ktspfnsb-1, ORA-12012, ora-20011, ORA-600, ora-6512 | Leave a comment

ORA-1000导致的ORA-7445错误

Posted on 2012/11/14 by yangtingkun

客户10.2.0.1环境，出现了ORA-1000错误并导致了ORA-7445错误的产生。
Oracle的ORA-1000错误是个普通的问题，就是当前使用的游标值超过了OPEN_CURSOR初始化参数的值，而这个错误导致的ORA-7445错误还是第一次看到：

Thu Oct 28 16:32:57 2010
Errors IN file /u01/app/oracle/admin/orcl/orcl/orcl_mmon_356528.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-00604: error occurred at recursive SQL level 2
ORA-01000: maximum OPEN cursors exceeded

在文档ORA-7445 Followed By ORA-1000 “MAXIMUM OPEN CURSORS EXCEEDED” Error [ID 1138647.1]介绍了这个错误。
显然这个错误的解决方法就是调整OPEN_CURSORS的值，而当前数据库采用了默认值300，确实并不高。由于OPEN_CURSORS设置的是最大值，因此将这个值设置的高一些并不会有什么不良影响，可以将其调整到1000甚至是3000。

Posted in BUG | Tagged OPEN_CURSORS, ORA-1000, ora-604, ORA-7445 | Leave a comment

更改SERVICE_NAME导致大量会话被KILL

Posted on 2012/11/13 by yangtingkun

在10.2.0.4 RAC环境中，出现了更改SERVICE_NAME导致大量会话被KILL的现象。
告警日志中信息如下：

Wed Oct 24 20:06:16 2012
ALTER SYSTEM SET service_names='' SCOPE=MEMORY SID='orcl2';
Wed Oct 24 20:06:16 2012
ALTER SYSTEM SET service_names='orcl' SCOPE=MEMORY SID='orcl2';
Wed Oct 24 20:06:16 2012
Immediate KILL SESSION#: 1418, Serial#: 22066
Immediate KILL SESSION: sess: 0x18dc79b70  OS pid: 4879
Immediate KILL SESSION#: 1424, Serial#: 108
Immediate KILL SESSION: sess: 0x18dc81be0  OS pid: 15110
Immediate KILL SESSION#: 1425, Serial#: 22
Immediate KILL SESSION: sess: 0x18dc83148  OS pid: 15112
Immediate KILL SESSION#: 1426, Serial#: 9
Immediate KILL SESSION: sess: 0x18dc846b0  OS pid: 15157
Immediate KILL SESSION#: 1427, Serial#: 17
Immediate KILL SESSION: sess: 0x18dc85c18  OS pid: 15119
Immediate KILL SESSION#: 1429, Serial#: 24221
Immediate KILL SESSION: sess: 0x18dc886e8  OS pid: 1044
Immediate KILL SESSION#: 1430, Serial#: 9
Immediate KILL SESSION: sess: 0x18dc89c50  OS pid: 15126
.
.
.
Immediate KILL SESSION#: 1605, Serial#: 60258
Immediate KILL SESSION: sess: 0x18dd73e68  OS pid: 11966
Immediate KILL SESSION#: 1606, Serial#: 18413
Immediate KILL SESSION: sess: 0x18dd753d0  OS pid: 11999
Immediate KILL SESSION#: 1607, Serial#: 18517
Immediate KILL SESSION: sess: 0x18dd76938  OS pid: 15378
Immediate KILL SESSION#: 1608, Serial#: 57825
Immediate KILL SESSION: sess: 0x18dd77ea0  OS pid: 1035
Wed Oct 24 20:06:27 2012
Immediate KILL SESSION#: 1616, Serial#: 30253
Immediate KILL SESSION: sess: 0x18dd829e0  OS pid: 11977
Immediate KILL SESSION#: 1626, Serial#: 34413
Immediate KILL SESSION: sess: 0x18dd8fff0  OS pid: 4863

显然大量的KILL SESSION和同一秒发生了ALTER SYSTEM SET SERVICE_NAME有直接关系，根据MOS文档Sessions Get Killed if Connection Use Default Service name (Same as db_name) [ID 730315.1]，这是为公布的Bug 6955040 ALL THE SESSIONS LOST CONNECTION AFTER KILLING CRSD.BIN。
当CRSD进程被杀掉或自动崩溃，会导致CLUSTER检测不到VIP资源的运行，因此数据库会删除默认的服务名并断开所有使用默认服务名的连接。
Oracle在10.2.0.5和11.1.0.7中解决了这个问题，如果没有升级的计划，那么不要使用了DB_NAME相同的服务名进行连接。

Posted in BUG | Tagged alter system set service_names, immediate kill session | Leave a comment

BLOG访问量突破千万

Posted on 2012/11/12 by yangtingkun

从BLOG访问过百万到突破千万，用了超过4年半的时间。
老版的BLOG本以为坚持不到千万的访问量，一方面是新的个人网页会产生一些分流，另一方面ITPUB可能会关闭老版的BLOG，不过没想到这个目标最终还是实现了。
由于大量的文章都保存在老版BLOG中，且早期的绝大部分文章中的超链接也指向了老版的文章，因此老版的更新会一直保持下去，直到ITPUB将整个老版BLOG停掉为止。
而ITPUB的新版BLOG今后不会再进行更新，因为同时维护三份BLOG实在没有什么意义，且浪费太多的时间。
以前确定的两个目标坚持5年的BLOG和访问量达到千万，现在都已经实现，目前看没有什么特别的计划了，以后就可以顺其自然了。

Posted in NEWS | Leave a comment

ORA-600(17067)错误

Posted on 2012/11/11 by yangtingkun

客户9.2.0.6 RAC出现ORA-600[17067]错误。
错误信息如下：

Wed DEC  3 00:51:02 2008
Errors IN file /ora9i/app/oracle/admin/orcl9i/udump/orcl9i2_ora_25250.trc:
ORA-00600: internal error code, arguments: [17067], [0], [], [], [], [], [], []
Wed DEC  3 00:51:07 2008
Errors IN file /ora9i/app/oracle/admin/orcl9i/udump/orcl9i2_ora_25250.trc:
ORA-00600: internal error code, arguments: [26599], [1], [229], [], [], [], [], []
ORA-00600: internal error code, arguments: [17067], [0], [], [], [], [], [], []
ORA-06512: at "SYS.COPYFILE", line 0
ORA-06512: at "ORCL.AUTOUTIL", line 426
ORA-06512: at "ORCL.AUTOUTIL", line 292
ORA-06512: at line 1
Wed DEC  3 00:51:07 2008
Trace dumping IS performing id=[cdmp_20081203005107]
Wed DEC  3 00:51:07 2008
Errors IN file /ora9i/app/oracle/admin/orcl9i/udump/orcl9i2_ora_25250.trc:
ORA-00600: internal error code, arguments: [26599], [1], [229], [], [], [], [], []
ORA-00600: internal error code, arguments: [26599], [1], [229], [], [], [], [], []
ORA-00600: internal error code, arguments: [17067], [0], [], [], [], [], [], []
ORA-06512: at "SYS.COPYFILE", line 0
ORA-06512: at "ORCL.AUTOUTIL", line 426
ORA-06512: at "ORCL.AUTOUTIL", line 292
ORA-06512: at line 1
Wed DEC  3 00:51:08 2008
Errors IN file /ora9i/app/oracle/admin/orcl9i/udump/orcl9i2_ora_25250.trc:
ORA-00600: internal error code, arguments: [26599], [1], [229], [], [], [], [], []
ORA-00600: internal error code, arguments: [26599], [1], [229], [], [], [], [], []
ORA-00600: internal error code, arguments: [26599], [1], [229], [], [], [], [], []
ORA-00600: internal error code, arguments: [17067], [0], [], [], [], [], [], []
ORA-06512: at "SYS.COPYFILE", line 0
ORA-06512: at "ORCL.AUTOUTIL", line 426
ORA-06512: at "ORCL.AUTOUTIL", line 292
ORA-06512: at line 1

对应的详细TRACE如下：

*** 2008-12-03 00:51:02.208
ksedmp: internal OR fatal error
ORA-00600: internal error code, arguments: [17067], [0], [], [], [], [], [], []
CURRENT SQL statement FOR this SESSION:
BEGIN AUTOUTIL.AutoSynSingle(:1) ; END;
----- PL/SQL Call Stack -----
  object      line  object
  handle    NUMBER  name
4b20c5828         0  PROCEDURE SYS.COPYFILE
4b20c75e8       426  package body ORCL.AUTOUTIL
4b20c75e8       292  package body ORCL.AUTOUTIL
4a9af7878         1  anonymous block
----- Call Stack Trace -----
calling              CALL     entry                argument VALUES IN hex      
location             TYPE     point                (? means dubious VALUE)     
-------------------- -------- -------------------- ----------------------------
ksedmp()+328         CALL     ksedst()             00000000B ? 000000000 ?
                                                   000000000 ? 00000004A ?
                                                   FFFFFFFF7FFEA3F8 ?
                                                   1032E18E8 ?
kgeriv()+208         PTR_CALL 0000000000000000     000103705 ? 103705000 ?
                                                   103705468 ? 10370A000 ?
                                                   000102C00 ? 000000000 ?
kgeasi()+180         CALL     kgeriv()             1037056C8 ? 103821CF8 ?
                                                   000000258 ? 0000013C8 ?
                                                   FFFFFFFF7FFEDD18 ?
                                                   103706A98 ?
kglrel()+128         CALL     kgeasi()             1037056C8 ? 103821CF8 ?
                                                   0000042AB ? 000000002 ?
                                                   000000001 ? 000000004 ?
jox24_update_lock()  CALL     kglrel()             1037056C8 ?
+340                                               FFFFFFFF7C99C3F8 ?
                                                   000000000 ?
                                                   FFFFFFFF7FFF7810 ?
                                                   FFFFFFFF7FFEDB28 ?
                                                   FFFFFFFF7FFEDA58 ?
ioc_lookup_name()+8  CALL     jox24_update_lock()  1037056C8 ? 0000053F0 ?
560                                                000005000 ? 4B6C1E380 ?
                                                   102EBA200 ?
                                                   FFFFFFFF7FFF7810 ?
iocbf_lookup_name()  CALL     FFFFFFFF7EA3E580     000000000 ? 4B6C1E380 ?
+8                                                 FFFFFFFF7C980150 ?
                                                   1037056C8 ?
                                                   FFFFFFFF7EA38700 ?
                                                   FFFFFFFF7E858558 ?
ioc_do_call()+276    PTR_CALL 0000000000000000     FFFFFFFF7FFF7810 ?
                                                   FFFFFFFF7FFEF4B8 ?
                                                   000000000 ? 000005000 ?
                                                   103705808 ? 000000000 ?
joet_switched_env_c  CALL     FFFFFFFF7EA4E780     0000012E0 ?
allback()+356                                      FFFFFFFF7E81DA20 ?
                                                   000000000 ?
                                                   FFFFFFFF7FFF7398 ?
                                                   00000000C ?
                                                   FFFFFFFF7FFEF3E8 ?
ioct_lookup_name()+  CALL     joet_switched_env_c  FFFFFFFF7C7BE17C ?
56                            allback()            0FFFFFFFF ?
                                                   FFFFFFFF7E81DA20 ?
                                                   FFFFFFFF7FFEF4B8 ?
                                                   FFFFFFFF7FFEFFA0 ?
                                                   FFFFFFFFFFFFFFFF ?
jom_lookup_active_c  CALL     ioct_lookup_name()   FFFFFFFF7FFF7810 ?
lint_internal()+219                                FFFFFFFF7C7BE17C ?
6                                                  FFFFFFFF7FFEF598 ?
                                                   000000001 ? 000000000 ?
                                                   FFFFFFFF7FFEF5E9 ?
jom_lookup_active_c  CALL     jom_lookup_active_c  000000001 ? 000004000 ?
lint()+32                     lint_internal()      000004300 ? 000000000 ?
                                                   000000000 ? 000000000 ?
jon_find_class()+68  CALL     jom_lookup_active_c  FFFFFFFF7C7BE17C ?
8                             lint()               FFFFFFFF7C8761B8 ?
                                                   00000001D ? 000000000 ?
                                                   000000000 ? 000000001 ?
joncla_for_name0()+  CALL     jon_find_class()     FFFFFFFF7C7BE17C ?
224                                                FFFFFFFF7C8761B8 ?
                                                   00000001D ? 000000000 ?
                                                   000000000 ? 000000000 ?
jtcfs_ffa206dc14_ja  CALL     FFFFFFFF7C16A880     FFFFFFFF7C7BE17C ?
va_lang_Class__forN                                1038C26A3 ? 481E01BBC ?
ame0()+92                                          000000001 ? 000000000 ?
                                                   000000000 ?
jtcfs_ffa206dc14_ja  CALL     jtcfs_ffa206dc14_ja  FFFFFFFF7C7BE17C ?
va_lang_Class__forN           va_lang_Class__forN  FFFFFFFF7FFEFC10 ?
ame__1()+168                  ame0()               1038C26A3 ? 481E01BBC ?
                                                   000000001 ? 000000000 ?
jtcmcalld_ffa206dc1  PTR_CALL 0000000000000000     FFFFFFFF7C7BE17C ?
4_OracleDriver_7__j                                FFFFFFFF7FFF0548 ?
ava_lang_Class__for                                1038C26A3 ? 481E01BBC ?
Name__1()+48                                       FFFFFFFF7FFEFD6B ?
                                                   FFFFFFFF7FFEFD6A ?
jtcfv_ffa206dc14_or  CALL     jtcmcalld_ffa206dc1  FFFFFFFF7C7BE17C ?
acle_jdbc_driver_Or           4_OracleDriver_7__j  FFFFFFFF7FFF0548 ?
acleDriver__getConn           ava_lang_Class__for  1038C732B ? 481E01BBC ?
ectionInstance()+92           Name__1()            000000049 ? 000000000 ?
08                                                 
jtcfv_ffa206dc14_or  CALL     jtcfv_ffa206dc14_or  FFFFFFFF7C7BE17C ?
acle_jdbc_driver_Or           acle_jdbc_driver_Or  FFFFFFFF7C7BE17C ?
acleDriver__connect           acleDriver__getConn  000000000 ?
()+8508                       ectionInstance()     FFFFFFFF7FFF0548 ?
                                                   FFFFFFFF7C869D40 ?
                                                   1038C732B ?
jtcfs_ffa206dc14_ja  CALL     jtcmcalld_ffa206dc1  FFFFFFFF7C7BE17C ?
va_sql_DriverManage           4_DriverManager_7__  FFFFFFFF7C86E4B8 ?
r__getConnection()+           java_sql_Driver__co  1038C732B ?
4768                          nnect()              FFFFFFFF7FFF06E8 ?
                                                   1038C7328 ?
                                                   FFFFFFFF7C875660 ?
jtcfs_ffa206dc14_ja  CALL     jtcfs_ffa206dc14_ja  FFFFFFFF7C875660 ?
va_sql_DriverManage           va_sql_DriverManage  000000000 ?
r__getConnection__1           r__getConnection()   FFFFFFFF7C870068 ?
()+728                                             FFFFFFFF7C8758D0 ?
                                                   FFFFFFFF7C870068 ?
                                                   FFFFFFFF7C870068 ?
jtcmcalld_ffa206dc1  PTR_CALL 0000000000000000     FFFFFFFF7C7BE17C ?
4_OracleDriver_7__j                                FFFFFFFF7C2C3039 ?
ava_sql_DriverManag                                1038DB593 ? 481E01674 ?
er__getConnectio()+                                000000001 ? 000000003 ?
336                                                
jtcfv_ffa206dc14_or  CALL     jtcmcalld_ffa206dc1  FFFFFFFF7C7BE17C ?
acle_jdbc_driver_Or           4_OracleDriver_7__j  FFFFFFFF7FFF10C0 ?
acleDriver__default           ava_sql_DriverManag  000000000 ? 481E01674 ?
Connection()+452              er__getConnection__  FFFFFFFF7C347420 ?
                              1()                  00001F000 ?
jtcmcalldm_ffa206dc  PTR_CALL 0000000000000000     FFFFFFFF78C0C290 ?
14_VersionedObject_                                FFFFFFFF7FFF1460 ?
7__oracle_jdbc_driv                                1038C732B ? 000006C00 ?
er_OracleDriver_()+                                FFFFFFFF7C2C3039 ?
388                                                481E0929D ?
jtcfclinit_ffa206dc  CALL     jtcmcalld_ffa206dc1  FFFFFFFF7C7BE17C ?
14_oracle_aurora_rd           4_VersionedObject_7  FFFFFFFF7FFF1460 ?
bms_security_Versio           __oracle_jdbc_drive  000000000 ?
nedObject()+1100              r_OracleDriver__def  FFFFFFFF7C875650 ?
                              a()                  FFFFFFFF7C2C3039 ?
                                                   FFFFFFFF7FFF11D8 ?
jtcisfclinit_ffa206  CALL     jtcfclinit_ffa206dc  000000003 ? 1038D8F20 ?
dc14_oracle_aurora_           14_oracle_aurora_rd  FFFFFFFF7C875650 ?
rdbms_security_Vers           bms_security_Versio  FFFFFFFF7FFF1460 ?
ionedObject()+72              nedObject()          FFFFFFFF7FFF1460 ?
                                                   481C4E29C ?
joe_init_class()+18  PTR_CALL 0000000000000000     FFFFFFFF7C7BE17C ?
68                                                 1038D8E53 ?
                                                   FFFFFFFF7C2BBF90 ?
                                                   FFFFFFFF7C2BBF90 ?
                                                   0000054F8 ?
                                                   FFFFFFFF7EA5BE30 ?
jtc_make_instance_w  CALL     joe_init_class()     FFFFFFFFFFFFFFEB ?
ith_cpool()+168                                    1038D8E50 ?
                                                   FFFFFFFF78087200 ?
                                                   000000849 ?
                                                   FFFFFFFF7C2C3039 ?
                                                   FFFFFFFF7C7BE17C ?
jtcfc_ffa206dc14_or  CALL     FFFFFFFF781C0FC0     FFFFFFFF7C7BE17C ?
acle_aurora_rdbms_s                                FFFFFFFF7FFF1C08 ?
ecurity_PolicyTable                                1038D8D7B ? 000000002 ?
_8_MyVersionedOb()+                                000000012 ? 000000000 ?
560                                                
jtcfc_ffa206dc14_or  CALL     jtcfc_ffa206dc14_or  FFFFFFFF7C7BE17C ?
acle_aurora_rdbms_s           acle_aurora_rdbms_s  FFFFFFFF7FFF1CF8 ?
ecurity_PolicyTable           ecurity_PolicyTable  1038D8D7B ?
()+2244                       _8_MyVersionedObjec  FFFFFFFF7C875548 ?
                              t()                  FFFFFFFF7C869368 ?
                                                   481E57164 ?
jtctord_ffa206dc14_  PTR_CALL 0000000000000000     FFFFFFFF7C7BE17C ?
SecurityManagerImpl                                FFFFFFFF7C875548 ?
_7__oracle_aurora_r                                1038D9B13 ?
dbms_security_Po()+                                FFFFFFFF7C872900 ?
464                                                FFFFFFFF7C869368 ?
                                                   FFFFFFFF7C872B60 ?
jtcfv_ffa206dc14_or  CALL     jtctord_ffa206dc14_  FFFFFFFF7C7BE17C ?
acle_aurora_rdbms_S           SecurityManagerImpl  FFFFFFFF7FFF2308 ?
ecurityManagerImpl_           _7__oracle_aurora_r  1038C9603 ?
_getPolicyTable()+2           dbms_security_Polic  FFFFFFFF7C872900 ?
424                           y()                  FFFFFFFF7C872AC8 ?
                                                   481E90F7C ?
jtcfc_ffa206dc14_or  CALL     jtcfv_ffa206dc14_or  0000003BA ?
acle_aurora_rdbms_S           acle_aurora_rdbms_S  FFFFFFFF7FFF2308 ?
ecurityManagerImpl(           ecurityManagerImpl_  481E66298 ? 0000003B2 ?
)+140                         _getPolicyTable()    481E5710C ? 07FFF1A41 ?
jtcfv_ffa206dc14_or  CALL     jtcfc_ffa206dc14_or  FFFFFFFF7C7BE17C ?
acle_aurora_rdbms_E           acle_aurora_rdbms_S  FFFFFFFF7FFF24D0 ?
nvironmentSpecificI           ecurityManagerImpl(  1038C9603 ?
mpl__securityMan()+           )                    FFFFFFFF7C869C60 ?
544                                                0000000A4 ?
                                                   FFFFFFFF7C869CF0 ?
jtcmcalldm_ffa206dc  PTR_CALL 0000000000000000     FFFFFFFF7C7BE17C ?
14_EnvironmentSpeci                                FFFFFFFF7FFF26B8 ?
fic_7__oracle_auror                                1038CDE63 ?
a_vm_Environment()+                                FFFFFFFF7AF5E5E8 ?
388                                                FFFFFFFF7AF74EB8 ?
                                                   000000011 ?
jtcfs_ffa206dc14_or  CALL     jtcmcalld_ffa206dc1  FFFFFFFF7C7BE17C ?
acle_aurora_vm_Envi           4_EnvironmentSpecif  FFFFFFFF7FFF26B8 ?
ronmentSpecific__se           ic_7__oracle_aurora  000000000 ?
curityManager()+724           _vm_EnvironmentSpec  FFFFFFFF7C862AA8 ?
                              i()                  FFFFFFFF7C2C3039 ?
                                                   FFFFFFFF7FFF25E8 ?
jtcmcalld_ffa206dc1  PTR_CALL 0000000000000000     FFFFFFFF7C7BE17C ?
4_System_7__oracle_                                000000001 ? 1038C323B ?
aurora_vm_Environme                                481FC9A50 ? 000000000 ?
ntSpecific__secu()+                                1038C3300 ?
320                                                
jtcfs_ffa206dc14_ja  CALL     jtcmcalld_ffa206dc1  FFFFFFFF7C7BE17C ?
va_lang_System__set           4_System_7__oracle_  FFFFFFFF7FFF2910 ?
SecurityManager()+1           aurora_vm_Environme  1038C5A43 ?
36                            ntSpecific__securit  FFFFFFFF7BFCC828 ?
                              y()                  0001A0B1C ?
                                                   FFFFFFFF7C1657E8 ?
jtcfs_ffa206dc14_ja  CALL     jtcfs_ffa206dc14_ja  FFFFFFFF7C7BE17C ?
va_lang_System__ini           va_lang_System__set  FFFFFFFF7FFF2E10 ?
tializeSystemClass(           SecurityManager()    1038C5A43 ? 481FCF29C ?
)+5064                                             FFFFFFFF7C2C3039 ?
                                                   1038C5A40 ?
jtcisfs_ffa206dc14_  CALL     jtcfs_ffa206dc14_ja  FFFFFFFF7C7BE17C ?
java_lang_System__i           va_lang_System__ini  000000308 ? 1038C5A43 ?
nitializeSystemClas           tializeSystemClass(  FFFFFFFF7C85DD80 ?
s()+80                        )                    FFFFFFFF7C868FA0 ?
                                                   FFFFFFFF7C867A68 ?
joet_initialize_sys  PTR_CALL 0000000000000000     FFFFFFFF7C7BE17C ?
tem_class()+1068                                   1038C5A43 ?
                                                   FFFFFFFF7C2BBF48 ?
                                                   FFFFFFFF7C2BBF48 ?
                                                   000000848 ? 000000000 ?
joet_aux_thread_mai  CALL     joet_initialize_sys  000000021 ? 000000000 ?
n()+1248                      tem_class()          1038BFCF3 ? 1038BFCF0 ?
                                                   000000000 ?
                                                   FFFFFFFF7E857208 ?
joet_thread_main()+  CALL     joet_aux_thread_mai  000000001 ?
16                            n()                  FFFFFFFF7C2C4139 ?
                                                   49DC5D9FC ? 000000000 ?
                                                   1038BFCF0 ?
                                                   FFFFFFFF7C7BE17C ?
sjontlo_initialize(  PTR_CALL 0000000000000000     FFFFFFFF7C7BE17C ?
)+84                                               FFFFFFFF7C2C4139 ?
                                                   FFFFFFFFFFFFFFFF ?
                                                   FFFFFFFFFFFFFFF8 ?
                                                   000000000 ?
                                                   FFFFFFFF7FFF4309 ?
joe_enter_vm()+1728  CALL     sjontlo_initialize(  FFFFFFFF7C7BE17C ?
                              )                    FFFFFFFF7E76A020 ?
                                                   FFFFFFFF7C2C4139 ?
                                                   000005220 ?
                                                   FFFFFFFF7C2C4139 ?
                                                   000000001 ?
ioei_call_java()+27  CALL     joe_enter_vm()       FFFFFFFF7FFF7810 ?
20                                                 FFFFFFFF7FFF4B88 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
ioe_call_java()+320  CALL     ioei_call_java()     000000000 ? 000000000 ?
                                                   FFFFFFFF7FFF4DC8 ?
                                                   000000002 ?
                                                   FFFFFFFF7FFF4B88 ?
                                                   FFFFFFFFFFFFFFB9 ?
jox_invoke_java_()+  CALL     FFFFFFFF7EA3F0C0     FFFFFFFF7FFF7810 ?
3816                                               49DC596A8 ? 49DC5D9FC ?
                                                   000000008 ? 4B6CF3635 ?
                                                   000000027 ?
jox_invoke_java()+9  CALL     00000001037017E0     102EBA200 ? 1037056C8 ?
6                                                  103705808 ? 000000008 ?
                                                   4B6CF362C ? 000000000 ?
kkxmjexe()+528       CALL     jox_invoke_java()    1037056C8 ? 00000000E ?
                                                   10383C388 ? 000000002 ?
                                                   000000000 ? 4B6CF365D ?
kgmexcb()+40         PTR_CALL 0000000000000000     000000000 ? 4B6CF35A8 ?
                                                   000000000 ? 4B6CF362C ?
                                                   00000000E ? 000000008 ?
rpiswu2()+384        PTR_CALL 0000000000000000     FFFFFFFF7FFF83F0 ?
                                                   100229D50 ? 000000000 ?
                                                   FFFFFFFF7FFF8448 ?
                                                   00000000A ?
                                                   FFFFFFFEFC7D2480 ?
kkxmswu()+196        CALL     rpiswu2()            48F93E2A0 ? 000103705 ?
                                                   103705690 ? 1037056C8 ?
                                                   000000000 ? 10329F000 ?
kgmexwi()+1452       PTR_CALL 0000000000000000     000000001 ? 000000000 ?
                                                   FFFFFFFF7FFF898C ?
                                                   FFFFFFFFFFFFFFFF ?
                                                   000000001 ? 000000003 ?
kgmexec()+896        CALL     kgmexwi()            00003B418 ?
                                                   FFFFFFFF7C980EC0 ?
                                                   FFFFFFFF7FFF83F0 ?
                                                   FFFFFFFF7C980E48 ?
                                                   4B20C5828 ? 102EBAEA0 ?
pefjavacal()+408     CALL     kgmexec()            4B20C5828 ? 4B6CF35A8 ?
                                                   FFFFFFFF7FFF8930 ?
                                                   1037056C8 ? 1036C47E8 ?
                                                   000000001 ?
pefcal()+84          CALL     pefjavacal()         FFFFFFFF7FFF8CA8 ?
                                                   0001023C3 ? 10383C230 ?
                                                   1023C3000 ?
                                                   FFFFFFFF7FFFB000 ?
                                                   FFFFFFFF7C981348 ?
pevm_FCAL()+124      CALL     pefcal()             FFFFFFFF7FFF8CA8 ?
                                                   FFFFFFFF7C981DB8 ?
                                                   000000000 ? 000000000 ?
                                                   4B6CF31D0 ? 4B6CF3200 ?
pfrrun()+14580       CALL     pevm_FCAL()          FFFFFFFF7CA67BC8 ?
                                                   4B6CF32E8 ? 000000000 ?
                                                   0000000E8 ? 4B6CF32E8 ?
                                                   000000004 ?
peicnt()+268         CALL     pfrrun()             000102ECF ?
                                                   FFFFFFFF7FFFB000 ?
                                                   FFFFFFFF7CA67BC8 ?
                                                   FFFFFFFF7CA67C30 ?
                                                   48F93ED00 ? 103705808 ?
kkxexe()+524         CALL     peicnt()             FFFFFFFF7FFFB000 ?
                                                   FFFFFFFF7CA67BC8 ?
                                                   000000009 ? 10382FCB8 ?
                                                   000102C00 ?
                                                   FFFFFFFF7FFFAE78 ?
opiexe()+9256        CALL     kkxexe()             000103400 ? 000000000 ?
                                                   00000FFFB ?
                                                   FFFFFFFF7CA67BC8 ?
                                                   000000000 ? 103705468 ?
opiall0()+1776       CALL     opiexe()             00000002E ? 10370D808 ?
                                                   FFFFFFFF7CA60490 ?
                                                   10370D800 ?
                                                   FFFFFFFF7CA69068 ?
                                                   103705808 ?
kpoal8()+1040        CALL     opiall0()            000000000 ? 00000005E ?
                                                   FFFFFFFF7FFFC118 ?
                                                   103705808 ?
                                                   FFFFFFFF7CA69068 ?
                                                   FFFFFFFF7FFFC4A8 ?
opiodr()+1688        PTR_CALL 0000000000000000     000000000 ? 000000000 ?
                                                   FFFFFFFF7FFFE960 ?
                                                   000000024 ? 000000000 ?
                                                   0000022B0 ?
ttcpip()+1556        PTR_CALL 0000000000000000     000103400 ? 100FBBFC0 ?
                                                   10370D808 ? 103705808 ?
                                                   103707D40 ?
                                                   FFFFFFFF7FFFCB00 ?
opitsk()+984         CALL     ttcpip()             10370D800 ? 000000014 ?
                                                   FFFFFFFF7FFFE960 ?
                                                   000000000 ? 000000000 ?
                                                   FFFFFFFF7FFFDC4C ?
opiino()+1572        CALL     opitsk()             000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   103707D28 ?
                                                   FFFFFFFF7FFFEAB4 ?
opiodr()+1688        PTR_CALL 0000000000000000     000380007 ? 10370C658 ?
                                                   1037F9458 ?
                                                   FFFFFFFF7FFFF7F0 ?
                                                   000000000 ? 492889EF8 ?
opidrv()+736         CALL     opiodr()             000103400 ? 10100C380 ?
                                                   10370D808 ? 103705808 ?
                                                   103707D40 ?
                                                   FFFFFFFF7FFFF310 ?
sou2o()+16           CALL     opidrv()             000000000 ? 000000004 ?
                                                   1037051EC ? 00000003C ?
                                                   1037056C8 ? 000103400 ?
main()+184           CALL     sou2o()              FFFFFFFF7FFFF810 ?
                                                   00000003C ? 000000004 ?
                                                   FFFFFFFF7FFFF7F0 ?
                                                   000039E70 ? 000000000 ?
_start()+380         CALL     main()               000000002 ?
                                                   FFFFFFFF7FFFF958 ?
                                                   FFFFFFFF7FFFF970 ?
                                                   000000000 ? 000000000 ?
                                                   100000000 ?
--------------------- Binary Stack Dump ---------------------

*** 2008-12-03 00:51:02.208 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [17067], [0], [], [], [], [], [], [] Current SQL statement for this session: BEGIN AUTOUTIL.AutoSynSingle(:1) ; END; ----- PL/SQL Call Stack ----- object line object handle number name 4b20c5828 0 procedure SYS.COPYFILE 4b20c75e8 426 package body ORCL.AUTOUTIL 4b20c75e8 292 package body ORCL.AUTOUTIL 4a9af7878 1 anonymous block ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- ksedmp()+328 CALL ksedst() 00000000B ? 000000000 ? 000000000 ? 00000004A ? FFFFFFFF7FFEA3F8 ? 1032E18E8 ? kgeriv()+208 PTR_CALL 0000000000000000 000103705 ? 103705000 ? 103705468 ? 10370A000 ? 000102C00 ? 000000000 ? kgeasi()+180 CALL kgeriv() 1037056C8 ? 103821CF8 ? 000000258 ? 0000013C8 ? FFFFFFFF7FFEDD18 ? 103706A98 ? kglrel()+128 CALL kgeasi() 1037056C8 ? 103821CF8 ? 0000042AB ? 000000002 ? 000000001 ? 000000004 ? jox24_update_lock() CALL kglrel() 1037056C8 ? +340 FFFFFFFF7C99C3F8 ? 000000000 ? FFFFFFFF7FFF7810 ? FFFFFFFF7FFEDB28 ? FFFFFFFF7FFEDA58 ? ioc_lookup_name()+8 CALL jox24_update_lock() 1037056C8 ? 0000053F0 ? 560 000005000 ? 4B6C1E380 ? 102EBA200 ? FFFFFFFF7FFF7810 ? iocbf_lookup_name() CALL FFFFFFFF7EA3E580 000000000 ? 4B6C1E380 ? +8 FFFFFFFF7C980150 ? 1037056C8 ? FFFFFFFF7EA38700 ? FFFFFFFF7E858558 ? ioc_do_call()+276 PTR_CALL 0000000000000000 FFFFFFFF7FFF7810 ? FFFFFFFF7FFEF4B8 ? 000000000 ? 000005000 ? 103705808 ? 000000000 ? joet_switched_env_c CALL FFFFFFFF7EA4E780 0000012E0 ? allback()+356 FFFFFFFF7E81DA20 ? 000000000 ? FFFFFFFF7FFF7398 ? 00000000C ? FFFFFFFF7FFEF3E8 ? ioct_lookup_name()+ CALL joet_switched_env_c FFFFFFFF7C7BE17C ? 56 allback() 0FFFFFFFF ? FFFFFFFF7E81DA20 ? FFFFFFFF7FFEF4B8 ? FFFFFFFF7FFEFFA0 ? FFFFFFFFFFFFFFFF ? jom_lookup_active_c CALL ioct_lookup_name() FFFFFFFF7FFF7810 ? lint_internal()+219 FFFFFFFF7C7BE17C ? 6 FFFFFFFF7FFEF598 ? 000000001 ? 000000000 ? FFFFFFFF7FFEF5E9 ? jom_lookup_active_c CALL jom_lookup_active_c 000000001 ? 000004000 ? lint()+32 lint_internal() 000004300 ? 000000000 ? 000000000 ? 000000000 ? jon_find_class()+68 CALL jom_lookup_active_c FFFFFFFF7C7BE17C ? 8 lint() FFFFFFFF7C8761B8 ? 00000001D ? 000000000 ? 000000000 ? 000000001 ? joncla_for_name0()+ CALL jon_find_class() FFFFFFFF7C7BE17C ? 224 FFFFFFFF7C8761B8 ? 00000001D ? 000000000 ? 000000000 ? 000000000 ? jtcfs_ffa206dc14_ja CALL FFFFFFFF7C16A880 FFFFFFFF7C7BE17C ? va_lang_Class__forN 1038C26A3 ? 481E01BBC ? ame0()+92 000000001 ? 000000000 ? 000000000 ? jtcfs_ffa206dc14_ja CALL jtcfs_ffa206dc14_ja FFFFFFFF7C7BE17C ? va_lang_Class__forN va_lang_Class__forN FFFFFFFF7FFEFC10 ? ame__1()+168 ame0() 1038C26A3 ? 481E01BBC ? 000000001 ? 000000000 ? jtcmcalld_ffa206dc1 PTR_CALL 0000000000000000 FFFFFFFF7C7BE17C ? 4_OracleDriver_7__j FFFFFFFF7FFF0548 ? ava_lang_Class__for 1038C26A3 ? 481E01BBC ? Name__1()+48 FFFFFFFF7FFEFD6B ? FFFFFFFF7FFEFD6A ? jtcfv_ffa206dc14_or CALL jtcmcalld_ffa206dc1 FFFFFFFF7C7BE17C ? acle_jdbc_driver_Or 4_OracleDriver_7__j FFFFFFFF7FFF0548 ? acleDriver__getConn ava_lang_Class__for 1038C732B ? 481E01BBC ? ectionInstance()+92 Name__1() 000000049 ? 000000000 ? 08 jtcfv_ffa206dc14_or CALL jtcfv_ffa206dc14_or FFFFFFFF7C7BE17C ? acle_jdbc_driver_Or acle_jdbc_driver_Or FFFFFFFF7C7BE17C ? acleDriver__connect acleDriver__getConn 000000000 ? ()+8508 ectionInstance() FFFFFFFF7FFF0548 ? FFFFFFFF7C869D40 ? 1038C732B ? jtcfs_ffa206dc14_ja CALL jtcmcalld_ffa206dc1 FFFFFFFF7C7BE17C ? va_sql_DriverManage 4_DriverManager_7__ FFFFFFFF7C86E4B8 ? r__getConnection()+ java_sql_Driver__co 1038C732B ? 4768 nnect() FFFFFFFF7FFF06E8 ? 1038C7328 ? FFFFFFFF7C875660 ? jtcfs_ffa206dc14_ja CALL jtcfs_ffa206dc14_ja FFFFFFFF7C875660 ? va_sql_DriverManage va_sql_DriverManage 000000000 ? r__getConnection__1 r__getConnection() FFFFFFFF7C870068 ? ()+728 FFFFFFFF7C8758D0 ? FFFFFFFF7C870068 ? FFFFFFFF7C870068 ? jtcmcalld_ffa206dc1 PTR_CALL 0000000000000000 FFFFFFFF7C7BE17C ? 4_OracleDriver_7__j FFFFFFFF7C2C3039 ? ava_sql_DriverManag 1038DB593 ? 481E01674 ? er__getConnectio()+ 000000001 ? 000000003 ? 336 jtcfv_ffa206dc14_or CALL jtcmcalld_ffa206dc1 FFFFFFFF7C7BE17C ? acle_jdbc_driver_Or 4_OracleDriver_7__j FFFFFFFF7FFF10C0 ? acleDriver__default ava_sql_DriverManag 000000000 ? 481E01674 ? Connection()+452 er__getConnection__ FFFFFFFF7C347420 ? 1() 00001F000 ? jtcmcalldm_ffa206dc PTR_CALL 0000000000000000 FFFFFFFF78C0C290 ? 14_VersionedObject_ FFFFFFFF7FFF1460 ? 7__oracle_jdbc_driv 1038C732B ? 000006C00 ? er_OracleDriver_()+ FFFFFFFF7C2C3039 ? 388 481E0929D ? jtcfclinit_ffa206dc CALL jtcmcalld_ffa206dc1 FFFFFFFF7C7BE17C ? 14_oracle_aurora_rd 4_VersionedObject_7 FFFFFFFF7FFF1460 ? bms_security_Versio __oracle_jdbc_drive 000000000 ? nedObject()+1100 r_OracleDriver__def FFFFFFFF7C875650 ? a() FFFFFFFF7C2C3039 ? FFFFFFFF7FFF11D8 ? jtcisfclinit_ffa206 CALL jtcfclinit_ffa206dc 000000003 ? 1038D8F20 ? dc14_oracle_aurora_ 14_oracle_aurora_rd FFFFFFFF7C875650 ? rdbms_security_Vers bms_security_Versio FFFFFFFF7FFF1460 ? ionedObject()+72 nedObject() FFFFFFFF7FFF1460 ? 481C4E29C ? joe_init_class()+18 PTR_CALL 0000000000000000 FFFFFFFF7C7BE17C ? 68 1038D8E53 ? FFFFFFFF7C2BBF90 ? FFFFFFFF7C2BBF90 ? 0000054F8 ? FFFFFFFF7EA5BE30 ? jtc_make_instance_w CALL joe_init_class() FFFFFFFFFFFFFFEB ? ith_cpool()+168 1038D8E50 ? FFFFFFFF78087200 ? 000000849 ? FFFFFFFF7C2C3039 ? FFFFFFFF7C7BE17C ? jtcfc_ffa206dc14_or CALL FFFFFFFF781C0FC0 FFFFFFFF7C7BE17C ? acle_aurora_rdbms_s FFFFFFFF7FFF1C08 ? ecurity_PolicyTable 1038D8D7B ? 000000002 ? _8_MyVersionedOb()+ 000000012 ? 000000000 ? 560 jtcfc_ffa206dc14_or CALL jtcfc_ffa206dc14_or FFFFFFFF7C7BE17C ? acle_aurora_rdbms_s acle_aurora_rdbms_s FFFFFFFF7FFF1CF8 ? ecurity_PolicyTable ecurity_PolicyTable 1038D8D7B ? ()+2244 _8_MyVersionedObjec FFFFFFFF7C875548 ? t() FFFFFFFF7C869368 ? 481E57164 ? jtctord_ffa206dc14_ PTR_CALL 0000000000000000 FFFFFFFF7C7BE17C ? SecurityManagerImpl FFFFFFFF7C875548 ? _7__oracle_aurora_r 1038D9B13 ? dbms_security_Po()+ FFFFFFFF7C872900 ? 464 FFFFFFFF7C869368 ? FFFFFFFF7C872B60 ? jtcfv_ffa206dc14_or CALL jtctord_ffa206dc14_ FFFFFFFF7C7BE17C ? acle_aurora_rdbms_S SecurityManagerImpl FFFFFFFF7FFF2308 ? ecurityManagerImpl_ _7__oracle_aurora_r 1038C9603 ? _getPolicyTable()+2 dbms_security_Polic FFFFFFFF7C872900 ? 424 y() FFFFFFFF7C872AC8 ? 481E90F7C ? jtcfc_ffa206dc14_or CALL jtcfv_ffa206dc14_or 0000003BA ? acle_aurora_rdbms_S acle_aurora_rdbms_S FFFFFFFF7FFF2308 ? ecurityManagerImpl( ecurityManagerImpl_ 481E66298 ? 0000003B2 ? )+140 _getPolicyTable() 481E5710C ? 07FFF1A41 ? jtcfv_ffa206dc14_or CALL jtcfc_ffa206dc14_or FFFFFFFF7C7BE17C ? acle_aurora_rdbms_E acle_aurora_rdbms_S FFFFFFFF7FFF24D0 ? nvironmentSpecificI ecurityManagerImpl( 1038C9603 ? mpl__securityMan()+ ) FFFFFFFF7C869C60 ? 544 0000000A4 ? FFFFFFFF7C869CF0 ? jtcmcalldm_ffa206dc PTR_CALL 0000000000000000 FFFFFFFF7C7BE17C ? 14_EnvironmentSpeci FFFFFFFF7FFF26B8 ? fic_7__oracle_auror 1038CDE63 ? a_vm_Environment()+ FFFFFFFF7AF5E5E8 ? 388 FFFFFFFF7AF74EB8 ? 000000011 ? jtcfs_ffa206dc14_or CALL jtcmcalld_ffa206dc1 FFFFFFFF7C7BE17C ? acle_aurora_vm_Envi 4_EnvironmentSpecif FFFFFFFF7FFF26B8 ? ronmentSpecific__se ic_7__oracle_aurora 000000000 ? curityManager()+724 _vm_EnvironmentSpec FFFFFFFF7C862AA8 ? i() FFFFFFFF7C2C3039 ? FFFFFFFF7FFF25E8 ? jtcmcalld_ffa206dc1 PTR_CALL 0000000000000000 FFFFFFFF7C7BE17C ? 4_System_7__oracle_ 000000001 ? 1038C323B ? aurora_vm_Environme 481FC9A50 ? 000000000 ? ntSpecific__secu()+ 1038C3300 ? 320 jtcfs_ffa206dc14_ja CALL jtcmcalld_ffa206dc1 FFFFFFFF7C7BE17C ? va_lang_System__set 4_System_7__oracle_ FFFFFFFF7FFF2910 ? SecurityManager()+1 aurora_vm_Environme 1038C5A43 ? 36 ntSpecific__securit FFFFFFFF7BFCC828 ? y() 0001A0B1C ? FFFFFFFF7C1657E8 ? jtcfs_ffa206dc14_ja CALL jtcfs_ffa206dc14_ja FFFFFFFF7C7BE17C ? va_lang_System__ini va_lang_System__set FFFFFFFF7FFF2E10 ? tializeSystemClass( SecurityManager() 1038C5A43 ? 481FCF29C ? )+5064 FFFFFFFF7C2C3039 ? 1038C5A40 ? jtcisfs_ffa206dc14_ CALL jtcfs_ffa206dc14_ja FFFFFFFF7C7BE17C ? java_lang_System__i va_lang_System__ini 000000308 ? 1038C5A43 ? nitializeSystemClas tializeSystemClass( FFFFFFFF7C85DD80 ? s()+80 ) FFFFFFFF7C868FA0 ? FFFFFFFF7C867A68 ? joet_initialize_sys PTR_CALL 0000000000000000 FFFFFFFF7C7BE17C ? tem_class()+1068 1038C5A43 ? FFFFFFFF7C2BBF48 ? FFFFFFFF7C2BBF48 ? 000000848 ? 000000000 ? joet_aux_thread_mai CALL joet_initialize_sys 000000021 ? 000000000 ? n()+1248 tem_class() 1038BFCF3 ? 1038BFCF0 ? 000000000 ? FFFFFFFF7E857208 ? joet_thread_main()+ CALL joet_aux_thread_mai 000000001 ? 16 n() FFFFFFFF7C2C4139 ? 49DC5D9FC ? 000000000 ? 1038BFCF0 ? FFFFFFFF7C7BE17C ? sjontlo_initialize( PTR_CALL 0000000000000000 FFFFFFFF7C7BE17C ? )+84 FFFFFFFF7C2C4139 ? FFFFFFFFFFFFFFFF ? FFFFFFFFFFFFFFF8 ? 000000000 ? FFFFFFFF7FFF4309 ? joe_enter_vm()+1728 CALL sjontlo_initialize( FFFFFFFF7C7BE17C ? ) FFFFFFFF7E76A020 ? FFFFFFFF7C2C4139 ? 000005220 ? FFFFFFFF7C2C4139 ? 000000001 ? ioei_call_java()+27 CALL joe_enter_vm() FFFFFFFF7FFF7810 ? 20 FFFFFFFF7FFF4B88 ? 000000000 ? 000000000 ? 000000000 ? 000000000 ? ioe_call_java()+320 CALL ioei_call_java() 000000000 ? 000000000 ? FFFFFFFF7FFF4DC8 ? 000000002 ? FFFFFFFF7FFF4B88 ? FFFFFFFFFFFFFFB9 ? jox_invoke_java_()+ CALL FFFFFFFF7EA3F0C0 FFFFFFFF7FFF7810 ? 3816 49DC596A8 ? 49DC5D9FC ? 000000008 ? 4B6CF3635 ? 000000027 ? jox_invoke_java()+9 CALL 00000001037017E0 102EBA200 ? 1037056C8 ? 6 103705808 ? 000000008 ? 4B6CF362C ? 000000000 ? kkxmjexe()+528 CALL jox_invoke_java() 1037056C8 ? 00000000E ? 10383C388 ? 000000002 ? 000000000 ? 4B6CF365D ? kgmexcb()+40 PTR_CALL 0000000000000000 000000000 ? 4B6CF35A8 ? 000000000 ? 4B6CF362C ? 00000000E ? 000000008 ? rpiswu2()+384 PTR_CALL 0000000000000000 FFFFFFFF7FFF83F0 ? 100229D50 ? 000000000 ? FFFFFFFF7FFF8448 ? 00000000A ? FFFFFFFEFC7D2480 ? kkxmswu()+196 CALL rpiswu2() 48F93E2A0 ? 000103705 ? 103705690 ? 1037056C8 ? 000000000 ? 10329F000 ? kgmexwi()+1452 PTR_CALL 0000000000000000 000000001 ? 000000000 ? FFFFFFFF7FFF898C ? FFFFFFFFFFFFFFFF ? 000000001 ? 000000003 ? kgmexec()+896 CALL kgmexwi() 00003B418 ? FFFFFFFF7C980EC0 ? FFFFFFFF7FFF83F0 ? FFFFFFFF7C980E48 ? 4B20C5828 ? 102EBAEA0 ? pefjavacal()+408 CALL kgmexec() 4B20C5828 ? 4B6CF35A8 ? FFFFFFFF7FFF8930 ? 1037056C8 ? 1036C47E8 ? 000000001 ? pefcal()+84 CALL pefjavacal() FFFFFFFF7FFF8CA8 ? 0001023C3 ? 10383C230 ? 1023C3000 ? FFFFFFFF7FFFB000 ? FFFFFFFF7C981348 ? pevm_FCAL()+124 CALL pefcal() FFFFFFFF7FFF8CA8 ? FFFFFFFF7C981DB8 ? 000000000 ? 000000000 ? 4B6CF31D0 ? 4B6CF3200 ? pfrrun()+14580 CALL pevm_FCAL() FFFFFFFF7CA67BC8 ? 4B6CF32E8 ? 000000000 ? 0000000E8 ? 4B6CF32E8 ? 000000004 ? peicnt()+268 CALL pfrrun() 000102ECF ? FFFFFFFF7FFFB000 ? FFFFFFFF7CA67BC8 ? FFFFFFFF7CA67C30 ? 48F93ED00 ? 103705808 ? kkxexe()+524 CALL peicnt() FFFFFFFF7FFFB000 ? FFFFFFFF7CA67BC8 ? 000000009 ? 10382FCB8 ? 000102C00 ? FFFFFFFF7FFFAE78 ? opiexe()+9256 CALL kkxexe() 000103400 ? 000000000 ? 00000FFFB ? FFFFFFFF7CA67BC8 ? 000000000 ? 103705468 ? opiall0()+1776 CALL opiexe() 00000002E ? 10370D808 ? FFFFFFFF7CA60490 ? 10370D800 ? FFFFFFFF7CA69068 ? 103705808 ? kpoal8()+1040 CALL opiall0() 000000000 ? 00000005E ? FFFFFFFF7FFFC118 ? 103705808 ? FFFFFFFF7CA69068 ? FFFFFFFF7FFFC4A8 ? opiodr()+1688 PTR_CALL 0000000000000000 000000000 ? 000000000 ? FFFFFFFF7FFFE960 ? 000000024 ? 000000000 ? 0000022B0 ? ttcpip()+1556 PTR_CALL 0000000000000000 000103400 ? 100FBBFC0 ? 10370D808 ? 103705808 ? 103707D40 ? FFFFFFFF7FFFCB00 ? opitsk()+984 CALL ttcpip() 10370D800 ? 000000014 ? FFFFFFFF7FFFE960 ? 000000000 ? 000000000 ? FFFFFFFF7FFFDC4C ? opiino()+1572 CALL opitsk() 000000000 ? 000000000 ? 000000000 ? 000000000 ? 103707D28 ? FFFFFFFF7FFFEAB4 ? opiodr()+1688 PTR_CALL 0000000000000000 000380007 ? 10370C658 ? 1037F9458 ? FFFFFFFF7FFFF7F0 ? 000000000 ? 492889EF8 ? opidrv()+736 CALL opiodr() 000103400 ? 10100C380 ? 10370D808 ? 103705808 ? 103707D40 ? FFFFFFFF7FFFF310 ? sou2o()+16 CALL opidrv() 000000000 ? 000000004 ? 1037051EC ? 00000003C ? 1037056C8 ? 000103400 ? main()+184 CALL sou2o() FFFFFFFF7FFFF810 ? 00000003C ? 000000004 ? FFFFFFFF7FFFF7F0 ? 000039E70 ? 000000000 ? _start()+380 CALL main() 000000002 ? FFFFFFFF7FFFF958 ? FFFFFFFF7FFFF970 ? 000000000 ? 000000000 ? 100000000 ? --------------------- Binary Stack Dump ---------------------

根据MOS文档Bug 3691672 – OERI[17067]/ OERI[26599] / dump (kgllkdl) from JavaVM / OERI:1100 from PMON [ID 3691672.8]，这是9206上访问JAVA程序的bug。当高并发访问数据库中的JAVA程序，可能会引发这个错误。

SQL> SELECT TEXT FROM DBA_SOURCE WHERE NAME = 'COPYFILE' ORDER BY LINE;
TEXT
----------------------------------------------------------------------------------------
PROCEDURE CopyFile(sOldFileName IN varchar2,sNewFileName IN varchar2)
AS LANGUAGE JAVA
NAME 'XhphotoFileUtil.copyFile(java.lang.String, java.lang.String)';

当前的会话堆栈中存在大量JAVA过程的调用，检查报错调用的COPYFILE过程，果然是存储在数据库中的JAVA存储过程。
Oracle在9.2.0.7、10.1.0.4和10.2.0.1中解决了这个错误。

Posted in BUG | Tagged 17067, 26599, JAVA, ORA-600 | Leave a comment

20121110 Oracle技术嘉年华落幕

Posted on 2012/11/10 by yangtingkun

时间总是很短暂，两天的技术嘉年华今天成功落幕。
今天上午我有一个关于ODA的主题，之所以想和大家分享做一个近似产品介绍的主题，是因为在8月份现场对ODA进行了测试后，确认发现了ODA很多值得称道的地方。而且这次在OOW上听了很多关于ODA的主题，发现在国外，很多客户已经广泛的使用了ODA。而在国内，听说过一体机和Exadata的人很多，但是对ODA有了解的凤毛麟角。于是这次的主题就选择了ODA。
在下午最后一场圆桌会议时，时间已经超过了6点30，而现场仍然存在大量的技术人员在不断的向嘉宾提问，气氛空前热烈。这也使得我们很受鼓舞，大家对于我们的技术会议投以极大的热情，我们在明年一定会将更完善更专业的大会带给大家，希望大家明年再见。

Posted in NEWS | Tagged ACOUG, OTN CHINA TOUR | Leave a comment

yangtingkun

关闭数据库出现PMON failed to acquire latch信息

ORA-600(kocgor077)错误

ORA-21780、ORA-4030、ORA-600(keltenq)、SMG-3000、SMG-3503错误

控制文件自动备份报错并产生TRACE文件

ORA-600(ktspfnsb-1)错误

ORA-1000导致的ORA-7445错误

更改SERVICE_NAME导致大量会话被KILL

BLOG访问量突破千万

ORA-600(17067)错误

20121110 Oracle技术嘉年华落幕

Recent Posts

Recent Comments

Archives

Categories

Meta