Connection Refuseddescription= Error =12518
Contents |
TNS:listener could not hand off client connection If this is your first visit, be java sql sqlexception io exception connection refused sure to check out the FAQ by clicking the java.sql.sqlexception io exception connection refused(description=(err=1153) link above. You may have to register before you can post: click the register link vsnnum=186647296 above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 9 of error code 12505 in oracle 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
Vsnnum=186647552
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_DESC = (SID_NAME = PLSExtPro
hand off From: Praveen
Error=(code=305)(emfi=1)
I think default firewall enabling in SP2 we have disable. I'll check listener refused the connection with the following error ora 12518 that too. Thanks for response, Praveen Frank van Bortel
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us http://stackoverflow.com/questions/13624464/ora-12518-tnslistener-could-not-hand-off-client-connection Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow http://www.dbforums.com/showthread.php?971271-ERR-12505-Connection-refused Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ORA-12518, TNS:listener could not hand off client connection connection refused up vote 4 down vote favorite I am using ORACLE database in windows environment and running a jsp/servlet web application in tomcat. After i do some operations with the application it gives me the following error. ORA-12518, TNS:listener could not hand off client connection can any one help me to identify the reason for this problem and propose me a solution? jsp servlets oracle11g share|improve this question sqlexception io exception asked Nov 29 '12 at 11:11 Dinidu 1,03331629 dba-oracle.com/… –JiKra Nov 29 '12 at 21:38 add a comment| 5 Answers 5 active oldest votes up vote 2 down vote I ran across the same problem, in my case it was a new install of the Oracle client on a new desktop that was giving the error, other clients were working so I knew it wouldn't be a fix to the database configuration. tnsping worked properly but sqlplus failed with the ora-12518 listener error. I had the tnsnames.ora entry with a SID instead of a service_name, then once I fixed that, still the same error and found I had the wrong service_name as well. Once I fixed that, the error went away. share|improve this answer edited May 15 '15 at 16:14 HaveNoDisplayName 5,563132034 answered May 15 '15 at 15:53 Jeff Watson 284 And make sure the listener started :) Happy querying –Adi Prasetyo Jun 13 at 15:28 add a comment| up vote 0 down vote If from one day to another the issue shows for no apparent reasons, add these following lines at the bottom of the listner.ora file. If your oracle_home environment variable is set l
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 4 of 4 Thread: ERR=12505 Connection refused Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 11-19-03,15:27 #1 nealw View Profile View Forum Posts Registered User Join Date Nov 2003 Posts 4 Unanswered: ERR=12505 Connection refused I have recently installed Oracle 9 and am trying to connect to it using my Java code. I have done this many times before when connecting to Oracle 8 on other boxes. My java code looks like: String dbDriver = "oracle.jdbc.driver.OracleDriver"; String dbServer = "jdbc:oracle:thin:@192.168.1.70:1521:oracle.domain .bluespark.com"; String username = "meds"; String password = "meds"; ... con = DriverManager.getConnection(dbServer, username, password); I tested the above on another sid on another boxe and it worked fine. Using the SID above I get the following error: java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153092352)(ERR=1 2505)(ERROR_STACK=(ERR OR=(CODE=12505)(EMFI=4)))) If I use this SID: jdbc:oracle:thin:@192.168.1.70:1521:oracle I get this error: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], [] My tnsnames.ora looks like this: # TNSNAMES.ORA Network Configuration File: E:\Oracle\Ora9\network\admin\tnsnames.ora # Generated by Oracle configuration tools. INST1_HTTP.DOMAIN.BLUESPARK.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.70)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = SHARED) (SERVICE_NAME = MODOSE) (PRESENTATION = http://HRService) ) ) EXTPROC_CONNECTION_DATA.DOMAIN.BLUESPARK.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) ORACLE.DOMAIN.BLUESPARK.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.70)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oracle.neal.bluespark) ) ) My listener.ora looks like this: # LISTENER.ORA Network Configuration File: E:\Oracle\Ora9\network\admin\listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = I