11 Replies Latest reply: Apr 3, 2014 10:00 PM by jariola RSS

    Not able to get login page for apex application

    1974784

      Hi ,

      I installed oracle apex 4.2.4 on 11.1.0.7 database.I followed the following steps

      1)download apex4.2.4 zip file

      2)copied to oracle home and and unzipped it.

      3) changed to directory and installed $ORACLE_HOME/apex folder

      4)Run the script @apexins.sql APEX APEX TEMP /i/ which is succesfull.

      5)changesd the admin password by running the @apxchpwd.sql

      6)@apex_epg_config.sql $ORACLE_HOME/apex succesful

      7)EXEC DBMS_XDB.sethttpport(8080);

      8)

      [oraepib@epibdev apex]$ lsnrctl status EDEV

       

       

      LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 03-APR-2014 17:57:04

       

       

      Copyright (c) 1991, 2008, Oracle.  All rights reserved.

       

       

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=epibdev.enrichit.com)(PORT=1521)))

      STATUS of the LISTENER

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

      Alias                     EDEV

      Version                   TNSLSNR for Linux: Version 11.1.0.7.0 - Production

      Start Date                03-APR-2014 15:22:20

      Uptime                    0 days 2 hr. 34 min. 44 sec

      Trace Level               off

      Security                  ON: Local OS Authentication

      SNMP                      OFF

      Listener Parameter File   /db/EDEV/db/tech_st/11.1.0/network/admin/EDEV_avvas/listener.ora

      Listener Log File         /db/EDEV/db/tech_st/11.1.0/log/diag/tnslsnr/epibdev/edev/alert/log.xml

      Listening Endpoints Summary...

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=epibdev.avvas.com)(PORT=1521)))

        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=epibdev.avvas.com)(PORT=8080))(Presentation=HTTP)(Session=RAW))

      Services Summary...

      Service "EDEV" has 2 instance(s).

        Instance "EDEV", status UNKNOWN, has 1 handler(s) for this service...

        Instance "EDEV", status READY, has 1 handler(s) for this service...

      Service "EDEV_XPT" has 1 instance(s).

        Instance "EDEV", status READY, has 1 handler(s) for this service...

      The command completed successfully

       

      9) Made sure the port 8080 is opened in firewall.

       

      Still i am unable to login get starting page when accessing http:epibdev.avvas.com:8080/apex .Any logfiles i need to check.

       

      Thanks

      chow

        • 1. Re: Not able to get login page for apex application
          jariola

          Hi,

           

          Do you actual see login page or just empty screen?

          If you just see blank page, I'm quite sure step load images to database have failed as you did specify wrong path.

          Try run

          @apxldimg.sql $ORACLE_HOME


          Please note that you should not include /apex at end of path


          Regards,

          Jari

          • 2. Re: Not able to get login page for apex application
            1974784

            Is it mandatory to run @apxldimg.sql $ORACLE_HOME for fresh installation.It is mentioned that if we upgrade apex then we need to run.

             

             

             

            Thanks

            Giri

            • 3. Re: Not able to get login page for apex application
              1974784

              When i treid to enter in i.e it is showing that page cannot be displayed.

               

               

              Thanks

              Giri

              • 4. Re: Not able to get login page for apex application
                jariola

                Hi,

                 

                That script will reload images to database , as you did already run apex_epg_config.sql.

                 

                But as you get "page cannot be displayed." something is blocking connection, or EPG is not configured properly.

                 

                Regards,

                Jari

                • 5. Re: Not able to get login page for apex application
                  jariola

                  Hi,

                   

                  It might EPG accept connection only from local host try run

                  EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
                  

                   

                  Regards,

                  Jari

                  • 6. Re: Not able to get login page for apex application
                    1974784

                    This is the ouppu of epstat.sql

                    SQL> @epgstat.sql

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

                    | XDB protocol ports:                  |

                    |  XDB is listening for the protocol   |

                    |  when the protocol port is non-zero. |

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

                     

                     

                    HTTP Port FTP Port

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

                         8080        0

                     

                     

                    1 row selected.

                     

                     

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

                    | DAD virtual-path mappings |

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

                     

                     

                    Virtual Path                     DAD Name

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

                    /apex/*                          APEX

                     

                     

                    1 row selected.

                     

                     

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

                    | DAD attributes |

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

                     

                     

                    DAD Name     DAD Param                DAD Value

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

                    APEX         database-username        ANONYMOUS

                                 default-page             apex

                                 document-table-name      wwv_flow_file_objects$

                                 request-validation-funct wwv_flow_epg_include_modules.authorize

                                 ion

                     

                     

                                 document-procedure       wwv_flow_file_mgr.process_download

                                 nls-language             american_america.al32utf8

                                 document-path            docs

                     

                     

                    7 rows selected.

                     

                     

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

                    | DAD authorization:                                |

                    |  To use static authentication of a user in a DAD, |

                    |  the DAD must be authorized for the user.         |

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

                     

                     

                    no rows selected

                     

                     

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

                    | DAD authentication schemes |

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

                     

                     

                    DAD Name             User Name                        Auth Scheme

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

                    APEX                 ANONYMOUS                        Anonymous

                     

                     

                    1 row selected.

                     

                     

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

                    | ANONYMOUS user status:                                 |

                    |  To use static or anonymous authentication in any DAD, |

                    |  the ANONYMOUS account must be unlocked.               |

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

                     

                     

                    Database User   Status

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

                    ANONYMOUS       OPEN

                     

                     

                    1 row selected.

                     

                     

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

                    | ANONYMOUS access to XDB repository:                               |

                    |  To allow public access to XDB repository without authentication, |

                    |  ANONYMOUS access to the repository must be allowed.              |

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

                     

                     

                    Allow repository anonymous access?

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

                    false

                     

                     

                    1 row selected.

                     

                     

                     

                    But the listener.ora and tnsnames.ora had no chnages.Do i need to configure anything in listerner

                    • 7. Re: Not able to get login page for apex application
                      jariola

                      Hi,

                       

                      Output of script looks good.

                      You do not need change listener or tnasnames files.

                       

                      Did you run

                      EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);

                       

                      Regards,

                      Jari

                      • 8. Re: Not able to get login page for apex application
                        1974784

                        Yes  i ran the script.Do i need to do any changes after that.

                         

                         

                        Thanks

                        • 9. Re: Not able to get login page for apex application
                          jariola

                          Hi,

                           

                          No.

                          Can you access APEX now?

                           

                          Regards,

                          Jari

                          • 10. Re: Not able to get login page for apex application
                            1974784

                            Still i am unable to access the application.

                             

                             

                            Thanks

                            Giri

                            • 11. Re: Not able to get login page for apex application
                              jariola

                              Hi,

                               

                              Ok, have you try access APEX from localhost to see if it is not e.g. firewall issue after all?

                               

                              Regards,

                              Jari