今天巡检发现一oracle 10.2.0.4 sqlplus hang :
messages ,alert.log 均没有错误 。
ps -ef
oracle 17710 1 0 Aug02 ? 01:23:54 oraclerac2 (LOCAL=NO)
oracle 18124 1 0 Aug02 ? 00:27:19 oraclerac2 (LOCAL=NO)
oracle 18131 1 0 Aug02 ? 00:30:34 oraclerac2 (LOCAL=NO)
oracle 18133 1 0 Aug02 ? 00:31:11 oraclerac2 (LOCAL=NO)
oracle 19936 1 0 Aug03 ? 01:22:03 oraclerac2 (LOCAL=NO)
oracle 26945 1 0 Aug04 ? 00:14:04 oraclerac2 (LOCAL=NO)
oracle 26951 1 0 Aug04 ? 00:44:39 oraclerac2 (LOCAL=NO)
oracle 26953 1 0 Aug04 ? 00:52:09 oraclerac2 (LOCAL=NO)
oracle 26966 1 0 Aug04 ? 00:45:58 oraclerac2 (LOCAL=NO)
oracle 26968 1 0 Aug04 ? 00:56:45 oraclerac2 (LOCAL=NO)
oracle 26970 1 0 Aug04 ? 01:15:26 oraclerac2 (LOCAL=NO)
oracle 26972 1 0 Aug04 ? 00:14:44 oraclerac2 (LOCAL=NO)
oracle 16371 1 0 Aug04 ? 00:47:18 oraclerac2 (LOCAL=NO)
oracle 22428 1 0 Aug05 ? 00:34:12 oraclerac2 (LOCAL=NO)
oracle 22430 1 0 Aug05 ? 00:40:36 oraclerac2 (LOCAL=NO)
oracle 31695 1 0 Aug05 ? 00:31:26 oraclerac2 (LOCAL=NO)
oracle 31699 1 0 Aug05 ? 00:34:00 oraclerac2 (LOCAL=NO)
oracle 558 1 0 Aug05 ? 00:29:10 oracleerac2 (LOCAL=NO)
oracle 25198 1 0 Aug05 ? 00:33:43 oraclerac2 (LOCAL=NO)
oracle 21701 1 0 Aug01 ? 00:23:12 oraclerac2 (LOCAL=NO)
oracle 6433 1 0 Aug05 ? 01:19:00 oracleerac2 (LOCAL=NO)
oracle 6874 1 0 Aug05 ? 00:25:10 oracleasrac2 (LOCAL=NO)
oracle 7213 1 0 Aug05 ? 00:27:30 oraclerac2 (LOCAL=NO)
oracle 22422 1 0 Aug05 ? 00:36:16 oraclerac2 (LOCAL=NO)
oracle 15978 1 0 Aug05 ? 00:27:06 oraclerac2 (LOCAL=NO)
oracle 16003 1 0 Aug05 ? 00:24:55 oraclerac2 (LOCAL=NO)
oracle 20801 1 0 Aug08 ? 00:20:02 oraclerac2 (LOCAL=NO)
oracle 20808 1 0 Aug08 ? 00:21:28 oraclerac2 (LOCAL=NO)
oracle 1948 1 0 Aug08 ? 00:19:26 oracleerac2 (LOCAL=NO)
发现有很多历史进程,于是杀掉这些历史进程 ,
sqlplus 再次进入则正常 。
这种问题的通常解决方式一般是debug生成trc文件然后再看 ,本人觉得应该从系统进程入手来定位 。
messages ,alert.log 均没有错误 。
ps -ef
oracle 17710 1 0 Aug02 ? 01:23:54 oraclerac2 (LOCAL=NO)
oracle 18124 1 0 Aug02 ? 00:27:19 oraclerac2 (LOCAL=NO)
oracle 18131 1 0 Aug02 ? 00:30:34 oraclerac2 (LOCAL=NO)
oracle 18133 1 0 Aug02 ? 00:31:11 oraclerac2 (LOCAL=NO)
oracle 19936 1 0 Aug03 ? 01:22:03 oraclerac2 (LOCAL=NO)
oracle 26945 1 0 Aug04 ? 00:14:04 oraclerac2 (LOCAL=NO)
oracle 26951 1 0 Aug04 ? 00:44:39 oraclerac2 (LOCAL=NO)
oracle 26953 1 0 Aug04 ? 00:52:09 oraclerac2 (LOCAL=NO)
oracle 26966 1 0 Aug04 ? 00:45:58 oraclerac2 (LOCAL=NO)
oracle 26968 1 0 Aug04 ? 00:56:45 oraclerac2 (LOCAL=NO)
oracle 26970 1 0 Aug04 ? 01:15:26 oraclerac2 (LOCAL=NO)
oracle 26972 1 0 Aug04 ? 00:14:44 oraclerac2 (LOCAL=NO)
oracle 16371 1 0 Aug04 ? 00:47:18 oraclerac2 (LOCAL=NO)
oracle 22428 1 0 Aug05 ? 00:34:12 oraclerac2 (LOCAL=NO)
oracle 22430 1 0 Aug05 ? 00:40:36 oraclerac2 (LOCAL=NO)
oracle 31695 1 0 Aug05 ? 00:31:26 oraclerac2 (LOCAL=NO)
oracle 31699 1 0 Aug05 ? 00:34:00 oraclerac2 (LOCAL=NO)
oracle 558 1 0 Aug05 ? 00:29:10 oracleerac2 (LOCAL=NO)
oracle 25198 1 0 Aug05 ? 00:33:43 oraclerac2 (LOCAL=NO)
oracle 21701 1 0 Aug01 ? 00:23:12 oraclerac2 (LOCAL=NO)
oracle 6433 1 0 Aug05 ? 01:19:00 oracleerac2 (LOCAL=NO)
oracle 6874 1 0 Aug05 ? 00:25:10 oracleasrac2 (LOCAL=NO)
oracle 7213 1 0 Aug05 ? 00:27:30 oraclerac2 (LOCAL=NO)
oracle 22422 1 0 Aug05 ? 00:36:16 oraclerac2 (LOCAL=NO)
oracle 15978 1 0 Aug05 ? 00:27:06 oraclerac2 (LOCAL=NO)
oracle 16003 1 0 Aug05 ? 00:24:55 oraclerac2 (LOCAL=NO)
oracle 20801 1 0 Aug08 ? 00:20:02 oraclerac2 (LOCAL=NO)
oracle 20808 1 0 Aug08 ? 00:21:28 oraclerac2 (LOCAL=NO)
oracle 1948 1 0 Aug08 ? 00:19:26 oracleerac2 (LOCAL=NO)
发现有很多历史进程,于是杀掉这些历史进程 ,
sqlplus 再次进入则正常 。
这种问题的通常解决方式一般是debug生成trc文件然后再看 ,本人觉得应该从系统进程入手来定位 。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/90618/viewspace-704958/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/90618/viewspace-704958/