Arne S wrote:
>> Aixers!
>>
>> I've got a problem that all of a sudden came up after update of AIX to
>> ML09 and upgrade of Oracle from 7.4.3 to 8.1.7: The machine is sometimes
>> slowing down, and at the end I have to turn it off and back on again.
>> After the machine is up again, I find this error in the error log:
>> *********************************************
>> LABEL: PGSP_KILL
>> IDENTIFIER: C5C09FFA
>>
>> Date/Time: fre 02-04-26 05:33:
>> Sequence Number: 3811
>> Machine Id: 0040AD3A4C00
>> Node Id: bsprod
>> Class: S
>> Type: PERM
>> Resource Name: SYSVMM
>>
>> Description
>> SOFTWARE PROGRAM ABNORMALLY TERMINATED
>>
>> Probable Causes
>> SYSTEM RUNNING OUT OF PAGING SPACE
>>
>> Failure Causes
>> INSUFFICIENT PAGING SPACE DEFINED FOR THE SYSTEM
>> PROGRAM USING EXCESSIVE AMOUNT OF PAGING SPACE
>>
>> Recommended Actions
>> DEFINE ADDITIONAL PAGING SPACE
>> REDUCE PAGING SPACE REQUIREMENTS OF PROGRAM(S)
>>
>> Detail Data
>> PROGRAM
>> oracle
>> USER'S PROCESS ID:
>> 66786
>> PROGRAM'S PAGING SPACE USE IN 1KB BLOCKS
>> 152
>> *********************************************
>> Could it be the the valuse of "ulimit -a"? My new Oracle 8.1.7 is owned
>> by the user "oracle8" instead of the old "oracle".
>> ulimit -a for oracle:
>> $ ulimit -a
>> time(seconds) unlimited
>> file(blocks) unlimited
>> data(kbytes) unlimited
>> stack(kbytes) unlimited
>> memory(kbytes) unlimited
>> coredump(blocks) unlimited
>> nofiles(descriptors) unlimited
>>
>> ulimit -a for oracle8:
>> $ ulimit -a
>> time(seconds) unlimited
>> file(blocks) unlimited
>> data(kbytes) 131072
>> stack(kbytes) 32768
>> memory(kbytes) 32768
>> coredump(blocks) unlimited
>> nofiles(descriptors) 2000
>>
>> Info about the environment:
>> 2 * RS/6000
>> AIX 4.3.3-09
>> Hacmp 4.3.1 (cluster.base.server.rte 4.3.1.16)
>> SSA disks in concurrent VG
>> Oracle 8.1.7.0.0 (raw device for db files)
>> Mem 2GB
>> Paging 2GB
>>
>>
>> Any ideas??
>>
>> TIA!
>>
>> Arne S
My first suggestion would be DON"T reboot. Seems a bit excessive since what you
need is more paging space. You can add space dynamically thru smit. While you
can expand a page space, I like adding additional page lv's since I can remove
them a lot easier than shrinking them <grin>.
Next, since you get a message in errlog, you can set up a stanza in the error
notify class that can send you a message that this has occurred to you can get a
sense of the problem in real time instead of after the fact. Well, that's not
really true. You can also run "errpt -C" in a window and grep for the message
of interest and run some alert program - so errnotify is not the only way to go.
norm
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002
Received on Sat Apr 27 2002 - 10:49:23 CDT
