This discussion is archived
6 Replies Latest reply: Jan 29, 2010 2:39 PM by 750004 RSS

BIB-14122, ORA-17002 errors when trying to run deployed Java application

420471 Newbie
Currently Being Moderated
Greetings,

We deployed a BI Beans project as a java application. Local users can use it without problems. However, remote users are getting errors. I tried editing the connection and making the server name a fully-qualified name (i.e., server.subdomain.domain.com instead of just server), but that did not help. Any ideas? Error text follows.

oracle.dss.persistence.persistencemanager.common.PersistenceManagerRuntimeException: BIB-14122: The specified StorageManager could not be created.
oracle.dss.security.BISecurityException: ORA-17002 Io exception: The Network Adapter could not establish the connection
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
     at oracle.dss.persistence.persistencemanager.server.PersistenceManagerSupport.loadStorageAdapterFromXML(PersistenceManagerSupport.java:444)
     at oracle.dss.persistence.persistencemanager.server.PersistenceManagerSupport.<init>(PersistenceManagerSupport.java:145)
     at oracle.dss.persistence.persistencemanager.server.PersistenceManagerImpl.<init>(PersistenceManagerImpl.java:99)
     at oracle.dss.persistence.persistencemanager.server.InitPersistenceManagerFactory.getInitialContext(InitPersistenceManagerFactory.java:29)
     at javax.naming.spi.NamingManager.getInitialContext(Unknown Source)
     at javax.naming.InitialContext.getDefaultInitCtx(Unknown Source)
     at javax.naming.InitialContext.init(Unknown Source)
     at javax.naming.InitialContext.<init>(Unknown Source)
     at javax.naming.directory.InitialDirContext.<init>(Unknown Source)
     at oracle.dss.persistence.persistencemanager.server.InitialPersistenceManager.<init>(InitialPersistenceManager.java:103)
     at oracle.dss.connection.server.drivers.persistence.PersistenceConnectionDriverImpl.connect(PersistenceConnectionDriverImpl.java:147)
     at oracle.dss.connection.server.ConnectionImpl.connect(ConnectionImpl.java:279)
     at oracle.dss.connection.client.Connection.connect(Connection.java:400)
     at oracle.dss.connection.client.Connection.connect(Connection.java:320)
     at oracle.dss.metadataManager.client.MetadataManager.setConnectionObjects(MetadataManager.java:3985)
     at oracle.dss.metadataManager.client.MetadataManager.attach(MetadataManager.java:852)
     at oracle.dss.metadataManager.client.MetadataManager.attach(MetadataManager.java:792)
     at oracle.dss.datautil.client.XMLManagerFactory.createQueryManager(XMLManagerFactory.java:187)
     at oracle.dss.datautil.client.ManagerFactoryImpl.lookupQueryManager(ManagerFactoryImpl.java:176)
     at oracle.dss.datautil.client.ManagerFactoryImpl.lookupMetadataManager(ManagerFactoryImpl.java:219)
     at oracle.dss.datautil.client.ManagerFactoryImpl.lookupManager(ManagerFactoryImpl.java:128)
     at mypackage2.BIApplication3.getMetadataManager(BIApplication3.java:395)
     at mypackage2.BIApplication3.openView(BIApplication3.java:659)
     at mypackage2.BIApplication3.jbInit(BIApplication3.java:302)
     at mypackage2.BIApplication3.<init>(BIApplication3.java:184)
     at mypackage2.BIApplication3.main(BIApplication3.java:1066)
