第一次接触oracle，启动失败，帮忙一下，谢谢了

zdl801

我是redhat ES 5 下载的是oracle 10g

下载的是oracle-xe-univ-10.2.0.1-1.0.i386.rpm
然后运行 rpm -ivh oracle-xe-univ-10.2.0.1-1.0.i386.rpm安装
然后/etc/init.d/oracle-xe configure根据提示配置了，端口都直接回车默认。

在/etc/profile  加了export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

启动的时候报错：
[root@mh bin]# ./lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 11-SEP-2007 00:17:22

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

Starting /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
NL-00280: error creating log stream /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
NL-00278: cannot open log file
  SNL-00016: snlfohd: error opening file
   Linux Error: 13: Permission denied

Listener failed to start. See the error message(s) above...

zdl801

/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log的内容是这样的：


[root@mh log]# more listener.log

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 10-SEP-2007 23:26:42

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

System parameter file is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/lis
tener.ora
Log messages written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listen
er.log
Trace information written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/trace
/listener.trc
Trace level is currently 0

Started with pid=2915
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mh.localdomain)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
  TNS-00515: Connect failed because target host or object does not exist

No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))

TNSLSNR for Linux: Version 10.2.0.1.0 - Production on 10-SEP-2007 23:56:10

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

System parameter file is /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/lis
tener.ora
Log messages written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listen
er.log
Trace information written to /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/trace
/listener.trc
Trace level is currently 0

Started with pid=2313
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mh.localdomain)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
TNS-12560: TNS:protocol adapter error
  TNS-00515: Connect failed because target host or object does not exist

zdl801

晕了，没人帮忙一下吗，

是不是和我改名有关系呢，我把计算机改成mh

HOST=mh.localdomain也没错吧，我改成localhost 重新启动可以监听，但是手动关闭，又要启动监听器，又报错，晕死了

大大乎乎

把mh.locald改成你机器的IP地址吧，这样最好使

numenhuang

cat /etc/hosts
内容