【问题现象】
lsnrctl startLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 23-FEB-2012 15:21:21
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Starting /opt/oracle/product/11g//bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /opt/oracle/product/11g/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/oracle/listener/alert/log.xml
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted
Listener failed to start. See the error message(s) above...
【问题分析和解决】
从上面的错误来看,应该是对应的权限操作的问题,经了解,是关于/var/tmp目录下的.oracle文件权限因为.oracle是隐藏文件,所以要使用 ls -al命令
[oracle@oracle tmp]$ ls -al
查看/var/tmp目录下的所有文件,使用root 用户对.oracle文件赋权限
chmod 777 /var/tmp/.oracle
然后启动oracle数据库就好了
启动命令如下:
用 oracle用户登录(或su - oracle)
lsnrctl start
sqlplus / as sysdba
startup
exit