oracle发生600号错误，敢不敢重新启动？

显示全部楼层 · 2010-5-13 10:04:27

一分钟产生许多的trace文件，内容都一样。如下：
/oracle/app/oracle/admin/ora9i/bdump/ora9i2_ora_6378.trc
Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
With the Partitioning and Real Application Clusters options
JServer Release 9.2.0.2.0 - Production
ORACLE_HOME = /oracle/app/oracle/product/9.2.0.2
System name:AIX
Node name:lanzhou_CS2
Release:3
Version:4
Machine:000CA72A4C00
Instance name: ora9i2
Redo thread mounted by this instance: 2
Oracle process number: 0
6378
Number of Serviceable Networks detected is less than 2
Disabling Transparent Network Failover Feature.
#pg alert_ora9i2.log
Tue Sep7 11:10:22 2004
Errors in file /oracle/app/oracle/admin/ora9i/udump/ora9i2_ora_40122.trc:
ORA-00600: 内部错误代码，参数: [ttcgcshnd-1], [0], [], [], [], [], [], []
Tue Sep7 11:20:41 2004
Errors in file /oracle/app/oracle/admin/ora9i/udump/ora9i2_ora_30306.trc:
ORA-00600: 内部错误代码，参数: [ttcgcshnd-1], [0], [], [], [], [], [], []
Tue Sep7 11:30:12 2004
Errors in file /oracle/app/oracle/admin/ora9i/udump/ora9i2_ora_30848.trc:
ORA-00600: 内部错误代码，参数: [ttcgcshnd-1], [0], [], [], [], [], [], []
(EOF):
数据库使用正常，敢不敢重新启动？

千问 · 2010-5-13 10:04:27

贴出你的ora9i2_ora_40122.trc文件的内容出来看看。
是否使用了JDBC Thin Driver？

千问 · 2010-5-13 10:04:27

可以的,主要是为什么要重新启动？
有时执行某个SQL就引起了ora600，并不是什么大不了的问题，
如果你不解决问题,重启了还是会有ora600的。

千问 · 2010-5-13 10:04:27

发现rac的每个节点上都报
Number of Serviceable Networks detected is less than 2
Disabling Transparent Network Failover Feature.
我查了metalink说是hacmp或network的错误，但是经过检查没有错误
。
只有2号节点，报600号错误。
故障的原因可能是由于2号节点的trace文件占完了2号机器的oracle文件系统空间，造成legato不能做归档备份。归档文件系统满了后，数据库不能切出归档。造成了oracle出错了。
我想问的是，现在能不能重新启动2号节点的oracle实例！
谢谢！

千问 · 2010-5-13 10:04:27

當然可以﹐有什么問題嗎﹖

千问 · 2010-5-13 10:04:27

ora9i2_ora_30306.trc
ora9i2_ora_30848.trc
的错误内容？
最好打补丁到9204

千问 · 2010-5-13 10:04:27

最初由龙鸽发布
[B]一分钟产生许多的trace文件，内容都一样。如下：
/oracle/app/oracle/admin/ora9i/bdump/ora9i2_ora_6378.trc
Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production
With the Partitioning and Real Application Clusters options
JServer Release 9.2.0.2.0 - Production
ORACLE_HOME = /oracle/app/oracle/product/9.2.0.2
System name:AIX
Node name:lanzhou_CS2
Release:3
Version:4
Machine:000CA72A4C00
Instance name: ora9i2
Redo thread mounted by this instance: 2
Oracle process number: 0
6378
Number of Serviceable Networks detected is less than 2
Disabling Transparent Network Failover Feature.
#pg alert_ora9i2.log
Tue Sep7 11:10:22 2004
Errors in file /oracle/app/oracle/admin/ora9i/udump/ora9i2_ora_40122.trc:
ORA-00600: 内部错误代码，参数: [ttcgcshnd-1], [0], [], [], [], [], [], []
Tue Sep7 11:20:41 2004
Errors in file /oracle/app/oracle/admin/ora9i/udump/ora9i2_ora_30306.trc:
ORA-00600: 内部错误代码，参数: [ttcgcshnd-1], [0], [], [], [], [], [], []
Tue Sep7 11:30:12 2004
Errors in file /oracle/app/oracle/admin/ora9i/udump/ora9i2_ora_30848.trc:
ORA-00600: 内部错误代码，参数: [ttcgcshnd-1], [0], [], [], [], [], [], []
(EOF):
数据库使用正常，敢不敢重新启动？ [/B]