Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PMON does not start after creating instance
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:
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