Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to connect http://localhost:8080/apex/f?p=4950 in firefox. SQL command line is working fine.

Sandipan1893Jan 7 2019 — edited Feb 24 2019

Unable to connect http://localhost:8080/apex/f?p=4950 in firefox. SQL command line is working fine. My OS is Fedora 28. I am using oracle 11g express edition.

$ sudo /etc/init.d/oracle-xe start

Starting oracle-xe (via systemctl):                        [  OK  ]

$ sqlplus

SQL*Plus: Release 11.2.0.2.0 Production on Mon Jan 7 10:29:18 2019

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

Enter user-name: sys as sysdba

Enter password:

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1068937216 bytes

Fixed Size     2233344 bytes

Variable Size   616565760 bytes

Database Buffers   444596224 bytes

Redo Buffers     5541888 bytes

Database mounted.

Database opened.

SQL>

  $ sudo usermod -a -G dba username

SQL> select dbms_xdb.getHttpPort() from dual;

DBMS_XDB.GETHTTPPORT()

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

  8080

$ lsnrctl

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 07-JAN-2019 10:53:05

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

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> start

Starting /u01/app/oracle/product/11.2.0/xe/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.2.0 - Production

System parameter file is /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora

Log messages written to /u01/app/oracle/product/11.2.0/xe/log/diag/tnslsnr/localhost/listener/alert/log.xml

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))

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                07-JAN-2019 10:53:14

Uptime                    0 days 0 hr. 0 min. 0 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/product/11.2.0/xe/log/diag/tnslsnr/localhost/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(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

LSNRCTL>

Plese help me by providing valuable suggestion. Thanks------

Comments
Post Details
Added on Jan 7 2019
8 comments
9,923 views