1 Reply Latest reply on Jun 19, 2017 12:46 PM by Kiran Pawar

    Apex Login Page not comming up!

    2713349

      Dear All,

       

      My database is Oracle 11.2.0.4 on windows 2012 64 Bit OS.

      I am trying to install APEX. After successful installation I am unable to load the login page http://localhost:8050/apex/ that results in error "The page can't de displayed.

       

      I will go through the installation steps and out come of the log files.

       

      This is how I installed APEX

       

      1. Download and unzip APEX apex_5.1.1 to apex

      2. Install apex SQL>@apexins.sql APEX APEX APEX_TEMP /i/

      3. Uploading images SQL>@apxidimg.sql

      4. Running apex_epg_config.sql

      5. And finally script apexconf.sql

       

      I have also added this line in my listener.ora file

      (ADDRESS=  (PROTOCOL=tcp) (KEY = EXTPROC1526) (HOST=GRBHORDT01.garmco.local)(PORT=8050))  

       

      when I check status of listener I can see that in listening endpoints summary

       

      I have disabled the firewall as well and restarted my database and listener several times without success. The login page is not coming up.

       

      I can see the following error in my listener.log file

       

      WARNING: Subscription for node down event still pending

      18-JUN-2017 11:12:54 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=xxxxxx))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_DBA)(VERSION=186647552)) * status * 0

      TNS-12523: TNS:listener could not find instance appropriate for the client connection

      Sun Jun 18 11:12:54 2017

       

      That is the only error I can see.

       

      Any help will be highly appreciated.

       

      Regards,

        • 1. Re: Apex Login Page not comming up!
          Kiran Pawar

          Hi,

          2713349 wrote:

          Please change your user handle from "2713349" to something meaningful. Refer : Video tutorial how to change nickname available

          My database is Oracle 11.2.0.4 on windows 2012 64 Bit OS.

          ...

           

          This is how I installed APEX

           

          1. Download and unzip APEX apex_5.1.1 to apex

          2. Install apex SQL>@apexins.sql APEX APEX APEX_TEMP /i/

          3. Uploading images SQL>@apxidimg.sql

          4. Running apex_epg_config.sql

          5. And finally script apexconf.sql

          Where did you get these steps from as installing or upgrading to Oracle APEX 5.1 steps does not contain these steps(apxidimg.sql, apexconf.sql).

          I am trying to install APEX. After successful installation I am unable to load the login page http://localhost:8050/apex/ that results in error "The page can't de displayed.

          Have you enabled EPG on port 8050?

          Refer: https://docs.oracle.com/database/apex-5.1/HTMIG/configuring-embedded-PL-SQL-gateway.htm#GUID-C163D819-B796-4C11-8E89-69D…

          I can see the following error in my listener.log file

           

          WARNING: Subscription for node down event still pending

          18-JUN-2017 11:12:54 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=xxxxxx))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER_DBA)(VERSION=186647552)) * status * 0

          TNS-12523: TNS:listener could not find instance appropriate for the client connection

          Sun Jun 18 11:12:54 2017

          Check this error with Oracle DBA or check the listener configuration.

           

          Hope this helps!

           

          Regards,

          Kiran