千家信息网

请输入关键字词

热门搜索排行

最新搜索排行

导航： 首页 > 数据库 >

lsnrctl start启动监听很慢(AIX平台)

发表于：2026-11-01 作者：千家信息网编辑
千家信息网最后更新 2026年11月01日，今天登陆了一下公司AIX平台的ORACLE测试服务器，没有配置监听，由于手动配置监听后，启动监听，发现启动的时候很慢，日志如下：欢迎大家加入ORACLE超级群：17115662 免费解决各种ORACL
千家信息网最后更新 2026年11月01日lsnrctl start启动监听很慢(AIX平台)

今天登陆了一下公司AIX平台的ORACLE测试服务器，没有配置监听，由于手动配置监听后，启动监听，发现启动的时候很慢，日志如下：

欢迎大家加入ORACLE超级群：17115662 免费解决各种ORACLE问题,以后BLOG将迁移到http://www.htz.pw

  1. [$(hostname):oracle:/u01/app/oracle/10.2.0/db_1/network/admin]lsnrctl start
  2. LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 20-MAR-2013 21:52:46
  3. Copyright (c) 1991, 2005, Oracle. All rights reserved.
  4. Starting /u01/app/oracle/10.2.0/db_1/bin/tnslsnr: please wait...
  5. TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
  6. System parameter file is /u01/app/oracle/10.2.0/db_1/network/admin/listener.ora
  7. Log messages written to /u01/app/oracle/10.2.0/db_1/network/log/listener.log
  8. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cdolm2)(PORT=1521)))
  9. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
  10. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cdolm2)(PORT=1521)))

