8 Replies Latest reply on Oct 16, 2013 2:43 PM by rukbat

    I Could not open oracle database Homepage,127.0.0.1:8080/apex,, Please help....

    Sajib

      I Could not open oracle database Homepage,http://127.0.0.1:8080/apex

      but i can login in my database using  Run SQL Command Line.




      some information given below:


      [sajib@fws ~]$ lsnrctl status

      LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 05-OCT-2013 22:33:15

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

      Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
      STATUS of the LISTENER
      ------------------------
      Alias                     LISTENER
      Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
      Start Date                05-OCT-2013 22:01:03
      Uptime                    0 days 0 hr. 32 min. 12 sec
      Trace Level               off
      Security                  ON: Local OS Authentication
      SNMP                      OFF
      Default Service           XE
      Listener Parameter File /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
      Listener Log File /u01/app/oracle/diag/tnslsnr/fws/listener/alert/log.xml
      Listening Endpoints Summary...
        (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
        (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=::1)(PORT=1521)))
      Services Summary...
      Service "PLSExtProc" has 1 instance(s).
      Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
      The command completed successfully

       

      [sajib@fws ~]$ sqlplus / as sysdba

      SQL*Plus: Release 11.2.0.2.0 Production on Sat Oct 5 22:34:37 2013

      Copyright (c) 1982, 2011, Oracle.  All rights reserved.


      Connected to:
      Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

      SQL> select status from v$instance;

      STATUS
      ------------
      OPEN

      SQL> select open_mode from v$database;

      OPEN_MODE
      --------------------
      READ WRITE