ITPub博客

首页 > 数据库 > Oracle > 记一次监听无法启动处理

记一次监听无法启动处理

原创 Oracle 作者:jason_yehua 时间:2022-12-02 10:08:42 0 删除 编辑
[  oracle@standby Disk1]$ lsnrctl start
        LSNRCTL for Linux: Version 10.2.0.5.0 – Production on 07-AUG-2013 15:15:10
        Copyright (c) 1991, 2010,   Oracle.  All rights reserved.
        Starting /oracle/app/product/10.2.0/db_1/  bin/tnslsnr: please wait…
        TNSLSNR for Linux: Version 10.2.0.5.0 – Production
        System parameter file is /oracle/app/product/10.2.0/db_1/network/admin/listener.ora
        Log messages written to /oracle/app/product/10.2.0/db_1/network/log/listener.log
        Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=standby)(PORT=1521)))
        Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
          TNS-12555: TNS  ermission denied
         TNS-12560: TNS  rotocol adapter error
          TNS-00525: Insufficient privilege for operation
           Linux Error: 1: Operation not permitted
        Listener failed to start. See the error message(s) above…
        权限不够
用strace跟踪查看原因
[oracle@standby Disk1]$ strace lsnrctl start
        execve("/oracle/app/product/10.2.0/db_1/bin/lsnrctl", ["lsnrctl", "start"], [/* 24 vars */]) = 0
        brk(0)                                  = 0×8281000
        mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xbae000
        access("/etc/ld.so.preload", R_OK)      = -1 ENOENT (No such file or directory)
        open("/oracle/app/product/10.2.0/db_1/lib/tls/i686/sse2/libclntsh.so.10.1", O_RDONLY) = -1 ENOENT (No such file or directory)
        stat64("/oracle/app/product/10.2.0/db_1/lib/tls/i686/sse2", 0xbfc1c918) = -1 ENOENT (No such file or directory)
        open("/oracle/app/product/10.2.0/db_1/lib/tls/i686/libclntsh.so.10.1", O_RDONLY) = -1 ENOENT (No such file or directory)
        stat64("/oracle/app/product/10.2.0/db_1/lib/tls/i686", 0xbfc1c918) = -1 ENOENT (No such file or directory)
        open("/oracle/app/product/10.2.0/db_1/lib/tls/sse2/libclntsh.so.10.1", O_RDONLY) = -1 ENOENT (No such file or directory)
        stat64("/oracle/app/product/10.2.0/db_1/lib/tls/sse2", 0xbfc1c918) = -1 ENOENT (No such file or directory)
        open("/oracle/app/product/10.2.0/db_1/lib/tls/libclntsh.so.10.1", O_RDONLY) = -1 ENOENT (No such file or directory)
        stat64("/oracle/app/product/10.2.0/db_1/lib/tls", 0xbfc1c918) = -1 ENOENT (No such file or directory)
        open("/oracle/app/product/10.2.0/db_1/lib/i686/sse2/libclntsh.so.10.1", O_RDONLY) = -1 ENOENT (No such file or directory)
        stat64("/oracle/app/product/10.2.0/db_1/lib/i686/sse2", 0xbfc1c918) = -1 ENOENT (No such file or directory)
        open("/oracle/app/product/10.2.0/db_1/lib/i686/libclntsh.so.10.1", O_RDONLY) = -1 ENOENT (No such file or directory)
        stat64("/oracle/app/product/10.2.0/db_1/lib/i686", 0xbfc1c918) = -1 ENOENT (No such file or directory)
        open("/oracle/app/product/10.2.0/db_1/lib/sse2/libclntsh.so.10.1", O_RDONLY) = -1 ENOENT (No such file or directory)
        stat64("/oracle/app/product/10.2.0/db_1/lib/sse2", 0xbfc1c918) = -1 ENOENT (No such file or directory)
        open("/oracle/app/product/10.2.0/db_1/lib/libclntsh.so.10.1", O_RDONLY) = 3
        read(3, "\177ELF\1\1\1\3\3\1`\211\22004"…, 512) = 512
        fstat64(3, {st_mode=S_IFREG|0755, st_size=19203849, …}) = 0
        mmap2(NULL, 14890804, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0xbaf000
        mmap2(0×196b000, 405504, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xdbc) = 0×196b000
        mmap2(0×19ce000, 83764, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0×19ce000
        close(3)                                = 0
        open("/oracle/app/product/10.2.0/db_1/lib/libnnz10.so", O_RDONLY) = 3
        read(3, "\177ELF\1\1\1\3\3\1\340;\6004"…, 512) = 512
        fstat64(3, {st_mode=S_IFREG|0644, st_size=5659007, …}) = 0
        mmap2(NULL, 2119060, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0×88a000
        mmap2(0xa68000, 155648, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0×1de) = 0xa68000
        mmap2(0xa8e000, 5524, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0xa8e000
        close(3)                                = 0
        open("/oracle/app/product/10.2.0/db_1/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
        open("/oracle/app/product/10.2.0/db_1/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
        open("/etc/ld.so.cache", O_RDONLY)      = 3
        fstat64(3, {st_mode=S_IFREG|0644, st_size=51520, …}) = 0
        mmap2(NULL, 51520, PROT_READ, MAP_PRIVATE, 3, 0) = 0×110000
        close(3)                                = 0
        open("/lib/libdl.so.2", O_RDONLY)       = 3
        read(3, "\177ELF\1\1\1\3\3\1P\n004"…, 512) = 512
        fstat64(3, {st_mode=S_IFREG|0755, st_size=14644, …}) = 0
        mmap2(NULL, 12408, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0×11d000
        mmap2(0×11f000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0×1) = 0×11f000
        close(3)                                = 0
        open("/oracle/app/product/10.2.0/db_1/lib/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
        open("/oracle/app/product/10.2.0/db_1/lib/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
        open("/lib/libm.so.6", O_RDONLY)        = 3
        read(3, "\177ELF\1\1\1\3\3\1204004"…, 512) = 512
        fstat64(3, {st_mode=S_IFREG|0755, st_size=206380, …}) = 0
        mmap2(NULL, 155760, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0×14c000
        mmap2(0×171000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0×24) = 0×171000
        close(3)                                = 0
        open("/oracle/app/product/10.2.0/db_1/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
        open("/oracle/app/product/10.2.0/db_1/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
        open("/lib/libpthread.so.0", O_RDONLY)  = 3
        read(3, "\177ELF\1\1\1\3\3\1PH004"…, 512) = 512
        fstat64(3, {st_mode=S_IFREG|0755, st_size=127700, …}) = 0
        mmap2(NULL, 94692, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0×3a1000
        mmap2(0×3b5000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0×13) = 0×3b5000
        mmap2(0×3b7000, 4580, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0×3b7000
        close(3)                                = 0
        open("/oracle/app/product/10.2.0/db_1/lib/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
        open("/oracle/app/product/10.2.0/db_1/lib/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
        open("/lib/libnsl.so.1", O_RDONLY)      = 3
        read(3, "\177ELF\1\1\1\3\3\1 1004"…, 512) = 512
        fstat64(3, {st_mode=S_IFREG|0755, st_size=99660, …}) = 0
        mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0×7eb000
        mmap2(NULL, 92104, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0×5c1000
        mmap2(0×5d4000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0×12) = 0×5d4000
        mmap2(0×5d6000, 6088, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0×5d6000
        close(3)                                = 0
        open("/oracle/app/product/10.2.0/db_1/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
        open("/oracle/app/product/10.2.0/db_1/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
        open("/lib/libc.so.6", O_RDONLY)        = 3
        read(3, "\177ELF\1\1\1\3\3\1\340_\1004"…, 512) = 512
        fstat64(3, {st_mode=S_IFREG|0755, st_size=1608148, …}) = 0
        mmap2(NULL, 1332676, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0×173000
        mprotect(0×2b2000, 4096, PROT_NONE)     = 0
        mmap2(0×2b3000, 12288, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0×13f) = 0×2b3000
        mmap2(0×2b6000, 9668, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0×2b6000
        close(3)                                = 0
        mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0×121000
        set_thread_area({entry_number:-1 -> 6, base_addr:0×1216c0, limit:1048575, seg_32bit:1, contents:0, read_exec_only:0, limit_in_pages:1, seg_not_present:0, useable:1}) = 0
        mprotect(0×2b3000, 8192, PROT_READ)     = 0
        mprotect(0×5d4000, 4096, PROT_READ)     = 0
        mprotect(0×3b5000, 4096, PROT_READ)     = 0
        mprotect(0×171000, 4096, PROT_READ)     = 0
        mprotect(0×11f000, 4096, PROT_READ)     = 0
        mprotect(0×88a000, 1957888, PROT_READ|PROT_WRITE) = 0
        mprotect(0×88a000, 1957888, PROT_READ|PROT_EXEC) = 0
        mprotect(0xbaf000, 14401536, PROT_READ|PROT_WRITE) = 0
        mprotect(0xbaf000, 14401536, PROT_READ|PROT_EXEC) = 0
        mprotect(0×7d5000, 4096, PROT_READ)     = 0
        munmap(0×110000, 51520)                 = 0
        set_tid_address(0×121708)               = 10034
        set_robust_list(0×121710, 0xc)          = 0
        futex(0xbfc1d1b4, FUTEX_WAKE_PRIVATE, 1) = 0
        rt_sigaction(SIGRTMIN, {0×3a53e0, [], SA_SIGINFO}, NULL, 8) = 0
        rt_sigaction(SIGRT_1, {0×3a52e0, [], SA_RESTART|SA_SIGINFO}, NULL, 8) = 0
        rt_sigprocmask(SIG_UNBLOCK, [RTMIN RT_1], NULL, 8) = 0
        getrlimit(RLIMIT_STACK, {rlim_cur=10240*1024, rlim_max=RLIM_INFINITY}) = 0
        uname({sys="Linux", node="standby", …}) = 0
        brk(0)                                  = 0×8281000
        brk(0×82a2000)                          = 0×82a2000
        mmap2(NULL, 143360, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0×122000
        futex(0×12006c, FUTEX_WAKE_PRIVATE, 2147483647) = 0
        open("/oracle/app/product/10.2.0/db_1/lib/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)
        open("/oracle/app/product/10.2.0/db_1/lib/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
        open("/oracle/app/product/10.2.0/db_1/nls/data/lx1boot.nlb", O_RDONLY) = 3
        read(3, "\3\5 \n\20W\320%\216\1C\273\300\1\26\2(\2"…, 48) = 48
        read(3, ""…, 22240) = 22240
        close(3)                                = 0
        open("/oracle/app/product/10.2.0/db_1/nls/data/lx00001.nlb", O_RDONLY) = 3
        read(3, "\3\5 \n\263\3o\2Z\1"…, 92) = 92
        read(3, "\3\1\1\1`\2\4\6\f\24\34$,"…, 855) = 855
        close(3)                                = 0
        open("/oracle/app/product/10.2.0/db_1/nls/data/lx20001.nlb", O_RDONLY) = 3
        read(3, "\3\5 \n5\33\211\21\2Z\1"…, 92) = 92
        read(3, "\1\37\t?\1"…, 6873) = 6873
        close(3)                                = 0
        open("/oracle/app/product/10.2.0/db_1/nls/data/lx10001.nlb", O_RDONLY) = 3
        read(3, "\3\5 \np\4\214\3\1Z\1"…, 92) = 92
        read(3, "\3\1\1\4\1\2\2\1\1"…, 1044) = 1044
        close(3)                                = 0
        open("/oracle/app/product/10.2.0/db_1/nls/data/lx40011.nlb", O_RDONLY) = 3
        read(3, "\3\5 \nUNUN\4Z\1"…, 92) = 92
        read(3, "$\1(\1,\1000\10049H>HN"…, 19961) = 19961
        close(3)                                = 0
        ………………………………
        read(3, "", 4096)                       = 0
        close(3)                                = 0
        munmap(0×111000, 4096)                  = 0
        uname({sys="Linux", node="standby", …}) = 0
        socket(PF_FILE, SOCK_STREAM, 0)         = 3
        fcntl64(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
        fcntl64(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/host.conf", O_RDONLY)        = 3
        fstat64(3, {st_mode=S_IFREG|0644, st_size=17, …}) = 0
        mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0×111000
        read(3, "order hosts,bind\n", 4096)     = 17
        read(3, "", 4096)                       = 0
        close(3)                                = 0
        munmap(0×111000, 4096)                  = 0
        futex(0×2b7824, FUTEX_WAKE_PRIVATE, 2147483647) = 0
        open("/etc/hosts", O_RDONLY)            = 3
        fcntl64(3, F_GETFD)                     = 0
        fcntl64(3, F_SETFD, FD_CLOEXEC)         = 0
        fstat64(3, {st_mode=S_IFREG|0644, st_size=195, …}) = 0
        mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0×111000
        read(3, "# Do not remove the following li"…, 4096) = 195
        close(3)                                = 0
        munmap(0×111000, 4096)                  = 0
        socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 3
        connect(3, {sa_family=AF_INET, sin_port=htons(1521), sin_addr=inet_addr("127.0.0.1"  }, 16) = -1 ECONNREFUSED (Connection refused)
        close(3)                                = 0
        getsockopt(3, SOL_SOCKET, SO_SNDBUF, 0xbfc160f4, 0xbfc160f0) = -1 EBADF (Bad file descriptor)
        getsockopt(3, SOL_SOCKET, SO_RCVBUF, 0xbfc160f4, 0xbfc160f0) = -1 EBADF (Bad file descriptor)
        gettimeofday({1375859827, 38728}, NULL) = 0
        access("/var/tmp/.oracle", F_OK)        = 0
        chmod("/var/tmp/.oracle", 01777)        = -1 EPERM (Operation not permitted)
        socket(PF_FILE, SOCK_STREAM, 0)         = 3
        chmod(0×2, 0777)                        = -1 EFAULT (Bad address)
        access("/var/tmp/.oracle/sEXTPROC0", F_OK) = 0
          connect(3, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC0"…}, 110) = -1 ECONNREFUSED (Connection refused)
        access("/var/tmp/.oracle/sEXTPROC0", F_OK) = 0
        gettimeofday({1375859827, 49570}, NULL) = 0
        nanosleep({0, 100000000}, NULL)         = 0
        gettimeofday({1375859827, 154088}, NULL) = 0
        close(3)                                = 0
        ……………………………………
[root@standby tmp]# ls -ltra
        total 20
        drwxr-xr-x 23 root root 4096 Aug  7 12:28 ..
        drwxrwxrwt  3 root root 4096 Aug  7 13:42 .
          drwxrwxrwt  2 root root 4096 Aug  7 15:17 .oracle   
        权限问题
[root@standby tmp]# chown oracle  install /var/tmp/.oracle
再次启动监听就OK了


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/31547506/viewspace-2926329/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2019-05-22

  • 博文量
    122
  • 访问量
    99617