topic Re: SAN - HPUX - Oracle Issue in Operating System - HP-UX

SAN - HPUX - Oracle Issue

Sanjay Tailor_1 — Tue, 08 Nov 2005 11:30:48 GMT

Hello all,

I have somewhat of a complex issue.

We have a couple of N-class servers with SAN attached disks. All of our Oracle database and other info is stroed on these disks.

During the night, there seems to have been a problem on the SAN which caused the systems to switch to their alternate disks. This keps going back and forth. I also go syslog error messages as the ones below:

msgcnt 649 vxfs: mesg 016: vx_ilisterr - /database/DEVXXXX file system error re
ading inode 31
msgcnt 650 vxfs: mesg 037: vx_metaioerr - /dev/vgXXX/lvXXX file system meta
data read error
msgcnt 651 vxfs: mesg 017: vx_ilisterr - /apps file system inode 5716 marked bad
msgcnt 652 vxfs: mesg 016: vx_ilisterr - /apps file system error reading inode 5
716
msgcnt 653 vxfs: mesg 016: vx_ilisterr - /apps file system error reading inode 5
716

I have looked at these errors and most of them refer to a disk failure which is what the SAN failure would produce. The system kept switching over and caused more of the inode problems.

When we tried to run Oracle in the morning, it would not run. We found that there was a problem with the Shared Libraries that Oracle uses like this:

/usr/lib/dld.sl: Invalid shared library file: /apps/oracle81/lib/libobk.sl
/usr/lib/dld.sl: No such device or address

Even some of my other apps, not oracle based had problems and would create core files. I narrowed it down to one filesystem where the apps and shared libraries sit.

Right now, I have all disks failed over to the SAN port that is working. We also found that one particular SAN port is having problems staying up and is getting bit errors.

Does anyone know what may have caused this problem on the HPUX and Oracle side? It seems that a problem on the SAN caused a problem in HPUX which had a knock-on effect on Oracle.

How can I fix it?

I think the problem maybe related to inodes on the filesystem going bad but why does this happen and what can I do prevent / fix it?

Any help would be appreciated.

Thanks in advance,

Sanjay.

Re: SAN - HPUX - Oracle Issue

Steven E. Protter — Tue, 08 Nov 2005 11:37:42 GMT

If the app's can't handle alternate paths, then its game over for the apps.

Realistically you can go for lvm san patches in hopes of solving the problem with the shotgun approach.

The bottom line is the SAN should not be triggering disk fails and it should be checked. The fact that it happens on multiple machines leads me to suspect the problem is not with any one machine but the SAN or Fabric network.

SEP

Re: SAN - HPUX - Oracle Issue

Jean-Yves Picard — Tue, 08 Nov 2005 11:42:58 GMT

Hello,

for some reason you had a problem in your EVA.
maybe a disk failed some time ago, and now another failed too.

when an I/O error occur on disk, a problem appear on LVM and on vxfs.
some file cannot be read. From what I read, any file located on /apps might be at risk.

action:
1) repair disk.
2) fix filesystem using fsck.
3) restore any missing file from your backup.

Jean-Yves

Re: SAN - HPUX - Oracle Issue

Sheriff Andy — Tue, 08 Nov 2005 17:28:37 GMT

Sanjay,

Do you have patch PHKL_32920 installed (HP-UX 11.0)? Here is an exerpt from the warning produced by HP.

One Liner:
s700_800 11.00 LVM Cumulative Patch

