If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Hybrid View

database is shutting down frequently

My database is shutting down frequently (once in 24 hours)

Please see the below Alert file and trace file and suggest me what should I do

Alert file
=========
Mon May 04 11:44:05 2009
Process q002 started up but failed with error = 20
Process q002 started up but failed with error = 20
Process q002 started up but failed with error = 20
Process q002 started up but failed with error = 20
Process q002 started up but failed with error = 20
Mon May 04 11:49:18 2009
Process q005 started up but failed with error = 20
Process q005 started up but failed with error = 20
Process q005 started up but failed with error = 20
Process q005 started up but failed with error = 20
Process q005 started up but failed with error = 20
Mon May 04 11:51:02 2009
Private_strands 7 at log switch
Thread 1 advanced to log sequence 44692
Current log# 3 seq# 44692 mem# 0: D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCLJDE\REDO03.LOG
Mon May 04 11:52:31 2009
Errors in file d:\oracle\product\10.1.0\admin\orcljde\udump\orcljde_ora_3800.trc:
ORA-25254: time-out in LISTEN while waiting for a message
ORA-06512: at SYS.DBMS_AQ, line 577
ORA-06512: at SYSMAN.EMD_NOTIFICATION, line 492
ORA-06512: at line 1


When I checked individual trace file it shows as below
=====================================

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

But my worry is, will it affect anywhere else in the system.. Do I need to provide more space in SGA or PGA? because we have only 4Gb RAM in which I have mentioned SGA = 700 MB and PGA = 100 MB..And I have enabled Automatic Share Memory Management.

Please let me know which part of the system will affected by increasing the number of processes? Also what are all the negative part (if any) by increasing the processes

our server is dedicated server. and we have hardly 100 users logging at a time.

Currently we have enabled ASMM (Automatic Shared Memory Management). So I think even if I increase the processes ,Shared pool size will be taken care by ASMM (as no manual control due to enabling ASMM)

hope increasing processes will not affect sharedpool and other areas.. if you know what other areas it can affect please let me know.. So that i can be more cautious in that relevant areas.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.