当前位置: 首页 > LISTENER, ORA > 正文

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.  
  4. Copyright (c) 1991, 2005, Oracle.  All rights reserved.
  5.  
  6.  
  7.  
  8.  
  9.  
  10. Starting /u01/app/oracle/10.2.0/db_1/bin/tnslsnr: please wait...
  11.  
  12. TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
  13. System parameter file is /u01/app/oracle/10.2.0/db_1/network/admin/listener.ora
  14. Log messages written to /u01/app/oracle/10.2.0/db_1/network/log/listener.log
  15. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cdolm2)(PORT=1521)))
  16. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
  17.  
  18. 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.  
  9. 10.10.123.223   cdolm2 cdolm2  /fdfd2
  10. 192.168.1.250   cdolm2
  11.  
  12. 192.168.1.251   cdolm2
  13. 发现HOSTS文件不正确。

修改hosts

  1. [$(hostname):oracle:/home/oracle]set -o vi
  2. [$(hostname):oracle:/home/oracle]ifconfig -a
  3. en0: flags=4e080863,80<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,PSEG,CHAIN>
  4.         inet 192.168.1.250 netmask 0xffffff00 broadcast 192.168.1.255
  5. lo0: flags=e08084b<UP,BROADCAST,LOOPBACK,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT>
  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.          
  10.          
  11.          
  12. 修改hosts文件
  13.  
  14. 192.168.1.250   cdolm2

启动正常

  1. 启动正常
  2. [$(hostname):oracle:/u01/app/oracle/10.2.0/db_1/network/admin]lsnrctl start
  3.  
  4. LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 20-MAR-2013 21:56:37
  5.  
  6. Copyright (c) 1991, 2005, Oracle.  All rights reserved.
  7.  
  8. Starting /u01/app/oracle/10.2.0/db_1/bin/tnslsnr: please wait...
  9.  
  10. TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
  11. System parameter file is /u01/app/oracle/10.2.0/db_1/network/admin/listener.ora
  12. Log messages written to /u01/app/oracle/10.2.0/db_1/network/log/listener.log
  13. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cdolm2)(PORT=1521)))
  14. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
  15.  
  16. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=cdolm2)(PORT=1521)))
  17. STATUS of the LISTENER
  18. ------------------------ 
  19. Alias                     LISTENER
  20. Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
  21. Start Date                20-MAR-2013 21:56:37
  22. Uptime                    0 days 0 hr. 0 min. 1 sec
  23. Trace Level               off 
  24. Security                  ON: Local OS Authentication
  25. SNMP                      OFF 
  26. Listener Parameter File   /u01/app/oracle/10.2.0/db_1/network/admin/listener.ora
  27. Listener Log File         /u01/app/oracle/10.2.0/db_1/network/log/listener.log
  28. Listening Endpoints Summary...
  29.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cdolm2)(PORT=1521)))
  30.   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
  31. Services Summary...
  32. Service "PLSExtProc" has 1 instance(s).
  33.   Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
  34. The command completed successfully
 

本文固定链接: http://www.htz.pw/2014/05/25/lsnrctl-start%e5%90%af%e5%8a%a8%e7%9b%91%e5%90%ac%e5%be%88%e6%85%a2aix%e5%b9%b3%e5%8f%b0.html | 认真就输

该日志由 huangtingzhong 于2014年05月25日发表在 LISTENER, ORA 分类下, 你可以发表评论,并在保留原文地址及作者的情况下引用到你的网站或博客。
原创文章转载请注明: lsnrctl start启动监听很慢(AIX平台) | 认真就输