Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2006

    Unanswered: DB Crash - Advice

    We are having intermitent crash problems on our Oracle database running on an AIX 5.3 operating system.
    The environment was stable for over a year, until recently.
    What is interesting is crashes only occure between 7:00 AM and 9:00 AM, only once a day (not every day).
    After restart, everything is fine.

    There are no hardware level errors reported.
    We eliminated the OS or Oracle backup causing the issue.
    The contrl files have been rebuilt.

    Oracle suggest a PATCH.
    Any other ideas?

    Errors in file /u01/app/oracle/product/

    ORA-00221: error on write to controlfile

    ORA-00206: error in writing (block 3, # blocks 1) of controlfile

    ORA-00202: controlfile: '/u05/oracle/gvr1/gvr1/control03.ctl'

    ORA-27072: File I/O error

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

    Additional information: 7

    Sun Jul 17 00:11:48 2005

    CKPT: terminating instance due to error 221

    Instance terminated by CKPT, pid = 2601400

  2. #2
    Join Date
    Jun 2003
    West Palm Beach, FL


    10.1 has many problems, upgrade to 10.2

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Jul 2003
    yes, upgrade.
    also, check permissions on the directory and file that the controlfile ois trying to update to.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  4. #4
    Join Date
    May 2004
    Dominican Republic
    So, what the SA guy(s) has to say about the device where /u05/oracle/gvr1/gvr1/ is mounted ?

  5. #5
    Join Date
    Jul 2006


    The filesystem resides on a IBM Fast-T 900 SAN
    Filesystem type is JSF2

    We looked for OS level and SAN hardware level errors, there hasn't been any in over a month.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts