Re: [foxboro] "SCSI bus DATA IN phase parity error"

  • From: "de Groot, Rob" <rdegroot@xxxxxxxxxxx>
  • To: "'foxboro@xxxxxxxxxxxxx'" <foxboro@xxxxxxxxxxxxx>
  • Date: Fri, 19 Apr 2002 08:56:51 -0400

The last time i saw this error when i misplaced the SCSIin/out on the
external harddisk.
But ofcourse nobody on this list ever made that mistake, except for me. ;-)

Before that, i had build a SCSI chain which was too long. With the current
speed of SCSI i think you reach the maximum SCSI chain length quite easily.
I don't know the max. length, but you can look into that.

>               Rob de Groot
>               Senior system service engineer
>               Invensys Systems N.V.
>               Baarnsche dijk 10   P.O. Box 146   3740 AC Baarn   The
Netherlands
>               T: +31 (0)35 54 84 176   F: +31 (0)35 54 84 175 
> rdegroot@xxxxxxxxxxx   www.invensys-systems.nl


-----Original Message-----
From: Varsha Savyasachi [mailto:vsavyasachi@xxxxxxxxx]
Sent: Thursday, April 18, 2002 4:34 PM
To: foxboro@xxxxxxxxxxxxx
Subject: [foxboro] "SCSI bus DATA IN phase parity error" 
Importance: High


Hi list,

We recently upgraded our server hardware. We had 2*18.2G hdd. Added one more
18.2G hdd.

The hardware configuration details are :

Serial No.      13746540        
Model   UltraAX-MP+ WorkServer  
Processors      2*UltraSPARCII 400MHz   
Memory  2048 MB 
        OpenBoot 3.10.50 ME     
Keyboard        Sun Keyboard    

The current Solaris version installed is 8 and the patch-level is 
SunOS oracleapps 5.8 Generic_108528-08 sun4u sparc SUNW,UltraAX-MP


I tried a re-install of Oracle Applications again this evening. And this
time I used the new harddisk for the DB and not the Technology Stack as per
suggestion. The Technology stack was installed on the old disk ("disk 1").

But, the installation had to be aborted due to "Failed to execute the SQL
script wVIS.sql against %this_DBName%" error. When I checked the details of
the error, it said this :
----------------------------------------------------------------------------
-----------------------------------------------------------------------
Execution Error: wVIS.sql

   Failed to execute the SQL script wVIS.sql against %this_DBName%.
   Please check the log file
   (/d01/app/oravis/product/805/orainst/apps/orainst/appcweb.log) for
   more information.

----------------------------------------------------------------------------
-----------------------------------------------------------------------
And the contents of the log file :
----------------------------------------------------------------------------
-----------------------------------------------------------------------
old   2: set HOME_URL =
'http://&WEB_HOST_NAME:&WEB_PORT/OA_HTML/US/&CARTRIDGE..
htm'
new   2: set HOME_URL =
'http://oracleapps.egainindia.com:8100/OA_HTML/US/VIS.ht
m'

1 row updated.

old   2: set text  = 'http://&WEB_HOST_NAME:&WEB_PORT/&CARTRIDGE/plsql'
new   2: set text  = 'http://oracleapps.egainindia.com:8100/VIS/plsql'
update WF_RESOURCES
       *
