Oracle Error Code 12516
Contents |
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your ora-12516 tns listener message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions ora-12516 oracle 11g This discussion is archived 7 Replies Latest reply on Mar 2, 2009 12:06 PM by zaffer khan, cisa ORA-12516: TNS:listener could not ora-12516 oracle 12c find available handler with matching 443502 May 18, 2005 7:16 AM We are using Oracle 10g Database and 10g Oracle App Server We are finding this error continously after 2 - 3 hours of working We
Java.sql.sqlexception: Listener Refused The Connection With The Following Error: Ora-12516
are using Oracle 10g Database and 10g Oracle App Server Error Says ORA-12516: TNS:listener could not find available handler with matching protocol stack 133216Views Tags: none (add) This content has been marked as final. Show 7 replies 1. Re: ORA-12516: TNS:listener could not find available handler with matching The Human Fly May 18, 2005 7:37 AM (in response to 443502) Please refer metalink Note : 240710.1 that talks about this same error TNS-12516 ora-12516 rac occuring intermittently in the clients. This is because the listener, which relies on Automatic Instance Registration (or AIR) for configuring the services the listener should listen for, gets a lot of client requests and thus runs out of handles to open with the dbserver and hence this error. Action Points : 1.) As a Fix increase the value for PROCESSES in the init
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! ora 12516 sql developer Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don
Oracle Increase Processes
Burleson Blog
ORA-12516 tipsOracle Error Ora-12516
Oracle Database Tips by Burleson Consulting February 14, 2015 Question: I am getting this ORA-12516 error: ORA-12516, TNS: listener could not find available handler with matching https://community.oracle.com/thread/307117 protocol stack' When Running the RunETL Process Can you explain a solution to the ORA-12516 error? I have two application servers (Web Logic) and I am getting the ORA-12516 from only one of the application servers. Answer:The oerr utility shows this for the ORA-12516 error: ORA-12516: TNS: listener could not find available http://www.dba-oracle.com/t_ora_12516-tns_ould_not_find_available_handler.htm handler with matching protocol stack.Cause: None of the known and available service handlers for the given SERVICE_NAME support the client's protocol stack: transport, session, and presentation protocols. Action: Check to make sure that the service handlers (e.g. dispatchers) for the given SERVICE_NAME are registered with the listener, are accepting connections, and that they are properly configured to support the desired protocols. You have to check why the listener was rejecting the connection and do nslookup for the saecopq20(DNS name),and see what and all IP address are mapped to the DNS, and check to see those IP address are listening. Please refer to MOSC Note 1100982.1 and MOSC note 240710.1, notes that talk about the TNS-12516 occurring intermittently in the clients. This is because the listener, which relies on Automatic Instance Registration (or AIR) for configuring the services the listener should listen for, gets a lot of client requests and thus runs out
listener could not find available handler with matching protocol stack" when using Controller Technote (troubleshooting) Problem(Abstract) Users intermittently receive error https://www-01.ibm.com/support/docview.wss?uid=swg21603472 messages, especially when there are many users using the system. Symptom English: COM Exception (0x80004005) ORA-12516: TNS listener could not find available handler with matching protocol stack or: ORA-12520: http://www.nazmulhuda.info/ora-12516-tns-listener-could-not-find-available-handler-with-matching-protocol-stack TNS:listener could not find available handler for requested type of server Spanish: COM Exception (0x80004005) ORA-12516: TNS listener no ha encontrado ningin manejador disponible con una pila de protocolos oracle error coincidente Cause The Oracle database server (hosting the Controller database) has run out of available 'Oracle processes'. This means that the Oracle database server cannot accept any new connections. There are several potential causes for the Oracle database server running out of available 'processes': Scenario #1 - Oracle database server's value for "PROCESSES" has been configured too oracle error code low Scenario #2 - Bug in third party (Oracle) software, causing session leak when JDBC connections are created/used. This means that the used processes are never released when closed. Scenario #3 - Defect in Controller 10.1.0. For more details, see separate IBM Technote #1611403. Scenario #4 - Defect in Controller 10.2 onwards, which causes too many processes to be consumed. For more details, see separate IBM Technote #1978834. More Information on Oracle 'PROCESSES': One of the most common reasons for the TNS-12516 and/or TNS-12519 errors being reported is the configured maximum number of PROCESSES and/or SESSIONS limitation being reached. When this occurs, the service handlers for the TNS listener become "Blocked" and no new connections can be made. Once the TNS Listener receives an update from the PMON process associated with the Database instance telling the TNS Listener the thresholds are below the configured limit, and the database is now accepting connections connectivity resumes. PMON is responsible for updating the listener with information about a particular instance such as load and
FunctionsPL/SQLORA ERRORBugsScriptsToolsMySQLLinuxOtherContact ORA-12516:TNS:listener could not find available handler with matching protocol stack TNS-12516 TNS:listener could not find instance with matching protocol stack ORA-12516 TNS:listener could not find available handler with matching protocol stack TNS-12519 TNS: no appropriate service handler found ORA-12519 TNS: no appropriate service handler found ORA-12520 TNS:listener could not find available handler for requested type of server Cause: PMON update listener with information about instance such as load and dispatcher information. PROCESS parameter determines the maximum load for dedicated connection in database. The interval at which PMON provides SERVICE_UPDATE information differs according to the workload of the instance. The maximum interval between these service updates is 10 minutes. When the threshold exceeds the limit then listener become “Blocked” and no new session can be made since it refusing incoming connection. Once, listener gets the information from PMON that the thresholds are below the configured limit then listener resume accepting connection. Since SERVICE_UPDATE can take maximum 10 minutes, therefore, there can be a difference between the current instance load according to the listener and the actual instance load. The listener counts the number of connections it has established to the instance but does not immediately get information about connections that have terminated. Solution: · check if the number of current connections by using the following command in Unix: ps -ef | grep oracleSID | grep -v grep | wc –l · Check process parameter in database SQL> select * from v$version; BANNER -------------------------------------------------------------------------------- Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production PL/SQL Release 11.2.0.3.0 - Production CORE 11.2.0.3.0 Production TNS for Linux: Version 11.2.0.3.0 - Production NLSRTL Version 11.2.0.3.0 – Production SQL> show parameter processes NAME TYPE VALUE ------------------ ----------- ------- processes integer 200 SQL> select count(*) from v$process; COUNT(*) ---------- 199 Increase process: processes=x session=(1.5 * PROCESSES) + 22 SQL> alter system set processes=300 scope=