13 Replies Latest reply: Jul 26, 2012 3:02 PM by Hussein Sawwan-Oracle RSS

    Login page not displaying after atg 6 patch

    689285
      Hi,


      After Applying ATG 6 patch, log in page is not displaying, when ever i am trying to access i am getting HTTP 500 internal Server error,

      Thanks
        • 1. Re: Login page not displaying after atg 6 patch
          Hussein Sawwan-Oracle
          Hi,

          Did you apply the patch successfully?

          Please check Apache log files for more details about the error.

          Regards,
          Hussein
          • 2. Re: Login page not displaying after atg 6 patch
            689285
            Good Morning Sawwan,

            Yes i applied patch successfully without any issues,


            Here is error log file
            -------------------------
            [Wed Apr  8 15:37:22 2009] [warn] pid file /u01/oracle/ingora/iAS/Apache/Apache/logs/httpd_pls.pid overwritten -- Unclean shutdown of previous Apache run?
            [Wed Apr  8 15:37:22 2009] [notice] FastCGI: process manager initialized (pid 11722)
            [Wed Apr  8 15:37:23 2009] [notice] Oracle HTTP Server Powered by Apache/1.3.19 configured -- resuming normal operations
            [Wed Apr  8 16:26:17 2009] [notice] caught SIGTERM, shutting down
            [Wed Apr  8 16:31:00 2009] [notice] FastCGI: process manager initialized (pid 17140)
            [Wed Apr  8 16:31:07 2009] [notice] Oracle HTTP Server Powered by Apache/1.3.19 configured -- resuming normal operations
            [appling@peabody logs]$
            -------------------------------------

            here is access log file
            ---------------------------------

            192.168.149.1 - - [08/Apr/2009:16:03:31 -0400] "GET /OA_HTML/AppsLocalLogin.jsp?requestUrl=APPSHOMEPAGE&cancelUrl=http%3A%2F%2Fpeabody.ing.com%3A8001%2Foa_servlets%2Foracle.a
            pps.fnd.sso.AppsLogin&s2=E5ECC8A5BA8A3776F2E95E30898A6F7A37191C11501E8A0FE47EAE61A9D5CAC7 HTTP/1.1" 200 7220
            192.168.149.1 - - [08/Apr/2009:16:03:32 -0400] "GET /OA_HTML/cabo/styles/cache/oracle-desktop-2_2_24_2-en-ie-windows.css HTTP/1.1" 200 21940
            192.168.149.1 - - [08/Apr/2009:16:03:32 -0400] "GET /OA_HTML/cabo/jsLibs/Common2_2_24_2.js HTTP/1.1" 200 90253
            192.168.149.1 - - [08/Apr/2009:16:03:32 -0400] "GET /OA_HTML/cabo/images/t.htm HTTP/1.1" 200 28
            192.168.149.1 - - [08/Apr/2009:16:03:32 -0400] "GET /OA_HTML/cabo/images/t.gif HTTP/1.1" 200 85
            192.168.149.1 - - [08/Apr/2009:16:03:32 -0400] "GET /OA_MEDIA/FNDSSCORP.gif HTTP/1.1" 200 1435
            192.168.149.1 - - [08/Apr/2009:16:03:32 -0400] "GET /OA_MEDIA/fndpbs.gif HTTP/1.1" 200 211
            192.168.149.1 - - [08/Apr/2009:16:03:32 -0400] "GET /OA_HTML/cabo/images/cache/cghes.gif HTTP/1.1" 200 136
            192.168.149.1 - - [08/Apr/2009:16:03:32 -0400] "GET /OA_HTML/cabo/images/cache/cghec.gif HTTP/1.1" 200 119
            192.168.149.1 - - [08/Apr/2009:16:03:32 -0400] "GET /OA_HTML/cabo/images/cache/cghee.gif HTTP/1.1" 200 102
            192.168.149.1 - - [08/Apr/2009:16:03:32 -0400] "GET /OA_HTML/cabo/images/cache/cmbts.gif HTTP/1.1" 200 154
            192.168.149.1 - - [08/Apr/2009:16:03:32 -0400] "GET /OA_HTML/cabo/images/warnl.gif HTTP/1.1" 200 977
            192.168.149.1 - - [08/Apr/2009:16:03:39 -0400] "GET /servlets/weboam/oam/oamLogin HTTP/1.1" 302 549
            192.168.149.1 - - [08/Apr/2009:16:03:44 -0400] "GET /servlets/weboam/redirectURL$url=http_3A$|$|peabody.ing.com_3A8001$|oa*_servlets$|oracle.apps.fnd.sso.AppsLogin_3FrequestU
            rl$=$|oa*_servlets$|weboam$|oam$|oamLogin_26cancelUrl$=http_3A$|$|peabody.ing.com_3A8001$|oa*_servlets$|oracle.apps.fnd.sso.AppsLogin$forward=oam$|oamLogin?JServSessionIdroot
            peabody=b3nhc9ei91.q6jvmAXysgTDpArMmkOImQXHcBSUahmKah0- HTTP/1.1" 302 395
            192.168.149.1 - - [08/Apr/2009:16:04:20 -0400] "GET /servlets/weboam/oam/oamLogin HTTP/1.1" 302 475
            192.168.149.1 - - [08/Apr/2009:16:04:32 -0400] "GET /servlets/weboam/redirectURL$url=http_3A$|$|peabody.ing.com_3A8001$|oa*_servlets$|oracle.apps.fnd.sso.AppsLogin_3FrequestU
            rl$=$|oa*_servlets$|weboam$|oam$|oamLogin_26cancelUrl$=http_3A$|$|peabody.ing.com_3A8001$|oa*_servlets$|oracle.apps.fnd.sso.AppsLogin$forward=oam$|oamLogin HTTP/1.1" 302 395
            192.168.149.1 - - [08/Apr/2009:16:12:34 -0400] "GET /servlets/weboam/oam/oamLogin HTTP/1.1" 302 475
            192.168.149.1 - - [08/Apr/2009:16:12:45 -0400] "GET /servlets/weboam/redirectURL$url=http_3A$|$|peabody.ing.com_3A8001$|oa*_servlets$|oracle.apps.fnd.sso.AppsLogin_3FrequestU
            rl$=$|oa*_servlets$|weboam$|oam$|oamLogin_26cancelUrl$=http_3A$|$|peabody.ing.com_3A8001$|oa*_servlets$|oracle.apps.fnd.sso.AppsLogin$forward=oam$|oamLogin HTTP/1.1" 302 395
            192.168.149.1 - - [08/Apr/2009:16:22:33 -0400] "GET /OA_HTML/AppsLocalLogin.jsp?requestUrl=APPSHOMEPAGE&cancelUrl=http%3A%2F%2Fpeabody.ing.com%3A8001%2Foa_servlets%2Foracle.a
            pps.fnd.sso.AppsLogin&s2=E5ECC8A5BA8A3776F2E95E30898A6F7A37191C11501E8A0FE47EAE61A9D5CAC7 HTTP/1.1" 200 7226
            192.168.149.1 - - [08/Apr/2009:16:22:33 -0400] "GET /OA_HTML/cabo/styles/cache/oracle-desktop-2_2_24_2-en-ie-windows.css HTTP/1.1" 304 -
            192.168.149.1 - - [08/Apr/2009:16:22:33 -0400] "GET /OA_HTML/cabo/jsLibs/Common2_2_24_2.js HTTP/1.1" 304 -
            192.168.149.1 - - [08/Apr/2009:16:22:33 -0400] "GET /OA_HTML/cabo/images/t.gif HTTP/1.1" 304 -
            192.168.149.1 - - [08/Apr/2009:16:22:33 -0400] "GET /OA_MEDIA/FNDSSCORP.gif HTTP/1.1" 304 -
            192.168.149.1 - - [08/Apr/2009:16:22:33 -0400] "GET /OA_MEDIA/fndpbs.gif HTTP/1.1" 304 -
            192.168.149.1 - - [08/Apr/2009:16:22:33 -0400] "GET /OA_HTML/cabo/images/cache/cghes.gif HTTP/1.1" 304 -
            192.168.149.1 - - [08/Apr/2009:16:22:33 -0400] "GET /OA_HTML/cabo/images/cache/cghec.gif HTTP/1.1" 304 -
            192.168.149.1 - - [08/Apr/2009:16:22:33 -0400] "GET /OA_HTML/cabo/images/cache/cghee.gif HTTP/1.1" 304 -
            192.168.149.1 - - [08/Apr/2009:16:22:33 -0400] "GET /OA_HTML/cabo/images/cache/cmbts.gif HTTP/1.1" 304 -
            192.168.149.1 - - [08/Apr/2009:16:22:33 -0400] "GET /OA_HTML/cabo/images/warnl.gif HTTP/1.1" 304 -
            192.168.149.1 - - [08/Apr/2009:16:22:33 -0400] "GET /OA_HTML/cabo/images/t.htm HTTP/1.1" 304 -
            192.168.149.1 - - [08/Apr/2009:16:22:52 -0400] "GET /OA_HTML/AppsLocalLogin.jsp?requestUrl=APPSHOMEPAGE&cancelUrl=http%3A%2F%2Fpeabody.ingram.com%3A8001%2Foa_servlets%2Foracle.a
            pps.fnd.sso.AppsLogin&s2=E5ECC8A5BA8A3776F2E95E30898A6F7A37191C11501E8A0FE47EAE61A9D5CAC7 HTTP/1.1" 200 7220
            192.168.149.1 - - [08/Apr/2009:16:22:52 -0400] "GET /OA_HTML/cabo/styles/cache/oracle-desktop-2_2_24_2-en-ie-windows.css HTTP/1.1" 304 -
            192.168.149.1 - - [08/Apr/2009:16:22:52 -0400] "GET /OA_HTML/cabo/jsLibs/Common2_2_24_2.js HTTP/1.1" 304 -
            192.168.149.1 - - [08/Apr/2009:16:22:52 -0400] "GET /OA_HTML/cabo/images/t.gif HTTP/1.1" 304 -
            192.168.149.1 - - [08/Apr/2009:16:22:52 -0400] "GET /OA_HTML/cabo/images/t.htm HTTP/1.1" 304 -
            192.168.149.1 - - [08/Apr/2009:16:22:52 -0400] "GET /OA_MEDIA/FNDSSCORP.gif HTTP/1.1" 304 -
            192.168.149.1 - - [08/Apr/2009:16:22:52 -0400] "GET /OA_HTML/cabo/images/cache/cghes.gif HTTP/1.1" 304 -
            192.168.149.1 - - [08/Apr/2009:16:22:52 -0400] "GET /OA_HTML/cabo/images/cache/cghec.gif HTTP/1.1" 304 -
            192.168.149.1 - - [08/Apr/2009:16:22:52 -0400] "GET /OA_MEDIA/fndpbs.gif HTTP/1.1" 304 -
            192.168.149.1 - - [08/Apr/2009:16:22:52 -0400] "GET /OA_HTML/cabo/images/cache/cghee.gif HTTP/1.1" 304 -
            192.168.149.1 - - [08/Apr/2009:16:22:52 -0400] "GET /OA_HTML/cabo/images/cache/cmbts.gif HTTP/1.1" 304 -
            192.168.149.1 - - [08/Apr/2009:16:22:52 -0400] "GET /OA_HTML/cabo/images/warnl.gif HTTP/1.1" 304 -
            peabody.ing.com - - [08/Apr/2009:16:29:20 -0400] "GET /oprocmgr-service?cmd=Register&index=0&modName=JServ&grpName=XmlSvcsGrp&port=19010 HTTP/1.1" 200 15
            peabody.ing.com - - [08/Apr/2009:16:29:42 -0400] "GET /oprocmgr-service?cmd=Register&index=0&modName=JServ&grpName=DiscoGroup&port=17010 HTTP/1.1" 200 15
            peabody.ing.com - - [08/Apr/2009:16:29:47 -0400] "GET /oprocmgr-service?cmd=Register&index=0&modName=JServ&grpName=OACoreGroup&port=16010 HTTP/1.1" 200 15
            192.168.149.1 - - [08/Apr/2009:16:36:16 -0400] "GET /OA_HTML/AppsLocalLogin.jsp?requestUrl=APPSHOMEPAGE&cancelUrl=http%3A%2F%2Fpeabody.ing.com%3A8001%2Foa_servlets%2Foracle.a
            pps.fnd.sso.AppsLogin&s2=E5ECC8A5BA8A3776F2E95E30898A6F7A37191C11501E8A0FE47EAE61A9D5CAC7 HTTP/1.1" 200 6068
            192.168.149.1 - - [08/Apr/2009:16:38:56 -0400] "POST /OA_HTML/fndvald.jsp HTTP/1.1" 302 444
            192.168.149.1 - - [08/Apr/2009:16:40:14 -0400] "GET /OA_HTML/AppsLocalLogin.jsp?requestUrl=APPSHOMEPAGE&cancelUrl=http%3A%2F%2Fpeabody.ingram.com%3A8001%2Foa_servlets%2Foracle.a
            pps.fnd.sso.AppsLogin&s2=E5ECC8A5BA8A3776F2E95E30898A6F7A37191C11501E8A0FE47EAE61A9D5CAC7 HTTP/1.1" 200 6068
            192.168.149.1 - - [08/Apr/2009:16:41:26 -0400] "POST /OA_HTML/fndvald.jsp HTTP/1.1" 302 444
            192.168.149.1 - - [08/Apr/2009:16:41:30 -0400] "GET /OA_HTML/fndvald.jsp HTTP/1.1" 200 190
            192.168.149.1 - - [08/Apr/2009:16:53:40 -0400] "GET /OA_HTML/fndvald.jsp HTTP/1.1" 200 190
            • 3. Re: Login page not displaying after atg 6 patch
              Hussein Sawwan-Oracle
              Hi,
              pid file /u01/oracle/ingora/iAS/Apache/Apache/logs/httpd_pls.pid overwritten -- Unclean shutdown of previous Apache run
              Please do the following:

              - Stop Apache
              - From the OS, issue "ps -ef | grep -i apache"
              - Kill all Apache process manually
              - Start Apache again
              - Check the login again

              Regards,
              Hussein
              • 4. Re: Login page not displaying after atg 6 patch
                689285
                Sawwan,

                I am accessing from windows VISTA, My hostname is :peabody.ing.com

                when ever i am trying to access http://peabody.ing.com:8001,http://peabody.ing.com:8001/oa_servlets/AppsLogin in IE its not displaying anything ,
                but when ever i use ip addess its displaying login screen http://192.168.149.131:8001/ once i enter user name and password its displaying "page cannot be found"

                i am getting url http://192.168.149.131:8001/OA_HTML/fndvald.jsp with error


                ------------------------------
                After restarting Apache here is access log file

                ----------------------------------------------------------
                peabody.ing.com - - [08/Apr/2009:17:26:28 -0400] "GET /oprocmgr-service?cmd=Register&index=0&modName=JServ&grpName=XmlSvcsGrp&port=19010 HTTP/1.1" 200 15 0
                peabody.ing.com - - [08/Apr/2009:17:26:34 -0400] "GET /oprocmgr-service?cmd=Register&index=0&modName=JServ&grpName=DiscoGroup&port=17010 HTTP/1.1" 200 15 0
                peabody.ing.com - - [08/Apr/2009:17:26:35 -0400] "GET /oprocmgr-service?cmd=Register&index=0&modName=JServ&grpName=OACoreGroup&port=16010 HTTP/1.1" 200 15 0
                peabody.ing.com - - [08/Apr/2009:17:31:32 -0400] "GET /oprocmgr-service?cmd=Register&index=0&modName=JServ&grpName=XmlSvcsGrp&port=19010 HTTP/1.1" 200 15 0
                peabody.ing.com - - [08/Apr/2009:17:31:39 -0400] "GET /oprocmgr-service?cmd=Register&index=0&modName=JServ&grpName=DiscoGroup&port=17010 HTTP/1.1" 200 15 0
                peabody.ing.com - - [08/Apr/2009:17:31:39 -0400] "GET /oprocmgr-service?cmd=Register&index=0&modName=JServ&grpName=OACoreGroup&port=16010 HTTP/1.1" 200 15 0
                peabody.ing.com - - [08/Apr/2009:18:04:55 -0400] "GET /oprocmgr-service?cmd=Register&index=0&modName=JServ&grpName=DiscoGroup&port=17010 HTTP/1.1" 200 15 0
                peabody.ing.com - - [08/Apr/2009:18:04:59 -0400] "GET /oprocmgr-service?cmd=Register&index=0&modName=JServ&grpName=XmlSvcsGrp&port=19010 HTTP/1.1" 200 15 0
                peabody.ing.com - - [08/Apr/2009:18:05:02 -0400] "GET /oprocmgr-service?cmd=Register&index=0&modName=JServ&grpName=OACoreGroup&port=16010 HTTP/1.1" 200 15 0
                192.168.149.1 - - [08/Apr/2009:18:09:04 -0400] "GET /OA_HTML/AppsLocalLogin.jsp?requestUrl=APPSHOMEPAGE&cancelUrl=http%3A%2F%2Fpeabody.ing.com%3A8001%2Foa_servlets%2Foracle.a
                pps.fnd.sso.AppsLogin&s2=E5ECC8A5BA8A3776F2E95E30898A6F7A37191C11501E8A0FE47EAE61A9D5CAC7 HTTP/1.1" 200 6068 51
                192.168.149.1 - - [08/Apr/2009:18:09:31 -0400] "POST /OA_HTML/fndvald.jsp HTTP/1.1" 302 255 15
                192.168.149.1 - - [08/Apr/2009:18:10:29 -0400] "GET /OA_HTML/AppsLocalLogin.jsp?requestUrl=APPSHOMEPAGE&cancelUrl=http%3A%2F%2Fpeabody.ing.com%3A8001%2Foa_servlets%2Foracle.a
                pps.fnd.sso.AppsLogin&s2=E5ECC8A5BA8A3776F2E95E30898A6F7A37191C11501E8A0FE47EAE61A9D5CAC7 HTTP/1.1" 200 6074 1

                -----------------------------------------------

                Here are error log file

                ----------------------------------------
                [Wed Apr  8 18:05:12 2009] [notice] FastCGI: process manager initialized (pid 4061)
                [Wed Apr  8 18:05:14 2009] [notice] Oracle HTTP Server Powered by Apache/1.3.19 configured -- resuming normal operations

                Edited by: HumanDBA on Apr 9, 2009 1:35 AM
                • 5. Re: Login page not displaying after atg 6 patch
                  Hussein Sawwan-Oracle
                  Hi,

                  Are you able to ping the IP Address and the hostname.domainame from your machine?

                  Do you have a proper entry in the hosts file?

                  Can you access the application from other machines?

                  Regards,
                  Hussein
                  • 6. Re: Login page not displaying after atg 6 patch
                    689285
                    Sawwan,

                    I am able to ping using ip address..using hostname i am not able to ping .
                    C:\Users\admin>ping 192.168.149.131

                    Pinging 192.168.149.131 with 32 bytes of data:
                    Reply from 192.168.149.131: bytes=32 time=3ms TTL=64
                    Reply from 192.168.149.131: bytes=32 time<1ms TTL=64
                    Reply from 192.168.149.131: bytes=32 time<1ms TTL=64
                    Reply from 192.168.149.131: bytes=32 time<1ms TTL=64

                    Ping statistics for 192.168.149.131:
                    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
                    Approximate round trip times in milli-seconds:
                    Minimum = 0ms, Maximum = 3ms, Average = 0ms


                    C:\Users\admin>ping peabody.ing.com
                    Ping request could not find host peabody.ing.com. Please check the name and t
                    ry again.

                    C:\Users\admin>ping peabody.ing.com
                    Ping request could not find host peabody.ing.com. Please check the name and t
                    ry again.


                    ============================================

                    here is hostname entries
                    -------------------------------

                    [appling @peabody ]$ hostname
                    peabody.ing.com
                    [appling@peabody ]$ cat /etc/hosts
                    # Do not remove the following line, or various programs
                    # that require network functionality will fail.
                    127.0.0.1 localhost.localdomain localhost
                    192.168.149.131 peabody.ing.com peabody

                    ------------------------------------------------------------------------------------------------

                    Hence this is test instance, so i am only have accessing this instance.
                    • 7. Re: Login page not displaying after atg 6 patch
                      Hussein Sawwan-Oracle
                      Hi,

                      Please check the hosts file on your client machine (under "%Windows%\system32\drivers\etc" directory). Make sure you have the following entry:

                      192.168.149.131 peabody.ing.com peabody

                      Once you do the necessary change, try to ping the server from the client machine.

                      Did you try from a different machine?

                      Regards,
                      Hussein
                      • 8. Re: Login page not displaying after atg 6 patch
                        689285
                        Sawwan,


                        Its working fine now, Thanks for your help,

                        i have one more issue now, i am starting new thread for that.
                        • 9. Re: Login page not displaying after atg 6 patch
                          Hussein Sawwan-Oracle
                          Hi,

                          You're welcome!

                          Regards,
                          Hussein
                          • 10. Excel not displaying any data.
                            951995
                            Hi Sawan,


                            We are currently working on 11.5.10.2 and moving from Desktop ADI to Web ADI. At the time of publishing report in Web ADI the excel is empty.

                            AFter successfully running the WEB Adi reportset for Consolidate Balncesheet ( for a period ex: APR-2012), there were 3 reports that were publlished as a set. Then I went to Repository Management and went to the folder and subfolder where I saved all the above 3 reports. When I click on view on one of the reports, the excel spreadsheet opens and try to load something for a while but finally ends up loading nothing.

                            I am unable to figure out what went wrong. Do you have any idea.

                            The profile option 'BNE_UIX_PHYSICAL_DIRECTORY' -- showing as UnDeg,UnDef

                            Do I need to specify any Unix Dir?

                            Thanks
                            Uday
                            • 11. Re: Excel not displaying any data.
                              Hussein Sawwan-Oracle
                              948992 wrote:
                              Hi Sawan,


                              We are currently working on 11.5.10.2 and moving from Desktop ADI to Web ADI. At the time of publishing report in Web ADI the excel is empty.

                              AFter successfully running the WEB Adi reportset for Consolidate Balncesheet ( for a period ex: APR-2012), there were 3 reports that were publlished as a set. Then I went to Repository Management and went to the folder and subfolder where I saved all the above 3 reports. When I click on view on one of the reports, the excel spreadsheet opens and try to load something for a while but finally ends up loading nothing.

                              I am unable to figure out what went wrong. Do you have any idea.

                              The profile option 'BNE_UIX_PHYSICAL_DIRECTORY' -- showing as UnDeg,UnDef

                              Do I need to specify any Unix Dir?

                              Thanks
                              Uday
                              Yes -- BNE_UIX_PHYSICAL_DIRECTORY is not configured Error in Release 11i and R12 [ID 1312156.1]

                              Thanks,
                              Hussein
                              • 12. Re: Excel not displaying any data.
                                951995
                                Hi Sawan,

                                What could be the value for

                                BNE_UIX_PHYSICAL_DIRECTORY

                                or from where can I get the value for this.

                                Thanks
                                Uday
                                • 13. Re: Excel not displaying any data.
                                  Hussein Sawwan-Oracle
                                  948992 wrote:
                                  Hi Sawan,

                                  What could be the value for

                                  BNE_UIX_PHYSICAL_DIRECTORY

                                  or from where can I get the value for this.

                                  Thanks
                                  Uday
                                  Please check the doc referenced in my previous reply.

                                  Thanks,
                                  Hussein