ORA-27090及ORA-00600: internal error code, arguments: [4194], [18], [4]的解決方法
由於突然斷電,在恢復供電後啟動資料庫報以下錯誤資訊:
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_p002_14473.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
Started redo application at
Thread 1: logseq 15220, block 3
Fri May 17 14:22:15 CST 2013
Recovery of Online Redo Log: Thread 1 Group 2 Seq 15220 Reading mem 0
Mem# 0: /oradata/test/redo02.ora
Mem# 1: /oradata/test/redo12.ora
Fri May 17 14:22:15 CST 2013
Completed redo application
Fri May 17 14:22:15 CST 2013
Completed crash recovery at
Thread 1: logseq 15220, block 60, scn 12785313401558
4 data blocks read, 4 data blocks written, 57 redo blocks read
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
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Additional information: 128
Additional information: 65536
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
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Additional information: 128
Additional information: 65536
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
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Additional information: 128
Additional information: 65536
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
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Additional information: 128
Additional information: 65536
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
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Additional information: 128
Additional information: 65536
Fri May 17 14:22:15 CST 2013
Errors in file /orac/admin/test/bdump/test_p002_14473.trc:
ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Additional information: 128
Additional information: 65536
Fri May 17 14:22:16 CST 2013
Thread 1 advanced to log sequence 15221 (thread open)
Thread 1 opened at log sequence 15221
Current log# 3 seq# 15221 mem# 0: /oradata/test/redo03.ora
Current log# 3 seq# 15221 mem# 1: /oradata/test/redo13.ora
Successful open of redo thread 1
Fri May 17 14:22:17 CST 2013
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri May 17 14:22:17 CST 2013
SMON: enabling cache recovery
Fri May 17 14:22:19 CST 2013
Successfully onlined Undo Tablespace 1.
Fri May 17 14:22:19 CST 2013
SMON: enabling tx recovery
Fri May 17 14:22:19 CST 2013
Database Characterset is ZHS16GBK
Opening with internal Resource Manager plan
Fri May 17 14:22:20 CST 2013
Errors in file /orac/trace/test_ora_14467.trc:
ORA-00600: internal error code, arguments: [4194], [40], [4], [], [], [], [], []
Doing block recovery for file 2 block 27642
Resuming block recovery (PMON) for file 2 block 27642
Block recovery from logseq 15221, block 53 to scn 12785313405025
Fri May 17 14:22:24 CST 2013
Recovery of Online Redo Log: Thread 1 Group 3 Seq 15221 Reading mem 0
Mem# 0: /oradata/test/redo03.ora
Mem# 1: /oradata/test/redo13.ora
Block recovery stopped at EOT rba 15221.55.16
Block recovery completed at rba 15221.55.16, scn 2976.3490728813
Doing block recovery for file 2 block 89
Resuming block recovery (PMON) for file 2 block 89
Block recovery from logseq 15221, block 53 to scn 12785313401708
Fri May 17 14:22:24 CST 2013
Recovery of Online Redo Log: Thread 1 Group 3 Seq 15221 Reading mem 0
Mem# 0: /oradata/test/redo03.ora
Mem# 1: /oradata/test/redo13.ora
Block recovery completed at rba 15221.55.16, scn 2976.3490728813
Fri May 17 14:22:24 CST 2013
Errors in file /orac/trace/test_ora_14467.trc:
ORA-00600: internal error code, arguments: [4194], [56], [4], [], [], [], [], []
DEBUG: Replaying xcb 0x1196da808, pmd 0x118394558 for failed op 8
Doing block recovery for file 2 block 4266
No block recovery was needed
Fri May 17 14:22:26 CST 2013
Errors in file /orac/trace/test_ora_14467.trc:
ORA-00600: internal error code, arguments: [4194], [56], [4], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [56], [4], [], [], [], [], []
Fri May 17 14:22:27 CST 2013
Errors in file /orac/trace/test_ora_14467.trc:
ORA-00600: internal error code, arguments: [4194], [56], [4], [], [], [], [], []
ORA-00600: internal error code, arguments: [4194], [56], [4], [], [], [], [], []
Fri May 17 14:22:31 CST 2013
DEBUG: Replaying xcb 0x1196da808, pmd 0x118394558 for failed op 8
Doing block recovery for file 2 block 4266
No block recovery was needed
Fri May 17 14:22:33 CST 2013
Errors in file /orac/admin/test/bdump/test_pmon_14433.trc:
ORA-00600: internal error code, arguments: [4194], [56], [4], [], [], [], [], []
Fri May 17 14:22:34 CST 2013
Errors in file /orac/admin/test/bdump/test_pmon_14433.trc:
ORA-00600: internal error code, arguments: [4194], [56], [4], [], [], [], [], []
PMON: terminating instance due to error 472
對於ORA-27090: Unable to reserve kernel resources for asynchronous disk I/O
這個錯誤可以修改作業系統核心引數
核心引數的值：fs.aio-max-nr設定太低，推薦設定為fs.aio-max-nr= 3145728。修改引數使用/sbin/sysctl -p重新載入引數後，重啟資料庫即可。
對於ORA-00600: internal error code, arguments: [4194], [56], [4], [], [], [], [], []
這個是回滾表空間出錯,
可以先使用手功管理的回滾表空間的方式將資料庫開啟
設定如下引數
undo_tablespace='SYSTEM'
undo_management='MANUAL'
SQL> create pfile from spfile;
File created.
[root@powerdb dbs]# vi inittest.ora
test.__db_cache_size=2868903936
test.__java_pool_size=16777216
test.__large_pool_size=16777216
test.__shared_pool_size=285212672
test.__streams_pool_size=16777216
*.audit_file_dest='/orac/admin/test/adump'
*.background_dump_dest='/orac/admin/test/bdump'
*.compatible='10.2.0.5.0'
*.control_files='/oradata/test/control01.ctl','/oradata/test/control02.ctl','/oradata/test/control03.ctl'
*.core_dump_dest='/orac/admin/test/cdump'
*.db_block_size=8192
*.db_cache_size=0
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='test'
*.db_recovery_file_dest='/orac/flash_recovery_area'
*.db_recovery_file_dest_size=21474836480
*.db_writer_processes=5
*.dispatchers='(PROTOCOL=TCP) (SERVICE=testXDB)'
*.job_queue_processes=10
*.max_dump_file_size='500'
*.open_cursors=700
*.optimizer_mode='ALL_ROWS'
*.pga_aggregate_target=805306368
*.processes=500
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=600
*.sga_max_size=3221225472
*.sga_target=3221225472
*.sort_area_size=1048576
#*.undo_management='AUTO'
*.undo_retention=120
#*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/orac/trace'
undo_tablespace='SYSTEM'
undo_management='MANUAL'
修改引數後使用修改的引數檔案來啟動資料庫
SQL> startup pfile=/orac/10.2.0/db_1/dbs/inittest.ora
ORACLE instance started.
Total System Global Area 3221225472 bytes
Fixed Size 2099752 bytes
Variable Size 335545816 bytes
Database Buffers 2868903936 bytes
Redo Buffers 14675968 bytes
Database mounted.
Database opened.
然後建立新的回滾表空間
SQL> create undo tablespace undotbs02 datafile '/oradata/test/undotbs02.dbf' size 5G;
Tablespace created.
刪除原來的回滾表空間
SQL> drop tablespace undotbs1;
Tablespace dropped.
將回滾表空間設定為新建立的回滾表空間
SQL> alter system set undo_tablespace="undotbs02" scope=spfile;
System altered.
將回滾表空間管理方式設定為自動
SQL> alter system set undo_management=auto scope=spfile;
System altered.
修改伺服器引數檔案
SQL> create pfile from spfile;
File created.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 3221225472 bytes
Fixed Size 2099752 bytes
Variable Size 352323032 bytes
Database Buffers 2852126720 bytes
Redo Buffers 14675968 bytes
Database mounted.
Database opened.
SQL> select * from v$tablespace;
TS# NAME INC BIG FLA ENC
---------- ------------------------------ --- --- --- ---
0 SYSTEM YES NO YES
2 SYSAUX YES NO YES
4 USERS YES NO YES
3 TEMP NO NO YES
6 HYGEIA YES NO YES
9 UNDOTBS02 YES NO YES
6 rows selected.
[@more@]
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26015009/viewspace-1060511/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- ORA-27090,ORA-00600: internal error code, arguments: [4194],的解決方法Error
- ORA-00600: internal error code, arguments: [4194], [4], [31]Error
- ORA-00600: internal error code, arguments: [4194]Error
- ora-00600:internal error code,arguments:[4194],[7],[2],[],[]Error
- ORA-00600: internal error code, arguments: [4194], [30], [30], [],Error
- ORA-00600: internal error code, arguments: [4194] 錯誤處理Error
- 遭遇 ORA-00600: internal error code, arguments: [4194] ORA-1552Error
- 簡單記錄一次ORA-00600: internal error code, arguments: [4194]Error
- ORA-00600: internal error code, arguments: [kcbgtcr_12], [4]Error
- 臨時解決：ORA-00600: internal error code, arguments: [19004], [], [],Error
- ORA-00600: internal error code, arguments: [kpnatdm】Error
- ORA-00600: internal error code, arguments: [525]Error
- ORA-00600: internal error code, arguments: [15753]Error
- ORA-00600: internal error code, arguments: [17087]Error
- ORA-00600: internal error code, arguments: [Cursor not typechecked],Error
- ORA-00600: internal error code, arguments: [32695]Error
- ORA-00600: internal error code, arguments: [1883], [0x000000000], [], [], [], []Error
- 記一次無歸檔恢復ORA-00600: internal error code, arguments: [4194]Error
- 遭遇ORA-00600: internal error code, arguments: [kcrrrfswda.11], [4], [368], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [13310], [],錯誤解決Error
- ORA-00600: internal error code, arguments: [keltnfy-ldmInit] 錯誤解決Error
- ORA-00600: internal error code, arguments: [kcbgtcr_13], [], [],Error
- ORA-00600: internal error code, arguments: [2662], [0],Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnCloseError
- 轉載：ORA-00600: internal error code, arguments: [504]Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose]Error
- ORA-00600: internal error code, arguments: [15709]Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [],[], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], [], [], [], []ErrorIndex
- ORA-00600: internal error code, arguments: [krvxbpns01], [], [], [], [], [],Error
- ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []Error
- ORA-00600 : internal error code, arguments: [qertbFetchByRowID]Error
- ORA-00600: internal error code, arguments: [2131], [9], [8]Error
- ORA-00600: internal error code, arguments: [13011]Error
- 案例ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], []ErrorIndex
- ORA-00600: internal error code, arguments: [kssadd: null parent]ErrorNull
- ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [729], [4280], [space leak]Error