Me sale un error en la base de datos que no deja conectarse a nadie, tras reiniciar el servidor

Me salio el siguiente error y nadie se pudo conectar a la bd lo que hize fue reiniciar el srvidor pq se demoraba mucho al hacerle shutdown immediate ahora tengo como parametro 300 process creo que eso el problema espero me puedas comentar un poco mas por tu experiencia pq sales estos errores:
ORA-00444: fallo del proceso de segundo plano "EMN0" al iniciar
ORA-00020: número máximo de procesos () excedido

2 respuestas

Respuesta
1
En cuanto al error ORA-00444 LO UNICO QUE TE PUEDEO DECIR ES LO QUE DICE METALINK sobre eso
Cause
MEMORY_TARGET set to a value less than the sum of SGA_TARGET and PGA_AGGREGATE_TARGET.
Solution
Increase value of parameter MEMORY_TARGET to be larger than the sum of SGA_TARGET and PGA_AGGREGATE_TARGET.
What can cause an ORA-00020 error?
Goal
How can I avoid an ORA-00020: error with increased transaction volume in Oracle and WebLogic Server 5.1, 6.0, ¿or 7.0? I
Am receiving the following exception:
[Thu Mar 08 10:54:51 GMT+08:00 2001:(ExecuteThread-###) ] Exception getting new sql connection java.sql.SQLException:
ORA-00020: maximum number of processes (###) exceeded
Solution
If the total number of connections in all pools of all weblogic server instances connecting to this Oracle server (plus
connections from any other applications) exceed this value, the maximum number of available processes may need to be
increased by editing the PROCESSES parameter in the initORCL.ora file.
The following information is taken from the Oracle Release 8.0.4 document, Oracle8 Error Messages. Please see your
Oracle documentation to determine whether this recommendation is suitable for your release of the Oracle database
server:
<< ORA-00020 maximum number of processes (num) exceeded
Cause:
An operation requested a resource that was unavailable. The maximum number of processes is specified by the
initialization parameter PROCESSES. When this maximum is reached, no more requests are processed.
Action:
Try the operation again in a few minutes. If this message occurs often, shut down ORACLE, increase the PROCESSES
parameter in the initialization parameter file and restart ORACLE. >>
Resolving this issue may also require further tuning of your WebLogic Server as explained in the WebLogic Server
Performance and Tuning guide:
1. Under some circumstances, you may need to increase the server thread count. A thread count of 25-35 (not to exceed
50) is normally adequate. See the link below for further information:
Tuning WebLogic Server --> Setting Thread Count
http://e-docs.bea.com/wls/docs70/perform/WLSTuning.html#1112343
2. You may also need to tune your connection pool initial and maximum capacity as explained in the link below:
Tuning WebLogic Server --> How JDBC Connection Pools Enhance Performance
http://e-docs.bea.com/wls/docs70/perform/WL
eso es lo unico que te puedo decir
saludos.
Respuesta

Ohk I have the solution about server error here are more deals to buy with big saving for yours. I have got https://www.webtoolsoffers.com/store-list/kaspersky Kaspersky antivirus coupon code it's very beneficial for your PC. I have got Kaspersky antivirus coupon code it's very beneficial for your PC.

Añade tu respuesta

Haz clic para o

Más respuestas relacionadas