Error_stack=error=code=1153
Contents |
This Site Careers Other all forums Forum: JDBC and Relational Databases JDBC - Connection Refused Error. Connecting (trying) to Oracle connection refused(description=(err=1153)(vsnnum=0)(error_stack=(error=(code=1153)(emfi=4) DB. Rembrandt Reyes Greenhorn Posts: 3 posted 7 years
Error=(code=305)(emfi=1)
ago warning: greenhorn = me. I am getting the following error message in my log file
Oracle Error Code 305
whenever I run my Java app which makes connections to an Oracle DB: SQLException: Io exception: Connection 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
Java Sql Sqlexception Io Exception Connection Refused
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 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 ojdbc14.jar download 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 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 m
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 message and try again. More discussions in Java - JDBC Archive All PlacesOracle CommunityArchived ForumsJava - JDBC Archive https://coderanch.com/t/431821/JDBC/databases/JDBC-Connection-Refused-Error-Connecting 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 We are trying to connect via JDBC to an oracle database which is a Oracle 9i https://community.oracle.com/thread/358849 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 intermittently. In cases where it doesnt work, the error is as follows(sometimes the server mentioned is rkwsos02s): Io exception: Connection refused(DESCRIPTI ON=(ERR=1153)(VSNNUM=153093888)(ERROR_STACK=(ERROR=(CODE=1153)(EMFI=4)(ARGS='(ADDRESS=(PROTOCOL=TCP)(HOST=rkwsos01s)(PORT=1521))'))(ERROR=(CODE=305)(E MFI=1)))) java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(ERR=1153)(VSNNUM=153093888)(ERROR_STACK=(ERROR=(CODE=1153)(EMFI=4)(ARGS='(ADDRESS =(PROTOCOL=TCP)(HOST=rkwsos01s)(PORT=1521))'))(ERROR=(CODE=305)(EMFI=1)))) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(
from Oracle 9i application server and am getting Connection refused errors intermittently when using Connection Pooling. If I use only 1 connection in the pool, it works fine, but when I try to connection refused pool 2 or more connections, I successfully get few connections and Connection Refused errors for others. Coincidentally, the successful connections are always to the first node mentioned in the RAC, and the errors are always from the second oracle error code node.The jdbc jar I am using is classes12dms.jar; I tried to update to ojdbc14.jar because the connection is to 10G, but it does not seem to work. (Or maybe the appserver is still picking up the old jar file).Here is the connection string I am using:jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = XYZ1)(PORT = 1522))(ADDRESS = (PROTOCOL = TCP)(HOST = XYZ2)(PORT = 1522))(LOAD_BALANCE = off)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = XYZ)))Here is the error I am getting:org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(ERR=1153)(VSNNUM=169870080)(ERROR_STACK=(ERROR=(CODE=1153)(EMFI=4)(ARGS='(ADDRESS=(PROTOCOL=TCP)(HOST=XYZ2)(PORT=1522))'))(ERROR=(CODE=305)(EMFI=1))))java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(ERR=1153)(VSNNUM=169870080)(ERROR_STACK=(ERROR=(CODE=1153)(EMFI=4)(ARGS='(ADDRESS=(PROTOCOL=TCP)(HOST=XYZ2)(PORT=1522))'))(ERROR=(CODE=305)(EMFI=1)))) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:185) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:227) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:340) at oracle.jdbc.driver.OracleConnection.