Re: Help! Can't create a 6th Database...

In article <3vn5ad$b31_at_its.hooked.net>, Bill and Jan Allaway <allaway_at_hooked.net> wrote:

> I am running on an HP T500 which is being used as a development platform
> for a number of projects, all of which, it seems, need 4 databases each.
> I have scripts to create databases and have cloned them to create 5
> instances so far with no problem. I have had as many as 4 of the
> databases running at the same time without a problem. When I tried to
> create a 6th database using the same scripts I got something like the
> following errors (the numbers might not be right, but the messages are
> close):
> ora-0422 PMON process failed to start
> ora-7269 Background process execd successfully, then died
> additional information: 6
>
> I've checked all the init.ora parameters. I've shut down all but two of
> the databases to be sure it isn't a resource problem. I'm thinking it
> must be some parameter somewhere that is causing PMON to die, but I
> can't think of what it might be. Processes is set to 20, same as 2 other
> instances that created just fine and whose create scripts I cloned for
> the new instance. MTS is set to come up in init.ora, but I have not
> added the new instance to listener.ora or tnsnames.ora, could this be
> it? Any help would be greatly appreciated...
> Bill Allaway
> allaway_at_hooked.net
> voice: (415) 995-8733

Doug Henderson was on the right track. I had the same problem (on a much smaller HP box). The semaphore kernel configuration parameter that needs to be increased is probably SEMMNS. This is consumed by the number of PROCESSES each instance allows. You can check out the consumption with "ipcs -b". The other kernel parameter that may need adjustment is the one that determines how much shared memory is allowed (sorry, I can't remember the parameter name and I don't have access to my notes).

BTW, there is an excellent article available on the Oracle Canada BBS on Oracle memory considerations under UNIX that talks about all this stuff. If you have access to your local Oracle BBS, try and get a copy.

Stan Received on Fri Aug 11 1995 - 00:00:00 CEST