oracle 9i 启动监听报错误 TNS-12555: TNS:permission denied 解决

前端之家收集整理的这篇文章主要介绍了oracle 9i 启动监听报错误 TNS-12555: TNS:permission denied 解决前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

启动监听报错误如下:

Copyright (c) 1991,2006,Oracle Corporation. All rights reserved.


Starting /u01/app/oracle/ora9/9.2.0.8/db_1/bin/tnslsnr: please wait...


TNSLSNR for Linux: Version 9.2.0.8.0 - Production
System parameter file is /u01/app/oracle/ora9/9.2.0.8/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/ora9/9.2.0.8/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=redhat48)(PORT=1521)))
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12555: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00525: Insufficient privilege for operation
Linux Error: 1: Operation not permitted

通过strace -Ff -o /tmp/listener.log lsnrctl start 跟踪日志分析

4772 chmod("/var/tmp/.oracle",01777) = -1 EPERM (Operation not permitted)
4772 socket(PF_FILE,SOCK_STREAM,0) = 9
4772 getpid() = 4772
4772 access("/var/tmp/.oracle/s#4772.1",F_OK) = -1 ENOENT (No such file or directory)
4772 bind(9,{sa_family=AF_FILE,path="/var/tmp/.oracle/s#4772.1"},110) = 0
4772 chmod("/var/tmp/.oracle/s#4772.1",0777) = 0
4772 listen(9,100) = 0
4772 getsockname(9,[20495583936540]) = 0
4772 chmod("/var/tmp/.oracle/s#4772.1",0777) = 0
4772 fcntl(9,F_SETFD,FD_CLOEXEC) = 0
4772 rt_sigaction(SIGPIPE,{SIG_IGN},8) = 0
4772 socket(PF_FILE,0) = 10
4772 access("/var/tmp/.oracle/sEXTPROC",F_OK) = 0
4772 bind(10,path="/var/tmp/.oracle/sEXTPROC"},110) = -1 EADDRINUSE (Address already in use)
4772 connect(10,110) = -1 ECONNREFUSED (Connection refused)
4772 access("/var/tmp/.oracle/sEXTPROC",F_OK) = 0
4772 unlink("/var/tmp/.oracle/sEXTPROC") = -1 EPERM (Operation not permitted)
4772 close(10) = 0

处理方法 通过注释listener.ora 参数中的extproc,启动监听正常。

解决过程如下:

