Trouble connecting to ORACLE database

[Former Member]

I get the following error when trying to connect to an oracle database. I can see that the network traffic reaches the server and i get an initial reply from the database server. The tnslistener on the database does not register anything from the connection attempt from the xMII server.

Does anybody have an idea where i should look?

****************************************************************

Fatal error while filling connection pool for jdbc:oracle:thin:@172.18.90.2:1525:IBPPROD java.sql.SQLException: Io exception: The Network Adapter could not establish the connection 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:334) at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:418) at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:521) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:325) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.lighthammer.Illuminator.tools.database.ConnectionPool.createConnectionObject(ConnectionPool.java:318) at com.lighthammer.Illuminator.tools.database.ConnectionPool.fill(ConnectionPool.java:263) at com.lighthammer.Illuminator.tools.database.ConnectionPool.initialize(ConnectionPool.java:129) at com.lighthammer.Illuminator.tools.database.ConnectionPool.<init>(ConnectionPool.java:41) at com.lighthammer.Illuminator.tools.database.ConnectionHolder.addDBConnectionPool(ConnectionHolder.java:121) at com.lighthammer.Illuminator.server.Server.createHolder(Server.java:231) at com.lighthammer.Illuminator.server.Server.setEnabled(Server.java:114) at com.lighthammer.Illuminator.server.Server.parseProperties(Server.java:212) at com.lighthammer.Illuminator.server.Server.<init>(Server.java:40) at com.lighthammer.Illuminator.server.ServerManager.add(ServerManager.java:81) at com.lighthammer.Illuminator.server.ServerManager.update(ServerManager.java:143) at com.lighthammer.Illuminator.gui.handlers.ServerHandler.processServer(ServerHandler.java:232) at com.lighthammer.Illuminator.gui.handlers.ServerHandler.process(ServerHandler.java:75) at com.lighthammer.Illuminator.servlet.Admin.service(Admin.java:50) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.newatlanta.servletexec.SERequestDispatcher.forwardServlet(SERequestDispatcher.java:638) at com.newatlanta.servletexec.SERequestDispatcher.forward(SERequestDispatcher.java:236) at com.newatlanta.servletexec.SERequestDispatcher.internalForward(SERequestDispatcher.java:283) at com.newatlanta.servletexec.SEFilterChain.doFilter(SEFilterChain.java:96) at com.lighthammer.cms.system.CMSFilter.doFilter(CMSFilter.java:126) at com.newatlanta.servletexec.SEFilterChain.doFilter(SEFilterChain.java:60) at com.newatlanta.servletexec.ApplicationInfo.filterApplRequest(ApplicationInfo.java:2159) at com.newatlanta.servletexec.ApplicationInfo.processApplRequest(ApplicationInfo.java:1823) at com.newatlanta.servletexec.ServerHostInfo.processApplRequest(ServerHostInfo.java:937) at com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:1091) at com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:973) at com.newatlanta.servletexec.ServletExecService.processServletRequest(ServletExecService.java:167) at com.newatlanta.servletexec.ServletExecService.Run(ServletExecService.java:204) at com.newatlanta.servletexec.HttpServerRequest.run(HttpServerRequest.java:487)

[Former Member]

The problem is solved.

The tns listener on the database had been reconfigured to listen on another ip than specified, so the error occurred because no tnslistener was available.

[erik_schrampf]

Daniel,

What version of Oracle are you using depending on the version there maybe a different driver to use refer to note 943507.

Are you able to ping that machine IP or machine Name fully qualified?

Is 1525 the correct port?

Erik