千家信息网

请输入关键字词

热门搜索排行

最新搜索排行

导航： 首页 > 数据库 >

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

发表于：2024-11-23 作者：千家信息网编辑
千家信息网最后更新 2024年11月23日，今天登陆了一下公司AIX平台的ORACLE测试服务器，没有配置监听，由于手动配置监听后，启动监听，发现启动的时候很慢，日志如下：欢迎大家加入ORACLE超级群：17115662 免费解决各种ORACL
千家信息网最后更新 2024年11月23日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安全错误 数据库的锁怎样保障安全 数据库设计 字段名字 hp服务器说明书 哪个游戏服务器最好玩 软件开发 安全认证 计算机二级数据库考试条件 网络安全法是谁提议的 家务日记软件开发 数据库设计理论问题 app的服务器端 垃圾分类软件开发教程 软件开发都有什么工具 裸金属服务器纳管保留数据 php网页服务器 数据库 实体 深圳稳大网络技术有限公司 软件开发嵌入式课程 嵌入式和软件开发哪个薪资高 网络技术考题库吗 籽岷我的世界服务器生存 实验5 数据库完整性管理 xampp服务器 海曙嵌入式软件开发公司 列表网股票配资软件开发 国际服出现服务器未连接怎么办 黑龙江服务器电源厂商 缔邑网络技术有限公司 金卡网络技术有限公司 斐丽网络技术好吗 数据库技术文 汇丰高级软件开发工程师

相关文章

0