Oracle Database Discussions

Hi All ,

i am facing the following errors while the database starts up.
eariler my process parameter was set to 100 , and now i had set it to 200 but still i am getting this error.. and i wonder why is it showing "maximum number of processes 0 exceeded" whereas the current number of processes are 200.



I am facing the following errors in my trace file :
__________________________________________________________
System parameters with non-default values:
processes = 200
timed_statistics = TRUE
resource_limit = TRUE
sga_max_size = 700M
shared_pool_size = 312M
large_pool_size = 52M
java_pool_size = 52M
nls_length_semantics = "char"
control_files = "/uv114/u327/oradata/<database_name>/control01.ctl"
control_files = "/uv114/u327/oradata/<database_name>/control02.ctl"
control_files = "/uv114/u327/oradata/<database_name>/control03.ctl"
db_block_size = 8192
db_cache_size = 200M
dbhandles_cached = 0
db_cache_advice = "ON"
compatible = "11.1.0.7"
log_archive_dest = "/uv114/u327/ofaroot/<database_name>/arch"
log_archive_format = "arch%t_%s_%r.arc"
log_buffer = 1703936
log_checkpoint_interval = 10000
db_file_multiblock_read_count= 8
dml_locks = 100
replication_dependency_tracking= FALSE
undo_management = "AUTO"
undo_tablespace = "UNDO"
remote_os_roles = FALSE
O7_DICTIONARY_ACCESSIBILITY= FALSE
session_cached_cursors = 250
job_queue_processes = 50
cursor_sharing = "SIMILAR"
parallel_max_servers = 32
optimizer_features_enable= "11.1.0.7"
db_name = "<database_name>"
open_cursors = 200
os_authent_prefix = "joy"
optimizer_mode = "ALL_ROWS"
query_rewrite_enabled = "true"
query_rewrite_integrity = "trusted"
pga_aggregate_target = 100M
workarea_size_policy = "AUTO"
diagnostic_dest = "/uv1146/u325/ofaroot/<database_name>"
max_dump_file_size = "10240"
Wed Nov 17 07:43:20 2010
ksuapc : ORA-1033 foreground process starts before PMON
Wed Nov 17 07:43:20 2010
ksuapc : ORA-1033 foreground process starts before PMON
Wed Nov 17 07:43:20 2010
ksuapc : ORA-1033 foreground process starts before PMON
Wed Nov 17 07:43:20 2010
ksuapc : ORA-1033 foreground process starts before PMON
Wed Nov 17 07:43:20 2010
ksuapc : ORA-1033 foreground process starts before PMON
Wed Nov 17 07:43:20 2010
ksuapc : ORA-1033 foreground process starts before PMON
Wed Nov 17 07:43:20 2010
ksuapc : ORA-1033 foreground process starts before PMON
Wed Nov 17 07:43:20 2010
ksuapc : ORA-1033 foreground process starts before PMON
Wed Nov 17 07:43:20 2010
ksuapc : ORA-1033 foreground process starts before PMON
Wed Nov 17 07:43:20 2010
ksuapc : ORA-1033 foreground process starts before PMON
Wed Nov 17 07:43:20 2010
ksuapc : ORA-1033 foreground process starts before PMON
Wed Nov 17 07:43:20 2010
ksuapc : ORA-1033 foreground process starts before PMON
Wed Nov 17 07:43:20 2010
ksuapc : ORA-1033 foreground process starts before PMON
Wed Nov 17 07:43:20 2010
ksuapc : ORA-1033 foreground process starts before PMON
Wed Nov 17 07:43:20 2010
PMON started with pid=2, OS id=17303
Wed Nov 17 07:43:21 2010
VKTM started with pid=6, OS id=17316 at elevated priority
VKTM running at (20)ms precision
*********************************************************
*********************************************************
*****SOME TRACE FILE MISSING*****************************
*********************************************************
Wed Nov 17 07:43:44 2010
CJQ0 started with pid=182, OS id=18541
Wed Nov 17 07:43:46 2010
ORA-00020: maximum number of processes 0 exceeded
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Wed Nov 17 07:43:47 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:43:57 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:44:08 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:44:19 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:44:30 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:44:41 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:44:47 2010
ORA-00020: maximum number of processes 0 exceeded
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Wed Nov 17 07:44:52 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:45:04 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:45:15 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:45:26 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:45:37 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:45:48 2010
ORA-00020: No more process state objects available
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process q000 submission failed with error = 20
Wed Nov 17 07:45:59 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:46:10 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:46:21 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:46:32 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:46:43 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:46:49 2010
ORA-00020: maximum number of processes 0 exceeded
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Wed Nov 17 07:46:54 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:47:05 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:47:16 2010
Process q000 submission failed with error = 20
Process q000 submission failed with error = 20
Wed Nov 17 07:47:16 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:47:27 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:47:38 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:47:49 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:47:51 2010
ORA-00020: maximum number of processes 0 exceeded
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Wed Nov 17 07:48:00 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:48:11 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:48:22 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:48:34 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:48:45 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:48:46 2010
Starting background process SMCO
Process SMCO submission failed with error = 20
Errors in file /uv114/u327/ofaroot/<database_name>/diag/rdbms/<database_name>/<database_name>/trace/<database_name>smon17464.trc:
ORA-00444: background process "SMCO" failed while starting
ORA-00020: maximum number of processes () exceeded
Wed Nov 17 07:48:51 2010
ORA-00020: maximum number of processes 0 exceeded
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Wed Nov 17 07:48:56 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:48:56 2010
Restarting dead background process SMCO
Process SMCO submission failed with error = 20
Errors in file /uv114/u327/ofaroot/<database_name>/diag/rdbms/<database_name>/<database_name>/trace/<database_name>pmon17303.trc:
ORA-00444: background process "SMCO" failed while starting
ORA-00020: maximum number of processes () exceeded
Wed Nov 17 07:49:07 2010
Process q000 submission failed with error = 20
Wed Nov 17 07:50:09 2010
Starting background process SMCO
Wed Nov 17 07:50:09 2010
SMCO started with pid=86, OS id=22929
Wed Nov 17 08:03:53 2010
Stopping background process CJQ0
Wed Nov 17 08:09:21 2010
Errors in file /uv114/u327/ofaroot/<database_name>/diag/rdbms/<database_name>/<database_name>/trace/<database_name>ora23706.trc (incident=133029):
ORA-04030: out of process memory when trying to allocate 112 bytes (temporary memory,dbgf-glo)
Incident details in: /uv114/u327/ofaroot/<database_name>/diag/rdbms/<database_name>/<database_name>/incident/incdir_133029/<database_name>ora23706_i133029
.trc
Errors in file /uv114/u327/ofaroot/<database_name>/diag/rdbms/<database_name>/<database_name>/trace/<database_name>ora23706.trc (incident=133030):
ORA-04030: out of process memory when trying to allocate 312 bytes (kewa_dump_sess,kewa_ash_cb_nextsample: sample buffer)
ORA-04030: out of process memory when trying to allocate 112 bytes (temporary memory,dbgf-glo)
Incident details in: /uv114/u327/ofaroot/<database_name>/diag/rdbms/<database_name>/<database_name>/incident/incdir_133030/<database_name>ora23706_i133030
.trc
Wed Nov 17 08:09:30 2010
Sweep Incident[133030]: completed
Wed Nov 17 08:09:35 2010
Trace dumping is performing id=[cdmp_20101117080935]
Wed Nov 17 08:09:35 2010
Non critical error ORA-48913 caught while writing to trace file "/uv114/u327/ofaroot/<database_name>/diag/rdbms/<database_name>/<database_name>/inci
dent/incdir_133029/<database_name>_ora_23706_i133029.trc"
Error message: ORA-48913: Writing into trace file failed, file size limit [5242880] reached
Writing to the above trace file is disabled for now on...
Wed Nov 17 08:10:30 2010
Sweep Incident[133029]: completed
_______________________________________________________


tell me what to do .. Please.
- Kk