Problém
OCI0000367 - Unable to connect to Oracle ORA-12520: TNS:listener could not find available handler for requested type of server
Alert.log
Tue Jan 13 09:06:30 2015
ORA-00020: maximum number of processes (150) 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.
Process W001 submission failed with error = 20
[09:14:59 ~] $ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jan 13 09:15:00 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-00020: maximum number of processes (150) exceeded
Enter user-name: ^C
Řešení
[09:18:03 ~] $ ps -ef | grep pmon
oracle 5455 1 0 2014 ? 00:04:38 ora_pmon_DB01
oracle 7650 32440 0 09:18 pts/4 00:00:00 grep pmon
[09:18:50 ~] $ kill -9 5455
[09:19:55 ~] $ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Tue Jan 13 09:20:00 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 6263357440 bytes
Fixed Size 2239976 bytes
Variable Size 1207960088 bytes
Database Buffers 5033164800 bytes
Redo Buffers 19992576 bytes
Database mounted.
Database opened.
SQL> alter system set processes=500 scope=spfile;
System altered.
SQL> alter system set sessions=772 scope=spfile;
System altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 6263357440 bytes
Fixed Size 2239976 bytes
Variable Size 1207960088 bytes
Database Buffers 5033164800 bytes
Redo Buffers 19992576 bytes
Database mounted.
Database opened.
SQL> select
resource_name,
current_utilization,
max_utilization,
limit_value
from
v$resource_limit
where
resource_name in ( 'sessions', 'processes');
RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION LIMIT_VALU
------------------------------ ------------------- --------------- ----------
processes 153 159 500
sessions 159 165 772
Komentáře
