千家信息网

请输入关键字词

热门搜索排行

最新搜索排行

导航： 首页 > 数据库 >

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

发表于：2025-11-07 作者：千家信息网编辑
千家信息网最后更新 2025年11月07日，今天登陆了一下公司AIX平台的ORACLE测试服务器，没有配置监听，由于手动配置监听后，启动监听，发现启动的时候很慢，日志如下：欢迎大家加入ORACLE超级群：17115662 免费解决各种ORACL
千家信息网最后更新 2025年11月07日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安全错误 数据库的锁怎样保障安全 直销系统知晓软件开发 服务器安全工程师书籍 神奇宝贝服务器客户端 安防监控平台管理服务器 数据库系统的安全性问题 用json建立数据库 软件开发行业的成长 软件开发不用出差 校园日网络安全讲座 服务器进入硬盘启动项 怎样学手机软件开发 本机安装mysql数据库 国税局网络安全宣传画 广东社群互联网科技股东 海口app软件开发解决方案 网络安全制度6 造物法则手游服务器 数据库数据带一位小数 国家网络安全委员会是干嘛的 数据库技术的最新进展 SQL数据库删除还能恢复吗 鞍山租房软件开发 商云8 数据库配置文件 电石生产数据库 中微子软件开发公司 广西网络技术开发 天津crm软件开发公司 已连上wifi无法连接服务器 软件开发这一行怎么找工作 长宁区技术软件开发质量保障

相关文章

0