TNS-12516及ORA-12516错误解决

在客户端进行sqlplus连接报错如下：

ORA-12516: TNS: 监听程序找不到符合协议堆栈要求的可用处理程序

在/home/oracle/product/10.2.0/db_1/network/log/listener.log中查看到错误如下：

TNS-12516: TNS:listener could not find available handler with matching protocol stack

sqlplus连接之后报错：

[oracle@kel ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 16 00:06:17 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected.
SQL> show parameter session
ORA-01012: not logged on


SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-00020: maximum number of processes (%s) exceeded

alterlog中报错：

Wed Ma