AIX

AIX

Connect with fellow AIX users and experts to gain knowledge, share insights, and solve problems.


#Power
 View Only
Back to discussions
Expand all | Collapse all

IBM AIX RISC System/6000 Error: 22: Invalid argument

  • 1.  IBM AIX RISC System/6000 Error: 22: Invalid argument

    Posted Tue May 10, 2011 11:47 AM

    Originally posted by: sajid1


    Hi,
    PROD
    Db 9.2.0.8
    AIX 5.2

    Suddenly database crashed. What I found in alert log file and trace file find below.

    I started database it started normally but it took much time to start. Suggest me why it occurred and what I need to change so that I could not face again it.

    Alert log file:

    ARC1: Completed archiving log 2 thread 1 sequence 3653
    Mon May 9 21:14:43 2011
    Errors in file /vol01/oracle/product/admin/prod/bdump/prod_dbw0_695450.trc
    ORA-27061: skgfospo: waiting for async I/Os failed
    IBM AIX RISC System/6000 Error: 22: Invalid argument
    Mon May 9 21:14:43 2011
    DBW0: terminating instance due to error 27061
    Instance terminated by DBW0, pid = 695450

    Trace file prod_dbw0_695450.trc:

    Redo thread mounted by this instance: 1
    Oracle process number: 3
    Unix process pid: 695450, image: oracle@prod (DBW0)

    • 2011-05-09 21:14:43.089
    • SESSION ID:(2.1) 2011-05-09 21:14:43.028
    error 27061 detected in background process
    ORA-27061: skgfospo: waiting for async I/Os failed
    IBM AIX RISC System/6000 Error: 22: Invalid argument

    During database starting find below some of the lines of alert log file:

    Completed: ALTER DATABASE MOUNT
    Tue May 10 08:46:17 2011
    ALTER DATABASE OPEN
    Tue May 10 08:46:17 2011
    Beginning crash recovery of 1 threads
    Tue May 10 08:46:17 2011
    Started redo scan
    Tue May 10 08:46:32 2011
    Completed redo scan
    1884170 redo blocks read, 61752 data blocks need recovery
    Tue May 10 08:46:45 2011
    Started recovery at
    Thread 1: logseq 3653, block 1324175, scn 0.0
    Tue May 10 08:46:46 2011
    Recovery of Online Redo Log: Thread 1 Group 2 Seq 3653 Reading mem 0
    Mem# 0 errs 0: /vol01/oracle/product/oradata/prod/redo2a.log
    Mem# 1 errs 0:/vol02/oracle/product/oradata/prod//redo2b.log
    Tue May 10 08:46:57 2011
    Recovery of Online Redo Log: Thread 1 Group 3 Seq 3654 Reading mem 0
    Mem# 0 errs 0: /vol01/oracle/product/oradata/prod/redo3a.log
    Mem# 1 errs 0: /vol02/oracle/product/oradata/prod/redo3b.log
    Tue May 10 08:53:02 2011
    Completed redo application
    Tue May 10 08:53:13 2011
    Ended recovery at
    Thread 1: logseq 3654, block 1111196, scn 3.3471125210
    61752 data blocks read, 38719 data blocks written, 1884170 redo blocks read
    Crash recovery completed successfully

    Thanks
    #AIX-Forum


  • 2.  Re: IBM AIX RISC System/6000 Error: 22: Invalid argument

    Posted Tue May 10, 2011 01:09 PM

    Originally posted by: SystemAdmin


    call oracle support
    #AIX-Forum


  • 3.  Re: IBM AIX RISC System/6000 Error: 22: Invalid argument

    Posted Wed May 11, 2011 01:54 AM

    Originally posted by: SystemAdmin


    Hi,

    your datafiles are on external storage, right? It looks to me like something happened with SAN\fiber. Or storage itself.

    You could find more clues looking at
    1) errpt
    2) storage logs
    3) fiber switch logs (in case you use ones)

    And of course it took much more time to start db due to recovery.

    Regards,
    AM
    #AIX-Forum


Related Content