oracle.dss.security.BISecurityException: ORA-17002 Io exception: The Network Adapter could not establish the connection
java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
     at oracle.dss.persistence.storagemanager.bi.mapping.ReposConnectionDriver.connect(ReposConnectionDriver.java:116)
     at oracle.dss.persistence.storagemanager.bi.mapping.JdbcAdapter.init(JdbcAdapter.java:537)
     at oracle.dss.persistence.storagemanager.bi.BIStorageManagerImpl.init(BIStorageManagerImpl.java:206)
     at java.lang.reflect.Method.invoke(Native Method)
     at oracle.dss.persistence.persistencemanager.server.PersistenceManagerSupport.loadStorageAdapterFromXML(PersistenceManagerSupport.java:399)
     at oracle.dss.persistence.persistencemanager.server.PersistenceManagerSupport.<init>(PersistenceManagerSupport.java:145)
     at oracle.dss.persistence.persistencemanager.server.PersistenceManagerImpl.<init>(PersistenceManagerImpl.java:99)
     at oracle.dss.persistence.persistencemanager.server.InitPersistenceManagerFactory.getInitialContext(InitPersistenceManagerFactory.java:29)
     at javax.naming.spi.NamingManager.getInitialContext(Unknown Source)
     at javax.naming.InitialContext.getDefaultInitCtx(Unknown Source)
     at javax.naming.InitialContext.init(Unknown Source)
     at javax.naming.InitialContext.<init>(Unknown Source)
     at javax.naming.directory.InitialDirContext.<init>(Unknown Source)
     at oracle.dss.persistence.persistencemanager.server.InitialPersistenceManager.<init>(InitialPersistenceManager.java:103)
     at oracle.dss.connection.server.drivers.persistence.PersistenceConnectionDriverImpl.connect(PersistenceConnectionDriverImpl.java:147)
     at oracle.dss.connection.server.ConnectionImpl.connect(ConnectionImpl.java:279)
     at oracle.dss.connection.client.Connection.connect(Connection.java:400)
     at oracle.dss.connection.client.Connection.connect(Connection.java:320)
     at oracle.dss.metadataManager.client.MetadataManager.setConnectionObjects(MetadataManager.java:3985)
     at oracle.dss.metadataManager.client.MetadataManager.attach(MetadataManager.java:852)
     at oracle.dss.metadataManager.client.MetadataManager.attach(MetadataManager.java:792)
     at oracle.dss.datautil.client.XMLManagerFactory.createQueryManager(XMLManagerFactory.java:187)
     at oracle.dss.datautil.client.ManagerFactoryImpl.lookupQueryManager(ManagerFactoryImpl.java:176)
     at oracle.dss.datautil.client.ManagerFactoryImpl.lookupMetadataManager(ManagerFactoryImpl.java:219)
     at oracle.dss.datautil.client.ManagerFactoryImpl.lookupManager(ManagerFactoryImpl.java:128)
     at mypackage2.BIApplication3.getMetadataManager(BIApplication3.java:395)
     at mypackage2.BIApplication3.openView(BIApplication3.java:659)
     at mypackage2.BIApplication3.jbInit(BIApplication3.java:302)
     at mypackage2.BIApplication3.<init>(BIApplication3.java:184)
     at mypackage2.BIApplication3.main(BIApplication3.java:1066)
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(Unknown Source)
     at java.sql.DriverManager.getConnection(Unknown Source)
     at oracle.dss.persistence.storagemanager.bi.mapping.ReposConnectionDriver.connect(ReposConnectionDriver.java:105)
     at oracle.dss.persistence.storagemanager.bi.mapping.JdbcAdapter.init(JdbcAdapter.java:537)
     at oracle.dss.persistence.storagemanager.bi.BIStorageManagerImpl.init(BIStorageManagerImpl.java:206)
     at java.lang.reflect.Method.invoke(Native Method)
     at oracle.dss.persistence.persistencemanager.server.PersistenceManagerSupport.loadStorageAdapterFromXML(PersistenceManagerSupport.java:399)
     at oracle.dss.persistence.persistencemanager.server.PersistenceManagerSupport.<init>(PersistenceManagerSupport.java:145)
     at oracle.dss.persistence.persistencemanager.server.PersistenceManagerImpl.<init>(PersistenceManagerImpl.java:99)
     at oracle.dss.persistence.persistencemanager.server.InitPersistenceManagerFactory.getInitialContext(InitPersistenceManagerFactory.java:29)
     at javax.naming.spi.NamingManager.getInitialContext(Unknown Source)
     at javax.naming.InitialContext.getDefaultInitCtx(Unknown Source)
     at javax.naming.InitialContext.init(Unknown Source)
     at javax.naming.InitialContext.<init>(Unknown Source)
     at javax.naming.directory.InitialDirContext.<init>(Unknown Source)
     at oracle.dss.persistence.persistencemanager.server.InitialPersistenceManager.<init>(InitialPersistenceManager.java:103)
     at oracle.dss.connection.server.drivers.persistence.PersistenceConnectionDriverImpl.connect(PersistenceConnectionDriverImpl.java:147)
     at oracle.dss.connection.server.ConnectionImpl.connect(ConnectionImpl.java:279)
     at oracle.dss.connection.client.Connection.connect(Connection.java:400)
     at oracle.dss.connection.client.Connection.connect(Connection.java:320)
     at oracle.dss.metadataManager.client.MetadataManager.setConnectionObjects(MetadataManager.java:3985)
     at oracle.dss.metadataManager.client.MetadataManager.attach(MetadataManager.java:852)
     at oracle.dss.metadataManager.client.MetadataManager.attach(MetadataManager.java:792)
     at oracle.dss.datautil.client.XMLManagerFactory.createQueryManager(XMLManagerFactory.java:187)
     at oracle.dss.datautil.client.ManagerFactoryImpl.lookupQueryManager(ManagerFactoryImpl.java:176)
     at oracle.dss.datautil.client.ManagerFactoryImpl.lookupMetadataManager(ManagerFactoryImpl.java:219)
     at oracle.dss.datautil.client.ManagerFactoryImpl.lookupManager(ManagerFactoryImpl.java:128)
     at mypackage2.BIApplication3.getMetadataManager(BIApplication3.java:395)
     at mypackage2.BIApplication3.openView(BIApplication3.java:659)
     at mypackage2.BIApplication3.jbInit(BIApplication3.java:302)
     at mypackage2.BIApplication3.<init>(BIApplication3.java:184)
     at mypackage2.BIApplication3.main(BIApplication3.java:1066)


  • 1. Re: BIB-14122, ORA-17002 errors when trying to run deployed Java application
    152598 Newbie
    Currently Being Moderated
    Have you tried simply telneting or pinging the server from the remote location?
    Thanks
  • 2. Re: BIB-14122, ORA-17002 errors when trying to run deployed Java application
    420471 Newbie
    Currently Being Moderated
    That was it. I had to change my connections to use IP addresses instead of DNS names. Things are now working.
  • 3. Re: BIB-14122, ORA-17002 errors when trying to run deployed Java application
    414172 Newbie
    Currently Being Moderated
    Try to confirm the 2 Connection Authentication are correct:
    OLAP Data Source Connection & Catalog Connection. Please make sure you have made these 2 connection login id correct: use ip instead of hostname.
  • 4. Re: BIB-14122, ORA-17002 errors when trying to run deployed Java application
    691397 Newbie
    Currently Being Moderated
    We are having the same problems here at work, and
    problem is intermittent.

    The network guys think it may be related to
    TCP-IP keep alives being required on the
    JDBC connection (which uses TCP-IP
    underneath) , but not passing those keep
    alives through our firewall. So the connection
    is breaking.

    That is the theory ... at least ...

    Also, problem might be related to the initial
    query: if it is a simple query like:
    Select 1 from DUAL
    that executes quickly, so no problem is seen.
    But a query which takes a long time before
    the data starts flowing like:
    select * from YOURTABLE
    might be more problamatic ...

    My 2 cents...

    dbednar
  • 5. Re: BIB-14122, ORA-17002 errors when trying to run deployed Java application
    750004 Newbie
    Currently Being Moderated
    //**********************Error I'm getting**********************

    17002java.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.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3668)
    at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:353)
    at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:371)
    at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:551)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:351)
    at java.sql.DriverManager.getConnection(DriverManager.java:525)
    at java.sql.DriverManager.getConnection(DriverManager.java:171)
    at org.apache.jsp.WEB_002dINF.jsp.index_jsp._jspService(index_jsp.java:76)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
    at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
    at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
    at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
    at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:167)
    at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:239)
    at org.springframework.web.servlet.DispatcherServlet.render(DispatcherServlet.java:1158)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:808)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:476)
    at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:431)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:390)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    at java.lang.Thread.run(Thread.java:595)
    Error Is




    Io exception: The Network Adapter could not establish the connection





    ///***************Code **********************

    <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

    <%@page import="java.sql.SQLException"%><html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
    <title>Insert title here</title>
    </head>
    <body>
    <%="hii" %>
    <%@page import="java.sql.Connection,java.sql.DriverManager,java.sql.ResultSet,java.sql.Statement " %>


    <%
    try{
    String driver = "oracle.jdbc.driver.OracleDriver";
    Class.forName(driver);
    Connection con = DriverManager.getConnection("jdbc:oracle:thin:@172.16.119.72:1521:new","system","Iwasoptra10*");
    Statement st = con.createStatement();
    st.executeUpdate("insert into forums values(7,'oye','Lptiiptn');");
    st.close();
    con.close();
    }
    catch(SQLException e){
         e.printStackTrace();
         System.out.print("Error Is\n\n\n\n\n"+e.getMessage()+"\n\n\n\n\n"+e.getErrorCode());}
    %>

    //************************************* Additional Info **************************

    i gave following commands in sql and out puts are...

    1) SQL> select instance_name from v$instance;

    INSTANCE_NAME
    ----------------
    new


    2) SQL> SELECT UTL_INADDR.get_host_address from dual;

    GET_HOST_ADDRESS
    ---------------------------------------------------
    172.16.119.72


    I even tried with server address localhost & 127.0.0.1 but it did not solve the purpose. Please help...please...
  • 6. Re: BIB-14122, ORA-17002 errors when trying to run deployed Java application
    750004 Newbie
    Currently Being Moderated
    //***************************Problem solved*****************

    1) goto control panel --> Administrative Tools --> services --> "OracleOraDB....Listner" and enable this listner process.... Hirray it's working...