Database crushes every 20 minutes
MarGurNov 1 2007 — edited Feb 15 2010Hello 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.