1 2 Previous Next 15 Replies Latest reply on Sep 10, 2009 4:01 AM by 721738

    Login Page Problem

    user3308982
      Hi


      Environmant:Oracle11i (11.5.10.2) ,Windows 2000 Server (service Pack 4).
      This Newly Cloned instance.(we don't have this problem on production)

      after entering the username and password we are getting following error message. after refreshing the page then it is displaying application PHP some time even we need to bounce Apache service.we are getting this problem frequently 2 0r 3 time daily.

      Error Page


      You have encountered an unexpected error. Please contact the System Administrator for assistance.
      Click here for exception details.


      oracle.apps.fnd.framework.OAException: Application: FND, Message Name: POOL-NO AVAILABLE OBJECTS. Tokens: POOLDATA = [oracle.apps.fnd.security.DBConnObjPool@7b0f4d extends [oracle.apps.fnd.security.DBConnObjPool@7b0f4d $Revision: 115.33 $ {false,true,1239002106438,0,1239002106438,0,true,60,1,1,7,500,0,5,50,8000,3,5,2,0,oracle.apps.fnd.common.Statistics@12e317}] $Revision: 115.31 $ {true,true,false,-1,-1,2}];
           at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1223)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1986)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:508)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:429)
           at oa_html._OA._jspService(_OA.java:85)
           at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
           at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
           at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
           at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
           at oracle.jsp.JspServlet.service(JspServlet.java:156)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
           at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
           at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
           at oa_html._OA._jspService(_OA.java:95)
           at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
           at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
           at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
           at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
           at oracle.jsp.JspServlet.service(JspServlet.java:156)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
           at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
           at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
           at oa_html._OA._jspService(_OA.java:95)
           at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
           at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
           at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
           at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
           at oracle.jsp.JspServlet.service(JspServlet.java:156)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
           at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
           at org.apache.jserv.JServConnection.run(JServConnection.java:294)
           at java.lang.Thread.run(Thread.java:479)
      ## Detail 0 ##
      oracle.apps.fnd.framework.OAException: Application: FND, Message Name: POOL-NO AVAILABLE OBJECTS. Tokens: POOLDATA = [oracle.apps.fnd.security.DBConnObjPool@7b0f4d extends [oracle.apps.fnd.security.DBConnObjPool@7b0f4d $Revision: 115.33 $ {false,true,1239002106438,0,1239002106438,0,true,60,1,1,7,500,0,5,50,8000,3,5,2,0,oracle.apps.fnd.common.Statistics@12e317}] $Revision: 115.31 $ {true,true,false,-1,-1,2}];
           at oracle.apps.fnd.framework.server.OAExceptionUtils.processAOLJErrorStack(OAExceptionUtils.java:969)
           at oracle.apps.fnd.framework.server.OAConnectionPoolManagerImpl.getConnection(OAConnectionPoolManagerImpl.java:208)
           at oracle.jbo.server.DBTransactionImpl.establishNewConnection(DBTransactionImpl.java:741)
           at oracle.jbo.server.DBTransactionImpl.initTransaction(DBTransactionImpl.java:965)
           at oracle.jbo.server.DBTransactionImpl.reconnect(DBTransactionImpl.java:4533)
           at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.reconnectStaticAKApplicationModule(OAJSPApplicationRegistry.java:546)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:961)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:508)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:429)
           at oa_html._OA._jspService(_OA.java:85)
           at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
           at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
           at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
           at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
           at oracle.jsp.JspServlet.service(JspServlet.java:156)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
           at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
           at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
           at oa_html._OA._jspService(_OA.java:95)
           at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
           at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
           at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
           at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
           at oracle.jsp.JspServlet.service(JspServlet.java:156)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
           at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
           at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
           at oa_html._OA._jspService(_OA.java:95)
           at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
           at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
           at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
           at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
           at oracle.jsp.JspServlet.service(JspServlet.java:156)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
           at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
           at org.apache.jserv.JServConnection.run(JServConnection.java:294)
           at java.lang.Thread.run(Thread.java:479)
      oracle.apps.fnd.framework.OAException: Application: FND, Message Name: POOL-NO AVAILABLE OBJECTS. Tokens: POOLDATA = [oracle.apps.fnd.security.DBConnObjPool@7b0f4d extends [oracle.apps.fnd.security.DBConnObjPool@7b0f4d $Revision: 115.33 $ {false,true,1239002106438,0,1239002106438,0,true,60,1,1,7,500,0,5,50,8000,3,5,2,0,oracle.apps.fnd.common.Statistics@12e317}] $Revision: 115.31 $ {true,true,false,-1,-1,2}];
           at oracle.apps.fnd.framework.server.OAExceptionUtils.processAOLJErrorStack(OAExceptionUtils.java:969)
           at oracle.apps.fnd.framework.server.OAConnectionPoolManagerImpl.getConnection(OAConnectionPoolManagerImpl.java:208)
           at oracle.jbo.server.DBTransactionImpl.establishNewConnection(DBTransactionImpl.java:741)
           at oracle.jbo.server.DBTransactionImpl.initTransaction(DBTransactionImpl.java:965)
           at oracle.jbo.server.DBTransactionImpl.reconnect(DBTransactionImpl.java:4533)
           at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.reconnectStaticAKApplicationModule(OAJSPApplicationRegistry.java:546)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:961)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:508)
           at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:429)
           at oa_html._OA._jspService(_OA.java:85)
           at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
           at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
           at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
           at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
           at oracle.jsp.JspServlet.service(JspServlet.java:156)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
           at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
           at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
           at oa_html._OA._jspService(_OA.java:95)
           at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
           at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
           at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
           at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
           at oracle.jsp.JspServlet.service(JspServlet.java:156)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
           at oracle.jsp.provider.Jsp20RequestDispatcher.forward(Jsp20RequestDispatcher.java:162)
           at oracle.jsp.runtime.OraclePageContext.forward(OraclePageContext.java:187)
           at oa_html._OA._jspService(_OA.java:95)
           at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
           at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
           at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
           at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
           at oracle.jsp.JspServlet.service(JspServlet.java:156)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
           at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
           at org.apache.jserv.JServConnection.run(JServConnection.java:294)
           at java.lang.Thread.run(Thread.java:479)


      Thanks

      With Regards
      Umair
        • 1. Re: Login Page Problem
          Hussein Sawwan-Oracle
          Hi,

          Did AutoConfig complete successfully?

          Any errors in the alert_<SID>.log file?

          Did you try to clear the cache and bounce Apache?

          Regards,
          Hussein
          • 2. Re: Login Page Problem
            user3308982
            Hi,

            Did AutoConfig complete successfully?

            Yes,it was completed successfully

            Any errors in the alert_<SID>.log file?

            No errors in alert log file

            Did you try to clear the cache and bounce Apache?

            yes , i tested by clearing cache also

            Regards,
            umair
            • 3. Re: Login Page Problem
              Hussein Sawwan-Oracle
              Umair,

              I would suggest you enable debug on Apache, it should collect more details about the error.

              Note: 249669.1 - How To Collect Apache and Jserv Debugging Details For Applications 11i
              https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=249669.1

              Regards,
              Hussein
              • 4. Re: Login Page Problem
                user3308982
                Hi Hussein

                I would suggest you enable debug on Apache, it should collect more details about the error.

                Note: 249669.1 - How To Collect Apache and Jserv Debugging Details For Applications 11i
                https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=249669.1


                I verified above Note,But in our application server jserv.conf and jserv.properties are empty files

                can i add debug options to these files or not?.



                # $Header: empty_stub.txt 115.0 2002/05/09 01:38:04 pkm ship $
                #
                # ###############################################################
                #
                # This file is automatically generated by AutoConfig. It will be read and
                # overwritten. If you were instructed to edit this file, or if you are not
                # able to use the settings created by AutoConfig, refer to Metalink document
                # 165195.1 for assistance.
                #
                # ###############################################################

                #
                ######################################################################
                #
                # This is an empty file generated for a component not used
                # in this environment test_appsbkp
                #
                #######################################################################



                Regards,
                Umair
                • 5. Re: Login Page Problem
                  Hussein Sawwan-Oracle
                  Hi,
                  I verified above Note,But in our application server jserv.conf and jserv.properties are empty files
                  You should be able to find those two files on the web node, under $IAS_ORACLE_HOME/Apache/Jserv/etc directory.

                  Regards,
                  Hussein
                  • 6. Re: Login Page Problem
                    user3308982
                    Hi

                    i enabled debug options according that metalink note even though i didn't find any perticular in those log files



                    Thanks

                    with Regards

                    Umair
                    • 7. Re: Login Page Problem
                      Hussein Sawwan-Oracle
                      Hi,

                      If enabling debug does not help, then I would suggest you log a SR.

                      Regards,
                      Hussein
                      • 8. Re: Login Page Problem
                        user3308982
                        Hi Hussein



                        I am follwoing SR still issue not solved ,But From Our Orgnization side they are keeping pressure one me to resolve this issue Because they have been facing this issue for long time,frequently means every 2 or three hours we are getting this error.How can i handle this situation?

                        Note:every 2 or 3 hours i am bouncing apache service to logon application



                        Thanks

                        Regards

                        Umair
                        • 9. Re: Login Page Problem
                          Hussein Sawwan-Oracle
                          Umair,

                          What ATG RUP patchset you are on?

                          Note: 390864.1 - How to check which Techstack patchsets have been applied
                          https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=390864.1

                          Regards,
                          Hussein
                          • 10. Re: Login Page Problem
                            user3308982
                            Hi Sir



                            we are using ATG Rollup 5.


                            Thanks

                            Regrads,

                            Umair
                            • 11. Re: Login Page Problem
                              Srini Chavali-Oracle
                              This issue could possibly be caused by the first symptom/issue listed in MOS Doc 459353.1 (Known issues on Top of 11i.ATG_PF.H. delta.6 (RUP6) - 5903765) where jdbc settings were changed to lower case in RUP5, which causes an increased number of JDBC connections. There is a patch available (as mentioned in this doc).. Pl verify with Support to see if this could be a possible cause in your situation.

                              HTH
                              Srini
                              • 12. Re: Login Page Problem
                                Hussein Sawwan-Oracle
                                Umair,
                                we are using ATG Rollup 5.
                                Please try the suggested solutions in the following documents.

                                Note: 785826.1 - Cannot Login After Clone. Error: 'No data found for region (FND_AUTOFOOTER_REGION)'
                                https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=785826.1

                                Note: 418130.1 - Unable To Login After Clone
                                https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=418130.1

                                Note: 553937.1 - Getting Blank Page at Login After Applied Patch 11.5.10.5RUP
                                https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=553937.1

                                Regards,
                                Hussein
                                • 13. Re: Login Page Problem
                                  user3308982
                                  Hi Hussein,


                                  Please try the suggested solutions in the following documents.

                                  Note: 785826.1 - Cannot Login After Clone. Error: 'No data found for region (FND_AUTOFOOTER_REGION)'
                                  https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=785826.1


                                  i verfied above doc on our Database server having correct time But application and database server displaying time in different languages means application server displaying in arabic and database is displaying in english

                                  Note: 418130.1 - Unable To Login After Clone
                                  https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=418130.1

                                  i verfied above DOC also and subimitted concurrent request specified in above DOC,it is completed successfully.

                                  Note: 553937.1 - Getting Blank Page at Login After Applied Patch 11.5.10.5RUP
                                  https://metalink2.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=553937.1

                                  I verfied above doc but we are not facing blak page problem



                                  Thanks

                                  With Regards

                                  Umair
                                  • 14. Re: Login Page Problem
                                    Hussein Sawwan-Oracle
                                    Umair,
                                    i verfied above doc on our Database server having correct time But application and database server displaying time in different languages means application server displaying in arabic and database is displaying in english
                                    Not sure what do you mean by different languages, but I would suggest you have the same regional settings on both servers.
                                    i verfied above DOC also and subimitted concurrent request specified in above DOC,it is completed successfully.
                                    Let us see if you get any error after this program.
                                    I verfied above doc but we are not facing blak page problem
                                    If possible, apply the patch on your test instance, and see if it helps.

                                    Regards,
                                    Hussein
                                    1 2 Previous Next