ERROR at line 1:
ORA-01115: IO error reading block from file 6 (block # 36218)
ORA-01110: data file 6: '/d03/oradata/VIS/data01.dbf'
ORA-27072: skgfdisp: I/O error
SVR4 Error: 5: I/O error
Additional information: 36217


Disconnected from Oracle8 Enterprise Edition Release 8.0.5.1.0 - Production
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------

And as you can see form the table below, the /d03 mount point is on disk 2
(the new disk added today!)

Filesystem            kbytes    used   avail capacity  Mounted on
/dev/dsk/c0t0d0s0    1017296   54821  901438     6%    /
/dev/dsk/c0t0d0s1    1599884  781197  770691    51%    /usr
/proc                      0       0       0     0%    /proc
fd                         0       0       0     0%    /dev/fd
mnttab                     0       0       0     0%    /etc/mnttab
/dev/dsk/c0t0d0s5    2054562  352089 1640837    18%    /var
swap                 4731816       0 4731816     0%    /var/run
/dev/dsk/c0t1d0s0    5253468 1814037 3386897    35%    /d01
/dev/dsk/c0t0d0s6    8784155 4283694 4412620    50%    /d05
swap                 4732184     368 4731816     1%    /tmp
/dev/dsk/c0t2d0s0    8256595 2049099 6124931    26%    /d03
/dev/dsk/c0t2d0s1    9380384 1236954 8049627    14%    /d04
/dev/dsk/c0t0d0s4    1017296   16898  939361     2%    /export/home
/dev/dsk/c0t1d0s1    8346707 1639987 6623253    20%    /d02
/vol/dev/dsk/c0t6d0/oa_1103_visdb
                      502250  502250       0   100%    /cdrom/oa_1103_visdb
----------------------------------------------------------------------------
----------------------------------------------------------------------------
-------------

I checked the OS system log (/var/adm/messages) for OS error messages and
found this :
----------------------------------------------------------------------------
--------------------------------------------------------------
Apr 18 09:19:20 oracleapps      SCSI bus DATA IN phase parity error
Apr 18 09:19:20 oracleapps glm: [ID 663555 kern.warning] WARNING:
ID[SUNWpd.glm.
parity_check.6010]
Apr 18 09:19:20 oracleapps scsi: [ID 107833 kern.warning] WARNING:
/pci@4,4000/s
csi@6,1 (glm2):
Apr 18 09:19:20 oracleapps      Target 2 disabled wide SCSI mode
Apr 18 09:19:20 oracleapps glm: [ID 681974 kern.warning] WARNING:
ID[SUNWpd.glm.
sync_wide_backoff.6012]
Apr 18 09:19:20 oracleapps scsi: [ID 107833 kern.warning] WARNING:
/pci@4,4000/s
csi@6,1 (glm2):
Apr 18 09:19:20 oracleapps      Target 2 reverting to async. mode
Apr 18 09:19:20 oracleapps glm: [ID 802533 kern.warning] WARNING:
ID[SUNWpd.glm.
sync_wide_backoff.6013]
Apr 18 09:19:20 oracleapps scsi: [ID 107833 kern.warning] WARNING:
/pci@4,4000/s
csi@6,1/sd@2,0 (sd32):
Apr 18 09:19:20 oracleapps      SCSI transport failed: reason 'tran_err':
retryi
ng command
Apr 18 09:19:21 oracleapps scsi: [ID 107833 kern.warning] WARNING:
/pci@4,4000/s
csi@6,1/sd@2,0 (sd32):
Apr 18 09:19:21 oracleapps      incomplete read- retrying
Apr 18 09:19:21 oracleapps scsi: [ID 107833 kern.warning] WARNING:
/pci@4,4000/s
csi@6,1/sd@2,0 (sd32):

----------------------------------------------------------------------------
--------------------------------------------------------------
I looked up the error on the web for "SCSI bus DATA IN phase parity error" :

----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----
Cause
The most common cause of this problem is unapproved hardware. Some SCSI
devices for the PC market do not meet the high I/O speed requirements for
the
UNIX market. Other possible causes of this problem are improper cabling or
termination, and power fluctuations. Data corruption is possible but
unlikely to occur,
because this parity error prevents data transfer.
Action
Check that all SCSI devices on the bus are Sun-approved hardware. Then
verify that all cables measure no longer than six meters, total, and that
all SCSI
connections are properly terminated. If power fluctuations are occurring,
invest in an uninterruptible power supply.
----------------------------------------------------------------------------
----------------------------------------------------------------------------
----------------------------------------------------------------------------
------
We have the new harddisk that was replaced recently. The model No. is
ST318406LC, whereas both our existing hdds are ST318404LC. In myt opinion
this could be the problem. In the meantime, I am also tried to get the
"hardware compatibility list" for the model we have. But, since this is not
a "branded"  server, it is not listed anywhere and may be difficult to get. 
Can anybody confirm that this error is due to hardware incompatibility and
not application or what is it that is causing this problem?

Thanks
Varsha







 
 
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html
 
foxboro mailing list:             http://www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave
 
 
 
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html
 
foxboro mailing list:             http://www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave
 

Other related posts: