IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    TNS-00525: Insufficient privilege for operation 11g 监听启动报错

    admin发表于 2015-07-31 05:25:12
    love 0

    启动监听程序出现错误 TNS:permission denied
    1、启动
    [oracle@test admin]$ lsnrctl start
    LSNRCTL for Linux: Version 10.2.0.1.0 – Production on 16-JUL-2009 17:40:44
    Copyright (c) 1991, 2005, Oracle. All rights reserved.
    Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait…
    TNSLSNR for Linux: Version 10.2.0.1.0 – Production
    System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
    Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
    Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test)(PORT=1521)))
    Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
    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…
    [oracle@test admin]$
    2、检查/tmp/.oracle的权限,发现不正确
    [root@test tmp]# ls -al
    total 104
    …
    drwxrwxrwt 2 root root 4096 Jul 16 14:53 .oracle
    …
    [root@test tmp]# chown -R oracle.oinstall /tmp/.oracle
    [root@test tmp]#
    3、再次启动还是报错,于是检查/var/tmp/.oracle 权限,发现也有问题
    [root@test tmp]# ll /var/tmp/.oracle
    total 0
    srwxrwxrwx 1 501 oinstall 0 Apr 26 20:40 s#13042.1
    srwxrwxrwx 1 501 oinstall 0 Apr 26 20:40 s#13042.2
    srwxrwxrwx 1 501 oinstall 0 Jul 1 16:13 s#20818.1
    srwxrwxrwx 1 501 oinstall 0 Jul 1 16:13 s#20818.2
    srwxrwxrwx 1 501 oinstall 0 Oct 9 2008 s#4165.1
    srwxrwxrwx 1 501 oinstall 0 Oct 9 2008 s#4165.2
    srwxrwxrwx 1 501 oinstall 0 Apr 26 22:38 s#4433.1
    srwxrwxrwx 1 501 oinstall 0 Apr 26 22:38 s#4433.2
    srwxrwxrwx 1 501 oinstall 0 Apr 28 2008 s#5366.1
    srwxrwxrwx 1 501 oinstall 0 Apr 28 2008 s#5366.2
    srwxrwxrwx 1 501 oinstall 0 Mar 23 2008 s#5756.1
    srwxrwxrwx 1 501 oinstall 0 Mar 23 2008 s#5756.2
    srwxrwxrwx 1 501 oinstall 0 Nov 29 2007 s#6842.1
    srwxrwxrwx 1 501 oinstall 0 Nov 29 2007 s#6842.2
    srwxrwxrwx 1 501 oinstall 0 Jun 29 11:18 stestDBG_CSSD
    srwxrwxrwx 1 501 oinstall 0 Oct 9 2008 sEXTPROC0
    srwxrwxrwx 1 501 oinstall 0 Jun 29 11:18 sOCSSD_LL_test_localhost
    srwxrwxrwx 1 501 oinstall 0 Jun 29 11:18 sOracle_CSS_LclLstnr_localhost_0
    [root@test tmp]# cd ..
    [root@test /]# chown -R oracle.oinstall /var/tmp/.oracle
    再次启动,OK
     



沪ICP备19023445号-2号
友情链接