Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PMON does not start after creating instance

Re: PMON does not start after creating instance

From: <attwoody_at_my-dejanews.com>
Date: Wed, 02 Dec 1998 23:46:43 GMT
Message-ID: <744jh4$jn0$1@nnrp1.dejanews.com>


In article <36637354.E219523C_at_abraxis.com>,   Anil Bharadwa <anil_at_abraxis.com> wrote:
> I created an instance on a Sun box with three disks to install an
> Enterprise Asset Management application. There are currently three other
> instances running different versions of the same application on the same
> box. The instances are used purely for application development.
> When I try to start the database I receive an error stating that PMON
> was unable to start after 120s. If I shutdown one of the other instances
> I can start the one that would previously not start. Therfore indicating
> the maximum capacity has been reached.
> Is it possible or wise to alter the size of PMON to prevent this or is
> there an obvious error in the way that the instances have been created
> that would cause this error. There is at least 4GB of hard disk space
> available.
> Thanks for any help with this matter.

Greetings, Anil

 I would check out the following:

  1. Amount of memory on the Sun box
  2. The SGA (System Global Area) size of each of the instances. You can do this by going into Server Manager, and typing 'show sga' at the SVRMGR> prompt.
  3. The swap size on the Sun box; I have found that for Unix servers running Oracle, the swap size should be 2-3 times the amount of memory
  4. The shared memory parameters in /etc/system

There are four parameters in the init.ora that influence the size of the SGA: DB_BLOCK_SIZE, DB_BLOCK_BUFFERS, SHARED_POOL_SIZE, and SORT_AREA_SIZE. By adjusting one or more of these, you can change the total SGA size.

You also want to check the amount of free memory in your instances; this can be done by doing a 'select * from v$sgastat order by bytes desc'. If the 'free memory' is high', this indicates the SGA can be reduced.

Hope this helps.
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 02 1998 - 17:46:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US