Oracle Database Discussions

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)
)
)