千家信息网

请输入关键字词

热门搜索排行

最新搜索排行

导航： 首页 > 数据库 >

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

发表于：2025-02-01 作者：千家信息网编辑
千家信息网最后更新 2025年02月01日，今天登陆了一下公司AIX平台的ORACLE测试服务器，没有配置监听，由于手动配置监听后，启动监听，发现启动的时候很慢，日志如下：欢迎大家加入ORACLE超级群：17115662 免费解决各种ORACL
千家信息网最后更新 2025年02月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安全错误 数据库的锁怎样保障安全 清远数据库机房建设 电脑一开机出现服务器登录失败 别克君威互联网科技技术 社区医院网络安全自查报告 使命召唤ol连接服务器会断开吗 网络安全公司的人犯罪 网络安全法对酒店管理等影响 数据库预约表 sql数据库建视图 容众网络技术有限公司 数据库查询某个字数量 济南网络安全资讯培训机构 cpu处理哪里的数据库 网络安全与执法概论小结 暨南大学网络安全基础考什么 专业数据库问题解决技术 如何处理数据库并发 mysql查询数据库表里内容 网络安全绘画男生网名 宜春做app的软件开发多少钱 河南乐游网络技术有限公司 hiveon矿池服务器 应用软件开发学院 江西学校卫星授时服务器虚拟主机 最近网络安全方面的新闻 如何控制信息化软件开发费用 网络安全智能监控平台 fifa15 连接服务器 政府网络安全关注点 县审计局网络安全工作

相关文章

0