配置DG时Oracle监听不能启动问题

最新推荐文章于 2021-04-04 16:10:30 发布
最新推荐文章于 2021-04-04 16:10:30 发布
阅读量206 收藏
点赞数
文章标签： 数据库 操作系统 网络

配置DG的第2个备库时，启动监听出现一个奇怪的错误
监听配置文件如下：

  1. [oracle@kvm103 admin]$ cat listener.ora
  2. SID_LIST_LISTENER =
  3.   (SID_LIST =
  4.     (SID_DESC =
  5.       (GLOBAL_DBNAME = aspdb03)
  6.       (ORACLE_HOME = /oracle/product/11.2.0/db_1)
  7.       (SID_NAME = aspdb03)
  8.     )
  9.   )

  11. LISTENER =
  12.   (DESCRIPTION_LIST =
  13.     (DESCRIPTION =
  14.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
  15.     )
  16.     (DESCRIPTION =
  17.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.103)(PORT = 1521))
  18.     )
  19.   )

  21. ADR_BASE_LISTENER = /oracle
启动监听报错：


  1. [oracle@kvm103 admin]$ lsnrctl start

  3. LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-9月 -2016 23:12:30

  5. Copyright (c) 1991, 2009, Oracle. All rights reserved.

  7. 启动/oracle/product/11.2.0/db_1/bin/tnslsnr: 请稍候...

  9. TNSLSNR for Linux: Version 11.2.0.1.0 - Production
  10. 系统参数文件为/oracle/product/11.2.0/db_1/network/admin/listener.ora
  11. 写入/oracle/diag/tnslsnr/kvm103/listener/alert/log.xml的日志信息
  12. 监听该对象时出错: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
  13. TNS-12555: TNS: 权限被拒绝
  14.  TNS-12560: TNS: 协议适配器错误
  15.   TNS-00525: 无足够权限以执行操作
  16.    Linux Error: 1: Operation not permitted

  18. 监听程序未能启动。请参阅上面的错误消息...

