ORA-12516, TNS: listener could not find available handler with matching protocol stack'
来源:互联网 发布:校园招聘 云计算 编辑:程序博客网 时间:2024/06/05 03:36
Error: 'Oracle XE: ORA-12516, TNS: listener could not find available handler with matching protocol stack' When Running the RunETL Process [ID 1100982.1]
修改时间 28-DEC-2011 类型 PROBLEM 状态 PUBLISHED
Information in this document applies to any platform.
***Checked relevance on 28-Dec-2011***
When the listener believes the current number of connections has reached maximum load, it may set the state of the service handler for an instance to "blocked" and begin refusing incoming client connections with the error:
1) Connect to the XE database using the sys or system user:
2) To confirm the PROCESSES and SESSIONS values, run the following script:
3) Run the following commands to set the PROCESSES and SESSIONS to a higher value:
5) Restart the XE database to reflect the changes
6) To confirm new values re-run the script in.step 2.
修改时间 28-DEC-2011 类型 PROBLEM 状态 PUBLISHED
In this Document
Symptoms
Cause
Solution
References
Applies to:
Primavera P6 Reporting Database - Version: R1 to R2.1 - Release: R1 to R2Information in this document applies to any platform.
***Checked relevance on 28-Dec-2011***
Symptoms
When running runetl.bat on an Oracle XE database the process fails with error:Listener refused the connection with the following error: ORA-12516, TNS:listener could not find available handler with matching protocol stack
Cause
The Oracle XE Database is configured by default to run only 20 or 40 PROCESSES; the maximum load for dedicated connections is determined by the PROCESSES parameter.When the listener believes the current number of connections has reached maximum load, it may set the state of the service handler for an instance to "blocked" and begin refusing incoming client connections with the error:
TNS-12516 TNS:listener could not find instance with matching protocol stack
Solution
To resolve the issue, do the following:1) Connect to the XE database using the sys or system user:
sqlplus system/<password>
2) To confirm the PROCESSES and SESSIONS values, run the following script:
sql> col name format A30
sql> col value format A30
sql> select name, value from v$parameter where name in ('processes','sessions');
3) Run the following commands to set the PROCESSES and SESSIONS to a higher value:
SQL> alter system set processes=300 scope=spfile;
SQL> alter system set sessions=300 scope=spfile;
5) Restart the XE database to reflect the changes
6) To confirm new values re-run the script in.step 2.
References
NOTE:240710.1 - Intermittent TNS-12516 or TNS-12519 Errors When Connecting Via Oracle Net- 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
- 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
- TNS:listener could not find available handler with matching protocol stack 解决办法
- TNS:listener could not find available handler with matching protocol stack
- 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
- ORA-12518, TNS:listener could not hand off client connection
- ORA-12518: TNS:listener could not hand off client connection
- ORA-12518, TNS:listener could not hand off client connection
- hibernate 表关联 数据出错报的异常
- 怎样像iPhone模拟器中添加图片
- HDU 1020 Encoding 典型的字符串的压缩
- C++ const与指针关系
- 内连接,迫切内连接,左外连接,迫切左外连接
- ORA-12516, TNS: listener could not find available handler with matching protocol stack'
- SQL Server 模糊查询
- 堆和栈的区别
- 命令行安装配置db2
- 关于protected access label
- IOS中Info.plist文件中重要的键
- C++ 异常处理
- C++继承多态下的内存分布
- hdu 4046 Panda