
(FAQ)Oracle控制文件损坏导致数据库故障
原因分析:
步骤 1 检查客户端,发现数据库异常。从错误信息看,数据库无法连接,提示实例不允许建立连接。
Caused by: java.sql.SQLException: Listener refused the connection with the following error:
ORA-12528, TNS:listener: all appropriate instances are blocking new connections
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:260)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)
at oracle.jdbc.driver.PhysicalConnection.
(PhysicalConnection.java:438)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:164)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at com.kingdee.bos.sql.shell.KDDriver.connect(Unknown Source)
... 36 more
步骤 2 检查监听状态,显示EAS54实例处于阻塞状态。
步骤 3 检查alert日志,发现有IO操作及数据库启动异常。
Thread 1 advanced to log sequence 1397
Current log# 1 seq# 1397 mem# 0: D:ORACLEPRODUCT10.2.0ORADATAEAS54REDO01.LOG
Mon Nov 30 18:44:23 2009
Process startup failed, error stack:
Mon Nov 30 18:44:23 2009
Errors in file d:oracleproduct10.2.0admineas54dumpeas54_psp0_3504.trc:
ORA-27300: OS 绯荤粺鐩稿叧鎿嶄綔: spcdr:9261:4200 澶辫触, 鐘舵€佷负: 997
ORA-27301: OS 鏁呴殰娑堟伅: 重叠 I/O 操作在进行中。
ORA-27302: 閿欒鍙戠敓鍦? skgpspawn
Mon Nov 30 18:44:24 2009
Process J000 died, see its trace file
Mon Nov 30 18:44:24 2009
kkjcre1p: unable to spawn jobq slave process
Mon Nov 30 18:44:24 2009
Errors in file