Re: HELP: ORA-12500 error, SQL*Net V2

On Wed, 05 Aug 1998 11:30:14 GMT, tgp_at_mci2000.com <tgp_at_mci2000.com> wrote:
>
>
>> Well, get back to me if I'm wrong but I do think it's rather obvious
>> especially since (>It's not solid, by the way. > Sometimes you get it and
>> sometimes you don't.)
>>
>> I think it's quite simply the number UNIX processes AIX can spawn. If that
>> value is set to anything lower than the 250 you allow for Oracle users, each
>> time a new user tries to connect Oracle tries to fork off a process and
>> can't.
>>
>> Use SMIT to change the value online - no need to reboot
>
>Well, you sure make it sound obvious, but ...
>
>1. This problem is occurring on our test machine, which has far fewer users
>and processes than our production machine, which is configured just like it.
>A "ps" command shows about 70 processes on the machine that exhibits the
>problem, and about 200 on the machine that's healthy.

>
>2. Also, I am not aware of an AIX parameter that sets the global max process
>count. There is certainly a per-user maximum, but I have never found a global
>one. If you know how to actually get one's hands on this thing, I'd like to
>know about it.
>
>3. The dedicated server process IS being forked. It is just getting a "signal
>11" and dying. The listener.log shows the listener is seeing an EPIPE error,
>too. I interpret to mean that the listener is forking a dedicated process,
>(not getting an error on the fork), setting up a pipe to the process, and
>then later being notified by AIX that the other end of the pipe is dead.

I don't have access currently to an AIX box, but it sounds like whatever AIX does to make pipes is getting messed up. Isn't there a directory like /tmp where all these pipes are made? I have a vague memory that it is possible for this directory to get munged up with old filenames when the system is bought down incorrectly, such that when those filenames are next needed, they confuse the heck out of everything (especially if there were permissions problems). Of course, I might be thinking of a completely diff problem on diff hardware, but it's worth a look.

Also, man pipe and the part about file table entry is the system resource you don't want to be running out of. The pipe will die if enough entries aren't allowed, and some machines default way too low.

>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

hope this helps.

jg
--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Thu Aug 06 1998 - 20:19:48 CDT