1 2 Previous Next 15 Replies Latest reply: Mar 7, 2013 12:53 PM by Hussein Sawwan-Oracle RSS

    R12.1.3 AppsLocal on OEL6

    995262
      Hi All,

      I’m trying to login after installing and upgrading to Oracle EBS R12.1.3 Vision, DB 11.2.0.2 instance on OEL6 3 x86_64bit platform on a laptop.

      Using Oracle VM VirtualBox version 4.2.4
      i3 and 6GB memory
      HDD: 750 GB

      Issue: Install and upgrade completed, but cannot login into application once the Application Home page comes up. No errors in the Apache logs and enabling debug does not seem to generate any issues.

      Fact:
      http://xxxxx:8002/OA_HTML/AppsLogin
      http://xxxxx:8002/OA_HTML/ServletPing
      http://xxxxx:8002/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE
      http://xxxxx:8002/OA_HTML/jsp/fnd/aoljtest.jsp
      http://xxxxx:8002/OA_MEDIA/FNDLOGOL.gif

      All these test work fine.... but I still cannot log into the application with sysadmin or with any other user. Tested the application via http://xxxxx:8002/OA_HTML/jsp/fnd/aoljtest.jsp
      and all the tests work fine including the user/password for sysadmin user, also changed the password using FNDCPASS, but no joy.

      Compiled jsp several times..

      Current Version of Java:
      sh -c "`awk -F= '$1 ~ /^JSERVJAVA.*$/ {print $2}' $ADMIN_SCRIPTS_HOME/java.sh` -version;"
      java version "1.6.0_38"
      Java(TM) SE Runtime Environment (build 1.6.0_38-b05)
      Java HotSpot(TM) Server VM (build 20.13-b02, mixed mode)

      Current OS version:
      uname -a
      Linux xxxxxx 2.6.39-300.17.3.el6uek.x86_64 #1 SMP Wed Dec 19 06:28:03 PST 2012 x86_64 x86_64 x86_64 GNU/Linux

      Report_Inventory does not show any errors either

      Does anyone have any ideas how I can resolve this issue?
      I can only suspect the OS is my issue, reference:
      Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64 [ID 761566.1]

      Regards
        • 1. Re: R12.1.3 AppsLocal on OEL6
          Hussein Sawwan-Oracle
          Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64 [ID 761566.1]
          Did you complete all the steps in this doc for OEL6/RHEL6?

          Can you find any errors in the database log file?

          What is the error you get when you try to login?

          Can you find any errors in the application.log file?

          Thanks,
          Hussein
          • 2. Re: R12.1.3 AppsLocal on OEL6
            995262
            Followed the doc 761566.1, although I have some versions higher, ie. last digit

            No errors in the alert log

            There is no error when login in, the page just does not login and the username/password just disappears

            Application log:
            html: LeakSetting:
            global:true,session:false,aggressive:false,stderr:false,appslog:false,corelog:false
            ignoring:null
            • 3. Re: R12.1.3 AppsLocal on OEL6
              Hussein Sawwan-Oracle
              Please see these docs.

              Blank Page Accessing R12 - Application.log shows "html: chain failed", "Unable to create user session" [ID 734692.1]
              R12: Users Are Unable to Log Into Applications [ID 1497554.1]
              How To Set A System Profile Value Without Logging In To The Applications [ID 364503.1]

              Thanks,
              Hussein
              • 4. Re: R12.1.3 AppsLocal on OEL6
                Srini Chavali-Oracle
                Pl check the database alert log for any errors

                HTH
                Srini
                • 5. Re: R12.1.3 AppsLocal on OEL6
                  Hussein Sawwan-Oracle
                  Srini Chavali wrote:
                  Pl check the database alert log for any errors

                  HTH
                  Srini
                  992259 wrote:Followed the doc 761566.1, although I have some versions higher, ie. last digit

                  No errors in the alert log
                  Thanks,
                  Hussein
                  • 6. Re: R12.1.3 AppsLocal on OEL6
                    995262
                    Hi,

                    Reviewed all the notes, tried a few things like recomp the jsp pages, no joy. Checked the site level params and everything is fine (as should be). None of the notes listed could resolve this issue. Furthermore, I can confirm there are no errors in the database alert log.... See extract of current space availeable..


                    Tablespace Size(Mb) Total Free(MB) % Free Max Free(Kb) No Of Ext.
                    -------------------- --------- -------------- ------- ------------ ----------
                    OLTS_CT_STORE 8 1 10.16 832 1
                    ORABPEL 13 2 11.54 1,536 1
                    APPS_TS_SEED 3,932 473 12.04 309,632 2
                    APPS_TS_TX_IDX 34,143 4,131 12.10 1,685,120 181
                    SYSTEM 20,491 2,618 12.78 507,904 61
                    APPS_TS_TX_DATA 60,588 7,893 13.03 1,702,272 492
                    UDDISYS_TS 22 3 13.07 2,944 1
                    SYSAUX 1,339 182 13.57 18,752 356
                    IAS_META 234 34 14.45 34,624 1
                    DISCO_PTM5_CACHE 114 17 14.47 16,320 2

                    Total
                    Tablespace Size(Mb) Total Free(MB) % Free Max Free(Kb) No Of Ext.
                    -------------------- --------- -------------- ------- ------------ ----------
                    APPS_TS_QUEUES 4,336 648 14.94 545,920 10
                    APPS_TS_MEDIA 5,547 832 15.00 409,472 5
                    GEOR_TBS 2,261 339 15.00 216,064 8
                    APPS_TS_DISCO 906 136 15.02 139,392 1
                    RBS_MIG 46 7 15.08 7,104 1
                    DCM 210 32 15.12 30,656 3
                    B2B_RT 45 7 15.14 6,976 1
                    B2B_DT 72 11 15.45 11,392 1
                    B2B_IDX 17 3 15.81 2,752 1
                    SYNCSERVER 58 9 15.91 8,200 5

                    Total
                    Tablespace Size(Mb) Total Free(MB) % Free Max Free(Kb) No Of Ext.
                    -------------------- --------- -------------- ------- ------------ ----------
                    APPS_TS_SUMMARY 23,685 3,798 16.04 1,836,288 3134
                    HTMLDB 500 84 16.88 85,952 2
                    APPS_TS_INTERFACE 2,538 449 17.69 157,632 366
                    B2B_LOB 13 2 17.79 2,368 1
                    RE 8 1 17.97 1,472 1
                    APPS_TS_ARCHIVE 1,101 201 18.26 163,968 17
                    BAM 8 2 21.09 960 2
                    DSGATEWAY_TAB 7 2 21.43 1,536 1
                    OPMOR 6 1 22.92 1,408 1
                    ODM_DATA 40 10 23.91 3,840 6

                    Total
                    Tablespace Size(Mb) Total Free(MB) % Free Max Free(Kb) No Of Ext.
                    -------------------- --------- -------------- ------- ------------ ----------
                    XDB 200 49 24.59 50,112 3
                    OLTS_SVRMGSTORE 3 1 27.08 832 1
                    APPS_CALCLIP 4,770 1,544 32.36 380,800 26
                    DISCO_PTM5_META 3 1 35.42 1,088 1
                    OCATS 3 1 41.67 1,280 1
                    APPS_TS_NOLOGGING 654 279 42.60 204,160 4
                    WCRSYS_TS 3 1 43.75 1,344 1
                    APPS_OMO 1,150 512 44.51 511,872 2
                    CTXSYS 92 44 47.55 27,904 26
                    OLTS_DEFAULT 3 1 47.92 1,344 2

                    Total
                    Tablespace Size(Mb) Total Free(MB) % Free Max Free(Kb) No Of Ext.
                    -------------------- --------- -------------- ------- ------------ ----------
                    UNDO_TBS 3,686 1,889 51.23 65,536 238
                    MTR 4 2 57.81 1,408 12
                    OLTS_ATTRSTORE 15 15 97.92 15,040 1
                    OLTS_BATTRSTORE 15 15 97.92 15,040 1
                    APPS_TS_DISCO_OLAP 1,350 1,334 98.81 698,624 7
                    OWAPUB 10 10 99.38 10,176 1
                    CWMLITE 24 24 99.48 20,416 2
                    TS_SIM 50 50 99.88 51,136 1
                    TS_SALES_DATA_ENGINE 50 50 99.88 51,136 1
                    _X

                    Total
                    Tablespace Size(Mb) Total Free(MB) % Free Max Free(Kb) No Of Ext.
                    -------------------- --------- -------------- ------- ------------ ----------

                    TS_SALES_DATA 50 50 99.88 51,136 1
                    TS_DP 50 50 99.88 51,136 1
                    TS_SIM_X 50 50 99.88 51,136 1
                    TS_SALES_DATA_X 50 50 99.88 51,136 1
                    TS_SALES_DATA_ENGINE 50 50 99.88 51,136 1
                    DW_LOOKUP_TBS 100 100 99.94 102,336 1
                    DW_MVLOG_TBS 100 100 99.94 102,336 1
                    DW_DM_TBS 100 100 99.94 102,336 1
                    DW_DERIVED_TBS 100 100 99.94 102,336 1

                    Total
                    Tablespace Size(Mb) Total Free(MB) % Free Max Free(Kb) No Of Ext.
                    -------------------- --------- -------------- ------- ------------ ----------
                    DW_BASE_IDX 100 100 99.94 102,336 1
                    DW_AGGREGATE_TBS 100 100 99.94 102,336 1
                    DW_DERIVED_IDX 100 100 99.94 102,336 1
                    DW_AGGREGATE_IDX 100 100 99.94 102,336 1
                    DW_REFERENCE_IDX 100 100 99.94 102,336 1
                    DW_BASE_TBS 100 100 99.94 102,336 1
                    DW_REFERENCE_TBS 134 134 99.95 137,088 1
                    OLAP_BAAD 1,500 1,500 99.99 511,936 3
                    BIA_RTL 1,000 1,000 99.99 1,023,936 1
                    DEMANTRA 5,400 5,400 100.00 2,047,936 4

                    Total
                    Tablespace Size(Mb) Total Free(MB) % Free Max Free(Kb) No Of Ext.
                    -------------------- --------- -------------- ------- ------------ ----------
                    DATA 7,200 7,200 100.00 1,843,136 5

                    69 rows selected.

                    Any other idea of what may be the issue here????
                    • 7. Re: R12.1.3 AppsLocal on OEL6
                      995262
                      No db errors....!
                      • 8. Re: R12.1.3 AppsLocal on OEL6
                        Hussein Sawwan-Oracle
                        Any other idea of what may be the issue here????
                        Can you please do the following?

                        - Enable Apache/Application debug
                        - Stop the services
                        - Backup the log files and rename it
                        - Start the services
                        - Reproduce the issue
                        - Upload all log files to any free hosting website and post the link here (in one zip/tar file)

                        Thanks,
                        Hussein
                        • 9. Re: R12.1.3 AppsLocal on OEL6
                          Hussein Sawwan-Oracle
                          992259 wrote:
                          No db errors....!
                          Yes, and you mentioned/confirmed this before.

                          Thanks,
                          Hussein
                          • 10. Re: R12.1.3 AppsLocal on OEL6
                            995262
                            Issue, the debug mode does not pick up much info,
                            see link for details

                            http://www.uploadmb.com/dw.php?id=1362611892
                            http://www.uploadmb.com/dw.php?id=1362611931
                            • 11. Re: R12.1.3 AppsLocal on OEL6
                              Hussein Sawwan-Oracle
                              I can find access* log file only but not the error* log file.

                              Thanks,
                              Hussein
                              • 12. Re: R12.1.3 AppsLocal on OEL6
                                995262
                                That's correct, the error log is not generated during the attempted login and even debugging is on...

                                This is where I am struggling to resolve this issue.
                                • 13. Re: R12.1.3 AppsLocal on OEL6
                                  Hussein Sawwan-Oracle
                                  Have you enabled debug as per these docs?

                                  R12, 12.1 - How To Enable and Collect Debug for HTTP, OC4J and OPMN [ID 422419.1]
                                  How to enable Apache, OC4J and OPMN logging in Oracle Applications R12 [ID 419839.1]

                                  Thanks,
                                  Hussein
                                  • 14. Re: R12.1.3 AppsLocal on OEL6
                                    995262
                                    Yes, I followed the notes to turn on tracing, the debug mode did not produce any error log for this issue.

                                    The login page starts up and the access log shows access.... but there are no errors produced, yet I cannot log into the application. Tried several browsers and other clients, no joy!

                                    127.0.0.1 - - [07/Mar/2013:07:14:22 +0000] "HEAD /index.html HTTP/1.1" 200 0 0 "-" "-"
                                    127.0.0.1 - - [07/Mar/2013:07:14:42 +0000] "HEAD /index.html HTTP/1.1" 200 0 0 "-" "-"
                                    127.0.0.1 - - [07/Mar/2013:07:15:02 +0000] "HEAD /index.html HTTP/1.1" 200 0 0 "-" "-"
                                    127.0.0.1 - - [07/Mar/2013:07:15:22 +0000] "HEAD /index.html HTTP/1.1" 200 0 0 "-" "-"
                                    1 2 Previous Next