ORA-27090,ORA-00600: internal error code, arguments: [4194],的解决方法

最新推荐文章于 2024-07-31 10:17:32 发布

qq_33279575

最新推荐文章于 2024-07-31 10:17:32 发布

阅读量715

点赞数

本文链接：https://blog.csdn.net/qq_33279575/article/details/50202439

版权

在遭遇突然断电后，数据库启动时出现ORA-27090和ORA-00600错误。错误信息表明无法预留内核资源进行异步磁盘I/O。解决方案包括调整操作系统的内核参数fs.aio-max-nr，设置为3145728，并在重启数据库后检查。对于ORA-00600错误，可能是因为回滚表空间问题，需要手动管理回滚表空间，创建新的表空间，删除旧的，然后将回滚表空间设置为自动管理并更新服务器参数文件。

摘要由CSDN通过智能技术生成

ORA-27090,ORA-00600: internal error code, arguments: [4194],的解决方法

由于突然断电,在恢复供电后启动数据库报以下错误信息:

ALTER DATABASE OPEN

Fri May 17 14:22:14 CST 2013

Beginning crash recovery of 1 threads

parallel recovery started with 7 processes

Fri May 17 14:22:14 CST 2013

Started redo scan

Fri May 17 14:22:14 CST 2013

Completed redo scan

57 redo blocks read, 4 data blocks need recovery

Fri May 17 14:22:15 CST 2013

Errors in file /orac/admin/test/bdump/test_p003_14475.trc:

ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O

Additional information: 3

Additional information: 1

Additional information: 65536

Fri May 17 14:22:15 CST 2013

Warning: recovery process cannot use async I/O

Fri May 17 14:22:15 CST 2013

Errors in file /orac/admin/test/bdump/test_p006_14483.trc:

ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O

Additional information: 3

Additional information: 1

Additional information: 65536

Fri May 17 14:22:15 CST 2013

Warning: recovery process cannot use async I/O

Fri May 17 14:22:15 CST 2013

Errors in file /orac/admin/test/bdump/test_p004_14477.trc:

ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O

Additional information: 3

Additional information: 1

Additional information: 65536

Fri May 17 14:22:15 CST 2013

Warning: recovery process cannot use async I/O

Fri May 17 14:22:15 CST 2013

Errors in file /orac/admin/test/bdump/test_p005_14479.trc:

ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O

Additional information: 3

Additional information: 1

Additional information: 65536

Fri May 17 14:22:15 CST 2013

Errors in file /orac/admin/test/bdump/test_p000_14469.trc:

ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O

Additional information: 3

Additional information: 1

Additional information: 65536

Fri May 17 14:22:15 CST 2013

Warning: recovery process cannot use async I/O

Fri May 17 14:22:15 CST 2013

Warning: recovery process cannot use async I/O

Fri May 17 14:22:15 CST 2013

Errors in file /orac/admin/test/bdump/test_p001_14471.trc:

ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O

Additional information: 3

Additional information: 1

Additional information: 65536

Fri May 17 14:22:15 CST 2013

Warning: recovery process cannot use async I/O

Fri May 17 14:22:15 CST 2013

Errors in file /orac/admin/test/bdump/test