5 Replies Latest reply: Mar 21, 2013 7:11 AM by EBSDBA RSS

    only one customised user is working in R12 and others not

    user13376823
      we are facing a strange problem in our R12.1.1 server.


      only one customised user (e.g john.kameroon) is fully working in R12 .

      other users are able to login but does not proceed further from there after login. even with sysadmin same is issue.



      one thing which i am observing at tablespace level is UNDO tablespace is rapidly going to be consumed. i dont know why ?


      please if some body helps that will be appreciable.

      thanks
        • 1. Re: only one customised user is working in R12 and others not
          EBSDBA
          user13376823 wrote:
          we are facing a strange problem in our R12.1.1 server.


          only one customised user (e.g john.kameroon) is fully working in R12 .

          other users are able to login but does not proceed further from there after login. even with sysadmin same is issue.
          Please elobarate what is meant by not able to proceed. Do they get any error? And what is the behavior of application?
          one thing which i am observing at tablespace level is UNDO tablespace is rapidly going to be consumed. i dont know why ?
          Please see which profile options were changed recently and also post the contents of access_log, error_log and alert log file.
          please if some body helps that will be appreciable.
          What concurrent requests are running? Did some one update any tables directly?
          thanks
          • 2. Re: only one customised user is working in R12 and others not
            user13376823
            after login there is white screen. no java applet and forms loaded ( this in not client issue , its happening on every client with this specific R12 test server)



            it looks problem with apache services.
            • 3. Re: only one customised user is working in R12 and others not
              user13376823
              apache error log contains error messages :


              [Thu Mar 21 10:08:38 2013] [error] [client 10.2.17.15] [ecid: 1363842518:10.0.1.13:30297:0:49,0] File does not exist: /opt/FFCL8001/oracle/inst/apps/FFCL8001_lhrho/portal/favicon.ico
              [Thu Mar 21 10:11:44 2013] [error] [client 10.2.17.15] [ecid: 1363842704:10.0.1.13:29001:0:41,0] File does not exist: /opt/FFCL8001/oracle/inst/apps/FFCL8001_lhrho/portal/favicon.ico
              [Thu Mar 21 10:11:50 2013] [error] [client 10.2.17.15] [ecid: 1363842710:10.0.1.13:29001:0:44,0] File does not exist: /opt/FFCL8001/oracle/inst/apps/FFCL8001_lhrho/portal/favicon.ico
              [Thu Mar 21 10:13:24 2013] [error] [client 10.2.17.15] [ecid: 1363842804:10.0.1.13:30368:0:41,0] File does not exist: /opt/FFCL8001/oracle/inst/apps/FFCL8001_lhrho/portal/favicon.ico
              [Thu Mar 21 10:13:31 2013] [error] [client 10.2.17.15] [ecid: 1363842811:10.0.1.13:30368:0:44,0] File does not exist: /opt/FFCL8001/oracle/inst/apps/FFCL8001_lhrho/portal/favicon.ico
              [Thu Mar 21 10:23:52 2013] [error] [client 10.42.20.35] [ecid: 1363843432:10.0.1.13:30370:0:128,0] Directory index forbidden by rule: /opt/FFCL8001/oracle/apps/apps_st/comn/java/classes/
              [Thu Mar 21 11:05:03 2013] [error] [client 10.42.20.86] [ecid: 1363845903:10.0.1.13:28995:0:143,0] File does not exist: /opt/FFCL8001/oracle/inst/apps/FFCL8001_lhrho/portal/favicon.ico
              [Thu Mar 21 11:05:06 2013] [error] [client 10.42.20.86] [ecid: 1363845906:10.0.1.13:28999:0:82,0] File does not exist: /opt/FFCL8001/oracle/inst/apps/FFCL8001_lhrho/portal/favicon.ico
              [Thu Mar 21 11:05:06 2013] [error] [client 10.42.20.86] [ecid: 1363845906:10.0.1.13:30370:0:158,0] File does not exist: /opt/FFCL8001/oracle/inst/apps/FFCL8001_lhrho/portal/favicon.ico
              [Thu Mar 21 11:19:57 2013] [error] [client 10.1.5.224] [ecid: 1363846797:10.0.1.13:28995:0:167,0] File does not exist: /opt/FFCL8001/oracle/inst/apps/FFCL8001_lhrho/portal/favicon.ico
              [Thu Mar 21 11:35:31 2013] [notice] Oracle-Application-Server-10g/10.1.3.4.0 Oracle-HTTP-Server configured -- resuming normal operations
              [Thu Mar 21 11:35:31 2013] [notice] Accept mutex: fcntl (Default: fcntl)
              [Thu Mar 21 11:48:33 2013] [notice] Oracle-Application-Server-10g/10.1.3.4.0 Oracle-HTTP-Server configured -- resuming normal operations
              [Thu Mar 21 11:48:33 2013] [notice] Accept mutex: fcntl (Default: fcntl)
              [Thu Mar 21 11:49:41 2013] [error] [client 10.1.5.46] [ecid: 1363848581:10.0.1.13:4938:0:1,0] mod_oc4j: Failed to find a failover oc4j process for session request for destination: application://oacore (no island or jgroup).
              [Thu Mar 21 11:49:52 2013] [error] [client 10.1.5.46] [ecid: 1363848592:10.0.1.13:4938:0:2,0] mod_oc4j: Failed to find a failover oc4j process for session request for destination: application://oacore (no island or jgroup).
              [Thu Mar 21 11:49:54 2013] [error] [client 10.1.5.46] [ecid: 1363848594:10.0.1.13:4938:0:3,0] mod_oc4j: Failed to find a failover oc4j process for session request for destination: application://oacore (no island or jgroup).



              access log contains :


              10.1.5.46 - - [21/Mar/2013:11:50:26 +0500] "GET /OA_HTML/cabo/oajsLibs/oafcoreR121.js HTTP/1.1" 304 0 0 "http://lhrho.fgho.com:8001/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; InfoPath.3)"
              10.1.5.46 - - [21/Mar/2013:11:50:26 +0500] "GET /OA_HTML/cabo/images/swan/t.htm HTTP/1.1" 304 0 0 "http://lhrho.fgho.com:8001/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; InfoPath.3)"
              10.1.5.46 - - [21/Mar/2013:11:50:26 +0500] "GET /OA_HTML/blank.html HTTP/1.1" 304 0 0 "http://lhrho.fgho.com:8001/OA_HTML/OA.jsp?OAFunc=OAHOMEPAGE" "Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; InfoPath.3)"
              127.0.0.1 - - [21/Mar/2013:11:50:33 +0500] "HEAD /index.html HTTP/1.1" 200 0 0 "-" "-"
              127.0.0.1 - - [21/Mar/2013:11:50:53 +0500] "HEAD /index.html HTTP/1.1" 200 0 0 "-" "-"
              127.0.0.1 - - [21/Mar/2013:11:51:13 +0500] "HEAD /index.html HTTP/1.1" 200 0 0 "-" "-"
              127.0.0.1 - - [21/Mar/2013:11:51:33 +0500] "HEAD /index.html HTTP/1.1" 200 0 0 "-" "-"
              127.0.0.1 - - [21/Mar/2013:11:51:53 +0500] "HEAD /index.html HTTP/1.1" 200 0 0 "-" "-"
              127.0.0.1 - - [21/Mar/2013:11:52:13 +0500] "HEAD /index.html HTTP/1.1" 200 0 0 "-" "-"
              127.0.0.1 - - [21/Mar/2013:11:52:33 +0500] "HEAD /index.html HTTP/1.1" 200 0 0 "-" "-"
              127.0.0.1 - - [21/Mar/2013:11:52:53 +0500] "HEAD /index.html HTTP/1.1" 200 0 0 "-" "-"
              127.0.0.1 - - [21/Mar/2013:11:53:13 +0500] "HEAD /index.html HTTP/1.1" 200 0 0 "-" "-"
              127.0.0.1 - - [21/Mar/2013:11:53:33 +0500] "HEAD /index.html HTTP/1.1" 200 0 0 "-" "-"
              127.0.0.1 - - [21/Mar/2013:11:53:53 +0500] "HEAD /index.html HTTP/1.1" 200 0 0 "-" "-"
              127.0.0.1 - - [21/Mar/2013:11:54:13 +0500] "HEAD /index.html HTTP/1.1" 200 0 0 "-" "-"
              127.0.0.1 - - [21/Mar/2013:11:54:33 +0500] "HEAD /index.html HTTP/1.1" 200 0 0 "-" "-"
              127.0.0.1 - - [21/Mar/2013:11:54:53 +0500] "HEAD /index.html HTTP/1.1" 200 0 0 "-" "-"
              127.0.0.1 - - [21/Mar/2013:11:55:13 +0500] "HEAD /index.html HTTP/1.1" 200 0 0 "-" "-"
              127.0.0.1 - - [21/Mar/2013:11:55:33 +0500] "HEAD /index.html HTTP/1.1" 200 0 0 "-" "-"
              127.0.0.1 - - [21/Mar/2013:11:55:53 +0500] "HEAD /index.html HTTP/1.1" 200 0 0 "-" "-"
              127.0.0.1 - - [21/Mar/2013:11:56:13 +0500] "HEAD /index.html HTTP/1.1" 200 0 0 "-" "-"
              127.0.0.1 - - [21/Mar/2013:11:56:33 +0500] "HEAD /index.html HTTP/1.1" 200 0 0 "-" "-"


              please reply
              • 4. Re: only one customised user is working in R12 and others not
                user13376823
                now apache error log contains these messages :

                [Thu Mar 21 14:44:11 2013] [error] [client 10.2.17.27] [ecid: 1363859051:10.0.1.13:16511:0:158,0] File does not exist: /opt/FFCL8001/oracle/apps/apps_st/comn/java/classes/oracle/apps/fnd/jar/fndlist.jar.pack.gz
                [Thu Mar 21 14:44:11 2013] [error] [client 10.2.17.27] [ecid: 1363859051:10.0.1.13:17179:0:54,0] File does not exist: /opt/FFCL8001/oracle/apps/apps_st/comn/java/classes/oracle/apps/fnd/jar/fndaolj.jar.pack.gz
                [Thu Mar 21 14:44:11 2013] [error] [client 10.2.17.27] [ecid: 1363859051:10.0.1.13:17226:0:197,0] File does not exist: /opt/FFCL8001/oracle/apps/apps_st/comn/java/class
                • 5. Re: only one customised user is working in R12 and others not
                  EBSDBA
                  [Thu Mar 21 11:49:41 2013] [error] [client 10.1.5.46] [ecid: 1363848581:10.0.1.13:4938:0:1,0] mod_oc4j: Failed to find a failover oc4j process for session request for destination: application://oacore (no island or jgroup).
                  [Thu Mar 21 11:49:52 2013] [error] [client 10.1.5.46] [ecid: 1363848592:10.0.1.13:4938:0:2,0] mod_oc4j: Failed to find a failover oc4j process for session request for destination: application://oacore (no island or jgroup).
                  [Thu Mar 21 11:49:54 2013] [error] [client 10.1.5.46] [ecid: 1363848594:10.0.1.13:4938:0:3,0] mod_oc4j: Failed to find a failover oc4j process for session request for destination: application://oacore (no island or jgroup).
                  Please see
                  R12: Resolving error mod_oc4j Failed To find A Failover OC4J Process For Session Request For Destination [ID 785296.1]

                  Thanks