ora9@redhat48 bin]$ lsnrctl start LSNRCTL for Linux: Version 9.2.0.8.0 - Production on 28-MAR-2017 10:01:14 Copyright (c) 1991,Oracle Corporation. All rights reserved. Starting /u01/app/oracle/ora9/9.2.0.8/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 9.2.0.8.0 - Production System parameter file is /u01/app/oracle/ora9/9.2.0.8/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/ora9/9.2.0.8/db_1/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=redhat48)(PORT=1521))) Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) 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... [ora9@redhat48 bin]$ vi /tmp/listener.log 4770 execve("/u01/app/oracle/ora9/9.2.0.8/db_1/bin/lsnrctl",["lsnrctl","start"],[/* 24 vars */]) = 0 4770 uname({sys="Linux",node="redhat48",...}) = 0 4770 brk(0) = 0x6b1000 4770 mmap(NULL,4096,PROT_READ|PROT_WRITE,MAP_PRIVATE|MAP_ANONYMOUS,-1,0) = 0x2a95556000 4770 access("/etc/ld.so.preload",R_OK) = -1 ENOENT (No such file or directory) 4770 open("/u01/app/oracle/ora9/9.2.0.8/db_1/lib/tls/x86_64/libclntsh.so.9.0",O_RDONLY) = -1 ENOENT (No such file or directory) 4770 stat("/u01/app/oracle/ora9/9.2.0.8/db_1/lib/tls/x86_64",0x7fbfffee00) = -1 ENOENT (No such file or directory) 4770 open("/u01/app/oracle/ora9/9.2.0.8/db_1/lib/tls/libclntsh.so.9.0",O_RDONLY) = -1 ENOENT (No such file or directory) 4770 stat("/u01/app/oracle/ora9/9.2.0.8/db_1/lib/tls",0x7fbfffee00) = -1 ENOENT (No such file or directory) 4770 open("/u01/app/oracle/ora9/9.2.0.8/db_1/lib/x86_64/libclntsh.so.9.0",O_RDONLY) = -1 ENOENT (No such file or directory) 4770 stat("/u01/app/oracle/ora9/9.2.0.8/db_1/lib/x86_64",0x7fbfffee00) = -1 ENOENT (No such file or directory) 4770 open("/u01/app/oracle/ora9/9.2.0.8/db_1/lib/libclntsh.so.9.0",O_RDONLY) = 3 4770 read(3,"\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0P;\25\0\0\0\0\0"...,832) = 832 4770 fstat(3,{st_mode=S_IFREG|0755,st_size=13386484,...}) = 0 4770 mmap(NULL,13576392,PROT_READ|PROT_EXEC,MAP_PRIVATE|MAP_DENYWRITE,3,0) = 0x2a95557000 4770 mprotect(0x2a960d8000,1513672,PROT_NONE) = 0 4770 mmap(0x2a961d7000,393216,MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE,0xb80000) = 0x2a961d7000 4770 mmap(0x2a96237000,75976,MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS,0) = 0x2a96237000 4770 close(3) = 0 "/tmp/listener.log" 716L,49482C 4772 fstat(8,{st_mode=S_IFREG|0644,st_size=171,...}) = 0 4772 mmap(NULL,0) = 0x2a969e3000 4772 read(8,"# Do not remove the following li"...,4096) = 171 4772 close(8) = 0 4772 munmap(0x2a969e3000,4096) = 0 4772 getpid() = 4772 4772 open("/etc/hosts",O_RDONLY) = 8 4772 fcntl(8,F_GETFD) = 0 4772 fcntl(8,FD_CLOEXEC) = 0 4772 fstat(8,4096) = 0 4772 socket(PF_INET,IPPROTO_IP) = 8 4772 setsockopt(8,SOL_SOCKET,SO_REUSEADDR,[1],4) = 0 4772 uname({sys="Linux",...}) = 0 4772 open("/etc/hosts",O_RDONLY) = 9 4772 fcntl(9,F_GETFD) = 0 4772 fcntl(9,FD_CLOEXEC) = 0 4772 fstat(9,0) = 0x2a969e3000 4772 read(9,4096) = 171 4772 close(9) = 0 4772 munmap(0x2a969e3000,4096) = 0 4772 bind(8,{sa_family=AF_INET,sin_port=htons(1521),sin_addr=inet_addr("0.0.0.0")},16) = 0 4772 listen(8,128) = 0 4772 getsockname(8,[253403070480]) = 0 4772 getpeername(8,0x7fbfff9720,[253403070480]) = -1 ENOTCONN (Transport endpoint is not connected) 4772 uname({sys="Linux",4096) = 0 4772 fcntl(8,FD_CLOEXEC) = 0 4772 rt_sigaction(SIGPIPE,8) = 0 4772 uname({sys="Linux",4096) = 0 4772 lseek(6,19456,SEEK_SET) = 19456 4772 read(6,"\21\0+\4\0\0n\0.\4\0\0\211\0/\4\0\0\246\0000\4\0\0\266\0001\4\0\0\304\0"...,512) = 512 4772 lseek(3,SEEK_CUR) = 24651 4772 write(3,"Listening on: (DESCRIPTION=(ADDR"...,79) = 79 4772 access("/var/tmp/.oracle",F_OK) = 0 4772 chmod("/var/tmp/.oracle",01777) = -1 EPERM (Operation not permitted) 4772 socket(PF_FILE,0) = 9 4772 getpid() = 4772 4772 access("/var/tmp/.oracle/s#4772.1",F_OK) = -1 ENOENT (No such file or directory) 4772 bind(9,110) = 0 4772 chmod("/var/tmp/.oracle/s#4772.1",0777) = 0 4772 listen(9,100) = 0 4772 getsockname(9,[20495583936540]) = 0 4772 chmod("/var/tmp/.oracle/s#4772.1",0777) = 0 4772 fcntl(9,8) = 0 4772 socket(PF_FILE,0) = 10 4772 access("/var/tmp/.oracle/sEXTPROC",F_OK) = 0 4772 bind(10,110) = -1 EADDRINUSE (Address already in use) 4772 connect(10,110) = -1 ECONNREFUSED (Connection refused) 4772 access("/var/tmp/.oracle/sEXTPROC",F_OK) = 0 4772 unlink("/var/tmp/.oracle/sEXTPROC") = -1 EPERM (Operation not permitted) 4772 close(10) = 0 4772 lseek(6,SEEK_CUR) = 24730 4772 write(3,"Error listening on: (DESCRIPTION"...,72) = 72 [ora9@redhat48 bin]$ cd $ORACLE_HOME/network/admin [ora9@redhat48 admin]$ ls libnk59.def listener.ora samples shrept.lst snmp_ro.ora sqlnet.log sqlnet.ora sqlnet.ora.1 [ora9@redhat48 admin]$ vi listener.ora # LISTENER.ORA Network Configuration File: /u01/app/oracle/ora9/9.2.0.8/db_1/network/admin/listener.ora # Generated by Oracle configuration tools. SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oracle/ora9/9.2.0.8/db_1) # (PROGRAM = extproc) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = redhat48)(PORT = 1521) (IP=FIRST)) ) (ADDRESS_LIST = # (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) ) ) "listener.ora" 24L,576C written [ora9@redhat48 admin]$ lsnrctl start LSNRCTL for Linux: Version 9.2.0.8.0 - Production on 28-MAR-2017 10:04:02 Copyright (c) 1991,Oracle Corporation. All rights reserved. Starting /u01/app/oracle/ora9/9.2.0.8/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 9.2.0.8.0 - Production System parameter file is /u01/app/oracle/ora9/9.2.0.8/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/ora9/9.2.0.8/db_1/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=redhat48)(PORT=1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=redhat48)(PORT=1521)(IP=FIRST))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 9.2.0.8.0 - Production Start Date 28-MAR-2017 10:04:02 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /u01/app/oracle/ora9/9.2.0.8/db_1/network/admin/listener.ora Listener Log File /u01/app/oracle/ora9/9.2.0.8/db_1/network/log/listener.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=redhat48)(PORT=1521))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc",status UNKNOWN,has 1 handler(s) for this service... The command completed successfully

原文链接:https://www.f2er.com/oracle/209904.html

猜你在找的Oracle相关文章