listener could not find available handler with matching protocol stack -

oywl2008

浏览: 1051851 次
性别:
来自: 广州

最近访客更多访客>>

panghu

wangyy

qjl26

chyanog

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

listener could not find available handler with matching protocol stack

博客分类：

Oracle

oracle processes

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

[plain] view plain copy print ?

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

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

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

[plain] view plain copy print ?

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

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

sqlplus连接之后报错：

[plain] view plain copy print ?

[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

[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中报错：

[plain] view plain copy print ?

Wed May 15 23:59:26 2013
Process m000 died, see its trace file
Wed May 15 23:59:26 2013
ksvcreate: Process(m000) creation failed
Thu May 16 00:00:26 2013
Process m000 died, see its trace file
Thu May 16 00:00:26 2013
ksvcreate: Process(m000) creation failed
Process m000 died, see its trace file
Thu May 16 00:00:27 2013
ksvcreate: Process(m000) creation failed
Thu May 16 00:01:27 2013
Process m000 died, see its trace file
Thu May 16 00:01:27 2013
ksvcreate: Process(m000) creation failed
Process m000 died, see its trace file
Thu May 16 00:01:27 2013
ksvcreate: Process(m000) creation failed

Wed May 15 23:59:26 2013
Process m000 died, see its trace file
Wed May 15 23:59:26 2013
ksvcreate: Process(m000) creation failed
Thu May 16 00:00:26 2013
Process m000 died, see its trace file
Thu May 16 00:00:26 2013
ksvcreate: Process(m000) creation failed
Process m000 died, see its trace file
Thu May 16 00:00:27 2013
ksvcreate: Process(m000) creation failed
Thu May 16 00:01:27 2013
Process m000 died, see its trace file
Thu May 16 00:01:27 2013
ksvcreate: Process(m000) creation failed
Process m000 died, see its trace file
Thu May 16 00:01:27 2013
ksvcreate: Process(m000) creation failed

1、无法登陆数据库的情况下使用以下方法：

a、找到数据库的关键进程，然后杀死，此时数据库实例会自动进行关闭

[plain] view plain copy print ?

[oracle@kel ~]$ ps -ef|grep dbw
oracle 16107 1 0 00:04 ? 00:00:00 ora_dbw0_orcl
oracle 16755 15946 0 00:19 pts/0 00:00:00 grep dbw
[oracle@kel ~]$ kill -9 16107

[oracle@kel ~]$ ps -ef|grep dbw
oracle   16107     1  0 00:04 ?        00:00:00 ora_dbw0_orcl
oracle   16755 15946  0 00:19 pts/0    00:00:00 grep dbw
[oracle@kel ~]$ kill -9 16107

2、公用的方法，当能登陆进数据库之后

b、sqlplus登录进数据库，启动数据库

[plain] view plain copy print ?

[oracle@kel ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 16 00:20:11 2013
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 176160768 bytes
Fixed Size 2019384 bytes
Variable Size 100667336 bytes
Database Buffers 71303168 bytes
Redo Buffers 2170880 bytes
Database mounted.
Database opened.

[oracle@kel ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 16 00:20:11 2013

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  176160768 bytes
Fixed Size		    2019384 bytes
Variable Size		  100667336 bytes
Database Buffers	   71303168 bytes
Redo Buffers		    2170880 bytes
Database mounted.
Database opened.

c、查看系统，发现process的值已经接近上限，修改processes的值

[plain] view plain copy print ?

SQL> show parameter process
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 20

SQL> show parameter process

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes 		     integer	 0
db_writer_processes		     integer	 1
gcs_server_processes		     integer	 0
job_queue_processes		     integer	 10
log_archive_max_processes	     integer	 2
processes			     integer	 20

[plain] view plain copy print ?

SQL> alter system set processes=1150 scope=spfile;
System altered.

SQL> alter system set processes=1150 scope=spfile;

System altered.

d、重新启动oracle数据库

[plain] view plain copy print ?

SQL> startup force
ORACLE instance started.
Total System Global Area 176160768 bytes
Fixed Size 2019384 bytes
Variable Size 100667336 bytes
Database Buffers 71303168 bytes
Redo Buffers 2170880 bytes
Database mounted.
Database opened.
SQL> show parameter process;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 150

SQL> startup force
ORACLE instance started.

Total System Global Area  176160768 bytes
Fixed Size		    2019384 bytes
Variable Size		  100667336 bytes
Database Buffers	   71303168 bytes
Redo Buffers		    2170880 bytes
Database mounted.
Database opened.
SQL> show parameter process;

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes 		     integer	 0
db_writer_processes		     integer	 1
gcs_server_processes		     integer	 0
job_queue_processes		     integer	 10
log_archive_max_processes	     integer	 2
processes			     integer	 150

连接不上数据库的时候，可能会是processes值已经达到了上限，从而修改processes的值，加大即可

http://blog.csdn.net/kellyseeme/article/details/8935208

分享到：

零基础学HTML 5实战开发(第一季) | 如何领导社交商务发展

2015-05-28 10:46
浏览 1212
评论(0)
分类:数据库
查看更多

发表评论

您还没有登录,请您登录后再发表评论

最近访客更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论

listener could not find available handler with matching protocol stack

评论

发表评论

相关推荐

最近访客 更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论

listener could not find available handler with matching protocol stack

评论

发表评论

相关推荐

Oracle SGA 设置

Oracle删除库中所有表

Oracle用户权限

DBMS_Job包的用法

export DB oracle and DB2

oracle export DB

listener does not currently know of SID given in connect descriptor

Oracle表连接操作——Nest Loop Join（嵌套循环）

oracle hints

hibernate hints oracle database

关于 varchar2 的最大长度

Oracle %TYPE

Oracle 系统知识总结

View Oracle table PK column

Some important SQL about Oracle

Oracle数据库的一些常用操作经验总结

获得单个表和索引DDL语句的方法：

NVARCHAR2和VARCHAR2的区别

Oracle常用系统表

最近访客更多访客>>