TNS:listener could not find available handler with matching protocol stack 解决办法
来源:互联网 发布:linux 开启snmp 编辑:程序博客网 时间:2024/05/19 14:18
ERROR:
ORA-12516: TNS:listener could not find available handler with
matching protocol
stack
修改参数时发现启动第一个sqlplus通过系统认证可以正常连接数据库
。当启动第二个sqlplus工具,以系统认证方式连接数据库时发现连接
到一个空闲例程上。
第一个sqlplus:
[oracle@jason]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.5.0 - Production on Wed Aug 17
18:43:11 2011
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
SQL> conn /as sysdba
Connected.
SQL> show parameter processes;
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 22
SQL> show parameter sessions;
NAME TYPE VALUE
------------------------------------ ----------- ------------
------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
logmnr_max_persistent_sessions integer 1
sessions integer 29
shared_server_sessions integer
SQL> select count(*) from v$session;
COUNT(*)
----------
20
SQL> select count(*) from v$process;
COUNT(*)
----------
21
SQL>
第二个sqlplus:
[oracle@jason]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.5.0 - Production on Wed Aug 17
18:39:55 2011
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
SQL> conn /as sysdba
Connected to an idle instance.
测试尝试启动报错,证明数据库已经运行。
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down
first
SQL>
这点有点不理解,希望得到指点。
在第一个sqlplus连接中,修改processes参数。
SQL> alter system set processes=300 scope=spfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 1207959552 bytes
Fixed Size 2095864 bytes
Variable Size 369100040 bytes
Database Buffers 822083584 bytes
Redo Buffers 14680064 bytes
Database mounted.
Database opened.
SQL> show parameter sessions;
NAME TYPE VALUE
------------------------------------ ----------- ------------
------------------
java_max_sessionspace_size integer 0
java_soft_sessionspace_limit integer 0
license_max_sessions integer 0
license_sessions_warning integer 0
logmnr_max_persistent_sessions integer 1
sessions integer 335
shared_server_sessions integer
SQL> show parameter processes;
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 300
SQL>
在客户端再次利用pl/sql连接数据库,测试可以正常连接.错误提示没有
再出现.
补充:sessions=(1.1 * PROCESSES) + 5
注:本环境为测试环境。
- TNS:listener could not find available handler with matching protocol stack 解决办法
- RAC 中 ORA-12516: TNS: listener could not find available handler with matching protocol stack
- ORA-12516, TNS: listener could not find available handler with matching protocol stack'
- ORA-12516: TNS:listener could not find available handler with matching protocol stack
- ORA-12516: TNS:LISTENER COULD NOT FIND AVAILABLE HANDLER WITH MATCHING PROTOCOL STACK
- ORA-12516, TNS:listener could not find available handler with matching protocol stack
- TNS:listener could not find available handler with matching protocol stack
- Oracle报错ORA-12516 TNS:listener could not find available handler with matching protocol stack
- ora-12516 tns listener could not find available handler with matching protocol
- ora-12516 tns listener could not find available handler with matching protocol
- ORA-12520: TNS:listener could not find available handler
- TNS-12520 TNS:listener could not find available handler for requested type of server
- ORA-12520 TNS:Listener count not find available handler for requested type of server错误解决办法
- ORA-12520 TNS:Listener count not find available handler for requested type of server错误解决办法
- listener could not find available handler for requested type of server
- Could not find *.apk!解决办法
- Could not find *.apk!解决办法
- Could not find *.apk!解决办法
- JSP文件和Servlet在文件目录以及服务器中配置的不同
- 自定义ViewGroup-自定义LayoutParams支持显示方位
- 排序
- 应用java mail和阿里云发送邮件和上传附件
- 使用HTML5制作云层效果
- TNS:listener could not find available handler with matching protocol stack 解决办法
- 斐波那契额数列
- 机器学习之-分类性能指标-准确率-召回率-ROC曲线
- ZARCHIVE_WRITE(限制用于Z表)
- FFMPEG 图像拉伸缩放及数据格式转换
- 软件测试面试题
- C#学习心得
- esxi
- 关于.net连接mysql时配置文件要怎么写