listener (1521) and web interface (8080) doesnt start after install RHES3
519184Jun 20 2006 — edited Jun 21 2006installed according to install guide on Redhat ES 3 (as root)
after install the database starts and sqlplus works.
for example i added remote access to the HTTP:
SQL> EXEC DBMS_XDB.SETLISTENERLOCALACCESS(FALSE);
PL/SQL procedure successfully completed.
but i cannot access web or listener.
i see some references to SElinux to resolve this problem, but as far as i can tell no SElinux is installed (not included in RHES3? /etc/selinux does not exist). iptables are also disabled. i list open ports and they are not there (shuld be even if iptables was enabled).
this is the error message i get when starting lsnrctl as oracle:
-bash-2.05b$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 20-JUN-2006 16:35:50
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: please wait...
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
TNS-00507: Connection closed
Linux Error: 29: Illegal seek
other important information after /etc/init.d/oracle-xe start is run:
----------------------------------------------------------------
root@nemo ~]# ps ax|grep xe_
4985 ? S 0:00 xe_pmon_XE
4987 ? S 0:00 xe_psp0_XE
4989 ? S 0:00 xe_mman_XE
4991 ? S 0:00 xe_dbw0_XE
4993 ? S 0:00 xe_lgwr_XE
4995 ? S 0:00 xe_ckpt_XE
4997 ? S 0:00 xe_smon_XE
4999 ? S 0:00 xe_reco_XE
5001 ? S 0:00 xe_cjq0_XE
5003 ? S 0:00 xe_mmon_XE
5005 ? S 0:00 xe_mmnl_XE
5007 ? S 0:00 xe_d000_XE
5009 ? S 0:00 xe_s000_XE
5011 ? S 0:00 xe_s001_XE
5013 ? S 0:00 xe_s002_XE
5015 ? S 0:00 xe_s003_XE
5021 ? S 0:00 xe_qmnc_XE
5027 ? S 0:00 xe_q000_XE
5029 ? S 0:00 xe_q001_XE
[root@nemo ~]# cat /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/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 = nemo.bulocal.net)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
[root@nemo ~]# nmap -p1-9000 localhost
Port State Service
21/tcp open ftp
22/tcp open ssh
25/tcp open smtp
111/tcp open sunrpc
199/tcp open smux
6000/tcp open X11
7210/tcp open unknown
7269/tcp open unknown
[root@nemo ~]# cat /etc/hosts|grep localhost
127.0.0.1 nemo.bulocal.net nemo localhost.localdomain localhost
[root@nemo ~]# ping nemo.bulocal.net
PING nemo.bulocal.net (127.0.0.1) 56(84) bytes of data.
64 bytes from nemo.bulocal.net (127.0.0.1): icmp_seq=0 ttl=0 time=0.032 ms
[root@nemo ~]# tnsping nemo.bulocal.net
TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 20-JUN-2006 16:38:42
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
TNS-12541: TNS:no listener
[root@nemo ~]# cat /etc/sysconfig/oracle-xe
#This is a configuration file for automatic starting of the Oracle
#Database and listener at system startup.It is generated By running
#'/etc/init.d/oracle-xe configure'.Please use that method to modify this
#file
# ORACLE_DBENABLED:'true' means to load the Database at system boot.
ORACLE_DBENABLED=true
# LISTENER_PORT: Database listener
LISTENER_PORT=1521
# HTTP_PORT : HTTP port for Oracle Application Express
HTTP_PORT=8080
# Configuration : Check whether configure has been done or not
CONFIGURE_RUN=true
[root@nemo ~]# sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
kernel.sysrq = 0
kernel.core_uses_pid = 1
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000