RE: HP-UX 11 kernal parameters for Oracle

  • From: "Ehresmann, David" <David.Ehresmann@xxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 5 Aug 2004 13:13:13 -0500

Can anybody translate this?  Is it a SCSI and/or async write error?
thanks,
David.

Aug  5 07:57:53  EMS [1483]: ------ EMS Event Notification ------   Value:
"CRITICAL (5)" for Resource: "/storage/events/disks/default/0_0_2_0.0.0"
(Threshold:
  >= " 3")    Execute the following command to obtain event details:
/opt/resmon/bin/resdata -R 97189896 -r
/storage/events/disks/default/0_0_2_0.0.0 -n 97189889 -a 
Aug  5 07:57:56  vmunix: SCSI: Request Timeout -- lbolt: 16524944, dev:
1f020000
Aug  5 07:57:56  vmunix:            lbp->state: 4060
Aug  5 07:57:56  vmunix:            lbp->offset: ffffffff
Aug  5 07:57:56  vmunix:            lbp->uPhysScript: f87ba000
Aug  5 07:57:56  vmunix:    From most recent interrupt:
Aug  5 07:57:56  vmunix:            ISTAT: 22, SIST0: 00, SIST1: 04, DSTAT:
00, DSPS: f87ba540
Aug  5 07:57:56  vmunix:    lsp: 0000000043e14700
Aug  5 07:57:56  vmunix:            bp->b_dev: 1f020000
Aug  5 07:57:56  vmunix:            scb->io_id: 2150c23
Aug  5 07:57:56  vmunix:            scb->cdb: 28 00 02 06 b1 c8 00 00 10 00
Aug  5 07:57:56  vmunix:            lbolt_at_timeout: 16521816,
lbolt_at_start: 16521816
Aug  5 07:57:56  vmunix:            lsp->state: 10d
Aug  5 07:57:56  vmunix:    lbp->owner: 0000000043e14700
Aug  5 07:57:56  vmunix:    scratch_lsp: 0000000000000000
Aug  5 07:57:56  vmunix:    Pre-DSP script dump [fffffffff87ba020]:
Aug  5 07:57:56  vmunix:            00000000 00000000 41000000 f87ba290
Aug  5 07:57:56  vmunix:            78347d00 0000000a 78350800 00000000
Aug  5 07:57:56  vmunix:    Script dump [fffffffff87ba040]:
Aug  5 07:57:56  vmunix:            0e000004 f87ba540 e0100004 f87ba7f4
Aug  5 07:57:56  vmunix:            870b0000 f87ba2d8 0a000000 f87ba548
Aug  5 07:57:56  vmunix: SCSI: Abort abandoned -- lbolt: 16524944, dev:
1f020000, io_id: 2150c23, status: 200
Aug  5 07:57:56  vmunix: 
Aug  5 07:57:56  vmunix: SCSI: Async write error -- dev: b 31 0x020000,
errno: 126, resid: 4096,
Aug  5 07:57:56  vmunix:    blkno: 12176248, sectno: 24352496, offset:
3878543360, bcount: 4096.
Aug  5 07:57:56  vmunix: SCSI: Read error -- dev: b 31 0x020000, errno: 126,
resid: 2048,
Aug  5 07:57:56  vmunix:    blkno: 8, sectno: 16, offset: 8192, bcount:
2048.
Aug  5 07:57:56  vmunix: LVM: vg[1]: pvnum=2 (dev_t=0x1f020000) is
POWERFAILED
Aug  5 07:57:56  vmunix: 

-/var/adm/syslog$ 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Ron Thomas
Sent: Thursday, August 05, 2004 12:14 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: HP-UX 11 kernal parameters for Oracle



dmesg and /var/adm/syslog/syslog.log would be a good place to start.
Thanks,
Ron.

"To really screw up Linux you have to work at it...To really screw up
Windows, you have to work ON
it..."
"The software said to install Windows 98 or better... So I installed linux."


 

             David.Ehresmann@xxxxxx

             Sent by:

             oracle-l-bounce@xxxxxxxxxxx
To 
             rg                                  oracle-l@xxxxxxxxxxxxx

 
cc 
 

             08/05/04 10:13 AM
Subject 
                                                 RE: HP-UX 11 kernal
parameters for Oracle          
 

                  Please respond to

               oracle-l@xxxxxxxxxxxxx

 

 

 





This is a cheap box they want us to keep using.  What logfile name on the
unix side would I look in to see if it is scsi bus and/or flacky
disk/controller?

thanks,
David.



-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Ron Thomas
Sent: Thursday, August 05, 2004 11:58 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: HP-UX 11 kernal parameters for Oracle



I've seen this happen due to scsi bus resets caused by a flacky
disk/controller.  Just food for
thought.

BTW, you are running this many instances in only 4GB?  They must be really
really small or you are
hitting swap pertty hard.

Thanks,
Ron.

"To really screw up Linux you have to work at it...To really screw up
Windows, you have to work ON
it..."
"The software said to install Windows 98 or better... So I installed linux."




             David.Ehresmann@xxxxxx

             Sent by:

             oracle-l-bounce@xxxxxxxxxxx
To
             rg                                  oracle-l@xxxxxxxxxxxxx


cc


             08/05/04 09:49 AM
Subject
                                                 HP-UX 11 kernal parameters
for Oracle


                  Please respond to

               oracle-l@xxxxxxxxxxxxx











We have a development box that is HP-UX  B.11.11 9000/800. It has 4gb of
memory.  It is running anywhere from 5 to 7 8i instances and 3-5 9i
instances on any particular day.  Once every week it will "lock up".  vmstat
will show blocked processes and the %wio will go to the high 90s.  Nothing
crashes or dies, it just appears to have to many processes to run.  I have
used TOP to look at the processes running.  I see nothing unusual.  Can
anybody share their kernal parameters for HP that they have running 8i and
9i on?  Particularly the shmmax, shmmni, ... and so on.  Any help will be
greatly appreciated.

David Ehresmann     PerotSystems
david.ehresmann@xxxxxx
972.577.6236

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------



----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------



----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: