12 Replies Latest reply on Aug 29, 2009 5:37 AM by Reetesh Sharma

    Error in Running a Page in Jdeveloper through VPN

    697969
      I am having an issue running a Hello World Page in JDeveloper9i through VPN. When I try to run a page, web browser is trying to open
      the page based on the Host Name or IP Address used to refer to Embedded OC4J.

      It would be really great if you could help me to resolve this issue.

      Thanks

      Edited by: user2014196 on May 18, 2009 6:40 PM

      Edited by: user2014196 on May 18, 2009 7:11 PM
        • 1. Re: Error in Running a Page in Jdeveloper through VPN
          Sumit Chandra Sharma
          What is the exact Error you are facing in your case?

          Just as a guideline first check whether the DB is accessible through VPN or not. One way would be to find the DB connections and test the connection. The other option is to check the Application login/password/responsibility key that you provided in Project->Runtime Connections. If that is correct too then go to Emebedded OC4J preferences and select the IP as the option.

          Regards
          • 2. Re: Error in Running a Page in Jdeveloper through VPN
            697969
            The exact error is I cannot view the HelloWorld Page.

            I can access the database through VPN. I checked the Application Login/pwd and Responsibility name and Key. Everything is correct.
            There are four options to select from embedded OC4J, I tried all the four options but the HelloWorld page is not displaying.

            I got this exception when i selected Default Local IP Address in Embedded OC4J.

            oracle.apps.fnd.framework.OAException: Application: FND, Message Name: SYSTEM-ERROR. Tokens: MESSAGE = Io exception: The Network Adapter could not establish the connection; (Could not lookup message because there is no database connection) at oracle.apps.fnd.framework.server.OAExceptionUtils.processAOLJErrorStack(OAExceptionUtils.java:988) at oracle.apps.fnd.framework.server.OAUtility.getWebAppsContext(OAUtility.java:352) at oracle.apps.fnd.framework.CreateIcxSession.getEncryptedSessId(CreateIcxSession.java:144) at oracle.apps.fnd.framework.CreateIcxSession.createSession(CreateIcxSession.java:80) at runregion.jspService(runregion.jsp:96) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803) at java.lang.Thread.run(Thread.java:534) ## Detail 0 ## oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLException: Io exception: The Network Adapter could not establish the connection; (Could not lookup message because there is no database connection) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:888) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:862) at oracle.apps.fnd.framework.server.OAExceptionUtils.processAOLJErrorStack(OAExceptionUtils.java:980) at oracle.apps.fnd.framework.server.OAUtility.getWebAppsContext(OAUtility.java:352) at oracle.apps.fnd.framework.CreateIcxSession.getEncryptedSessId(CreateIcxSession.java:144) at oracle.apps.fnd.framework.CreateIcxSession.createSession(CreateIcxSession.java:80) at runregion.jspService(runregion.jsp:96) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803) at java.lang.Thread.run(Thread.java:534) ## Detail 0 ## 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.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3675) at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:352) at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:365) at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:536) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:328) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:140) at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1194) at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1121) at oracle.apps.fnd.security.AppsConnectionManager.makeGwyuidConn(AppsConnectionManager.java:664) at oracle.apps.fnd.security.AppsConnectionManager.getGwyuidConn(AppsConnectionManager.java:736) at oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:575) at oracle.apps.fnd.security.DBConnObj.<init>(DBConnObj.java:240) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at oracle.apps.fnd.common.Pool.createObject(Pool.java:1187) at oracle.apps.fnd.common.Pool.borrowObject(Pool.java:946) at oracle.apps.fnd.security.DBConnObjPool.borrowObject(DBConnObjPool.java:703) at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:232) at oracle.apps.fnd.common.Context.borrowConnection(Context.java:1773) at oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2460) at oracle.apps.fnd.common.AppsContext.getPrivateConnection(AppsContext.java:2398) at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2257) at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2072) at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1976) at oracle.apps.fnd.profiles.Profiles.getConnection(Profiles.java:2494) at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1304) at oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:384) at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfileFromDB(ExtendedProfileStore.java:210) at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(ExtendedProfileStore.java:169) at oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(ExtendedProfileStore.java:148) at oracle.apps.fnd.common.logging.DebugEventManager.configureUsingDatabaseValues(DebugEventManager.java:1147) at oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:1008) at oracle.apps.fnd.common.logging.DebugEventManager.internalReinit(DebugEventManager.java:977) at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:944) at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:931) at oracle.apps.fnd.common.AppsLog.reInitialize(AppsLog.java:570) at oracle.apps.fnd.common.AppsContext.initLog(AppsContext.java:873) at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:858) at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:827) at oracle.apps.fnd.common.AppsContext.<init>(AppsContext.java:686) at oracle.apps.fnd.common.WebAppsContext.<init>(WebAppsContext.java:846) at oracle.apps.fnd.framework.server.OAUtility.getWebAppsContext(OAUtility.java:351) at oracle.apps.fnd.framework.CreateIcxSession.getEncryptedSessId(CreateIcxSession.java:144) at oracle.apps.fnd.framework.CreateIcxSession.createSession(CreateIcxSession.java:80) at runregion.jspService(runregion.jsp:96) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803) at java.lang.Thread.run(Thread.java:534) oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLException: Io exception: The Network Adapter could not establish the connection; (Could not lookup message because there is no database connection) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:888) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:862) at oracle.apps.fnd.framework.server.OAExceptionUtils.processAOLJErrorStack(OAExceptionUtils.java:980) at oracle.apps.fnd.framework.server.OAUtility.getWebAppsContext(OAUtility.java:352) at oracle.apps.fnd.framework.CreateIcxSession.getEncryptedSessId(CreateIcxSession.java:144) at oracle.apps.fnd.framework.CreateIcxSession.createSession(CreateIcxSession.java:80) at runregion.jspService(runregion.jsp:96) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803) at java.lang.Thread.run(Thread.java:534) ## Detail 0 ## 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.ttc7.TTC7Protocol.handleIOException(TTC7Protocol.java:3675) at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:352) at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:365) at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:536) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:328) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:140) at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1194) at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1121) at oracle.apps.fnd.security.AppsConnectionManager.makeGwyuidConn(AppsConnectionManager.java:664) at oracle.apps.fnd.security.AppsConnectionManager.getGwyuidConn(AppsConnectionManager.java:736) at oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:575) at oracle.apps.fnd.security.DBConnObj.<init>(DBConnObj.java:240) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:274) at oracle.apps.fnd.common.Pool.createObject(Pool.java:1187) at oracle.apps.fnd.common.Pool.borrowObject(Pool.java:946) at oracle.apps.fnd.security.DBConnObjPool.borrowObject(DBConnObjPool.java:703) at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:232) at oracle.apps.fnd.common.Context.borrowConnection(Context.java:1773) at oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2460) at oracle.apps.fnd.common.AppsContext.getPrivateConnection(AppsContext.java:2398) at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2257) at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2072) at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1976) at oracle.apps.fnd.profiles.Profiles.getConnection(Profiles.java:2494) at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1304) at oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:384) at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfileFromDB(ExtendedProfileStore.java:210) at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(ExtendedProfileStore.java:169) at oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(ExtendedProfileStore.java:148) at oracle.apps.fnd.common.logging.DebugEventManager.configureUsingDatabaseValues(DebugEventManager.java:1147) at oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:1008) at oracle.apps.fnd.common.logging.DebugEventManager.internalReinit(DebugEventManager.java:977) at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:944) at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:931) at oracle.apps.fnd.common.AppsLog.reInitialize(AppsLog.java:570) at oracle.apps.fnd.common.AppsContext.initLog(AppsContext.java:873) at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:858) at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:827) at oracle.apps.fnd.common.AppsContext.<init>(AppsContext.java:686) at oracle.apps.fnd.common.WebAppsContext.<init>(WebAppsContext.java:846) at oracle.apps.fnd.framework.server.OAUtility.getWebAppsContext(OAUtility.java:351) at oracle.apps.fnd.framework.CreateIcxSession.getEncryptedSessId(CreateIcxSession.java:144) at oracle.apps.fnd.framework.CreateIcxSession.createSession(CreateIcxSession.java:80) at runregion.jspService(runregion.jsp:96) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803) at java.lang.Thread.run(Thread.java:534)

            Is there any settings do I need to set when accessing Jdeveloper through VPN???
            • 3. Re: Error in Running a Page in Jdeveloper through VPN
              Sumit Chandra Sharma
              Your Jdeveloper is not able to access the instance. Check the Database connection details you provided is correct. Click on Test Connection to make sure its working.

              Regards
              Sumit
              • 4. Re: Error in Running a Page in Jdeveloper through VPN
                697969
                The database details i gave is correct and I tested the connection and it says success but i still cannot view the page.
                • 5. Re: Error in Running a Page in Jdeveloper through VPN
                  697969
                  Is there any steps need to be followed if the Jdeveloper is connected through VPN?

                  Edited by: user2014196 on May 22, 2009 11:32 AM
                  • 6. Re: Error in Running a Page in Jdeveloper through VPN
                    701414
                    Hi,

                    Try this option.

                    Goto Tools->Preferences->Embedded OC4J

                    and select the specify Host Name radio button and give the value as "localhost"

                    Thanks
                    sreenu
                    • 7. Re: Error in Running a Page in Jdeveloper through VPN
                      697969
                      It is still not working.
                      • 8. Re: Error in Running a Page in Jdeveloper through VPN
                        Sumit Chandra Sharma
                        Check the DBC file too. The problem is with database connectivity.
                        • 9. Re: Error in Running a Page in Jdeveloper through VPN
                          697969
                          The dbc file is good. Jdeveloper is working if I cannot my computer to the network directly through LAN.
                          • 10. Re: Error in Running a Page in Jdeveloper through VPN
                            user7909886
                            Hi, I have the same problem. Have you resolved ?

                            Thanks
                            Giuseppe
                            • 11. Re: Error in Running a Page in Jdeveloper through VPN
                              Braj Pratap
                              hi

                              try one more steps,just go to run option of Jdeveloper ->Terminate->embeddedOC4j ,and then try to run the page once again .

                              thanx
                              Pratap
                              • 12. Re: Error in Running a Page in Jdeveloper through VPN
                                Reetesh Sharma
                                Hi,

                                It is a known issue when you run JDeveloper on VPN.

                                When you login using VPN, every time it gives new IP address to your machine so after connecting to VPN, check your IP address and in preferences>embedded OC4J>specify host address, mention here your IP address, it should work.

                                Even if it persists then check Metalink for known issues of Jdev it will give you resolution for your problem.

                                Have a nice day.

                                Regards,
                                Reetesh Sharma