Netops + Oracle 8i gets disconnects... any idea ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Netops + Oracle 8i gets disconnects... any idea ?

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Location
    San Diego
    Posts
    24

    Netops + Oracle 8i gets disconnects... any idea ?

    Hi,

    We are having oracle 8i, on W2k (Service pack3). We are using NAS (form Netops) as our storage divices. About twice a week the entire oracle shuts down with the following error:

    ---------

    ERROR at line 1:
    ORA-01115: IO error reading block from file 32 (block # 919817)
    ORA-01110: data file 32: 'O:\ORADATA\BAANP\C501_IDX02.DBF'
    ORA-27091: skgfqio: unable to queue I/O
    OSD-04006: ReadFile() failure, unable to read from file
    O/S-Error: (OS 64) The specified network name is no longer available.

    ----------

    When I look at Aler.log I see :
    -----
    Wed Jan 08 09:57:33 2003
    Current log# 2 seq# 2417 mem# 0: N:\ORADATA\BAANP\REDO\REDO02.LOG
    Wed Jan 08 09:57:33 2003
    KCF: write/open error block=0xd798e online=1
    file=32 O:\ORADATA\BAANP\C501_IDX02.DBF
    error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file
    O/S-Error: (OS 64) The specified network name is no longer available.'
    Automatic datafile offline due to write error on
    file 32: O:\ORADATA\BAANP\C501_IDX02.DBF
    KCF: write/open error block=0xbb57a online=1
    file=21 O:\ORADATA\BAANP\C501_IDX01.DBF
    error=27072 txt: 'OSD-04008: WriteFile() failure, unable to write to file
    O/S-Error: (OS 64) The specified network name is no longer available.'
    Wed Jan 08 09:57:33 2003
    Errors in file p:\oradata\baanp\dump\bdump\baanLGWR.TRC:
    ORA-00202: controlfile: 'O:\ORADATA\BAANP\CONTROL02.CTL'
    ORA-27091: skgfqio: unable to queue I/O
    OSD-04006: ReadFile() failure, unable to read from file
    O/S-Error: (OS 64) The specified network name is no longer available.

    Wed Jan 08 09:57:34 2003
    Errors in file p:\oradata\baanp\dump\bdump\baanCKPT.TRC:
    ORA-00206: error in writing (block 3, # blocks 1) of controlfile
    ORA-00202: controlfile: 'P:\ORADATA\BAANP\CONTROL03.CTL'
    ORA-27072: skgfdisp: I/O error
    OSD-04008: WriteFile() failure, unable to write to file
    O/S-Error: (OS 59) An unexpected network error occurred.
    ORA-00206: error in writing (block 3, # blocks 1) of controlfile
    ORA-00202: controlfile: 'O:\ORADATA\BAANP\CONTROL02.CTL'
    ORA-27072: skgfdisp: I/O error
    OSD-04008: WriteFile() failure, unable to write to file
    O/S-Error: (OS 59) An unexpected network error occurred.

    Automatic datafile offline due to write error on
    file 21: O:\ORADATA\BAANP\C501_IDX01.DBF
    Wed Jan 08 09:57:35 2003
    Errors in file p:\oradata\baanp\dump\bdump\baanLGWR.TRC:
    ORA-00204: error in reading (block 1, # blocks 1) of controlfile
    ORA-00202: controlfile: 'O:\ORADATA\BAANP\CONTROL02.CTL'
    ORA-27091: skgfqio: unable to queue I/O
    OSD-04006: ReadFile() failure, unable to read from file
    O/S-Error: (OS 64) The specified network name is no longer available.

    ----

    Once we get this error we just restart oracle and recover the datafiles and put them back on line.

    We belive that some how the box running oracle is loosing connection with the filers (storage devices).. My question is have you guys ever encounter such error..? Are there any users who are using similar conifiguration (8i, NAS, W2k)? are any thoughts on this problem ?

    Thanks,
    -Hidayath

  2. #2
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Hi. we have netops with win2k +8i as well but we dotn have any problems with the connectivity. The filer i think is probably disconnecting your NFS mount. Talk to the the NetApps guys to check on how the netapps is configured. I believe there is a timeout feauture that is probablyu activated on your o:\ nfs mount.
    "High Salaries = Happiness = Project Success."

Posting Permissions

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



Click Here to Expand Forum to Full Width