1 2 Previous Next 17 Replies Latest reply on Sep 1, 2015 4:48 AM by yoonas

    Oracle EBS R12.2.3 - Unable to connect to Application login page

    Rohit Chaube

      We have a 2 node - Vision install of EBS R12.2.3.

      The install has been working great, yesterday due to some blip we had to restart the services.

       

      All services - database and application ended with status 0 and one is able to connect to the database.

      But while accessing the Application login page returns the following error on the browser

       

      R12_2_error_msg.JPG

       

      None of the script log files have any relevant error messages.

      Any ideas or suggestion to debug this issue.

       

      thanks

      Rohit

        • 1. Re: Oracle EBS R12.2.3 - Unable to connect to Application login page
          Chiranjeevi M A

          Hello Rohit,

           

          Are you able to ping host successfully??

          • 2. Re: Oracle EBS R12.2.3 - Unable to connect to Application login page
            aJohny

            Are you on the same network ?

            Is there any firewall on your machine ?

            Can you try to replace the hostname with IP and see it works ?

            • 3. Re: Oracle EBS R12.2.3 - Unable to connect to Application login page
              Pravin Takpire

              Test below

              ping servername

              telnet servername port

              regards

              Pravin

              • 4. Re: Oracle EBS R12.2.3 - Unable to connect to Application login page
                Rohit Chaube

                Thanks you gentlemen for your quick response.

                 

                 

                Following are my findings for the requested information

                 

                 

                1. Yes I am able to ping the host successfully

                2. Yes I am am on the same network

                3. Replacing hostname with the IP address didn't help.

                 

                 

                I am not able to telnet servername port.

                It returns

                 

                 

                Could not open connection to the host, on port 8000: Connect failed

                 

                 

                Any suggestions how I can proceed from here.

                 

                 

                As I have mentioned before the server was working fine earlier and there has not been any patch that has been applied. Is it possible the port number would have changed

                • 5. Re: Oracle EBS R12.2.3 - Unable to connect to Application login page
                  aJohny

                  Have a look at the suggestion mentioned in the below thread  and see if any of that helps

                  Access R12 Instance from Host(Win 7,64 Bit): Installed on Guest (OEL5)

                  • 6. Re: Oracle EBS R12.2.3 - Unable to connect to Application login page
                    Rohit Chaube

                    Thank Johny, saw the same post and contemplating should i run autoconfig ?

                     

                    For EBS R12.2 do i need to follow addition steps/ scripts before I can run autoconfig due to two environments - run and patch ?

                     

                    Also since the environment was up and running well, is running autoconfig an extreme step or is there something simpler.

                     

                    -Rohit

                    • 7. Re: Oracle EBS R12.2.3 - Unable to connect to Application login page
                      Rohit Chaube

                      I ran autoconfig on both the servers as suggested by the mentioned string.Still not luck accessing the application login page.

                       

                      One of the things I noticed is the Oracle HTTP Server (OHS) being down and restarting/starting the results in status 0 but it still doesn't start the server/service.

                       

                      Any thoughts, ideas etc how i can overcome this issue.

                       

                      thanks

                      Rohit

                      • 8. Re: Oracle EBS R12.2.3 - Unable to connect to Application login page
                        yoonas

                        Rohit,

                         

                        What is the status

                        adopmnctl status

                        admanagedsrvctl.sh status <oacore_server1>

                         

                        Checking log files might help understand things better

                         

                        12.2 Ebusiness Suite - Collecting Fusion Middleware Log Files (Doc ID 1362900.1)

                         

                         

                        Regards

                         

                        Yoonas

                        • 9. Re: Oracle EBS R12.2.3 - Unable to connect to Application login page
                          Rohit Chaube

                          Thank you Yoonas for the response

                           

                          The status for the mentioned services are

                          adopmnctl status

                           

                          status - Stop

                           

                          I have tried starting this from EM but have not been successful.

                          Not much information in log file too.

                           

                           

                          admanagedsrvctl.sh status <oacore_server1>


                          <oacore_server1>  is running



                          I am going over the mentioned Oracle Support document, will update the thread shortly.


                          Thanks

                          Rohit

                          • 10. Re: Oracle EBS R12.2.3 - Unable to connect to Application login page
                            yoonas

                            The status for the mentioned services are

                            adopmnctl status

                             

                            status - Stop

                             

                            I think this is not the output of command


                            adopmnctl.sh status

                            Was just meaning to post the output from above command

                            • 11. Re: Oracle EBS R12.2.3 - Unable to connect to Application login page
                              Rohit Chaube

                              Here is the exact output of the mentioned commands

                               

                              [applmgr@kc1dvebsr122as scripts]$ ./adopmnctl.sh status

                               

                               

                              You are running adopmnctl.sh version 120.0.12020000.2

                               

                               

                              Checking status of OPMN managed processes...

                               

                               

                              Processes in Instance: EBS_web_PROD_OHS1

                              ---------------------------------+--------------------+---------+---------

                              ias-component                    | process-type       |     pid | status 

                              ---------------------------------+--------------------+---------+---------

                              EBS_web_PROD                     | OHS                |    3602 | Stop   

                               

                               

                               

                               

                              adopmnctl.sh: exiting with status 0

                               

                               

                              adopmnctl.sh: check the logfile /d01/oracle/PROD/fs2/inst/apps/PROD_kc1dvebsr122as/logs/appl/admin/log/adopmnctl.txt for more information ... 

                               

                               

                              [applmgr@kc1dvebsr122as scripts]$ ./admanagedsrvctl.sh status oacore_server1

                               

                               

                              You are running admanagedsrvctl.sh version 120.14.12020000.8

                               

                               

                              Enter the WebLogic Admin password:

                               

                               

                              oacore_server1 is running.

                               

                               

                              admanagedsrvctl.sh: exiting with status 0

                               

                               

                              admanagedsrvctl.sh: check the logfile /d01/oracle/PROD/fs2/inst/apps/PROD_kc1dvebsr122as/logs/appl/admin/log/adoacorectl.txt for more information ...

                               

                               

                              [applmgr@kc1dvebsr122as scripts]$

                              • 12. Re: Oracle EBS R12.2.3 - Unable to connect to Application login page
                                Rohit Chaube

                                Just to add some additional information from the log files

                                 

                                In OHS log files - console~OHS~1.log since the servers have been down, been seeing the following error

                                 

                                --------

                                15/08/19 11:26:25 Stop process

                                --------

                                /d01/oracle/PROD/fs2/FMW_Home/webtier/ohs/bin/apachectl stop: httpd (no pid file) not running

                                 

                                 

                                --------

                                15/08/19 11:27:25 Stop process

                                --------

                                /d01/oracle/PROD/fs2/FMW_Home/webtier/ohs/bin/apachectl hardstop: httpd (no pid file) not running

                                 

                                 

                                Based on various suggestions have killed zombie processes and tried restarting the services.

                                No luck so far.

                                 

                                One of the things I noticed is missing httpd.conf file.

                                Any suggestions how I can overcome this.

                                 

                                 

                                thanks

                                Rohit

                                • 13. Re: Oracle EBS R12.2.3 - Unable to connect to Application login page
                                  yoonas

                                  start OHS using adopmnctl

                                  adopmnctl.sh startall

                                  Post output

                                   

                                  adopmnctl.sh status

                                  One of the things I noticed is missing httpd.conf file.

                                  post listing of $IAS_ORACLE_HOME/instances/<replace>/config/OHS/<replace>/

                                   

                                  ls -l $IAS_ORACLE_HOME/instances/<replace>/config/OHS/<replace>/

                                   

                                  You will have one with PATCH filesystem

                                   

                                  share log files from (you can attach log files using advanced editor option)

                                  $IAS_ORACLE_HOME/instances/<replace>/diagnostics/logs/OHS/<replace>/

                                  $IAS_ORACLE_HOME/instances/<replace>/diagnostics/logs/OPMN/opmn

                                  • 14. Re: Re: Oracle EBS R12.2.3 - Unable to connect to Application login page
                                    Rohit Chaube

                                    Hi Yoonas,

                                    Attached is the requested OHS and OPMN log files.

                                     

                                    Also other requested details are as follows

                                     

                                    [applmgr@kc1dvebsr122as scripts]$ ./adopmnctl.sh startall

                                     

                                     

                                    You are running adopmnctl.sh version 120.0.12020000.2

                                     

                                     

                                    Starting Apache...

                                    Apache started successfully.

                                     

                                     

                                     

                                    adopmnctl.sh: exiting with status 0

                                     

                                     

                                    adopmnctl.sh: check the logfile /d01/oracle/PROD/fs2/inst/apps/PROD_kc1dvebsr122as/logs/appl/admin/log/adopmnctl.txt for more information ...

                                     

                                     

                                    [applmgr@kc1dvebsr122as scripts]$ ./adopmnctl.sh status

                                     

                                     

                                    You are running adopmnctl.sh version 120.0.12020000.2

                                     

                                     

                                    Checking status of OPMN managed processes...

                                     

                                     

                                    Processes in Instance: EBS_web_PROD_OHS1

                                    ---------------------------------+--------------------+---------+---------

                                    ias-component                    | process-type       |     pid | status

                                    ---------------------------------+--------------------+---------+---------

                                    EBS_web_PROD                     | OHS                |    3602 | Stop

                                     

                                     

                                     

                                     

                                    adopmnctl.sh: exiting with status 0

                                     

                                     

                                    adopmnctl.sh: check the logfile /d01/oracle/PROD/fs2/inst/apps/PROD_kc1dvebsr122as/logs/appl/admin/log/adopmnctl.txt for more information ...

                                     

                                     

                                    [applmgr@kc1dvebsr122as scripts]$ ./adopmnctl.sh status -l

                                     

                                     

                                    You are running adopmnctl.sh version 120.0.12020000.2

                                     

                                     

                                    Checking status of OPMN managed processes...

                                     

                                     

                                    Processes in Instance: EBS_web_PROD_OHS1

                                    ---------------------------------+--------------------+---------+----------+------------+----------+-----------+------

                                    ias-component                    | process-type       |     pid | status   |        uid |  memused |    uptime | ports

                                    ---------------------------------+--------------------+---------+----------+------------+----------+-----------+------

                                    EBS_web_PROD                     | OHS                |    3602 | Stop     |  370877378 |        0 | 195:51:40 | https:4443,https:10000,http:8000

                                     

                                     

                                     

                                     

                                    adopmnctl.sh: exiting with status 0

                                     

                                     

                                    adopmnctl.sh: check the logfile /d01/oracle/PROD/fs2/inst/apps/PROD_kc1dvebsr122as/logs/appl/admin/log/adopmnctl.txt for more information ...

                                     

                                     

                                    [applmgr@kc1dvebsr122as scripts]$

                                     

                                    [applmgr@kc1dvebsr122as EBS_web_PROD]$ pwd

                                    /d01/oracle/PROD/fs2/FMW_Home/webtier/instances/EBS_web_PROD_OHS1/config/OHS/EBS_web_PROD

                                    [applmgr@kc1dvebsr122as EBS_web_PROD]$ ls -l httpd.conf

                                    -rw------- 1 applmgr dba 37819 Aug  6  2014 httpd.conf

                                    [applmgr@kc1dvebsr122as EBS_web_PROD]$

                                    1 2 Previous Next