看上去就是对某个目录没有权限，跟踪这个启动：

  1. [oracle@kvm103 admin]$ strace lsnrctl start
  2. execve("/oracle/product/11.2.0/db_1/bin/lsnrctl", ["lsnrctl", "start"], [/* 28 vars */]) = 0
  3. brk(0) = 0x1617000
  4. mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f681fc77000
  5. access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)
  6. open("/oracle/product/11.2.0/db_1/lib/tls/x86_64/libclntsh.so.11.1", O_RDONLY) = -1 ENOENT (No such file or directory)
  7. stat("/oracle/product/11.2.0/db_1/lib/tls/x86_64", 0x7fff002aa700) = -1 ENOENT (No such file or directory)
  8. open("/oracle/product/11.2.0/db_1/lib/tls/libclntsh.so.11.1", O_RDONLY) = -1 ENOENT (No such file or directory)
  9. stat("/oracle/product/11.2.0/db_1/lib/tls", 0x7fff002aa700) = -1 ENOENT (No such file or directory)
  10. open("/oracle/product/11.2.0/db_1/lib/x86_64/libclntsh.so.11.1", O_RDONLY) = -1 ENOENT (No such file or directory)
  11. stat("/oracle/product/11.2.0/db_1/lib/x86_64", 0x7fff002aa700) = -1 ENOENT (No such file or directory)
  12. open("/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1", O_RDONLY) = 3
  13. read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\240YA\0\0\0\0\0"..., 832) = 832
  14. fstat(3, {st_mode=S_IFREG|0755, st_size=48725713, ...}) = 0
  15. mmap(NULL, 40018760, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f681d64c000
  16. mprotect(0x7f681f8d6000, 2097152, PROT_NONE) = 0
  17. mmap(0x7f681fad6000, 1556480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x228a000) = 0x7f681fad6000
  18. mmap(0x7f681fc52000, 148296, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7f681fc52000
  19. mprotect(0x7fff002ab000, 4096, PROT_READ|PROT_WRITE|PROT_EXEC|PROT_GROWSDOWN) = 0
  20. close(3) = 0
  21. open("/oracle/product/11.2.0/db_1/lib/libnnz11.so", O_RDONLY) = 3
  22. 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"..., 832) = 832
  23. fstat(3, {st_mode=S_IFREG|0644, st_size=7899997, ...}) = 0
  24. mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f681d64b000
  25. mmap(NULL, 3964864, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f681d283000
  26. mprotect(0x7f681d508000, 1044480, PROT_NONE) = 0
  27. mmap(0x7f681d607000, 274432, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x284000) = 0x7f681d607000
  28. mmap(0x7f681d64a000, 4032, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7f681d64a000
  29. close(3) = 0
  30. open("/oracle/product/11.2.0/db_1/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
  31. open("/oracle/product/11.2.0/db_1/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
  32. open("/usr/lib/tls/x86_64/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
  33. stat("/usr/lib/tls/x86_64", 0x7fff002aa6a0) = -1 ENOENT (No such file or directory)
  34. open("/usr/lib/tls/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
  35. stat("/usr/lib/tls", 0x7fff002aa6a0) = -1 ENOENT (No such file or directory)
  36. open("/usr/lib/x86_64/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
  37. stat("/usr/lib/x86_64", 0x7fff002aa6a0) = -1 ENOENT (No such file or directory)
  38. open("/usr/lib/libdl.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
  39. stat("/usr/lib", {st_mode=S_IFDIR|0555, st_size=12288, ...}) = 0
  40. open("/etc/ld.so.cache", O_RDONLY) = 3
  41. fstat(3, {st_mode=S_IFREG|0644, st_size=77442, ...}) = 0
  42. mmap(NULL, 77442, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7f681d270000
  43. close(3) = 0
  44. open("/lib64/libdl.so.2", O_RDONLY) = 3
  45. read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\340\r`\37<\0\0\0"..., 832) = 832
  46. fstat(3, {st_mode=S_IFREG|0755, st_size=22536, ...}) = 0
  47. mmap(0x3c1f600000, 2109696, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3c1f600000
  48. mprotect(0x3c1f602000, 2097152, PROT_NONE) = 0
  49. mmap(0x3c1f802000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2000) = 0x3c1f802000
  50. close(3) = 0
  51. open("/oracle/product/11.2.0/db_1/lib/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
  52. open("/oracle/product/11.2.0/db_1/lib/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
  53. open("/usr/lib/libm.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
  54. open("/lib64/libm.so.6", O_RDONLY) = 3
  55. read(3, "\177ELF\2\1\1\3\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0p>\340\37<\0\0\0"..., 832) = 832
  56. fstat(3, {st_mode=S_IFREG|0755, st_size=599392, ...}) = 0
  57. mmap(0x3c1fe00000, 2633912, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3c1fe00000
  58. mprotect(0x3c1fe83000, 2093056, PROT_NONE) = 0
  59. mmap(0x3c20082000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x82000) = 0x3c20082000
  60. close(3) = 0
  61. open("/oracle/product/11.2.0/db_1/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
  62. open("/oracle/product/11.2.0/db_1/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
  63. open("/usr/lib/libpthread.so.0", O_RDONLY) = -1 ENOENT (No such file or directory)
  64. open("/lib64/libpthread.so.0", O_RDONLY) = 3
  65. read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0000^\240\37<\0\0\0"..., 832) = 832
  66. fstat(3, {st_mode=S_IFREG|0755, st_size=145936, ...}) = 0
  67. mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f681d26f000
  68. mmap(0x3c1fa00000, 2212848, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3c1fa00000
  69. mprotect(0x3c1fa17000, 2097152, PROT_NONE) = 0
  70. mmap(0x3c1fc17000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x17000) = 0x3c1fc17000
  71. mmap(0x3c1fc19000, 13296, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3c1fc19000
  72. close(3) = 0
  73. open("/oracle/product/11.2.0/db_1/lib/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
  74. open("/oracle/product/11.2.0/db_1/lib/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
  75. open("/usr/lib/libnsl.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
  76. open("/lib64/libnsl.so.1", O_RDONLY) = 3
  77. read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0p@ .<\0\0\0"..., 832) = 832
  78. fstat(3, {st_mode=S_IFREG|0755, st_size=116368, ...}) = 0
  79. mmap(0x3c2e200000, 2198192, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3c2e200000
  80. mprotect(0x3c2e216000, 2093056, PROT_NONE) = 0
  81. mmap(0x3c2e415000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x15000) = 0x3c2e415000
  82. mmap(0x3c2e417000, 6832, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3c2e417000
  83. close(3) = 0
  84. open("/oracle/product/11.2.0/db_1/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
  85. open("/oracle/product/11.2.0/db_1/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
  86. open("/usr/lib/libc.so.6", O_RDONLY) = -1 ENOENT (No such file or directory)
  87. open("/lib64/libc.so.6", O_RDONLY) = 3
  88. read(3, "\177ELF\2\1\1\3\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0p\356!\37<\0\0\0"..., 832) = 832
  89. fstat(3, {st_mode=S_IFREG|0755, st_size=1926520, ...}) = 0
  90. mmap(0x3c1f200000, 3750152, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x3c1f200000
  91. mprotect(0x3c1f38a000, 2097152, PROT_NONE) = 0
  92. mmap(0x3c1f58a000, 20480, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x18a000) = 0x3c1f58a000
  93. mmap(0x3c1f58f000, 18696, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x3c1f58f000
  94. close(3) = 0
  95. open("/oracle/product/11.2.0/db_1/lib/libaio.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
  96. open("/oracle/product/11.2.0/db_1/lib/libaio.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
  97. open("/oracle/product/11.2.0/db_1/lib/libaio.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
  98. open("/usr/lib/libaio.so.1", O_RDONLY) = -1 ENOENT (No such file or directory)
  99. open("/lib64/libaio.so.1", O_RDONLY) = 3
  100. read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0p\5\340\3505\0\0\0"..., 832) = 832
  101. fstat(3, {st_mode=S_IFREG|0755, st_size=5624, ...}) = 0
  102. mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f681d26e000
  103. mmap(0x35e8e00000, 2099840, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x35e8e00000
  104. mprotect(0x35e8e01000, 2093056, PROT_NONE) = 0
  105. mmap(0x35e9000000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0) = 0x35e9000000
  106. close(3) = 0
  107. mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f681d26d000
  108. mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f681d26c000
  109. mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f681d26b000
  110. arch_prctl(ARCH_SET_FS, 0x7f681d26c700) = 0
  111. mprotect(0x3c1f58a000, 16384, PROT_READ) = 0
  112. mprotect(0x3c2e415000, 4096, PROT_READ) = 0
  113. mprotect(0x3c1fc17000, 4096, PROT_READ) = 0
  114. mprotect(0x3c20082000, 4096, PROT_READ) = 0
  115. mprotect(0x3c1f802000, 4096, PROT_READ) = 0
  116. mprotect(0x7f681d64c000, 36216832, PROT_READ|PROT_WRITE) = 0
  117. mprotect(0x7f681d64c000, 36216832, PROT_READ|PROT_EXEC) = 0
  118. mprotect(0x3c1f01f000, 4096, PROT_READ) = 0
  119. munmap(0x7f681d270000, 77442) = 0
  120. set_tid_address(0x7f681d26c9d0) = 29282
  121. set_robust_list(0x7f681d26c9e0, 0x18) = 0
  122. futex(0x7fff002aaffc, FUTEX_WAKE_PRIVATE, 1) = 0
  123. futex(0x7fff002aaffc, FUTEX_WAIT_BITSET_PRIVATE|FUTEX_CLOCK_REALTIME, 1, NULL, 7f681d26c700) = -1 EAGAIN (Resource temporarily unavailable)
  124. rt_sigaction(SIGRTMIN, {0x3c1fa05cb0, [], SA_RESTORER|SA_SIGINFO, 0x3c1fa0f7e0}, NULL, 8) = 0
  125. rt_sigaction(SIGRT_1, {0x3c1fa05d40, [], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x3c1fa0f7e0}, NULL, 8) = 0
  126. rt_sigprocmask(SIG_UNBLOCK, [RTMIN RT_1], NULL, 8) = 0
  127. getrlimit(RLIMIT_STACK, {rlim_cur=10240*1024, rlim_max=RLIM_INFINITY}) = 0
  128. brk(0) = 0x1617000
  129. brk(0x1638000) = 0x1638000
  130. uname({sys="Linux", node="kvm103", ...}) = 0
  131. open("/etc/resolv.conf", O_RDONLY) = 3
  132. fstat(3, {st_mode=S_IFREG|0644, st_size=110, ...}) = 0
  133. mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f681d282000
  134. read(3, "# Generated by NetworkManager\ndo"..., 4096) = 110
  135. read(3, "", 4096) = 0
  136. close(3) = 0
  137. munmap(0x7f681d282000, 4096) = 0
  138. socket(PF_FILE, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 3
  139. connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)
  140. close(3) = 0
  141. socket(PF_FILE, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 3
  142. connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)
  143. close(3) = 0
  144. open("/etc/nsswitch.conf", O_RDONLY) = 3
  145. fstat(3, {st_mode=S_IFREG|0644, st_size=1688, ...}) = 0
  146. mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f681d282000
  147. read(3, "#\n# /etc/nsswitch.conf\n#\n# An ex"..., 4096) = 1688
  148. read(3, "", 4096) = 0
  149. close(3) = 0
  150. munmap(0x7f681d282000, 4096) = 0
  151. open("/oracle/product/11.2.0/db_1/lib/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
  152. open("/oracle/product/11.2.0/db_1/lib/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
  153. open("/usr/lib/libnss_files.so.2", O_RDONLY) = -1 ENOENT (No such file or directory)
  154. open("/etc/ld.so.cache", O_RDONLY) = 3
  155. fstat(3, {st_mode=S_IFREG|0644, st_size=77442, ...}) = 0
  156. mmap(NULL, 77442, PROT_READ, MAP_PRIVATE, 3, 0) = 0x7f681d270000
  157. close(3) = 0
  158. open("/lib64/libnss_files.so.2", O_RDONLY) = 3
  159. read(3, "\177ELF\2\1\1\0\0\0\0\0\0\0\0\0\3\0>\0\1\0\0\0\360!\0\0\0\0\0\0"..., 832) = 832
  160. fstat(3, {st_mode=S_IFREG|0755, st_size=65928, ...}) = 0
  161. mmap(NULL, 2151824, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0x7f681d05d000
  162. mprotect(0x7f681d069000, 2097152, PROT_NONE) = 0
  163. mmap(0x7f681d269000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xc000) = 0x7f681d269000
  164. close(3) = 0
  165. mprotect(0x7f681d269000, 4096, PROT_READ) = 0
  166. munmap(0x7f681d270000, 77442) = 0
  167. open("/etc/host.conf", O_RDONLY) = 3
  168. fstat(3, {st_mode=S_IFREG|0644, st_size=9, ...}) = 0
  169. mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f681d282000
  170. read(3, "multi on\n", 4096) = 9
  171. read(3, "", 4096) = 0
  172. close(3) = 0
  173. munmap(0x7f681d282000, 4096) = 0
  174. futex(0x3c1f5923a4, FUTEX_WAKE_PRIVATE, 2147483647) = 0
  175. open("/etc/hosts", O_RDONLY|O_CLOEXEC) = 3
  176. fcntl(3, F_GETFD) = 0x1 (flags FD_CLOEXEC)
  177. fstat(3, {st_mode=S_IFREG|0644, st_size=246, ...}) = 0
  178. mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f681d282000
  179. read(3, "127.0.0.1 localhost localhost."..., 4096) = 246
  180. read(3, "", 4096) = 0
  181. close(3) = 0
  182. munmap(0x7f681d282000, 4096) = 0
  183. mmap(NULL, 143360, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f681d03a000
  184. futex(0x3c1f8030ec, FUTEX_WAKE_PRIVATE, 2147483647) = 0
  185. open("/oracle/product/11.2.0/db_1/lib/libociei.so", O_RDONLY) = -1 ENOENT (No such file or directory)
  186. open("/oracle/product/11.2.0/db_1/lib/libociicus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
  187. open("/oracle/product/11.2.0/db_1/nls/data/lx1boot.nlb", O_RDONLY) = 3
  188. read(3, "\0\0\0\3\0\1 \v\260W\0\0X\356\216\0\0\0\0\0\1\0E\0\276\0\304\1\32\2,\2"..., 48) = 48
  189. 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
  190. close(3) = 0
  191. open("/oracle/product/11.2.0/db_1/nls/data/lx00023.nlb", O_RDONLY) = 3
  192. read(3, "\0\0\0\3\0\1 \v\33\3\0\0\327\1\0\0\0\0\0\0\0\0\0\0\0Z\1\0\0\0\0\0"..., 92) = 92
  193. read(3, "\3\0\0\0#\0005\0R\3`\0\0\0\4\0\6\0\10\0\n\0\22\0\32\0\"\0*\0002\0"..., 703) = 703
  194. close(3) = 0
  195. brk(0x1665000) = 0x1665000
  196. open("/oracle/product/11.2.0/db_1/nls/data/lx20354.nlb", O_RDONLY) = 3
  197. read(3, "\0\0\0\3\0\1 \v\311\276\1\0\35\265\1\0\0\0\0\0\2\0\0\0\0Z\1\0\0\0\0\0"..., 92) = 92
  198. read(3, "T\3\0\0\21\0\3\0\277\0\0\0\0\0\0\0 ~?\201@\0\0\2\376\0\0\0\0\0\0\0"..., 114285) = 114285
  199. close(3) = 0
  200. open("/oracle/product/11.2.0/db_1/nls/data/lx10035.nlb", O_RDONLY) = 3
  201. read(3, "\0\0\0\3\0\1 \v~\3\0\0\232\2\0\0\0\0\0\0\1\0\0\0\0Z\1\0\0\0\0\0"..., 92) = 92
  202. read(3, "\3\0\0\0005\0\1\0\0\0\0\0\1\0\4\0\1\0\2\0\2\0\1\0\1\0\0\0\0\0\0\0"..., 802) = 802
  203. close(3) = 0
  204. open("/oracle/product/11.2.0/db_1/nls/data/lx40011.nlb", O_RDONLY) = 3
  205. read(3, "\0\0\0\5\0\1 \vaV\0\0aV\0\0\0\0\0\0\4\0\0\0\0Z\1\0\0\0\0\0"..., 92) = 92
  206. 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
  207. close(3) = 0
  208. socket(PF_INET6, SOCK_DGRAM, IPPROTO_IP) = 3
  209. 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
  210. close(3) = 0
  211. access("/etc/listener.ora", F_OK) = -1 ENOENT (No such file or directory)
  212. access("/oracle/product/11.2.0/db_1/network/admin/listener.ora", F_OK) = 0
  213. open("/oracle/product/11.2.0/db_1/network/admin/listener.ora", O_RDONLY) = 3
  214. fcntl(3, F_SETFD, FD_CLOEXEC) = 0
  215. fstat(3, {st_mode=S_IFREG|0644, st_size=411, ...}) = 0
  216. mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f681d282000
  217. read(3, "SID_LIST_LISTENER =\n (SID_LIST "..., 4096) = 411
  218. read(3, "", 4096) = 0
  219. close(3) = 0
  220. munmap(0x7f681d282000, 4096) = 0
  221. stat("/oracle", {st_mode=S_IFDIR|0775, st_size=4096, ...}) = 0
  222. stat("/oracle/diag", {st_mode=S_IFDIR|0775, st_size=4096, ...}) = 0
  223. stat("/oracle/diag/lsnrctl", 0x7fff002a7f90) = -1 ENOENT (No such file or directory)
  224. stat("/oracle/product/11.2.0/db_1/log", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
  225. stat("/oracle/product/11.2.0/db_1/log/diag", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
  226. stat("/oracle/product/11.2.0/db_1/log/diag/lsnrctl", 0x7fff002a7f90) = -1 ENOENT (No such file or directory)
  227. stat("/home/oracle", {st_mode=S_IFDIR|0700, st_size=4096, ...}) = 0
  228. getuid() = 601
  229. socket(PF_FILE, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 3
  230. connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)
  231. close(3) = 0
  232. socket(PF_FILE, SOCK_STREAM|SOCK_CLOEXEC|SOCK_NONBLOCK, 0) = 3
  233. connect(3, {sa_family=AF_FILE, path="/var/run/nscd/socket"}, 110) = -1 ENOENT (No such file or directory)
  234. close(3) = 0
  235. open("/etc/passwd", O_RDONLY|O_CLOEXEC) = 3
  236. fstat(3, {st_mode=S_IFREG|0644, st_size=2130, ...}) = 0
  237. mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f681d282000
  238. read(3, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 2130
  239. close(3) = 0
  240. munmap(0x7f681d282000, 4096) = 0
  241. times({tms_utime=0, tms_stime=0, tms_cutime=0, tms_cstime=0}) = 923867561
  242. open("/oracle/product/11.2.0/db_1/rdbms/mesg/diaus.msb", O_RDONLY) = 3
  243. fcntl(3, F_SETFD, FD_CLOEXEC) = 0
  244. lseek(3, 0, SEEK_SET) = 0
  245. 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
  246. lseek(3, 512, SEEK_SET) = 512
  247. read(3, "\237\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
  248. lseek(3, 1024, SEEK_SET) = 1024
  249. 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"..., 186) = 186
  250. gettimeofday({1473347478, 976376}, NULL) = 0
  251. brk(0x1686000) = 0x1686000
  252. getrlimit(RLIMIT_NOFILE, {rlim_cur=1024, rlim_max=64*1024}) = 0
  253. open("/proc/self/fd/", O_RDONLY|O_NONBLOCK|O_DIRECTORY|O_CLOEXEC) = 4
  254. fcntl(4, F_GETFD) = 0x1 (flags FD_CLOEXEC)
  255. getrlimit(RLIMIT_FSIZE, {rlim_cur=RLIM_INFINITY, rlim_max=RLIM_INFINITY}) = 0
  256. rt_sigprocmask(SIG_BLOCK, [WINCH], NULL, 8) = 0
  257. rt_sigaction(SIGWINCH, {0x7f681ea1cd8c, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x3c1fa0f7e0}, {SIG_DFL, [], 0}, 8) = 0
  258. rt_sigprocmask(SIG_UNBLOCK, [WINCH], NULL, 8) = 0
  259. rt_sigaction(SIGWINCH, NULL, {0x7f681ea1cd8c, ~[ILL ABRT BUS FPE KILL SEGV USR2 STOP XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x3c1fa0f7e0}, 8) = 0
  260. rt_sigaction(SIGWINCH, {0x7f681ea1cd8c, ~[ILL ABRT BUS FPE KILL SEGV USR2 STOP XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_SIGINFO, 0x3c1fa0f7e0}, NULL, 8) = 0
  261. gettimeofday({1473347478, 976814}, NULL) = 0
  262. open("/etc/localtime", O_RDONLY) = 5
  263. fstat(5, {st_mode=S_IFREG|0644, st_size=405, ...}) = 0
  264. fstat(5, {st_mode=S_IFREG|0644, st_size=405, ...}) = 0
  265. mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f681d282000
  266. 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
  267. lseek(5, -240, SEEK_CUR) = 165
  268. 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
  269. close(5) = 0
  270. munmap(0x7f681d282000, 4096) = 0
  271. fstat(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 3), ...}) = 0
  272. mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f681d282000
  273. write(1, "\n", 1
  274. ) = 1
  275. write(1, "LSNRCTL for Linux: Version 11.2."..., 134LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-9月 -2016 23:11:18

  277. Copyright (c) 1991, 2009, Oracle. All rights reserved.

  279. ) = 134
  280. access("/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora", F_OK) = -1 ENOENT (No such file or directory)
  281. getrlimit(RLIMIT_NOFILE, {rlim_cur=1024, rlim_max=64*1024}) = 0
  282. setrlimit(RLIMIT_NOFILE, {rlim_cur=64*1024, rlim_max=64*1024}) = 0
  283. open("/oracle/product/11.2.0/db_1/lib/libnque11.so", O_RDONLY) = 5
  284. 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
  285. fstat(5, {st_mode=S_IFREG|0644, st_size=59589, ...}) = 0
  286. mmap(NULL, 1091040, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 5, 0) = 0x7f681cf2f000
  287. mprotect(0x7f681cf39000, 1044480, PROT_NONE) = 0
  288. mmap(0x7f681d038000, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 5, 0x9000) = 0x7f681d038000
  289. mmap(0x7f681d039000, 1504, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0x7f681d039000
  290. close(5) = 0
  291. mmap(NULL, 135168, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f681cf0e000
  292. mmap(NULL, 135168, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f681ceed000
  293. mmap(NULL, 135168, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f681cecc000
  294. mmap(NULL, 135168, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f681ceab000
  295. mmap(NULL, 528384, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f681ce2a000
  296. brk(0x16ae000) = 0x16ae000
  297. getuid() = 601
  298. open("/etc/passwd", O_RDONLY|O_CLOEXEC) = 5
  299. fstat(5, {st_mode=S_IFREG|0644, st_size=2130, ...}) = 0
  300. mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f681d281000
  301. read(5, "root:x:0:0:root:/root:/bin/bash\n"..., 4096) = 2130
  302. close(5) = 0
  303. munmap(0x7f681d281000, 4096) = 0
  304. uname({sys="Linux", node="kvm103", ...}) = 0
  305. gettimeofday({1473347478, 977916}, NULL) = 0
  306. access("/var/tmp/.oracle", F_OK) = 0
  307. chmod("/var/tmp/.oracle", 01777) = -1 EPERM (Operation not permitted)
  308. socket(PF_FILE, SOCK_STREAM, 0) = 5
  309. access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
  310. connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"}, 110) = -1 ECONNREFUSED (Connection refused)
  311. access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
  312. nanosleep({0, 100000000}, 0x7fff002a30c0) = 0
  313. close(5) = 0
  314. socket(PF_FILE, SOCK_STREAM, 0) = 5
  315. connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"}, 110) = -1 ECONNREFUSED (Connection refused)
  316. access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
  317. nanosleep({0, 200000000}, 0x7fff002a30c0) = 0
  318. close(5) = 0
  319. socket(PF_FILE, SOCK_STREAM, 0) = 5
  320. connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"}, 110) = -1 ECONNREFUSED (Connection refused)
  321. access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
  322. nanosleep({0, 10000000}, 0x7fff002a30c0) = 0
  323. close(5) = 0
  324. socket(PF_FILE, SOCK_STREAM, 0) = 5
  325. connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"}, 110) = -1 ECONNREFUSED (Connection refused)
  326. access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
  327. nanosleep({0, 20000000}, 0x7fff002a30c0) = 0
  328. close(5) = 0
  329. socket(PF_FILE, SOCK_STREAM, 0) = 5
  330. connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"}, 110) = -1 ECONNREFUSED (Connection refused)
  331. access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
  332. nanosleep({0, 40000000}, 0x7fff002a30c0) = 0
  333. close(5) = 0
  334. socket(PF_FILE, SOCK_STREAM, 0) = 5
  335. connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"}, 110) = -1 ECONNREFUSED (Connection refused)
  336. access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
  337. nanosleep({0, 80000000}, 0x7fff002a30c0) = 0
  338. close(5) = 0
  339. socket(PF_FILE, SOCK_STREAM, 0) = 5
  340. connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"}, 110) = -1 ECONNREFUSED (Connection refused)
  341. access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
  342. nanosleep({0, 160000000}, 0x7fff002a30c0) = 0
  343. close(5) = 0
  344. socket(PF_FILE, SOCK_STREAM, 0) = 5
  345. connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"}, 110) = -1 ECONNREFUSED (Connection refused)
  346. access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
  347. nanosleep({0, 320000000}, 0x7fff002a30c0) = 0
  348. close(5) = 0
  349. socket(PF_FILE, SOCK_STREAM, 0) = 5
  350. connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"}, 110) = -1 ECONNREFUSED (Connection refused)
  351. access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
  352. nanosleep({0, 10000000}, 0x7fff002a30c0) = 0
  353. close(5) = 0
  354. socket(PF_FILE, SOCK_STREAM, 0) = 5
  355. connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"}, 110) = -1 ECONNREFUSED (Connection refused)
  356. access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
  357. nanosleep({0, 20000000}, 0x7fff002a30c0) = 0
  358. close(5) = 0
  359. socket(PF_FILE, SOCK_STREAM, 0) = 5
  360. connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"}, 110) = -1 ECONNREFUSED (Connection refused)
  361. access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
  362. nanosleep({0, 40000000}, 0x7fff002a30c0) = 0
  363. close(5) = 0
  364. socket(PF_FILE, SOCK_STREAM, 0) = 5
  365. connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"}, 110) = -1 ECONNREFUSED (Connection refused)
  366. access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
  367. nanosleep({0, 80000000}, 0x7fff002a30c0) = 0
  368. close(5) = 0
  369. socket(PF_FILE, SOCK_STREAM, 0) = 5
  370. connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"}, 110) = -1 ECONNREFUSED (Connection refused)
  371. access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
  372. nanosleep({0, 160000000}, 0x7fff002a30c0) = 0
  373. close(5) = 0
  374. socket(PF_FILE, SOCK_STREAM, 0) = 5
  375. connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"}, 110) = -1 ECONNREFUSED (Connection refused)
  376. access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
  377. nanosleep({0, 320000000}, 0x7fff002a30c0) = 0
  378. close(5) = 0
  379. socket(PF_FILE, SOCK_STREAM, 0) = 5
  380. connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"}, 110) = -1 ECONNREFUSED (Connection refused)
  381. access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
  382. nanosleep({0, 10000000}, 0x7fff002a30c0) = 0
  383. close(5) = 0
  384. socket(PF_FILE, SOCK_STREAM, 0) = 5
  385. connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"}, 110) = -1 ECONNREFUSED (Connection refused)
  386. access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
  387. nanosleep({0, 20000000}, 0x7fff002a30c0) = 0
  388. close(5) = 0
  389. socket(PF_FILE, SOCK_STREAM, 0) = 5
  390. connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"}, 110) = -1 ECONNREFUSED (Connection refused)
  391. access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
  392. nanosleep({0, 40000000}, 0x7fff002a30c0) = 0
  393. close(5) = 0
  394. socket(PF_FILE, SOCK_STREAM, 0) = 5
  395. connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"}, 110) = -1 ECONNREFUSED (Connection refused)
  396. access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
  397. close(5) = 0
  398. gettimeofday({1473347480, 613875}, NULL) = 0
  399. socket(PF_NETLINK, SOCK_RAW, 0) = 5
  400. bind(5, {sa_family=AF_NETLINK, pid=0, groups=00000000}, 12) = 0
  401. getsockname(5, {sa_family=AF_NETLINK, pid=29282, groups=00000000}, [12]) = 0
  402. gettimeofday({1473347480, 614002}, NULL) = 0
  403. sendto(5, "\24\0\0\0\26\0\1\3\230\177\321W\0\0\0\0\0\0\0\0", 20, 0, {sa_family=AF_NETLINK, pid=0, groups=00000000}, 12) = 20
  404. recvmsg(5, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=00000000}, msg_iov(1)=[{"0\0\0\0\24\0\2\0\230\177\321Wbr\0\0\2\10\200\376\1\0\0\0\10\0\1\0\177\0\0\1"..., 4096}], msg_controllen=0, msg_flags=0}, 0) = 108
  405. recvmsg(5, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=00000000}, msg_iov(1)=[{"@\0\0\0\24\0\2\0\230\177\321Wbr\0\0\n\200\200\376\1\0\0\0\24\0\1\0\0\0\0\0"..., 4096}], msg_controllen=0, msg_flags=0}, 0) = 128
  406. recvmsg(5, {msg_name(12)={sa_family=AF_NETLINK, pid=0, groups=00000000}, msg_iov(1)=[{"\24\0\0\0\3\0\2\0\230\177\321Wbr\0\0\0\0\0\0\1\0\0\0\24\0\1\0\0\0\0\0"..., 4096}], msg_controllen=0, msg_flags=0}, 0) = 20
  407. close(5) = 0
  408. socket(PF_INET, SOCK_STREAM, IPPROTO_IP) = 5
  409. fcntl(5, F_SETFL, O_RDONLY|O_NONBLOCK) = 0
  410. connect(5, {sa_family=AF_INET, sin_port=htons(1521), sin_addr=inet_addr("192.168.56.103")}, 16) = -1 EINPROGRESS (Operation now in progress)
  411. times({tms_utime=0, tms_stime=0, tms_cutime=0, tms_cstime=0}) = 923867725
  412. mmap(NULL, 528384, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x7f681cda9000
  413. poll([{fd=5, events=POLLOUT}], 1, 60000) = 1 ([{fd=5, revents=POLLERR|POLLHUP}])
  414. getsockopt(5, SOL_SOCKET, SO_ERROR, [11877165121405039], [4]) = 0
  415. close(5) = 0
  416. getsockopt(5, SOL_SOCKET, SO_SNDBUF, 0x7fff002a34ec, 0x7fff002a34e8) = -1 EBADF (Bad file descriptor)
  417. getsockopt(5, SOL_SOCKET, SO_RCVBUF, 0x7fff002a34ec, 0x7fff002a34e8) = -1 EBADF (Bad file descriptor)
  418. open("/oracle/product/11.2.0/db_1/nls/data/lx20001.nlb", O_RDONLY) = 5
  419. read(5, "\0\0\0\3\0\1 \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
  420. read(5, "\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
  421. close(5) = 0
  422. open("/oracle/product/11.2.0/db_1/network/mesg/tnszhs.msb", O_RDONLY) = 5
  423. fcntl(5, F_SETFD, FD_CLOEXEC) = 0
  424. lseek(5, 0, SEEK_SET) = 0
  425. read(5, "\32\10\23\34!\7\2\v\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
  426. open("/oracle/product/11.2.0/db_1/network/mesg/tnsus.msb", O_RDONLY) = 6
  427. fcntl(6, F_SETFD, FD_CLOEXEC) = 0
  428. lseek(6, 0, SEEK_SET) = 0
  429. read(6, "\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
  430. lseek(5, 512, SEEK_SET) = 512
  431. 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
  432. lseek(5, 1024, SEEK_SET) = 1024
  433. read(5, "\16\0\32\0)\0@\0N\0W\0g\0y\0\206\0\223\0\323\0\337\0\355\0\374\0\n\1\34\1"..., 126) = 126
  434. lseek(5, 14848, SEEK_SET) = 14848
  435. read(5, "\24\0&\4\0\0\200\0'\4\0\0\233\0(\4\0\0\264\0)\4\0\0\317\0*\4\0\0\334\0"..., 512) = 512
  436. write(1, "\306\364\266\257/oracle/product/11.2.0/db_1/"..., 56启动/oracle/product/11.2.0/db_1/bin/tnslsnr: 请稍候...

  438. ) = 56
  439. gettimeofday({1473347480, 615172}, NULL) = 0
  440. pipe([7, 8]) = 0
  441. pipe([9, 10]) = 0
  442. clone(child_stack=0, flags=CLONE_CHILD_CLEARTID|CLONE_CHILD_SETTID|SIGCHLD, child_tidptr=0x7f681d26c9d0) = 29283
  443. rt_sigprocmask(SIG_BLOCK, [PIPE], NULL, 8) = 0
  444. rt_sigaction(SIGPIPE, {0x7f681ea1cd8c, ~[ILL ABRT BUS FPE SEGV USR2 XCPU XFSZ SYS RTMIN RT_1], SA_RESTORER|SA_RESTART|SA_SIGINFO, 0x3c1fa0f7e0}, {SIG_DFL, [], 0}, 8) = 0
  445. rt_sigprocmask(SIG_UNBLOCK, [PIPE], NULL, 8) = 0
  446. wait4(29283, [{WIFEXITED(s) && WEXITSTATUS(s) == 0}], 0, NULL) = 29283
  447. --- SIGCHLD (Child exited) @ 0 (0) ---
  448. close(7) = 0
  449. close(10) = 0
  450. fcntl(9, F_SETFD, FD_CLOEXEC) = 0
  451. fcntl(8, F_SETFD, FD_CLOEXEC) = 0
  452. read(9, "NTP0 29284\n", 64) = 11
  453. fcntl(9, F_SETFD, FD_CLOEXEC) = 0
  454. gettimeofday({1473347480, 623973}, NULL) = 0
  455. write(8, "\0\270\0\0\1\0\0\0\1:\1,\0\0 \0\20\0O\230\0\0\1\0\0~\0:\0\0\10\0"..., 184) = 184
  456. read(9, "\0\f\0\0\4\0\0\0\"\0\1\213", 8208) = 12
  457. read(9, "\1\225\0\0\6\0\0\0\0@TNSLSNR for Linux: Ver"..., 8208) = 405
  458. close(8) = 0
  459. close(9) = 0
  460. write(1, "TNSLSNR for Linux: Version 11.2."..., 395TNSLSNR for Linux: Version 11.2.0.1.0 - Production
  461. 系统参数文件为/oracle/product/11.2.0/db_1/network/admin/listener.ora
  462. 写入/oracle/diag/tnslsnr/kvm103/listener/alert/log.xml的日志信息
  463. 监听该对象时出错: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
  464. TNS-12555: TNS: 权限被拒绝
  465.  TNS-12560: TNS: 协议适配器错误
  466.   TNS-00525: 无足够权限以执行操作
  467.    Linux Error: 1: Operation not permitted
  468. ) = 395
  469. write(1, "\n", 1
  470. ) = 1
  471. lseek(5, 14848, SEEK_SET) = 14848
  472. read(5, "\24\0&\4\0\0\200\0'\4\0\0\233\0(\4\0\0\264\0)\4\0\0\317\0*\4\0\0\334\0"..., 512) = 512
  473. write(1, "\274\340\314\375\263\314\320\362\316\264\304\334\306\364\266\257\241\243\307\353\262\316\324\304\311\317\303\346\265\304\264\355


看到一堆这样的错误
  1. chmod("/var/tmp/.oracle", 01777) = -1 EPERM (Operation not permitted)
  2. socket(PF_FILE, SOCK_STREAM, 0) = 5
  3. access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0
  4. connect(5, {sa_family=AF_FILE, path="/var/tmp/.oracle/sEXTPROC1521"}, 110) = -1 ECONNREFUSED (Connection refused)
  5. access("/var/tmp/.oracle/sEXTPROC1521", F_OK) = 0

无法访问 /var/tmp/.oracle
看看我的
[oracle@kvm103 dg]$ ls -lrt /var/tmp/.oracle
total 0
srwxrwxrwx. 1 dasusr1 oinstall 0 Apr  8 16:39 sEXTPROC1521
srwxrwxrwx. 1 dasusr1 oinstall 0 Apr  8 16:39 s#7486.2
srwxrwxrwx. 1 dasusr1 oinstall 0 Apr  8 16:39 s#7486.1

dasusr1是db2的DAS用户，怎么和oinstall撤到一块了

改天再看看db2的问题，
先赋予Oracle的权限启动监听
chown -R oracle:oinstall /var/tmp/.oracle/


  1. [oracle@kvm103 admin]$ lsnrctl start

  3. LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-9月 -2016 23:20:00

  5. Copyright (c) 1991, 2009, Oracle. All rights reserved.

  7. 启动/oracle/product/11.2.0/db_1/bin/tnslsnr: 请稍候...

  9. TNSLSNR for Linux: Version 11.2.0.1.0 - Production
  10. 系统参数文件为/oracle/product/11.2.0/db_1/network/admin/listener.ora
  11. 写入/oracle/diag/tnslsnr/kvm103/listener/alert/log.xml的日志信息
  12. 监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  13. 监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.103)(PORT=1521)))

  15. 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
  16. LISTENER 的 STATUS
  17. ------------------------
  18. 别名 LISTENER
  19. 版本 TNSLSNR for Linux: Version 11.2.0.1.0 - Production
  20. 启动日期 08-9月 -2016 23:20:02
  21. 正常运行时间 0 天 0 小时 0 分 0 秒
  22. 跟踪级别 off
  23. 安全性 ON: Local OS Authentication
  24. SNMP OFF
  25. 监听程序参数文件 /oracle/product/11.2.0/db_1/network/admin/listener.ora
  26. 监听程序日志文件 /oracle/diag/tnslsnr/kvm103/listener/alert/log.xml
  27. 监听端点概要...
  28.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  29.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.103)(PORT=1521)))
  30. 服务摘要..
  31. 服务 "aspdb03" 包含 1 个实例。
  32.   实例 "aspdb03", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
  33. 命令执行成功
  34. [oracle@kvm103 admin]$
  35. [oracle@kvm103 admin]$ lsnrctl status

  37. LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 08-9月 -2016 23:20:48

  39. Copyright (c) 1991, 2009, Oracle. All rights reserved.

  41. 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
  42. LISTENER 的 STATUS
  43. ------------------------
  44. 别名 LISTENER
  45. 版本 TNSLSNR for Linux: Version 11.2.0.1.0 - Production
  46. 启动日期 08-9月 -2016 23:20:02
  47. 正常运行时间 0 天 0 小时 0 分 46 秒
  48. 跟踪级别 off
  49. 安全性 ON: Local OS Authentication
  50. SNMP OFF
  51. 监听程序参数文件 /oracle/product/11.2.0/db_1/network/admin/listener.ora
  52. 监听程序日志文件 /oracle/diag/tnslsnr/kvm103/listener/alert/log.xml
  53. 监听端点概要...
  54.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  55.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.103)(PORT=1521)))
  56. 服务摘要..
  57. 服务 "aspdb03" 包含 2 个实例。
  58.   实例 "aspdb03", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
  59.   实例 "aspdb03", 状态 READY, 包含此服务的 1 个处理程序...
  60. 命令执行成功

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

转载于:http://blog.itpub.net/29023300/viewspace-2124741/

cuifu4896
关注
strace诊断一次监听无法启动之TNS-12555 TNSpermission denied
DBAdream的专栏
02-13 967
TNSLSNR for Linux: Version 10.2.0.4.0 - Production System parameter file is /u01/app/oracle/network/admin/listener.ora Log messages written to /u01/app/oracle/network/log/listener.log Error listeni
oracle数据库关闭dg数据库,Oracle-DG配置灾备数据库
weixin_39957186的博客
04-03 552
1.在主库进行下面配置1.1确认主数据库运行在归档模式下使用下面命令确定主数据库处于归档模式下：SQL> archive log list;如果主数据库未处于归档模式下，使用下面命令设置主数据库：SQL> shutdown immediate; --立即关闭数据库SQL> startup mount; --开启数据库到mount状态SQL...
oracle配置DG的时候，碰到监听无法启动的问题及解决方法
weixin_34168880的博客
06-22 156
[oracle@dg-01 admin]$ lsnrctl LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 23-JUN-2010 02:35:37 Copyright (c) 1991, 2005, Oracle. All rights reserved. Welcome to LSNRC...
Oracle 运维篇+进程追踪调试（Linux系统）
ZZT_2009
05-02 638
说明：本文为Linux下Oracle进程追踪调试指导手册， 标签：strace、进程追踪、进程调试、Oracle进程追踪调试 温馨提示：如果您发现本文哪里写的有问题或者有更好的写法请留言或私信我进行修改优化 正文开始 大纲 --strace介绍 --在Oracle中的用途 --语法 --推荐网文 --命令样例 --输出日志 ★ strace介绍 ///////////////////...
oracleTNS-12555: TNS:permission denied、TNS-12541: TNS:no listener、Instance "orcl", status UNKNOWN
wj的博客
03-03 932
报错： LSNRCTL> start Starting /u01/app/oracle/product/12.1.0/dbhome_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 12.1.0.2.0 - Production System parameter file is /u01/app/oracle/product/...
Oracle19c RAC+ RACDG配置详细部署文档
07-13
在开始配置前，必须确保所有节点的Oracle版本相同，因为不同版本的数据库可能不兼容，这可能导致在切换主备库或进行其他操作时出现问题。例如，在描述中提到的环境，所有节点都是19.12.0.0版本，这是保持一致性的一...
Oracle 11g RAC+DG安装配置
08-09
Oracle 11g RAC (Real Application ...在完成以上步骤后，你应该拥有一个配置完整的 Oracle 11g RAC+DG 系统，具备高可用性和灾难恢复能力。记得在生产环境中进行充分的测试和性能调优，以确保系统的稳定和高效运行。
Oracle 19c DataGuard搭建以及使用dg_broker管理.docx
05-03
dg_broker 是 Oracle DataGuard 的一个组件，用于管理和监控 DataGuard 配置。通过使用 dg_broker，可以快速实现 DataGuard 的搭建和管理，并提供高效的故障切换功能。 Oracle 19c DataGuard 的主要特点包括： * ...
Oracle 11g RAC+DG 非常牛逼的部署手册
09-19
4.2 配置 DG 参数：配置 DG 的参数，包括监听器配置、连接池配置、会话管理配置等。 5. 配置高可用性 5.1 配置 Failover：配置 Failover，以便在节点故障时快速 Failover 到其他节点。 5.2 配置 Load Balancing：...
oracle数据库时,Oracle数据库夏令时问题解答
weixin_36070797的博客
04-03 607
夏天就快到了，DBA可能会突然遇到夏季“灵异事件”——夏令时。突然发现数据库时间快了一个小时。数据库环境为：Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Miningand...
oracle extproc1521,oracle中EXTPROC_CONNECTION_DATA这个数据库的实例是干嘛用的？
weixin_33286064的博客
04-04 799
分析如下：原因是由于使用的是OracleXE数据库，数据库服务名默认是ORCL要改为XE才可以。1、打开Navicat，输入主机名：127.0.0.12、修改服务名为：XE3、接着输入用户名密码之后，单击连接测试扩展资料它由至少一个表空间和数据库模式对象组成。这里，模式是对象的集合，而模式对象是直接引用数据库数据的逻辑结构。模式对象包括这样一些结构：表、视图、序列、存储过程、同义词、索引、簇和数据...
oracle extproc1521,oracle1521的问题细节
weixin_32616031的博客
04-04 654
需要工具Active Perl，Oracle客户端，Superscan或者是其它扫描端口的软件，Tnscmd.pl。我们先用Superscan扫描开放了端口1521的主机，假设其IP是xx.xx.110.110，这样目标已经有了。然后我们要做的就是用Tnscmd.pl来查询远程数据库的服务名了，Tnscmd.pl的用法如下：复制内容到剪贴板代码:C:\perl\bin>perl tnscmd...
/var/tmp/.oracle 和 oracle listener （监听）的一点理解
Lixora's DB Home
11-01 3832
关于 /var/tmp/.oracle 的作用测试 ~---查看 /var/tmp 的权限 [root@lixora var]# ll total 164 。。。 drwxrwxrwt  3 root root 4096 Oct 31 13:16 tmp   [root@lixora .oracle]# ll total 0 srwxrwxrwx 1 oracle10g oi
【进程管理】系统调用nanosleep()和pause()u
博客已搬家
05-20 2232
前面所讲的sched_yield()只是让内核有一次调度，而当前进程继续保持可运行状态；而是用nanosleep()和pause()是让当前进程睡眠，使它的进程状态变为TASK_INTERRUPTIBLE或TASK_UNINTERRUPTIBLE，并且从可执行队列中移除，调度结果一定是其他进程可以运行；进程一旦进入shuimian
nanosleep()函数使用
fjgui的博客
07-08 9496
nanosleep()函数会导致当前的线程将暂停执行,直到rqtp参数所指定的时间间隔。或者在指定时间间隔内有信号传递到当前线程，将引起当前线程调用信号捕获函数或终止该线程。 #include #include #include #include void* pthread_do(void *arg) { struct timespec ts, ts1; int c
linux fuser 命令 查看文件/网络端口 被什么进程占用
whatday的专栏
04-19 1246
linux环境下，当使用umount命令卸载挂载点时，会遇到“device is busy”提示，这时fuser就能查出谁在使用这个资源;当然umount –lf [挂载点] 也可以强制卸载 fuser 可以显示出当前哪个程序在使用磁盘上的某个文件、挂载点、甚至网络端口，并给出程序进程的详细信息. fuser只把PID输出到标准输出，其他的都输出到标准错误输出。 常用选项 -a 显示所...
Oracle 12C 数据守护(DG)配置指南
"Oracle 12C 数据库搭建灾难恢复（DG）方案，包括主备库配置、环境设定、参数调整及监听配置等关键步骤。" 在Oracle 12C中，搭建灾难恢复（DG）环境是为了确保数据的安全性和业务连续性。以下是一个详细的搭建过程...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值