Linux Error:111:Connection refused & Linux Error:29:Illegal seek
755562Feb 22 2010 — edited Oct 7 2011I have installed the rpm pack oracle-xe-univ-10.2.0.1-1.0.i386.rpm in Red Hat Enterprise Linux. I was able to install the rpm pack and am able to initiat sqlplus on the server and even run sql queries.
However i am facing the following issues:-
1) While browsing http://127.0.0.1:8090/apex for accessing the database home page i am getting the error message "The connection was refused when connecting to http://127.0.0.1:8090/apex" (i have mentioned 8090 as the HTTP port during configuration and this is the URL which was listed after the configuration).
2) I am unable to start the listerner service.
Please help me to resolve the above issues.
Following is the message while checking the listener status:-_
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=RHL-Research-001)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Following is the message while initiating a listener:-_
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=RHL-Research-001)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Following is the content of the listerner.ora file:-_
[root@RHL-Research-001 admin]# cat listener.ora
# 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 = RHL-Research-001)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
Following is the content of /etc/hosts:-_
[root@RHL-Research-001 admin]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 RHL-Research-001 localhost.localdomain localhost
[root@RHL-Research-001 admin]#
Following is the pinging status:-_
[root@RHL-Research-001 admin]# ping RHL-Research-001
PING RHL-Research-001 (127.0.0.1) 56(84) bytes of data.
64 bytes from RHL-Research-001 (127.0.0.1): icmp_seq=0 ttl=0 time=0.050 ms
64 bytes from RHL-Research-001 (127.0.0.1): icmp_seq=1 ttl=0 time=0.049 ms
64 bytes from RHL-Research-001 (127.0.0.1): icmp_seq=2 ttl=0 time=0.051 ms
64 bytes from RHL-Research-001 (127.0.0.1): icmp_seq=3 ttl=0 time=0.052 ms
64 bytes from RHL-Research-001 (127.0.0.1): icmp_seq=4 ttl=0 time=0.050 ms
64 bytes from RHL-Research-001 (127.0.0.1): icmp_seq=5 ttl=0 time=0.046 ms
64 bytes from RHL-Research-001 (127.0.0.1): icmp_seq=6 ttl=0 time=0.051 ms
--- RHL-Research-001 ping statistics ---
7 packets transmitted, 7 received, 0% packet loss, time 6016ms
rtt min/avg/max/mdev = 0.046/0.049/0.052/0.009 ms, pipe 2
Thanks,
SKP