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 上一个 下一个