solaris10下oracle10g 监听器启动问题

brucebo

bash-3.00$ lsnrctl status的输出
LSNRCTL for Solaris: Version 10.2.0.2.0 - Production on 14-NOV-2006 11:04:14

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Solaris Error: 146: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DB)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Solaris Error: 146: Connection refused

bash-3.00$ lsnrctl start

LSNRCTL for Solaris: Version 10.2.0.2.0 - Production on 13-NOV-2006 17:02:14

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

Starting /export/home/oracle/product/10.0/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 10.2.0.2.0 - Production
System parameter file is /export/home/oracle/product/10.0/network/admin/listener.ora
Log messages written to /export/home/oracle/product/10.0/network/log/listener.log
Error listening on: (DEscript_ION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
  TNS-00516: Permission denied
   Solaris Error: 13: Permission denied

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

我的环境变量:
DISPLAY=192.168.1.10
ORACLE_BASE=/export/home/oracle
ORACLE_HOME=/export/home/oracle/product/10.0
ORACLE_SID=orcl
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
PATH=$ORACLE_HOME/bin:/bin:/sbin:/usr/ccs/bin:/usr/local/bin
LD_LIBRARY_PATH=$ORACLE_HOME/libORACLE_HOME/network/lib:/usr/local/lib:/usr/lib
TMPDIR=/var/tmp
export DISPLAY ORACLE_BASE ORACLE_HOME ORACLE_SID NLS_LANG PATH LD_LIBRARY_PATH TMPDIR

listener.ora 文件
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /export/home/oracle/product/10.0)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = DB)(PORT = 1521))
    )
  )
tnsnames.ora 文件
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = socDB)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

vi /etc/hosts
127.0.0.1       localhost
192.168.1.10      DB   loghost


网上说的 直接写ip和日志文件太大，都不是问题的关键，希望各位大侠帮帮忙。

numenhuang

原帖由 brucebo 于 2006-11-14 15:09 发表
bash-3.00$ lsnrctl status的输出
LSNRCTL for Solaris: Version 10.2.0.2.0 - Production on 14-NOV-2006 11:04:14

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

Connecting to (DESCRIPTIO ...

ls -altr /var/tmp
or
ls -ltr /var/tmp/.oracle

结果

brucebo

bash-3.00$ ls -alt /var/tmp/.oracle/

drwxrwxrwt  21 root     sys         3584 11ÔÂ 14ÈÕ 14:23 ..
drwxrwxrwt   2 root     dba          512 11ÔÂ 11ÈÕ 09:24 .
srwxrwxrwx   1 100      dba            0 11ÔÂ 11ÈÕ 09:24 s#833.1
srwxrwxrwx   1 100      dba            0 11ÔÂ 11ÈÕ 09:24 sEXTPROC1
srwxrwxrwx   1 100      dba            0 11ÔÂ 10ÈÕ 14:18 s#835.1
srwxrwxrwx   1 100      dba            0 11ÔÂ 10ÈÕ 10:55 s#16064.1
srwxrwxrwx   1 100      dba            0 11Ô  9ÈÕ 15:42 s#3848.1
srwxrwxrwx   1 100      dba            0 11Ô  9ÈÕ 13:08 s#4096.1
bash-3.00$

numenhuang

原帖由 brucebo 于 2006-11-14 15:49 发表
bash-3.00$ ls -alt /var/tmp/.oracle/

drwxrwxrwt  21 root     sys         3584 11ÔÂ 14ÈÕ 14:23 ..
drwxrwxrwt   2 root     dba          512 11ÔÂ 11È& ...

cd /var/tmp
chown -R oracle:dba .oracle
或者
chmod -R 777 .oracle

brucebo

英雄，好用了，能告诉我是什么原因吗？ 我加了你的msn，希望你拜你为师，好好学习

numenhuang

原帖由 brucebo 于 2006-11-14 15:59 发表
英雄，好用了，能告诉我是什么原因吗？ 我加了你的msn，希望你拜你为师，好好学习

启动listener的时候，会在/var/tmp/.oracle目录下创建IPC socket file，你的目录权限有问题，估计是没有正确按照安装步骤来作的。

lmtok

呵呵，数据库安装得真有点问题或者是有人不小心修改过目录权限，不然不会出目录权限的问题