Reason:
Warn: 05/10/10 - This Critical Warning has been issued by HP.
- PHKL_32920 introduced behavior that can result on EIO errors
incorrectly being returned to the filesystem or the calling
application even when the logical timeout has been set to
infinity.
- This behavior can be observed when I/O requests fail because
a physical volume becomes unavailable for any reason (e.g. a
controller failure, etc.) and it depends on the number of
paths configured:
- For physical volumes with multiple paths, the incorrect
behavior can only be observed in the window in which
one I/O fails and LVM switches to a good link. Any
I/Os issued within that window will result on an EIO
error being returned.
- For physical volumes with single paths, the incorrect
behavior will be observed by all I/Os issued after the
first I/O which caused the link to become unavailable.
This behavior will continue to occur until the path to
the physical volume is restored.
- Additional information on this behavior may be found in
Service Request 8606413726 (JAGaf73586).
- To avoid this behavior, HP recommends removing PHKL_32920
from systems if the calling application or file system cannot
handle the error returned from the underlying logical volume.
- The previous patch, PHKL_30553, does not exhibit this same
behavior. While patch warnings have been issued against
PHKL_30553, they are of a less serious nature. If you
choose to remove PHKL_32920, HP recommends that PHKL_30553
be installed to ensure as many known issues as possible are
addressed. If PHKL_30553 was installed prior to PHKL_32920,
it will automatically be restored when PHKL_32920 is removed
and will not need to be reinstalled.
HW-OS:s700: 11.00
s800: 11.00
Fixed:Unknown
Fset:LVM.LVM-KRN,fr=B.11.00,fa=HP-UX_B.11.00_32,v=HP
OS-Core.CORE2-KRN,fr=B.11.00,fa=HP-UX_B.11.00_32,v=HP
LVM.LVM-KRN,fr=B.11.00,fa=HP-UX_B.11.00_64,v=HP
OS-Core.CORE2-KRN,fr=B.11.00,fa=HP-UX_B.11.00_64,v=HP
Prod:N/A
Reboot:Yes
CView:Yes

Re: SAN - HPUX - Oracle Issue

Sanjay Tailor_1 — Wed, 09 Nov 2005 04:08:51 GMT

Hello,

Thank you for all the replies. I do have PHKL_32920 installed. The problems described in the patch description are very much like what I am getting.

I am going to remove the patch and see what happens. Unfortunately, this is something that is not easily tested.

I will update with more points later,

Thank you so far.

Sanjay.

Re: SAN - HPUX - Oracle Issue

Eric Tromso — Fri, 30 Dec 2005 10:33:42 GMT

I just run up the exact same issue last night after a controller failure on my CX500. I also have Oracle installed and
PHKL 32920 on an L-Class 11.0 box

There are no disk issues on the Clariion Side.

Can someone confirm that removal of this patch resolves the issue?

Thanks a lot
Eric

Re: SAN - HPUX - Oracle Issue

baiju_3 — Fri, 30 Dec 2005 10:43:06 GMT

Also it is best practice to increase the default PV time out value for Disks .

pvchange -t 180 /dev/rdsk/c?t?d?

thx,
bl.

Re: SAN - HPUX - Oracle Issue

Eric Tromso — Fri, 30 Dec 2005 10:45:56 GMT

Hi,

The pvtimeout is set to 180" for all associated PVs and the lvtimeout is at the default for all LVs

Thanks Eric

Re: SAN - HPUX - Oracle Issue

Alzhy — Fri, 30 Dec 2005 10:48:37 GMT

Looks to me like a configuration issue than APPS issue. APPS do not deal directly with the underlying subsystem. The Filesystem/Volume Manager (LVM or VxVM) do.

Also it seems folks in this thread who've encountered this problem are simply using ALTERNATE PATHING or PVLINKS (hence I assume use LVM). Depending on the array/SAN you're using - make sure all recommended settings for the PV such as bad balock relocation, timeouts, etc. are what the array vendor says it should be. This is so your OS should be able to handle the most common faults of most arrays --- controller failure which would lead to a failover situation.

Aside from the VxFS errors (or JFS) mentioned, you or an experienced Admin should be able to tell via Syslogs or Console Messages or even STM what the issues why VxFS complained of filesystem errors. In the absence of any SAN or PV configuration faults -- then check that your JFS/VxFS is patched or at least at version 3.3 on 11.0 environments.

Re: SAN - HPUX - Oracle Issue

Eric Tromso — Fri, 30 Dec 2005 10:59:04 GMT

Thanks Nelson. I'm using PVLinks with JFS 3.1 with a ton of patches. I have one more HP-UX server in the fabric but that's an 11.11 box that did not experience any issues during the SP failure and recoved properly. The parameters are set according to the recommendations of our storage vendor. The paths are configured properly.

The Critical warning described in PHKL 32920 seems awfully similar to the behavior we saw. However, Since this is a production server I just can't start installing/removing patches without some sort of confirmation or level of certainty.

Re: SAN - HPUX - Oracle Issue

Alzhy — Fri, 30 Dec 2005 11:02:36 GMT

Then upgrade to VxFS/JFS 3.3 if you can and see if it fixes the problem.