From: KRASTEV Zdravko (zdravko.krastev@eurocontrol.int)
Date: Fri Aug 30 2002 - 12:10:31 EDT
Thanks to:
Lee J Kendrick
Rita Workman
Duncan, Jay
Rick Greene
1. The common explanation was that the shared memory is fragmented. In order
to de-fragment the memory a reboot, or at least to stop all oracle processes
and then restart.
This assumption was correct - after consulting with the DBA's it seems that
this particular Database would require 250MB of contiguous shared memory.
2. One additional obstacle according to my investigations seems to be that
32-bit application share a common shared memory pool 1.75 GB:
HP-UX has limitations for shared resources on 32-bit applications. All
applications in the system are limited to a total of 1.75 GB of shared
memory,
Release Notes for HP-UX 11.0 Additional Core Enhancements, November 1999
HP 9000 Computers
HP Part Number:B3782-90807
E1199
Copyright 1999 Hewlett-Packard Company
because of that it seems to me better to reboot, in order to clean the
complete shared memory.
Thank you list :o) You are great as usual!
Zdravko
Here is my question:
> Hi list,
> I have a weird Oracle problem.
> There is a three node cluster containing N-classes 4 proc/ 4 GB RAM.
> OS is HP-UX 11. Oracle 8.1.7.2
> Well the servers are quite loaded, but the load is ~ equal on all of them.
> (swap is reserved at 50%, CPU load ~1.8)
> I have a Oracle database which can start on two of the three nodes. On the
> third one I'm getting:
> SVRMGR> SVRMGR> ORA-27102: out of memory
> HP-UX Error: 12: Not enough space
> SVRMGR> ORA-01034: ORACLE not available
>
> The kernels are the same on the three nodes. ipcs shows approx. the same
> usage.
> Here are my shared mem kernel parameters:
> semmni 2000
> semmns 8000
> semmnu 200
> semume 50
> shmmax 0x40000000
> shmmni 800
> shmseg 480
> maxdsiz 0X040000000
> maxssiz 0X04000000
> maxtsiz 0X08000000
>
> I strongly suspect some kernel parameter, but no idea what.
> Any experience with similar problem
> --------------------------------------------------------
> Zdravko KRASTEV - CFMU/ENGD/OSM
> Eurocontrol - Central Flow Management Unit (22.122)
> Rue de la Fusee, 96
> 1130 Brussels - Belgium
>
> E-mail : zdravko.krastev@eurocontrol.int
> Tel: +32(2)7299642 - Fax: +32(2)7299022
>
>
--
---> Please post QUESTIONS and SUMMARIES only!! <---
To subscribe/unsubscribe to this list, contact majordomo@dutchworks.nl
Name: hpux-admin@dutchworks.nl Owner: owner-hpux-admin@dutchworks.nl
Archives: ftp.dutchworks.nl:/pub/digests/hpux-admin (FTP, browse only)
http://www.dutchworks.nl/htbin/hpsysadmin (Web, browse & search)
This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 11:02:19 EDT