Error_stack=error=code=12518
TNS:listener could not hand off client connection If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 9 of 9 Thread: TNS-12518: TNS:listener could not hand off client connection Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 05-16-2002,03:58 PM #1 marist89 View Profile View Forum Posts Visit Homepage Super-Genius Join Date Nov 2000 Location greenwich.ct.us Posts 9,092 I am trying to setup a 9.0.1.3 listener to service both 9.0.1.3 and 8.1.7.3 databases on Solaris 2.8. Regular dedicated connections and OCI Java connections work without a problem. JDBC Thin connections fail with an error of: Code: Exception in thread "main" java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(ERR=12518)(VSNNUM=150999808)(ERROR_STACK=(ERROR=(CODE=12518)(EMFI=4))(ERROR=(CODE=12560)(EMFI=4)))) at oracle.jdbc.dbaccess.DBError.throwSqlException(Compiled Code) at oracle.jdbc.dbaccess.DBError.throwSqlException(Compiled Code) at oracle.jdbc.dbaccess.DBError.throwSqlException(Compiled Code) at oracle.jdbc.driver.OracleConnection.(Compiled Code) at oracle.jdbc.driver.OracleDriver.getConnectionInstance(Compiled Code) at oracle.jdbc.driver.OracleDriver.connect(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at thintest.main(Compiled Code) In the listener.log, I get the following error: Code: TNS-12518: TNS:listener could not hand off client connection TNS-12560: TNS:protocol adapter error My listener.ora entry looks like: Code: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oradev1)(PORT = 1521)) ) ) ) SID_LIST_LISTENER = (SID_LIST = (SID
be accessing the database. Frequently they will get "ORA-12518: TNS:listener could not hand off" error and through sqlplus also i'll get this error. But, after sometime it works fine. I checked tnsnames.ora and listner.ora files entry. they seems to be ok. i have used system name itself for HOST flag instead of IP address. But still i'm getting this error. Can anybody tell me what might be the problem? Thanks, Praveen http://www.dbasupport.com/forums/showthread.php?24921-TNS-12518-TNS-listener-could-not-hand-off-client-connection Top ORA-12518: TNS:listener could not hand off by Hans Forbr » Sun, 10 Oct 2004 05:26:39 From Oracle's error messages docco, we see -------- TNS-12518 TNS:listener could not hand off client connection Cause: The process of handing off a client connection to another process failed. Action: Turn on listener tracing and re-execute http://www.yqcomputer.com/254_4038_1.htm the operation. Verify that the listener and database instance are properly configured for direct handoff. If the problem persists, contact Oracle Support Services. -------- So what does the listener trace indicate? /Hans Top ORA-12518: TNS:listener could not hand off by joel-garr » Sun, 10 Oct 2004 06:52:23 12518, 00000, "TNS:listener could not hand off client connection" // *Cause: The process of handing off a client connection to another process // failed. // *Action: Turn on listener tracing and re-execute the operation. Verify // that the listener and database instance are properly configured for // direct handoff. If problem persists, call Oracle Support. // *Comment: The problem can be worked around by configuring dispatcher(s) // to specifically handle the desired presentation(s), and connecting // directly to the dispatcher, bypassing the listener. I would wildly speculate the hostname resolution is too slow. jg @home.com is bogus. http://www.yqcomputer.com/ http://www.yqcomputer.com/ Top ORA-12518: TNS:listener could not hand off by spraveen20 &raq
location is: KBSolution23Pages15185160 Sign In Log In | Sign Up | Log out Feedback Authoring Home Toggle navigation https://kb.informatica.com/solution/23/Pages/15/185160.aspx Network Home Informatica.com Communities Big Data Management Big Data Management Edition Big Data Parser Big Data Management Trial Edition Cloud Integration Cloud Application Integration Cloud Data Integration Cloud Customer 360 DiscoveryIQ Cloud Data Wizard Informatica Cloud for Amazon AWS Complex Event Processing Proactive Healthcare Decision Management Proactive Monitoring Real-Time Alert Manager Rule Point Data Integration B2B Data Exchange B2B Data Transformation Data Integration Hub Data Replication Data Services Data Validation Option Fast Clone Informatica Platform Metadata Manager PowerCenter PowerCenter Express PowerExchange PowerExchange Adapters Data Quality Address Doctor Address Doctor Cloud Data as a Service Data Explorer Data Quality Data Quality Services (Strike Iron) Data Security Group (Formerly ILM) Data Archive Data Centric Security Secure@Source Secure Testing Master Data Management Identity Resolution MDM Big Data Relationship Management MDM Multidomain Edition MDM Registry Edition Process Automation ActiveVOS Cloud Extend Product Information Management Informatica Procurement Product Information Management Ultra Messaging Ultra Messaging Options Ultra Messaging Persistence Edition Ultra Messaging Queuing Edition Ultra Messaging Streaming Edition Vibe Data Stream Documentation Knowledge Base Resources PAM (Product Availability Matrices) Support TV Informatica Expert Assistant Velocity (Best Practices) Mapping Templates Debugging Tools User Groups Informatica Network Knowledge Base 23 KB > Solution > 23 > Pages > 15 > 185160 KB Home Page Authoring Home Top Link Bar KBCurrently selected FAQHowToSolution 6789 WhitepapersKBOktaSyncAdminKBOktaSync KB Search Authoring Home Search Demo Quick Launch Rate It: Average Rating: Informatica goes down without user intervention, while log reports contradict that Problem Description INFA_Problem_DescriptionLogs report "Analyst Service has stopped." The logs have the following errors: Node log:=======2014-05-12 03:13:09,606 ERROR [Master Elect Data Writer] [DOM_10162] Cannot update the data for the master gateway. The domain configuration repository database may not be available. Verify that the database is available.com.informatica.jdbc.oraclebase.ddej: [informatica][Oracle JDBC Driver]Error establishing socket to host and port: e