停在这儿 ，truss进程

  1. [$(hostname):oracle:/home/oracle]truss -p 241908
  2. connext(0, 0x0000000000000000, 0) (sleeping...)
  3. connext(0, 0x0000000000000000, 0) Err#78 ETIMEDOUT
  4. close(3) = 0
  5. getsockopt(3, 65535, 4097, 0x0FFFFFFFFFFF7824, 0x0FFFFFFFFFFF7820) Err#9 EBADF
  6. getsockopt(3, 65535, 4098, 0x0FFFFFFFFFFF7824, 0x0FFFFFFFFFFF7820) Err#9 EBADF
  7. access("/tmp/.oracle", 0) = 0
  8. chmod("/tmp/.oracle", 01777) Err#1 EPERM
  9. socket(1, 1, 0) = 3
  10. access("/tmp/.oracle/sEXTPROC0", 0) Err#2 ENOENT
  11. access("/tmp/o/sEXTPROC0", 0) Err#2 ENOENT
  12. close(3) = 0
  13. open("/u01/app/oracle/10.2.0/db_1/network/mesg/tnsus.msb", O_RDONLY) = 3
  14. kfcntl(3, F_SETFD, 0x0000000000000001) = 0
  15. lseek(3, 0, 0) = 0
  16. kread(3, "1513 "011303\t\t\0\0\0\0".., 256) = 256
  17. lseek(3, 512, 0) = 512
  18. kread(3, " 19B\0\0\0\0\0\0\0\0\0\0".., 512) = 512
  19. lseek(3, 1024, 0) = 1024
  20. kread(3, "\0\t\012\01A\0 &\0 -\0 F".., 170) = 170
  21. lseek(3, 19456, 0) = 19456
  22. kread(3, "\00F04 $\0\0\0 b04 %\0\0".., 512) = 512
  23. kwrite(1, " S t a r t i n g / u 0".., 66) = 66
  24. kfcntl(1, F_GETFL, 0x0000000000000008) = 2
  25. pipe(0x0FFFFFFFFFFFA548) = 0
  26. pipe(0x0FFFFFFFFFFFA540) = 0
  27. sigprocmask(0, 0x09001000A0198818, 0x09001000A01987F8) = 0
  28. kfork() = 200740
  29. thread_setmystate(0x0FFFFFFFFFFF9F50, 0x0000000000000000) = 0
  30. sigprocmask(0, 0x0FFFFFFFFFFFA420, 0x0000000000000000) = 0
  31. sigprocmask(2, 0x09001000A0198818, 0x0FFFFFFFFFFFA130) = 0
  32. _sigaction(13, 0x0FFFFFFFFFFFA260, 0x0FFFFFFFFFFFA290) = 0
  33. thread_setmystate(0x0FFFFFFFFFFF9D20, 0x0000000000000000) = 0
  34. sigprocmask(1, 0x0FFFFFFFFFFFA390, 0x0000000000000000) = 0
  35. kwaitpid(0x0FFFFFFFFFFFA530, 200740, 4, 0x0000000000000000, 0x0000000000000000) = 200740
  36. close(4) = 0
  37. close(7) = 0
  38. set -o vi
  39. kread(6, " N T P 0 2 7 8 5 8 8\n".., 64) = 12
  40. _getpid() = 241908
  41. kfcntl(6, F_SETFD, 0x0000000000000001) = 0
  42. kwrite(5, "\0 001\0\0\001 901 ,".., 184) = 184
  43. kread(6, "\0\0\0\0\0\0\0\0\0\0\0\0".., 2064) (sleeping...)
  44. kread(6, "\0 \0\002\0\0\001 9\0\0".., 2064) = 32
  45. kread(6, "01 }\0\006\0\0\0\0\0 T N".., 2064) = 381
  46. kwrite(1, " T N S L S N R f o r ".., 371) = 371
  47. kwrite(1, "\n", 1) = 1
  48. close(5) = 0
  49. close(6) = 0
  50. getuidx(2) = 202
  51. __libc_sbrk(0x0000000000010020) = 0x00000000106044E0
  52. open("/etc/passwd", O_RDONLY) = 4
  53. kioctl(4, 22528, 0x0000000000000000, 0x0000000000000000) Err#25 ENOTTY
  54. kfcntl(4, F_GETFD, 0x0000000000000000) = 0
  55. kfcntl(4, F_SETFD, 0x0000000000000001) = 0
  56. accessx("/etc/security/passwd", 04, 0) Err#13 EACCES
  57. _getpid() = 241908
  58. accessx("/etc/passwd", 04, 0) = 0
  59. statx("/etc/passwd", 0x0FFFFFFFFFFF7880, 176, 0) = 0
  60. _getpid() = 241908
  61. accessx("/etc/passwd", 04, 0) = 0
  62. statx("/etc/passwd", 0x0FFFFFFFFFFF7040, 176, 0) = 0
  63. accessx("/etc/passwd", 04, 0) = 0
  64. statx("/etc/passwd", 0x0FFFFFFFFFFF7100, 176, 0) = 0
  65. _getpid() = 241908
  66. accessx("/etc/passwd", 04, 0) = 0
  67. statx("/etc/passwd", 0x0FFFFFFFFFFF7000, 176, 0) = 0
  68. accessx("/etc/security/passwd", 04, 0) Err#13 EACCES
  69. accessx("/etc/passwd", 04, 0) = 0
  70. statx("/etc/passwd", 0x0FFFFFFFFFFF6D30, 176, 0) = 0
  71. accessx("/etc/passwd", 04, 0) = 0
  72. statx("/etc/passwd", 0x0FFFFFFFFFFF6DF0, 176, 0) = 0
  73. _getpid() = 241908
  74. accessx("/etc/security/passwd", 04, 0) Err#13 EACCES
  75. accessx("/etc/passwd", 04, 0) = 0
  76. close(4) = 0
  77. lseek(3, 18944, 0) = 18944
  78. kread(3, "\00F0413\0\0\0 b0414\0\0".., 512) = 512
  79. kwrite(1, " C o n n e c t i n g t".., 77) = 77
  80. kfcntl(1, F_GETFL, 0x0000000000000008) = 2
  81. getdomainname(0x0FFFFFFFFFFF66B0, 256) = 0
  82. open("/etc/hosts", O_RDONLY) = 4
  83. kioctl(4, 22528, 0x0000000000000000, 0x0000000000000000) Err#25 ENOTTY
  84. kfcntl(4, F_SETFD, 0x0000000000000001) = 0
  85. kioctl(4, 22528, 0x0000000000000000, 0x0000000000000000) Err#25 ENOTTY
  86. kread(4, " # @ ( # ) 4 7\t 1 . 1".., 4096) = 2026
  87. kread(4, " # @ ( # ) 4 7\t 1 . 1".., 4096) = 0
  88. close(4) = 0
  89. socket(2, 1, 0) = 4
  90. getsockopt(4, 65535, 4104, 0x0FFFFFFFFFFF7644, 0x0FFFFFFFFFFF7640) = 0
  91. connext(4, 0x0000000110603D30, 16) (sleeping...)

再不停的重新connext这个过程。

  1. [$(hostname):oracle:/home/oracle]ping cdolm2
  2. PING cdolm2: (10.10.123.223): 56 data bytes
  3. 没有反应了，ctrl+c结局
  4. ^C
  5. ----cdolm2 PING Statistics----
  6. 4 packets transmitted, 0 packets received, 100% packet loss
  1. [$(hostname):oracle:/home/oracle]cat /etc/hosts
  2. 127.0.0.1 loopback localhost # loopback (lo0) name/address
  3. 10.0.0.6 cdolm2-priv
  4. 192.168.0.221 cdolm1
  5. 10.0.0.5 cdolm1-priv
  6. 192.168.0.232 cdolm2-vip
  7. 192.168.0.231 cdolm1-vip
  8. 10.10.123.223 cdolm2 cdolm2 /fdfd2
  9. 192.168.1.250 cdolm2
  10. 192.168.1.251 cdolm2
  11. 发现HOSTS文件不正确。

修改hosts

  1. [$(hostname):oracle:/home/oracle]set -o vi
  2. [$(hostname):oracle:/home/oracle]ifconfig -a
  3. en0: flags=4e080863,80
  4. inet 192.168.1.250 netmask 0xffffff00 broadcast 192.168.1.255
  5. lo0: flags=e08084b
  6. inet 127.0.0.1 netmask 0xff000000 broadcast 127.255.255.255
  7. inet6 ::1/0
  8. tcp_sendspace 131072 tcp_recvspace 131072 rfc1323 1
  9. 修改hosts文件
  10. 192.168.1.250 cdolm2

启动正常

  1. 启动正常
  2. [$(hostname):oracle:/u01/app/oracle/10.2.0/db_1/network/admin]lsnrctl start
  3. LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 20-MAR-2013 21:56:37
  4. Copyright (c) 1991, 2005, Oracle. All rights reserved.
  5. Starting /u01/app/oracle/10.2.0/db_1/bin/tnslsnr: please wait...
  6. TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
  7. System parameter file is /u01/app/oracle/10.2.0/db_1/network/admin/listener.ora
  8. Log messages written to /u01/app/oracle/10.2.0/db_1/network/log/listener.log
  9. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cdolm2)(PORT=1521)))
  10. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
  11. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cdolm2)(PORT=1521)))
  12. STATUS of the LISTENER
  13. ------------------------
  14. Alias LISTENER
  15. Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
  16. Start Date 20-MAR-2013 21:56:37
  17. Uptime 0 days 0 hr. 0 min. 1 sec
  18. Trace Level off
  19. Security ON: Local OS Authentication
  20. SNMP OFF
  21. Listener Parameter File /u01/app/oracle/10.2.0/db_1/network/admin/listener.ora
  22. Listener Log File /u01/app/oracle/10.2.0/db_1/network/log/listener.log
  23. Listening Endpoints Summary...
  24. (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cdolm2)(PORT=1521)))
  25. (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
  26. Services Summary...
  27. Service "PLSExtProc" has 1 instance(s).
  28. Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
  29. The command completed successfully
很赞哦！
监听 文件 配置 平台 公司 手动 日志 时候 服务器 结局 过程 进程 问题 反应 服务 测试 登陆 数据库的安全要保护哪些东西 数据库安全各自的含义是什么 生产安全数据库录入 数据库的安全性及管理 数据库安全策略包含哪些 海淀数据库安全审计系统 建立农村房屋安全信息数据库 易用的数据库客户端支持安全管理 连接数据库失败ssl安全错误 数据库的锁怎样保障安全 上海卓越科技互联网 互联网科技公司华为 互联网科技行业发展 北京互联网科技公司 苏州互联网科技贷款公司 互联网科技缩写 有木互联网科技 甘肃拓世互联网科技有限公司 恒生科技互联网指数分析 团飞科技与伯堂互联网服务平台 湖南诚度互联网科技有限公司 湖北码尼互联网科技有限公司电话 荆州市昕露互联网络科技有限公司 花神(南京)互联网科技有限公司 领航科技大厦互联网公司 东营紫格互联网科技 互联网硬科技公司 互联网科技收购价值 西安左小互联网科技有限公司 现代科技的标志之一的互联网 中国 科技 互联网 互联网科技公司电话 善班互联网科技 朗涯互联网科技 宜安科技 互联网金融 小马过河互联网科技 云电互联网科技 互联网时代科技改变生活 长沙互联网科技 安徽九吞吴互联网科技有限公司

相关文章

0