Re: Stale IPC semephores causing problems

Great stuff, I'll look into it tomorrow, and ask the dba's accordingly, thanks. By the way,
did you see I got my oracle instance working. I think it was my oraclehome libs missing.

thanks for your help on both issues,

patrick.

Sybrand Bakker wrote in message ...
>"Patrick Mackeown" <patrick_nospam__at_patmac.demon.co.uk> wrote in message
news:<1020321629.6363.0.nnrp-10.c2def390_at_news.demon.co.uk>...
>> Hi Folks,
>>
>> We use oracle 8.0.5 on HPUX 11 and run peoplesoft financials. Anyway, on
>> rare occasions
>> two things happen. The temporary files on oracle partitions fill the
disks
>> up and on even rarer
>> occasions all semephores which could be created have been created and new
>> applications
>> fail. I believe we use ipcs to view the semephores and shared memory
>> allocation and ipcsrm
>> to remove undesired semephores, but I've been told that there's no
surefire
>> way to tell which
>> semephores to ipcsrm, "You just dig around, guess which ones to delete"
I've
>> been told. I'm
>> not to happy with this explanation! What should I do next? And is there a
>> method of scripting
>> the removal of these damned temporary files, which are such a pain in the
>> neck?
>>
>> Thanks for any tips and tricks!
>>
>> Patrick.
>
>I think you are symptom fighting if you start to remove semaphores.
>You must have more serious problems, like you are running dedicated
>server with more than 50 users, where you should run MTS, or you don't
>have dead connection detection enabled.
>
>
>--
>Regards
>
>Sybrand Bakker
>Senior Oracle DBA
Received on Thu May 02 2002 - 13:21:48 CDT