今天公司的开发库出现了连不上Oracle的情况,大家的工作就会开展不顺,毕竟很多人都需要测试的嘛,然后就找到了我,看了下情况
sqlplus / as sysdba
登录时,出现了maxnum process 超出最大个数,那句英语已经不能完全记得清了,于是去看alert告警日志,发现了如下情况:
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
以上错误是已经查获的,还有:
Corrupt block relative dba: 0x00811aa7 (file 2, block 72359)
这个是默认的sysaux表空间的数据文件,有坏块,有坏块后,告警日志中又出现了以下情况:
Reread (file 2, block 72359) found same corrupt data
Process m000 submission failed with error = 20
Process m001 submission failed with error = 20
Process m002 submission failed with error = 20
Process m001 submission failed with error = 20
Process m000 submission failed with error = 20
Process m003 subm