Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-27091: unable to queue I/O

DipakKalamkarOct 18 2012 — edited Oct 18 2012
I am facing problems on some of our database.


Details:

IBM p series servers
AIX 5.3
Server memory : 16G
there are 2 instances on this server.
1. Near DR - 9840M
2. Test server - 450M
Rest is for server.
Oracle 10.2.0.3.0 - Production


Here is the Alert Log..

Starting up ORACLE RDBMS Version: 10.2.0.3.0.
System parameters with non-default values:
processes = 100
sessions = 115
__shared_pool_size = 146800640
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
nls_language = AMERICAN
nls_territory = INDIA
sga_target = 473956352
control_files = /dev/rHCTRLR1_128M
db_block_size = 8192
__db_cache_size = 310378496
compatible = 10.2.0.1.0
log_archive_dest_1 = LOCATION=/HArch
log_archive_format = %s, %t and %r.arc
db_file_multiblock_read_count= 16
undo_management = AUTO
undo_tablespace = UNDO
remote_login_passwordfile= EXCLUSIVE
db_domain =
dispatchers = (PROTOCOL=TCP) (SERVICE=HISTDATAXDB)
job_queue_processes = 10
background_dump_dest = /Oracle/app/oracle10g/admin/HISTDATA/bdump
user_dump_dest = /Oracle/app/oracle10g/admin/HISTDATA/udump
core_dump_dest = /Oracle/app/oracle10g/admin/HISTDATA/cdump
audit_file_dest = /Oracle/app/oracle10g/admin/HISTDATA/adump
db_name = HISTDATA
open_cursors = 300
pga_aggregate_target = 1073741824
PMON started with pid=2, OS id=164070

Errors in file /Oracle/app/oracle10g/admin/HISTDATA/bdump/histdata_mmon_315640.trc:
ORA-00600: internal error code, arguments: [kmgs_parameter_update_timeout_1], [27091], [], [], [], [], [], []
ORA-27091: unable to queue I/O
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 9: Bad file number
Additional information: 7
Additional information: 4
Additional information: -1
Thu Oct 18 14:10:35 2012
Setting recovery target incarnation to 3

SMON: enabling tx recovery
Thu Oct 18 14:10:36 2012
Errors in file /Oracle/app/oracle10g/admin/HISTDATA/bdump/histdata_dbw0_262338.trc:
ORA-00600: internal error code, arguments: [kmgs_parameter_update_timeout_1], [27091], [], [], [], [], [], []
ORA-27091: unable to queue I/O
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 9: Bad file number
Additional information: 7
Additional information: 4
Additional information: -1
Thu Oct 18 14:10:36 2012
Database Characterset is WE8ISO8859P1
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=16, OS id=495870
Thu Oct 18 14:10:38 2012
Errors in file /Oracle/app/oracle10g/admin/HISTDATA/bdump/histdata_dbw0_262338.trc:
ORA-00600: internal error code, arguments: [kmgs_parameter_update_timeout_1], [27091], [], [], [], [], [], []
ORA-27091: unable to queue I/O
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 9: Bad file number
Additional information: 7
Additional information: 4
Additional information: -1
Thu Oct 18 14:10:38 2012
DBW0: terminating instance due to error 471
Instance terminated by DBW0, pid = 262338


Every time i start the DB, instance gets terminate dautomatically..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 15 2012
Added on Oct 18 2012
8 comments
5,812 views