ORACLE SOS-故障诊断-ORACLE运维管理-TNS-12555: TNS:permission denied

xifenfei 发表于 2014-5-8 16:42:57

TNS-12555: TNS:permission denied

单机使用asm，启动监听报错$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 08-MAY-2014 16:26:09

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

Starting /u01/app/grid/product/11.2.0/grid/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /u01/app/grid/product/11.2.0/grid/network/admin/listener.ora
Log messages written to /u01/app/grid/diag/tnslsnr/q9ogg01/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=q9ogg01.xifenfei.com)(PORT=1521)))
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...这里提示数据库启动监听报错，而报错信息是TNS-12555: TNS:permission denied

xifenfei 发表于 2014-5-8 16:45:02

对启动过程做strace$ strace lsnrctl start
execve("/u01/app/grid/product/11.2.0/grid/bin/lsnrctl", ["lsnrctl", "start"], [/* 31 vars */]) = 0
brk(0)                               = 0x7e8000
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8eff96000
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8eff95000
access("/etc/ld.so.preload", R_OK)    = -1 ENOENT (No such file or directory)
open("/u01/app/grid/product/11.2.0/grid/lib/tls/x86_64/libclntsh.so.11.1", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/u01/app/grid/product/11.2.0/grid/lib/tls/x86_64", 0x7fff9ded6cc0) = -1 ENOENT (No such file or directory)
open("/u01/app/grid/product/11.2.0/grid/lib/tls/libclntsh.so.11.1", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/u01/app/grid/product/11.2.0/grid/lib/tls", 0x7fff9ded6cc0) = -1 ENOENT (No such file or directory)
open("/u01/app/grid/product/11.2.0/grid/lib/x86_64/libclntsh.so.11.1", O_RDONLY) = -1 ENOENT (No such file or directory)
stat("/u01/app/grid/product/11.2.0/grid/lib/x86_64", 0x7fff9ded6cc0) = -1 ENOENT (No such file or directory)
open("/u01/app/grid/product/11.2.0/grid/lib/libclntsh.so.11.1", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\260\325G\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0640, st_size=53793394, ...}) = 0
mmap(NULL, 44471752, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fe8ed52b000
mprotect(0x7fe8efba9000, 2093056, PROT_NONE) = 0
mmap(0x7fe8efda8000, 1855488, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x267d000) = 0x7fe8efda8000
mmap(0x7fe8eff6d000, 161224, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fe8eff6d000
close(3)                            = 0
open("/u01/app/grid/product/11.2.0/grid/lib/libnnz11.so", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\0\326\4\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0640, st_size=7996693, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8ed52a000
mmap(NULL, 3983936, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fe8ed15d000
mprotect(0x7fe8ed3e7000, 1044480, PROT_NONE) = 0
mmap(0x7fe8ed4e6000, 270336, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x289000) = 0x7fe8ed4e6000
mmap(0x7fe8ed528000, 6720, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fe8ed528000
close(3)                            = 0
open("/u01/app/grid/product/11.2.0/grid/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/etc/ld.so.cache", O_RDONLY)    = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=151979, ...}) = 0
mmap(NULL, 151979, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7fe8ed137000
close(3)                            = 0
open("/lib64/libdl.so.2", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\20\16\340H4\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=23360, ...}) = 0
mmap(0x3448e00000, 2109696, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3448e00000
mprotect(0x3448e02000, 2097152, PROT_NONE) = 0
mmap(0x3449002000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x3449002000
close(3)                            = 0
open("/u01/app/grid/product/11.2.0/grid/lib/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib64/libm.so.6", O_RDONLY)    = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0`>\240H4\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=615136, ...}) = 0
mmap(0x3448a00000, 2629848, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3448a00000
mprotect(0x3448a82000, 2093056, PROT_NONE) = 0
mmap(0x3448c81000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x81000) = 0x3448c81000
close(3)                            = 0
open("/u01/app/grid/product/11.2.0/grid/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib64/libpthread.so.0", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\340W`I4\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=145872, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8ed136000
mmap(0x3449600000, 2204528, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3449600000
mprotect(0x3449616000, 2093056, PROT_NONE) = 0
mmap(0x3449815000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x15000) = 0x3449815000
mmap(0x3449817000, 13168, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3449817000
close(3)                            = 0
open("/u01/app/grid/product/11.2.0/grid/lib/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib64/libnsl.so.1", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\240@\340O4\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=114352, ...}) = 0
mmap(0x344fe00000, 2194096, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x344fe00000
mprotect(0x344fe15000, 2093056, PROT_NONE) = 0
mmap(0x3450014000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x14000) = 0x3450014000
mmap(0x3450016000, 6832, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3450016000
close(3)                            = 0
open("/u01/app/grid/product/11.2.0/grid/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/lib64/libc.so.6", O_RDONLY)    = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\220\332aH4\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=1722328, ...}) = 0
mmap(0x3448600000, 3502424, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3448600000
mprotect(0x344874f000, 2093056, PROT_NONE) = 0
mmap(0x344894e000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x14e000) = 0x344894e000
mmap(0x3448953000, 16728, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3448953000
close(3)                            = 0
open("/u01/app/grid/product/11.2.0/grid/lib/libaio.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/u01/app/grid/product/11.2.0/grid/lib/libaio.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/lib64/libaio.so.1", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\20\5\0\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=3768, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8ed135000
mmap(NULL, 2099744, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fe8ecf34000
mprotect(0x7fe8ecf35000, 2093056, PROT_NONE) = 0
mmap(0x7fe8ed134000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0) = 0x7fe8ed134000
close(3)                            = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8ecf33000
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8ecf32000
arch_prctl(ARCH_SET_FS, 0x7fe8ecf326e0) = 0
mprotect(0x344894e000, 16384, PROT_READ) = 0
mprotect(0x3450014000, 4096, PROT_READ) = 0
mprotect(0x3449815000, 4096, PROT_READ) = 0
mprotect(0x3448c81000, 4096, PROT_READ) = 0
mprotect(0x3449002000, 4096, PROT_READ) = 0
mprotect(0x344841c000, 4096, PROT_READ) = 0
munmap(0x7fe8ed137000, 151979)       = 0
set_tid_address(0x7fe8ecf32770)       = 18425
set_robust_list(0x7fe8ecf32780, 0x18) = 0
futex(0x7fff9ded781c, FUTEX_WAKE_PRIVATE, 1) = 0
rt_sigaction(SIGRTMIN, {0x34496053c0, [], SA_RESTORER|SA_SIGINFO, 0x344960ebe0}, NULL, 8) = 0
rt_sigaction(SIGRT_1, {0x34496052f0, [], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x344960ebe0}, NULL, 8) = 0
rt_sigprocmask(SIG_UNBLOCK, , NULL, 8) = 0
getrlimit(RLIMIT_STACK, {rlim_cur=8192*1024, rlim_max=RLIM_INFINITY}) = 0
brk(0)                               = 0x7e8000
brk(0x809000)                         = 0x809000
uname({sys="Linux", node="q9ogg01.xifenfei.com", ...}) = 0
mmap(NULL, 143360, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8ed13a000
futex(0x34490030ec, FUTEX_WAKE_PRIVATE, 2147483647) = 0
open("/u01/app/grid/product/11.2.0/grid/lib/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/u01/app/grid/product/11.2.0/grid/lib/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/u01/app/grid/product/11.2.0/grid/nls/data/lx1boot.nlb", O_RDONLY) = 3
read(3, "\0\0\0\3\0\4 \v\260W\0\0\230\363\216\0\0\0\0\0\1\0E\0\276\0\304\1\32\2,\2"..., 48) = 48
read(3, "\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 22400) = 22400
close(3)                            = 0
open("/u01/app/grid/product/11.2.0/grid/nls/data/lx00001.nlb", O_RDONLY) = 3
read(3, "\0\0\0\3\0\4 \v\267\3\0\0s\2\0\0\0\0\0\0\0\0\0\0\0Z\1\0\0\0\0\0"..., 92) = 92
read(3, "\3\0\0\0\1\0\1\0\1\0`\0\0\0\4\0\6\0\10\0\n\0\20\0\30\0 \0(\0000\0"..., 859) = 859
close(3)                            = 0
open("/u01/app/grid/product/11.2.0/grid/nls/data/lx20001.nlb", O_RDONLY) = 3
read(3, "\0\0\0\3\0\4 \v9\33\0\0\215\21\0\0\0\0\0\0\2\0\0\0\0Z\1\0\0\0\0\0"..., 92) = 92
read(3, "\1\0\37\0\t\0\2\0\0\0\0\0\0\0\0\0\0\0?\0\0\0\0\1\0\0\0\0\0\0\0\0"..., 6877) = 6877
close(3)                            = 0
open("/u01/app/grid/product/11.2.0/grid/nls/data/lx10001.nlb", O_RDONLY) = 3
read(3, "\0\0\0\3\0\4 \vt\4\0\0\220\3\0\0\0\0\0\0\1\0\0\0\0Z\1\0\0\0\0\0"..., 92) = 92
read(3, "\3\0\0\0\1\0\1\0\0\0\0\0\0\0\4\0\1\0\2\0\2\0\1\0\1\0\0\0\0\0\0\0"..., 1048) = 1048
close(3)                            = 0
open("/u01/app/grid/product/11.2.0/grid/nls/data/lx40011.nlb", O_RDONLY) = 3
read(3, "\0\0\0\5\0\4 \vaV\0\0aV\0\0\0\0\0\0\4\0\0\0\0Z\1\0\0\0\0\0"..., 92) = 92
read(3, "\0\0\0\0(\1\0\0,\1\0\0000\1\0\0004\1\0\0<A\0\0TF\0\0TV\0\0"..., 22021) = 22021
close(3)                            = 0
socket(PF_INET6, SOCK_DGRAM, IPPROTO_IP) = 3
bind(3, {sa_family=AF_INET6, sin6_port=htons(0), inet_pton(AF_INET6, "::1", &sin6_addr), sin6_flowinfo=0, sin6_scope_id=0}, 28) = 0
close(3)                            = 0
access("/etc/listener.ora", F_OK)    = -1 ENOENT (No such file or directory)
access("/u01/app/grid/product/11.2.0/grid/network/admin/listener.ora", F_OK) = 0
open("/u01/app/grid/product/11.2.0/grid/network/admin/listener.ora", O_RDONLY) = 3
fcntl(3, F_SETFD, FD_CLOEXEC)       = 0
fstat(3, {st_mode=S_IFREG|0644, st_size=422, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8ed139000
read(3, "# listener.ora Network Configura"..., 4096) = 422
read(3, "", 4096)                   = 0
close(3)                            = 0
munmap(0x7fe8ed139000, 4096)          = 0
stat("/u01/app/grid", {st_mode=S_IFDIR|0775, st_size=4096, ...}) = 0
stat("/u01/app/grid/diag", {st_mode=S_IFDIR|0775, st_size=4096, ...}) = 0
stat("/u01/app/grid/diag/lsnrctl", 0x7fff9ded47d0) = -1 ENOENT (No such file or directory)
stat("/u01/app/grid/product/11.2.0/grid/log", {st_mode=S_IFDIR|0770, st_size=4096, ...}) = 0
stat("/u01/app/grid/product/11.2.0/grid/log/diag", {st_mode=S_IFDIR|0770, st_size=4096, ...}) = 0
stat("/u01/app/grid/product/11.2.0/grid/log/diag/lsnrctl", 0x7fff9ded47d0) = -1 ENOENT (No such file or directory)
stat("/home/grid", {st_mode=S_IFDIR|0700, st_size=4096, ...}) = 0
getuid()                            = 500
socket(PF_FILE, SOCK_STREAM, 0)       = 3
fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0
connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory)
close(3)                            = 0
socket(PF_FILE, SOCK_STREAM, 0)       = 3
fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0
connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory)
close(3)                            = 0
open("/etc/nsswitch.conf", O_RDONLY) = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=1716, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8ed139000
read(3, "#\n# /etc/nsswitch.conf\n#\n# An ex"..., 4096) = 1716
read(3, "", 4096)                   = 0
close(3)                            = 0
munmap(0x7fe8ed139000, 4096)          = 0
open("/u01/app/grid/product/11.2.0/grid/lib/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/etc/ld.so.cache", O_RDONLY)    = 3
fstat(3, {st_mode=S_IFREG|0644, st_size=151979, ...}) = 0
mmap(NULL, 151979, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7fe8ecf0c000
close(3)                            = 0
open("/lib64/libnss_files.so.2", O_RDONLY) = 3
read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\340\37\0\0\0\0\0\0"..., 832) = 832
fstat(3, {st_mode=S_IFREG|0755, st_size=53880, ...}) = 0
mmap(NULL, 2139432, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7fe8ecd01000
mprotect(0x7fe8ecd0b000, 2093056, PROT_NONE) = 0
mmap(0x7fe8ecf0a000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x9000) = 0x7fe8ecf0a000
close(3)                            = 0
mprotect(0x7fe8ecf0a000, 4096, PROT_READ) = 0
munmap(0x7fe8ecf0c000, 151979)       = 0
open("/etc/passwd", O_RDONLY)       = 3
fcntl(3, F_GETFD)                   = 0
fcntl(3, F_SETFD, FD_CLOEXEC)       = 0
fstat(3, {st_mode=S_IFREG|0644, st_size=1687, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8ed139000
read(3, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 1687
close(3)                            = 0
munmap(0x7fe8ed139000, 4096)          = 0
brk(0x82b000)                         = 0x82b000
times({tms_utime=0, tms_stime=0, tms_cutime=0, tms_cstime=0}) = 431233280
open("/u01/app/grid/product/11.2.0/grid/rdbms/mesg/diaus.msb", O_RDONLY) = 3
fcntl(3, F_SETFD, FD_CLOEXEC)       = 0
lseek(3, 0, SEEK_SET)                = 0
read(3, "\25\23\"\1\23\3\t\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 256) = 256
lseek(3, 512, SEEK_SET)             = 512
read(3, "\371\311\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 512) = 512
lseek(3, 1024, SEEK_SET)             = 1024
read(3, "\210\273\353\273\363\273\373\273\4\274\16\274\26\274!\274)\2741\274<\274G\274T\274_\274k\274t\274"..., 192) = 192
brk(0x84f000)                         = 0x84f000
getrlimit(RLIMIT_NOFILE, {rlim_cur=128*1024, rlim_max=128*1024}) = 0
open("/proc/self/fd/", O_RDONLY|O_NONBLOCK|O_DIRECTORY) = 4
fcntl(4, F_SETFD, FD_CLOEXEC)       = 0
getrlimit(RLIMIT_FSIZE, {rlim_cur=RLIM_INFINITY, rlim_max=RLIM_INFINITY}) = 0
open("/etc/localtime", O_RDONLY)    = 5
fstat(5, {st_mode=S_IFREG|0644, st_size=405, ...}) = 0
fstat(5, {st_mode=S_IFREG|0644, st_size=405, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8ed139000
read(5, "TZif2\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\3\0\0\0\3\0\0\0\0"..., 4096) = 405
lseek(5, -240, SEEK_CUR)             = 165
read(5, "TZif2\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\3\0\0\0\3\0\0\0\0"..., 4096) = 240
close(5)                            = 0
munmap(0x7fe8ed139000, 4096)          = 0
fstat(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 7), ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8ed139000
write(1, "\n", 1
)                   = 1
write(1, "LSNRCTL for Linux: Version 11.2."..., 133LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 08-MAY-2014 16:26:22

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

) = 133
access("/u01/app/grid/product/11.2.0/grid/network/admin/sqlnet.ora", F_OK) = 0
open("/u01/app/grid/product/11.2.0/grid/network/admin/sqlnet.ora", O_RDONLY) = 5
fcntl(5, F_SETFD, FD_CLOEXEC)       = 0
fstat(5, {st_mode=S_IFREG|0644, st_size=215, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8ed138000
read(5, "# sqlnet.ora Network Configurati"..., 4096) = 215
read(5, "", 4096)                   = 0
close(5)                            = 0
munmap(0x7fe8ed138000, 4096)          = 0
getrlimit(RLIMIT_NOFILE, {rlim_cur=128*1024, rlim_max=128*1024}) = 0
open("/u01/app/grid/product/11.2.0/grid/lib/libnque11.so", O_RDONLY) = 5
read(5, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0p\24\0\0\0\0\0\0"..., 832) = 832
fstat(5, {st_mode=S_IFREG|0644, st_size=59021, ...}) = 0
mmap(NULL, 1090528, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 5, 0) = 0x7fe8ecbf6000
mprotect(0x7fe8ecc00000, 1044480, PROT_NONE) = 0
mmap(0x7fe8eccff000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 5, 0x9000) = 0x7fe8eccff000
mmap(0x7fe8ecd00000, 992, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7fe8ecd00000
close(5)                            = 0
mmap(NULL, 135168, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8ecf11000
mmap(NULL, 135168, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8ecbd5000
mmap(NULL, 135168, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8ecbb4000
mmap(NULL, 135168, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8ecb93000
mmap(NULL, 528384, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8ecb12000
getuid()                            = 500
open("/etc/passwd", O_RDONLY)       = 5
fcntl(5, F_GETFD)                   = 0
fcntl(5, F_SETFD, FD_CLOEXEC)       = 0
fstat(5, {st_mode=S_IFREG|0644, st_size=1687, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8ed138000
read(5, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 1687
close(5)                            = 0
munmap(0x7fe8ed138000, 4096)          = 0
uname({sys="Linux", node="q9ogg01.xifenfei.com", ...}) = 0
socket(PF_FILE, SOCK_STREAM, 0)       = 5
fcntl(5, F_SETFL, O_RDWR|O_NONBLOCK) = 0
connect(5, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory)
close(5)                            = 0
socket(PF_FILE, SOCK_STREAM, 0)       = 5
fcntl(5, F_SETFL, O_RDWR|O_NONBLOCK) = 0
connect(5, {sa_family=AF_FILE, path="/var/run/nscd/socket"...}, 110) = -1 ENOENT (No such file or directory)
close(5)                            = 0
open("/etc/host.conf", O_RDONLY)    = 5
fstat(5, {st_mode=S_IFREG|0644, st_size=0, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8ed138000
read(5, "", 4096)                   = 0
close(5)                            = 0
munmap(0x7fe8ed138000, 4096)          = 0
futex(0x3448955d44, FUTEX_WAKE_PRIVATE, 2147483647) = 0
open("/etc/resolv.conf", O_RDONLY)    = 5
fstat(5, {st_mode=S_IFREG|0644, st_size=48, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8ed138000
read(5, "nameserver 172.18.19.19\nnameserv"..., 4096) = 48
read(5, "", 4096)                   = 0
close(5)                            = 0
munmap(0x7fe8ed138000, 4096)          = 0
uname({sys="Linux", node="q9ogg01.xifenfei.com", ...}) = 0
open("/etc/hosts", O_RDONLY)          = 5
fcntl(5, F_GETFD)                   = 0
fcntl(5, F_SETFD, FD_CLOEXEC)       = 0
fstat(5, {st_mode=S_IFREG|0644, st_size=220, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8ed138000
read(5, "# Do not remove the following li"..., 4096) = 220
read(5, "", 4096)                   = 0
close(5)                            = 0
munmap(0x7fe8ed138000, 4096)          = 0
open("/etc/hosts", O_RDONLY)          = 5
fcntl(5, F_GETFD)                   = 0
fcntl(5, F_SETFD, FD_CLOEXEC)       = 0
fstat(5, {st_mode=S_IFREG|0644, st_size=220, ...}) = 0
mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8ed138000
read(5, "# Do not remove the following li"..., 4096) = 220
close(5)                            = 0
munmap(0x7fe8ed138000, 4096)          = 0
brk(0x870000)                         = 0x870000
socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 5
fcntl(5, F_SETFL, O_RDONLY|O_NONBLOCK)= 0
connect(5, {sa_family=AF_INET, sin_port=htons(1521), sin_addr=inet_addr("172.18.19.95")}, 16) = -1 EINPROGRESS (Operation now in progress)
times({tms_utime=0, tms_stime=1, tms_cutime=0, tms_cstime=0}) = 431233281
mmap(NULL, 802816, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7fe8eca4e000
poll([{fd=5, events=POLLOUT}], 1, 60000) = 1 ([{fd=5, revents=POLLOUT|POLLERR|POLLHUP}])
getsockopt(5, SOL_SOCKET, SO_ERROR, [-251504888192696209], ) = 0
close(5)                            = 0
getsockopt(5, SOL_SOCKET, SO_SNDBUF, 0x7fff9decfd3c, 0x7fff9decfd38) = -1 EBADF (Bad file descriptor)
getsockopt(5, SOL_SOCKET, SO_RCVBUF, 0x7fff9decfd3c, 0x7fff9decfd38) = -1 EBADF (Bad file descriptor)
access("/var/tmp/.oracle", F_OK)    = 0
chmod("/var/tmp/.oracle", 01777)    = -1 EPERM (Operation not permitted)
socket(PF_FILE, SOCK_STREAM, 0)       = 5
access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"...}, 110) = -1 ECONNREFUSED (Connection refused)
access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
nanosleep({0, 100000000}, {16, 140735842940128}) = 0
close(5)                            = 0
socket(PF_FILE, SOCK_STREAM, 0)       = 5
connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"...}, 110) = -1 ECONNREFUSED (Connection refused)
access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
nanosleep({0, 200000000}, {140735842941248, 140638398136657}) = 0
close(5)                            = 0
socket(PF_FILE, SOCK_STREAM, 0)       = 5
connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"...}, 110) = -1 ECONNREFUSED (Connection refused)
access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
nanosleep({0, 10000000}, {140735842941248, 140638398136657}) = 0
close(5)                            = 0
socket(PF_FILE, SOCK_STREAM, 0)       = 5
connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"...}, 110) = -1 ECONNREFUSED (Connection refused)
access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
nanosleep({0, 20000000}, {140735842941248, 140638398136657}) = 0
close(5)                            = 0
socket(PF_FILE, SOCK_STREAM, 0)       = 5
connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"...}, 110) = -1 ECONNREFUSED (Connection refused)
access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
nanosleep({0, 40000000}, {140735842941248, 140638398136657}) = 0
close(5)                            = 0
socket(PF_FILE, SOCK_STREAM, 0)       = 5
connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"...}, 110) = -1 ECONNREFUSED (Connection refused)
access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
nanosleep({0, 80000000}, {140735842941248, 140638398136657}) = 0
close(5)                            = 0
socket(PF_FILE, SOCK_STREAM, 0)       = 5
connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"...}, 110) = -1 ECONNREFUSED (Connection refused)
access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
nanosleep({0, 160000000}, {140735842941248, 140638398136657}) = 0
close(5)                            = 0
socket(PF_FILE, SOCK_STREAM, 0)       = 5
connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"...}, 110) = -1 ECONNREFUSED (Connection refused)
access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
nanosleep({0, 320000000}, {140735842941248, 140638398136657}) = 0
close(5)                            = 0
socket(PF_FILE, SOCK_STREAM, 0)       = 5
connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"...}, 110) = -1 ECONNREFUSED (Connection refused)
access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
nanosleep({0, 10000000}, {140735842941248, 140638398136657}) = 0
close(5)                            = 0
socket(PF_FILE, SOCK_STREAM, 0)       = 5
connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"...}, 110) = -1 ECONNREFUSED (Connection refused)
access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
nanosleep({0, 20000000}, {140735842941248, 140638398136657}) = 0
close(5)                            = 0
socket(PF_FILE, SOCK_STREAM, 0)       = 5
connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"...}, 110) = -1 ECONNREFUSED (Connection refused)
access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
nanosleep({0, 40000000}, {140735842941248, 140638398136657}) = 0
close(5)                            = 0
socket(PF_FILE, SOCK_STREAM, 0)       = 5
connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"...}, 110) = -1 ECONNREFUSED (Connection refused)
access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
nanosleep({0, 80000000}, {140735842941248, 140638398136657}) = 0
close(5)                            = 0
socket(PF_FILE, SOCK_STREAM, 0)       = 5
connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"...}, 110) = -1 ECONNREFUSED (Connection refused)
access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
nanosleep({0, 160000000}, {140735842941248, 140638398136657}) = 0
close(5)                            = 0
socket(PF_FILE, SOCK_STREAM, 0)       = 5
connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"...}, 110) = -1 ECONNREFUSED (Connection refused)
access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
nanosleep({0, 320000000}, {140735842941248, 140638398136657}) = 0
close(5)                            = 0
socket(PF_FILE, SOCK_STREAM, 0)       = 5
connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"...}, 110) = -1 ECONNREFUSED (Connection refused)
access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
nanosleep({0, 10000000}, {140735842941248, 140638398136657}) = 0
close(5)                            = 0
socket(PF_FILE, SOCK_STREAM, 0)       = 5
connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"...}, 110) = -1 ECONNREFUSED (Connection refused)
access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
nanosleep({0, 20000000}, {140735842941248, 140638398136657}) = 0
close(5)                            = 0
socket(PF_FILE, SOCK_STREAM, 0)       = 5
connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"...}, 110) = -1 ECONNREFUSED (Connection refused)
access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
nanosleep({0, 40000000}, {140735842941248, 140638398136657}) = 0
close(5)                            = 0
socket(PF_FILE, SOCK_STREAM, 0)       = 5
connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"...}, 110) = -1 ECONNREFUSED (Connection refused)
access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
close(5)                            = 0
open("/u01/app/grid/product/11.2.0/grid/network/mesg/tnsus.msb", O_RDONLY) = 5
fcntl(5, F_SETFD, FD_CLOEXEC)       = 0
lseek(5, 0, SEEK_SET)                = 0
read(5, "\25\23\"\1\23\3\t\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 256) = 256
lseek(5, 512, SEEK_SET)             = 512
read(5, "\2331\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 512) = 512
lseek(5, 1024, SEEK_SET)             = 1024
read(5, "\t\0\22\0\32\0&\0-\0F\0N\0U\0\\\0k\0w\0\201\0\212\0\223\0\321\0\334\0"..., 172) = 172
lseek(5, 19456, SEEK_SET)             = 19456
read(5, "\17\0$\4\0\0b\0%\4\0\0\207\0&\4\0\0\245\0'\4\0\0\311\0(\4\0\0\351\0"..., 512) = 512
write(1, "Starting /u01/app/grid/product/1"..., 72Starting /u01/app/grid/product/11.2.0/grid/bin/tnslsnr: please wait...

) = 72
pipe()                         = 0
pipe()                         = 0
clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0x7fe8ecf32770) = 18426
rt_sigprocmask(SIG_BLOCK, , NULL, 8) = 0
rt_sigaction(SIGPIPE, {0x7fe8eec65330, ~, SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x344960ebe0}, {SIG_DFL, [], 0}, 8) = 0
rt_sigprocmask(SIG_UNBLOCK, , NULL, 8) = 0
wait4(18426, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], 0, NULL) = 18426
--- SIGCHLD (Child exited) @ 0 (0) ---
close(6)                            = 0
close(9)                            = 0
fcntl(8, F_SETFD, FD_CLOEXEC)       = 0
fcntl(7, F_SETFD, FD_CLOEXEC)       = 0
read(8, "NTP0 18427\n", 64)          = 11
fcntl(8, F_SETFD, FD_CLOEXEC)       = 0
write(7, "\0\276\0\0\1\0\0\0\1:\1,\0\0 \0\20\0O\230\0\0\1\0\0\204\0:\0\0\10\0"..., 190) = 190
read(8, "\0\f\0\0\4\0\0\0\"\0\2&\0020\0\0\6\0\0\0\0@TNSLSNR fo"..., 8208) = 572
close(7)                            = 0
close(8)                            = 0
write(1, "TNSLSNR for Linux: Version 11.2."..., 550TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /u01/app/grid/product/11.2.0/grid/network/admin/listener.ora
Log messages written to /u01/app/grid/diag/tnslsnr/q9ogg01/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=q9ogg01.xifenfei.com)(PORT=1521)))
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
) = 550
write(1, "\n", 1
)                   = 1
lseek(5, 19968, SEEK_SET)             = 19968
read(5, "\r\0005\4\0\0V\0006\4\0\0p\0007\4\0\0\214\0008\4\0\0\246\0009\4\0\0\343\0"..., 512) = 512
write(1, "Listener failed to start. See th"..., 61Listener failed to start. See the error message(s) above...

) = 61
munmap(0x7fe8ecb93000, 135168)       = 0
munmap(0x7fe8ecbb4000, 135168)       = 0
munmap(0x7fe8ecbd5000, 135168)       = 0
munmap(0x7fe8ecf11000, 135168)       = 0
munmap(0x7fe8ecb12000, 528384)       = 0
munmap(0x7fe8eca4e000, 802816)       = 0
close(3)                            = 0
munmap(0x7fe8ecbf6000, 1090528)       = 0
close(5)                            = 0
exit_group(1)                         = ?这里可以清楚的看到
write(1, "TNSLSNR for Linux: Version 11.2."..., 550TNSLSNR for Linux: Version 11.2.0.4.0 - Production
System parameter file is /u01/app/grid/product/11.2.0/grid/network/admin/listener.ora
Log messages written to /u01/app/grid/diag/tnslsnr/q9ogg01/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=q9ogg01.xifenfei.com)(PORT=1521)))
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
) = 550
write(1, "\n", 1
是在读ipc的时候报错

xifenfei 发表于 2014-5-8 16:46:15

临时解决给问题方案为(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))注释掉$ vi /u01/app/grid/product/11.2.0/grid/network/admin/listener.ora

# listener.ora Network Configuration File: /u01/app/grid/product/11.2.0/grid/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = q9ogg01.xifenfei.com)(PORT = 1521))
# (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) --注释掉
)
)

ADR_BASE_LISTENER = /u01/app/grid

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

页: [1]

ORACLE SOS's Archiver

TNS-12555: TNS:permission denied