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

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

This sounds more like a system configuration limit, rather than an Oracle limit.

Some things that come to mind are total open files, total processes, max number of shared memory segments, max number of semaphores.

You would need to find a more specific reason why the PMON process is dieing.

Then, it's up to your sys admin, or kernel support people to rebuild the kernel or change kernel startup parameters, or what ever your flavor of operating system requires to increase the limitation.

It could even be something like out of swapfile space.

--
Doug Henderson, Glen Coulee Consulting, Calgary, Alberta, Canada
[Sent using Free Agent 1.0]