从数据库alert中发现如下错误:
Fri Mar 01 16:34:38 2013
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_9360.trc (incident=284103):
ORA-03137: TTC 协议内部错误: [12333] [76] [76] [79] [] [] [] []
Incident details in: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_284103\orcl_ora_9360_i284103.trc
Fri Mar 01 16:34:41 2013
Trace dumping is performing id=[cdmp_20130301163441]
Fri Mar 01 16:34:42 2013
Sweep [inc][284103]: completed
Sweep [inc2][284103]: completedorcl_ora_9360.trc文件内容为:PROF: Release 11.2.0.1.0 - Development on 星期一 3月 4 14:34:11 2013Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.Trace file: C:\Users\Administrator\Desktop\orcl_ora_9360.trc
Sort options: default********************************************************************************
count = number of times OCI procedure was executed
cpu = cpu time in seconds executing
elapsed = elapsed time in seconds executing
disk = number of physical reads of buffers from disk
query = number of buffers gotten for consistent read
current = number of buffers gotten in current mode (usually for update)
rows = number of rows processed by the fetch or execute call
********************************************************************************
Trace file: C:\Users\Administrator\Desktop\orcl_ora_9360.trc
Trace file compatibility: 11.1.0.7
Sort options: default 1 session in tracefile.
0 user SQL statements in trace file.
0 internal SQL statements in trace file.
0 SQL statements in trace file.
0 unique SQL statements in trace file.
18570 lines in trace file.
0 elapsed seconds in trace file.数据库版本为11.2.0.1.0,安装在Windows2008 server上。经过排查,ora-03137属于oracle内部错误,但是因没有metalink账号,所以没有解决,但是目前发现数据库实例会突然关闭,但是alert中没有任何异常信息,大家帮忙看下,会不会是这个bug导致的?数据库内部错误ora-03137
Fri Mar 01 16:34:38 2013
Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_ora_9360.trc (incident=284103):
ORA-03137: TTC 协议内部错误: [12333] [76] [76] [79] [] [] [] []
Incident details in: d:\app\administrator\diag\rdbms\orcl\orcl\incident\incdir_284103\orcl_ora_9360_i284103.trc
Fri Mar 01 16:34:41 2013
Trace dumping is performing id=[cdmp_20130301163441]
Fri Mar 01 16:34:42 2013
Sweep [inc][284103]: completed
Sweep [inc2][284103]: completedorcl_ora_9360.trc文件内容为:PROF: Release 11.2.0.1.0 - Development on 星期一 3月 4 14:34:11 2013Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.Trace file: C:\Users\Administrator\Desktop\orcl_ora_9360.trc
Sort options: default********************************************************************************
count = number of times OCI procedure was executed
cpu = cpu time in seconds executing
elapsed = elapsed time in seconds executing
disk = number of physical reads of buffers from disk
query = number of buffers gotten for consistent read
current = number of buffers gotten in current mode (usually for update)
rows = number of rows processed by the fetch or execute call
********************************************************************************
Trace file: C:\Users\Administrator\Desktop\orcl_ora_9360.trc
Trace file compatibility: 11.1.0.7
Sort options: default 1 session in tracefile.
0 user SQL statements in trace file.
0 internal SQL statements in trace file.
0 SQL statements in trace file.
0 unique SQL statements in trace file.
18570 lines in trace file.
0 elapsed seconds in trace file.数据库版本为11.2.0.1.0,安装在Windows2008 server上。经过排查,ora-03137属于oracle内部错误,但是因没有metalink账号,所以没有解决,但是目前发现数据库实例会突然关闭,但是alert中没有任何异常信息,大家帮忙看下,会不会是这个bug导致的?数据库内部错误ora-03137
[email protected]