Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database crushes every 20 minutes

MarGurNov 1 2007 — edited Feb 15 2010
Hello gurus,

ou dev database is crushing every 20 minutes. Or freezing, i'm not sure what will the best description.
What is going on, is that all of a sudden, the SQL*Plus throwing this error in response to any command:

db_manager@dev10g> @dev10g
ERROR:
ORA-03114: not connected to ORACLE


Error accessing package DBMS_APPLICATION_INFO

The new connections are not succeed, it jusr hangs. The Putty connection is not allowed, that means that even the oracle user prompt is not displayed. At the same time ping is working and returning 0% loss. I've reboot the server physically and didn't strt the database. In alert log, after the mounting the database, I see the following line:

WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected. ...
and then 10 times


kkjcre1p: unable to spawn jobq slave process

and in the trace file a lot of lines:

Waited for process J000 to be spawned for 81 seconds

with the different amounts of seconds.

While the database was up I saw

db_manager@dev10g> show parameter AQ_TM_PROCESSES

NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
aq_tm_processes integer
0


should I make this parameter 1 or more?
What I have to do know?
Please, advise. this database kinda 24/7 because of Indian outsource.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 15 2010
Added on Nov 1 2007
12 comments
8,202 views