SKGXP_KEEPALIVE_RESET messages in trace files
昨天下午,网络的同事调整接入层设备导致public 网络有短暂的中断,在RAC双节点的trace目录中各产生了如下的信息:/oracle/app/admin/pcendb/bdump/*****_lck0_1634484.trcOracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Oracle Label Security, OLAP,Data Mining and Real Application Testing optionsORACLE_HOME = /oracle/app/product/10.2.0System name: AIXNode name: *****Release: 1Version: 6Machine: 00C23A554C00Instance name: *****Redo
ksukia: Starting kill, force = 0 Message in trace files
/oracle/app/admin/pcendb/udump/*****_ora_3055724.trcOracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Oracle Label Security, OLAP,Data Mining and Real Application Testing optionsORACLE_HOME = /oracle/app/product/10.2.0System name: AIXNode name: *****Release: 1Version: 6Machine: 00C238C54C00Instance name: *****Redo thread mounted by this instance: 2Oracle process number: 61Unix process pid: 3055724, image: oracle@***** (T
SKGXPLOSTACK message in trace files
因为操作系统的一个bug, 我们对一个两节点的RAC做了一次切换以升级操作系统,导致有些应用在两个节点上都有连接,随后的几天经常在两个节点上的 trace 文件中发现如下的信息: /oracle/app/admin/pcendb/bdump/******_m000_1982704.trcOracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Oracle Label Security, OLAP,Data Mining and Real Application Testing optionsORACLE_HOME = /oracle/app/product/10.2.0System name: AIXNode name: *****Release:
WARNING:Could not lower the asynch I/O limit to 160 for SQL direct I/O. It is set to -1
最近一个运行了三年的系统bdump和udump目录突然生成大量类似下面关于异步io的警告。/oracle/app/admin/pcendb/bdump/*****_m001_1065178.trcOracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, Oracle Label Security, OLAP,Data Mining and Real Application Testing optionsORACLE_HOME = /oracle/app/product/10.2.0System name: AIXNode name: *****Release: 1Version: 6Machine: 00C23A554C00Instance name: *****Redo thread mounted by this instan