Io Exception Connection Refuseddescription= Error =1153
Contents |
Certification Databases Caching Books Engineering Languages Frameworks Products This Site Careers Other all forums Forum: JDBC and Relational Databases JDBC - Connection Refused Error. Connecting (trying) to Oracle DB. Rembrandt Reyes Greenhorn Posts: 3 posted java sql sqlexception io exception connection refused 7 years ago warning: greenhorn = me. I am getting the following error message connection refused(description=(err=1153)(vsnnum=0)(error_stack=(error=(code=1153)(emfi=4) in my log file whenever I run my Java app which makes connections to an Oracle DB: SQLException: Io exception: Connection
Error=(code=305)(emfi=1)
refused (DESCRIPTION=(ERR=1153)(VSNNUM=169869568)(ERROR_STACK=(ERROR=(CODE=1153)(EMFI=4) (ARGS='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.###.###)(PORT=1521))) (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))null))'))(ERROR=(CODE=303)(EMFI=1)))) I am sure the HOST is correct. I have also tried using the server name. Using google fu, I've found references to needing to use a driver called classes12.jar Although I'm not
Vsnnum=186647552
quite sure what to do with it (I've place it in different locations of the app directory but it didn't do anything) Let me know what other information I can share to help me solve my problem. Background info, we've recently changed from using a single node to load balancing 2 nodes. That is when the problem started (and when I inherited this application). I should also warn that this is my error code 12505 in oracle first programming/DB assignment coming from a hardware backround. I miss the warm comforts of my switches and routers.... Thank you in advance. Remy Paul Campbell Ranch Hand Posts: 338 posted 7 years ago It is your Oracle JDBC driver. in your classpath would be a good spot for it. Rembrandt Reyes Greenhorn Posts: 3 posted 7 years ago - Thanks for the reply Paul. I've made sure the classes12.jar is in the ClassPath and it already was. D:\SystemApps\Oracle\ora92\jdbc\lib\classes12.jar I also added classes12.jar as a jar to my project and then redeployed the app. I'm still getting the same errors. - To make sure I understand this, classes12.jar is an oracle driver or what Java uses to communicate with the oracle database. By placing it in the environment variables, the system knows where to find the said driver (and the file does exist in the location above) - Do I need to do anything else with the file to get it to "be seen"? - More info: I've installed tomcat on my machine and deployed the code there. It works. No errors. I didn't have to change anything locally (server and local machine are both using Tomcat 5.5). I'm not sure how my local copy is able to talk to Oracle without
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and
Error=(code=12505)(emfi=4)
much of it will not work correctly without io exception: invalid connection string format, a valid format is: "host:port:sid" it enabled. Please turn JavaScript back on and reload this page. Please enter err=12505 a title. You can not post a blank message. Please type your message and try again. More discussions in Java https://coderanch.com/t/431821/databases/JDBC-Connection-Refused-Error-Connecting - JDBC Archive All PlacesOracle CommunityArchived ForumsJava - JDBC Archive This discussion is archived 11 Replies Latest reply on Jun 18, 2011 1:16 AM by jschellSomeoneStoleMyAlias JDBC RAC URL - Intermittent Connection Refused errors. 485367 Jan 21, 2015 5:13 PM https://community.oracle.com/thread/358849 We are trying to connect via JDBC to an oracle database which is a Oracle 9i RAC (Real Application Cluster). And it seems that the connection fails intermittently with an connection refused error. Details as follows: ===================================== STGSB1 and STGSB2 are two Oracle 9i (9.2.0.1.0)db instances running behind the RAC (on solaris box1). Java application(on solaris box2) uses classes12.jar (Oracle thin driver version 9.2.0) ===================================== Scenario 1: JDBC connection to STGSB1 app.properties config: #db properties db.driver=oracle.jdbc.driver.OracleDriver db.url=jdbc:oracle:thin:@rkwsos01s.xyz.com:1521:STGSB1 db.userid=XXX db.passwd=XXX Result: Works all the time Scenario 2: JDBC connection to STGSB2 app.properties config: #db properties db.driver=oracle.jdbc.driver.OracleDriver db.url=jdbc:oracle:thin:@rkwsos02s.xyz.com:1521:STGSB2 db.userid=XXX db.passwd=XXX Result: Works all the time Scenario 3: JDBC connection to RAC app.properties config: #db properties db.driver=oracle.jdbc.driver.OracleDriver db.url=jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=rkwsos01s.xyz.com)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=rkwsos02s.xyz.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=STGSB.xyz.com))) db.userid=XXX db.passwd=XXX Result: Works intermitte
> HP OpenDeploy > DataDeploy failure Search the Dev Community http://h20435.www2.hp.com/t5/HP-OpenDeploy/DataDeploy-failure/td-p/276848 CommunityBoardUsers turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for Search instead for Do you mean post_question_text.title Post new question Subscribe to RSS Feed DataDeploy failure (744 Views) Reply Reply Topic Options Subscribe to io exception RSS Feed Mark Topic as New Mark Topic as Read Float this Topic to the Top Bookmark Subscribe Printer Friendly Page « Message Listing « Previous Topic Next Topic » Rajesh N/A Posts: 32 Registered: 06-05-2014 DataDeploy failure Options Mark as New Bookmark Subscribe Subscribe to RSS Feed Highlight Print Email to io exception connection a Friend Report Inappropriate Content 10-03-2014 01:22 AM Hello techies,I am facing problem with data deploy. My connection to databaseis refusedwith database.Win 2008 R2TS - 7.4.1OD - 7.4.1Database: Oracle 11gHere is the error I am seeing in the logs.DBD: Connecting to the database...DBD: Try connecting using jdbcracle:thin:@//hostname.com:1521/service_name...DBD: SQL failureDBD: ERROR:ERROR: Could not connect to [jdbcracle:thin:@//hostname.com:1521/service_name]DBD:DBD: *******************************************************DBD: SQLException occured in JdbcCheckup:MakeConnection()DBD: Exception Message: Io exception: Connection refused(DESCRIPTION=(ERR=1153)(VSNNUM=0)(ERROR_STACK=(ERROR=(CODE=1153)(EMFI=4)(ARGS='(ADDRESS=(PROTOCOL=TCP)(HOST=IP of DB server)(PORT=1521))'))(ERROR=(CODE=305)(EMFI=1))))DBD: Vendor Error Code: 17002DBD: SQL state: nullDBD: *******************************************************Here are the options I have tried so far:1) Tested connectivity from TeamSite/OD server to database on the connection port.2) Created a test java class on TeamSite serverto check if I get a connection object. I could connect to the database using ojdbc6.jar. However, connection fails if I use ojdbc14.jar3) I stopped OD and removed ojdbc14.jar and placed ojdbc6.jar, started OD but the DD deployments are still failing.4) However, same works fine on 7.2.1 environment.Any