Home » Infrastructure » Linux » Oracle XE browser homepage not opening (Oracle XE-10.2.0.1-1.0 OS: Fedora 8)
Oracle XE browser homepage not opening [message #375802] Sun, 14 December 2008 22:29 Go to next message
swiftguy121
Messages: 4
Registered: December 2008
Junior Member
Hello Experts,

I have installed Oracle XE-10.2.0.1-1.0 on my Fedora server system. Installation was successful but Im unable to open the server homepage in the browser i.e http://127.0.0.1:8080/apex .. If i enter this in the browser the message is "Unable to connect".

We have 2 NIC cards on this server system. One card is used for the internet connection and the other for the local network.

I googled a lot and tried to troubleshoot .. initially the 'Oracle Net listener' was not starting when i entered "/etc/init.d/oracle-xe start" in the console. But now the 'Oracle Net Listener' is starting i.e after making changes to the host value in listener.ora and tnsnames.ora files.

I feel there is some issue with the hostname or 2 nic cards which is the cause of this problem. (issue could be something else..this is just my guess).

Kindly look into the problem and help me out... thanks in advance!

Im listing out output/contents of the relevant commands/files to give a clear picture of the problem.

Note:
# xxx.xxx.xxx.xxx is the ip of our local network
# We also tried to http://xxx.xxx.xxx.xxx:8080/apex but still the same error
# We disabled iptables firewall and SE Linux.

/etc/hosts Output
==========
127.0.0.1 localhost.localdomain localhost
xxx.xxx.xxx.xxx server.savi.com

/etc/sysconfig/network Output
=================
NETWORKING=yes
HOSTNAME=server.savi.com
~

lsnrctl command output
===============
root@server admin#lsnrctl status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 14-DEC-2008 12:38:45

Copyright (c) 1991, 2005, 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 10.2.0.1.0 - Production
Start Date 14-DEC-2008 12:27:22
Uptime 0 days 0 hr. 11 min. 22 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/listener.ora
Listener Log File /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.xxx.xxx.xxx)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XE_XPT" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully


# listener.ora Network Configuration File:
=======================
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)


# tnsnames.ora Network Configuration File:
=========================
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Re: Oracle XE browser homepage not opening [message #375829 is a reply to message #375802] Mon, 15 December 2008 01:26 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Is your database started and are you using the correct port? To confirm, please post the output of the follwoing SQL (use the sqlplus utility):

select dbms_xdb.getHttpPort() from dual;
Re: Oracle XE browser homepage not opening [message #375903 is a reply to message #375829] Mon, 15 December 2008 05:24 Go to previous messageGo to next message
swiftguy121
Messages: 4
Registered: December 2008
Junior Member

Frank:
Thanks for responding to my query.

As instructed executed the following command .. output is as follows

SQL> select dbms_xdb.getHttpPort() from dual;

DBMS_XDB.GETHTTPPORT()
----------------------
                  8080



So the port is 8080.

In the lsnctrl command output.. there is some interesting info

...
...
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

...
...



Is this info of any use ?



# Alternatively if I want to manage the database from commandline ..what is the tool to be used (any specific command line access to the database apart from SQLPlus?)

# How do i unlock 'hr' database from commandline?

Re: Oracle XE browser homepage not opening [message #375904 is a reply to message #375903] Mon, 15 December 2008 05:30 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
SQL*Plus is the official command line tool. To unlock HR:
SQL> ALTER USER hr ACCOUNT UNLOCK;


The UNKNOWN is not relevant to your problem. See "What does UNKNOWN status mean in lsnrctl status output?" in the SQL*Net FAQ.
Re: Oracle XE browser homepage not opening [message #375914 is a reply to message #375904] Mon, 15 December 2008 06:14 Go to previous messageGo to next message
swiftguy121
Messages: 4
Registered: December 2008
Junior Member
Frank Naude wrote on Mon, 15 December 2008
The UNKNOWN is not relevant to your problem. See "What does UNKNOWN status mean in lsnrctl status output?" in the [url=/wiki/SQL*Net_FAQ
SQL*Net FAQ[/url].




Read SQL Net FAQ .. according to this if there is unknown status in lsnctrl output .. then we can use a local listener i.e

alter system set LOCAL_LISTENER="(address=(protocol=tcp)(host=yourhost)(port=1522))" SCOPE=SPFILE;


note that the port here is changed to '1522' .. is this a possible solution to my oracle access through web browser?

Re: Oracle XE browser homepage not opening [message #375923 is a reply to message #375914] Mon, 15 December 2008 06:27 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
It is just an example. And, no, it will not solve your problem.
Re: Oracle XE browser homepage not opening [message #376119 is a reply to message #375923] Tue, 16 December 2008 02:44 Go to previous message
swiftguy121
Messages: 4
Registered: December 2008
Junior Member
The problem could be solved by implementing the following from the SQL Plus


connect sys/passw@alias as sysdba
EXEC DBMS_XDB.SETHTTPPORT(8080);
COMMIT;

[Updated on: Tue, 16 December 2008 02:46]

Report message to a moderator

Previous Topic: PCC-F-NOERRFILE, unable to open error message file, facility PR2
Next Topic: Oracle installation on Suse Linux
Goto Forum:
  


Current Time: Fri Mar 29 05:12:34 CDT 2024