Err 12505 Error_stack Error
Contents |
here for a quick overview of the site Help Center Detailed java.sql.sqlexception io exception connection refused(description=(err=1153) answers to any questions you might have Meta Discuss error code 12505 in oracle the workings and policies of this site About Us Learn more about Stack Overflow the vsnnum=186647296 company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss
Vsnnum=186647552
Join the Stack Overflow 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 Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=168821248)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) error up vote 2 down vote favorite Yesterday i was using oracle 9.1 with ojdbc 14 error=(code=305)(emfi=1) jdbc driver with following code for adding employee, it was working fine but now i am using oracle 10.1.0.2.0 with ojdbc14 but now it is giving following error Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=168821248)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) error Following is code for adding employee public static Connection getConnection() throws Exception { String driver = "oracle.jdbc.driver.OracleDriver"; String url = "jdbc:oracle:thin:@localhost:5500:globldb3"; String username = "scott"; String password = "tiger"; Class.forName(driver); Connection conn = DriverManager.getConnection(url, username, password); return conn; } public String addEmployee(){ Connection conn = null; PreparedStatement pstmt = null; boolean committed = false; try { conn = getConnection(); conn.setAutoCommit(false); String query = "INSERT INTO employee(e_id,e_name,e_f_name,e_desg,e_address,e_phone_no,"+ "e_salary,e_house_rent,e_conv_allow,e_email,d_name,e_hire_month,e_hire_year)"+ "VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)"; pstmt = conn.prepareStatement(query); pstmt = conn.prepareStatement(query); // create a statement pstmt.setInt(1,this.eid); pstmt.setString(2,this.ename); pstmt.setString(3,this.efname); pstmt.setString(4,this.edesg); pstmt.setString(5,this.eaddress); pstmt.setLong(6,this.ephoneno); pstmt.setInt(7,this.esalary); pstmt.setInt(8,this.houserent); pstmt.setInt(9,this.convallow); pstmt.setString(10,this.eemail); pstmt.setString(11,this.edname); pstmt.setInt(12,this.ehmon); pstmt.setInt(13,this.ehy); pstmt.executeUpdate(); // execute insert statement conn.commit(); conn.setAutoCommit(true); committed = true; return "add-employee-msg.xhtml"; } catch (Exception e) { e.printStackTrace(); return "add-
visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the connection refused(description=(err=1153)(vsnnum=0)(error_stack=(error=(code=1153)(emfi=4) register link above to proceed. To start viewing messages, select the forum
Io Exception: Invalid Connection String Format, A Valid Format Is: "host:port:sid"
that you want to visit from the selection below. Results 1 to 4 of 4 Thread: ERR=12505 Connection
Io Exception: The Network Adapter Could Not Establish The 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 http://stackoverflow.com/questions/6503144/io-exception-connection-refuseddescription-tmp-vsnnum-168821248err-12505 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 http://www.dbforums.com/showthread.php?971271-ERR-12505-Connection-refused 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 Fi
CommunityOracle User Group CommunityTopliners CommunityOTN https://community.oracle.com/thread/317020 Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and https://mrothouse.wordpress.com/2006/11/02/oracle9i-jdbc-connection-refused/ much of it will not work correctly without it enabled. Please turn JavaScript io exception 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 err 12505 error_stack General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 13 Replies Latest reply on Oct 23, 2006 6:12 PM by 541351 HELP! - Io exception: Connection refused(DESCRIPTION=(TMP=)(... 371156 Jul 17, 2005 4:09 PM Can anyone help me figure out this exception? TIA! Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093120)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093120)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333) at oracle.jdbc.driver.OracleConnection.
to test the JDBC connection. The Java program accepts four command line arguments: user, password, hostname, and database. JdbcThinCheckup mike mike xxx.xx.xx.xxx niku Added a new service to Nagios to check a database and was getting the error below. Error: Io exception: Connection refused (DESCRIPTION=(TMP=)(VSNNUM=153094144)(ERR=12505) (ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) Turns out I was using the alias "nikuprod" found in the tnsnames.ora file rather than the database name "niku". JDBC doesn't utilize the tnsnames.ora file. Not sure why that didn't occur to me yesterday. Brain fart maybe? NIKUPROD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521)) ) (CONNECT_DATA = (SERVICE_NAME = NIKU) ) ) Wasted some time trying to resolve this error by not paying attention. At least I'll be able to refer back to my blog entry when this happens again a year from now. Share this:RedditLike this:Like Loading... Related This entry was posted on Thursday, November 2nd, 2006 at 15:25 pm and is filed under Oracle. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site. Post navigation « Previous Post Next Post » 11 Responses to Oracle9i JDBC - Connectionrefused masurie lim says: Wednesday, January 31, 2007 at 16:32 pm this is whats on my tnsnames.ora: NEW1.METATEC.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oracleprod01)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = new1.inoveris.com) ) ) and this is whats on my properties file: project.db.url=jdbc:oracle:thin:@oracleprod01:1521:new1.inoveris.com and i still got the error you got: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153094144)( ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=