Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › oracle 11.2.0.3 rac 监听经常停止
发新帖
ShineCQY

84

积分

1

好友

27

主题

[升级] oracle 11.2.0.3 rac 监听经常停止

1#
发表于 2013-12-3 13:25:18 | 查看: 4977| 回复: 4
环境：oracle 11.2.0.3 rac on AIX 6.1
总是第3个节点listener 停止。希望刘大以及热心的网友帮忙看下是BUG还是其他故障... 附件中为agent日志
db3[/home/oracle]$crs_stat -t
Name           Type           Target    State     Host        
------------------------------------------------------------
ora.DATA.dg    ora....up.type ONLINE    ONLINE    db1         
ora....ER.lsnr ora....er.type ONLINE    ONLINE    db1         
ora....N1.lsnr ora....er.type ONLINE    ONLINE    db1         
ora.MUSICA.dg  ora....up.type ONLINE    ONLINE    db1         
ora.asm        ora.asm.type   ONLINE    ONLINE    db1         
ora.cvu        ora.cvu.type   ONLINE    ONLINE    db1         
ora....SM1.asm application    ONLINE    ONLINE    db1         
ora....B1.lsnr application    ONLINE    ONLINE    db1         
ora.db1.gsd    application    ONLINE    OFFLINE               
ora.db1.ons    application    ONLINE    ONLINE    db1         
ora.db1.vip    ora....t1.type ONLINE    ONLINE    db1         
ora....SM2.asm application    ONLINE    ONLINE    db2         
ora....B2.lsnr application    ONLINE    ONLINE    db2         
ora.db2.gsd    application    ONLINE    OFFLINE               
ora.db2.ons    application    ONLINE    ONLINE    db2         
ora.db2.vip    ora....t1.type ONLINE    ONLINE    db2         
ora....SM3.asm application    ONLINE    ONLINE    db3         
ora....B3.lsnr application    ONLINE    OFFLINE               
ora.db3.gsd    application    ONLINE    OFFLINE               
ora.db3.ons    application    ONLINE    ONLINE    db3         
ora.db3.vip    ora....t1.type ONLINE    ONLINE    db3         
ora.gsd        ora.gsd.type   ONLINE    OFFLINE               
ora.musicdw.db ora....se.type ONLINE    ONLINE    db1         
ora....dw1.svc ora....ce.type ONLINE    ONLINE    db2         
ora....dw2.svc ora....ce.type ONLINE    ONLINE    db2         
ora....dw3.svc ora....ce.type ONLINE    ONLINE    db2         
ora....network ora....rk.type ONLINE    ONLINE    db1         
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    db2         
ora.ons        ora.ons.type   ONLINE    ONLINE    db1         
ora....ry.acfs ora....fs.type ONLINE    ONLINE    db1         
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    db1
listener 配置
listener.ora
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))                # line added by Agent
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))            # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON                # line added by Agent
listener日志
03-DEC-2013 10:28:17 * service_update * musicdw3 * 0
Tue Dec 03 10:30:54 2013
03-DEC-2013 10:30:29 * service_update * musicdw3 * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.25.161.158)(PORT=1521)))
03-DEC-2013 10:31:03 * service_died * LsnrAgt * 12537
Tue Dec 03 10:31:06 2013
03-DEC-2013 10:31:06 * service_update * musicdw3 * 0
03-DEC-2013 10:31:09 * service_update * musicdw3 * 0
Tue Dec 03 10:31:16 2013
03-DEC-2013 10:31:15 * service_update * musicdw3 * 0
03-DEC-2013 10:31:19 * service_update * +ASM3 * 0
03-DEC-2013 10:31:21 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=musicdw)(CID=(PROGRAM=sqlplus@web2)(HOST=web2)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.2
5.161.174)(PORT=47347)) * establish * musicdw * 0
03-DEC-2013 10:31:21 * service_update * musicdw3 * 0
03-DEC-2013 10:31:24 * service_update * musicdw3 * 0
Tue Dec 03 10:31:33 2013
03-DEC-2013 10:31:33 * service_update * musicdw3 * 0
03-DEC-2013 10:31:38 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=musicdw)(failover_mode=(type=select)(method=basic)(retries=5)(delay=5))(CID=(PROGRAM=python)(HOST
=db1)(USER=etl))(INSTANCE_NAME=musicdw3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.25.161.154)(PORT=62033)) * establish * musicdw * 0
03-DEC-2013 10:31:40 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=db3)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0
03-DEC-2013 10:31:43 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=musicdw)(failover_mode=(type=select)(method=basic)(retries=5)(delay=5))(CID=(PROGRAM=python)(HOST
=db1)(USER=etl))(INSTANCE_NAME=musicdw3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.25.161.154)(PORT=62045)) * establish * musicdw * 0
03-DEC-2013 10:31:43 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=musicdw)(failover_mode=(type=select)(method=basic)(retries=5)(delay=5))(CID=(PROGRAM=python)(HOST
=db3)(USER=etl))(INSTANCE_NAME=musicdw3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.25.161.158)(PORT=53368)) * establish * musicdw * 0
Tue Dec 03 10:31:43 2013
03-DEC-2013 10:31:43 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=musicdw)(failover_mode=(type=select)(method=basic)(retries=5)(delay=5))(CID=(PROGRAM=python)(HOST
=db3)(USER=etl))(INSTANCE_NAME=musicdw3)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.25.161.158)(PORT=53372)) * establish * musicdw * 0
03-DEC-2013 10:31:46 * version * 0
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.25.161.158)(PORT=1521)))
Dynamic address is already listened on (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.25.161.157)(PORT=1521)))
03-DEC-2013 10:31:46 * service_register * LsnrAgt * 0
03-DEC-2013 10:31:47 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=db3)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.25.161.158)(PORT=1521)))
03-DEC-2013 10:31:48 * service_died * LsnrAgt * 12537
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.25.161.157)(PORT=1521)))
Listener completed notification to CRS on stop
03-DEC-2013 10:31:48 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=db3)(USER=grid))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * stop * 0
listener.log: END

oraagent_grid.rar

7.87 KB, 下载次数: 959
2#
发表于 2013-12-3 15:03:57
crs日志

ocssd.rar

32.83 KB, 下载次数: 1023

crsd.rar

5.79 KB, 下载次数: 1026

回复 只看该作者 道具 举报

3#
发表于 2013-12-3 16:50:26
  1. [oracle@mlab2 ~]$ grep -i "ora.LISTENER.lsnr" oraagent_grid.log
  2. 2013-12-03 10:31:47.711: [ora.LISTENER.lsnr][1291] {0:14:2} [check] getOracleHomeAttrib: oracle_home = /oracle/app/11.2.0/grid
  3. 2013-12-03 10:31:47.712: [ora.LISTENER.lsnr][1291] {0:14:2} [check] getOracleHomeAttrib: oracle_home = /oracle/app/11.2.0/grid
  4. 2013-12-03 10:31:47.712: [ora.LISTENER.lsnr][1291] {0:14:2} [check] Utils::getCrsHome crsHome /oracle/app/11.2.0/grid
  5. 2013-12-03 10:31:47.712: [ora.LISTENER.lsnr][1291] {0:14:2} [check] Utils::execCmd 1 USR_ORA_ENV:ORACLE_BASE=/oracle/app/11.2.0/app oracleHome:/oracle/app/11.2.0/grid CrsHome:/oracle/app/11.2.0/grid
  6. 2013-12-03 10:31:47.713: [ora.LISTENER.lsnr][1291] {0:14:2} [check] Utils::getCrsHome crsHome /oracle/app/11.2.0/grid
  7. 2013-12-03 10:31:47.713: [ora.LISTENER.lsnr][1291] {0:14:2} [check] Utils::getCrsHome crsHome /oracle/app/11.2.0/grid
  8. 2013-12-03 10:31:47.713: [ora.LISTENER.lsnr][1291] {0:14:2} [check] Adding Environment Variables ORACLE_HOME=/oracle/app/11.2.0/grid
  9. 2013-12-03 10:31:47.713: [ora.LISTENER.lsnr][1291] {0:14:2} [check] Adding Environment Variables TNS_ADMIN=/oracle/app/11.2.0/grid/network/admin/
  10. 2013-12-03 10:31:47.713: [ora.LISTENER.lsnr][1291] {0:14:2} [check] Adding Environment variable from USR_ORA_ENV ORACLE_BASE=/oracle/app/11.2.0/app
  11. 2013-12-03 10:31:47.713: [ora.LISTENER.lsnr][1291] {0:14:2} [check] Utils:execCmd action = 3 flags = 38 ohome = (null) cmdname = lsnrctl.
  12. 2013-12-03 10:31:47.713: [ora.LISTENER.lsnr][1291] {0:14:2} [check] getOracleHomeAttrib: oracle_home = /oracle/app/11.2.0/grid
  13. 2013-12-03 10:31:47.928: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)
  14. 2013-12-03 10:31:47.928: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 03-DEC-2013 10:31:47
  15. 2013-12-03 10:31:47.928: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)
  16. 2013-12-03 10:31:47.929: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)Copyright (c) 1991, 2011, Oracle.  All rights reserved.
  17. 2013-12-03 10:31:47.929: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)
  18. 2013-12-03 10:31:47.929: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
  19. 2013-12-03 10:31:47.929: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)
  20. 2013-12-03 10:31:48.029: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)STATUS of the LISTENER
  21. 2013-12-03 10:31:48.029: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)------------------------
  22. 2013-12-03 10:31:48.029: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)Alias                     LISTENER
  23. 2013-12-03 10:31:48.030: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
  24. 2013-12-03 10:31:48.030: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)Start Date                30-NOV-2013 11:45:23
  25. 2013-12-03 10:31:48.030: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)Uptime                    2 days 22 hr. 46 min. 24 sec
  26. 2013-12-03 10:31:48.030: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)Trace Level               off
  27. 2013-12-03 10:31:48.030: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)Security                  ON: Local OS Authentication
  28. 2013-12-03 10:31:48.030: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)SNMP                      ON
  29. 2013-12-03 10:31:48.030: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)Listener Parameter File   /oracle/app/11.2.0/grid/network/admin/listener.ora
  30. 2013-12-03 10:31:48.030: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)
  31. 2013-12-03 10:31:48.031: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)Listener Log File         /oracle/app/11.2.0/app/diag/tnslsnr/db3/listener/alert/log.xml
  32. 2013-12-03 10:31:48.031: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)Listening Endpoints Summary...
  33. 2013-12-03 10:31:48.031: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  34. 2013-12-03 10:31:48.031: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.25.161.157)(PORT=1521)))
  35. 2013-12-03 10:31:48.031: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.25.161.158)(PORT=1521)))
  36. 2013-12-03 10:31:48.031: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)Services Summary...
  37. 2013-12-03 10:31:48.031: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)Service "+ASM" has 1 instance(s).
  38. 2013-12-03 10:31:48.031: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)  Instance "+ASM3", status READY, has 1 handler(s) for this service...
  39. 2013-12-03 10:31:48.032: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)Service "musicdw" has 1 instance(s).
  40. 2013-12-03 10:31:48.032: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)
  41. 2013-12-03 10:31:48.032: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)  Instance "musicdw3", status READY, has 1 handler(s) for this service...
  42. 2013-12-03 10:31:48.032: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)Service "musicdwXDB" has 1 instance(s).
  43. 2013-12-03 10:31:48.032: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)  Instance "musicdw3", status READY, has 1 handler(s) for this service...
  44. 2013-12-03 10:31:48.032: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)The command completed successfully
  45. 2013-12-03 10:31:48.032: [ora.LISTENER.lsnr][1291] {0:14:2} [check] (:CLSN00010:)
  46. 2013-12-03 10:31:48.033: [ora.LISTENER.lsnr][1291] {0:14:2} [check] execCmd ret = 0
  47. 2013-12-03 10:31:48.033: [ora.LISTENER.lsnr][1291] {0:14:2} [check] return val (clsagfwret) = 0
  48. 2013-12-03 10:31:48.033: [ora.LISTENER.lsnr][1291] {0:14:2} [check] LsnrAgent::check }
  49. 2013-12-03 10:31:48.035: [    AGFW][2314] {0:14:2} ora.LISTENER.lsnr db3 1 state changed from: STOPPING to: ONLINE
  50. 2013-12-03 10:31:48.035: [    AGFW][2314] {0:14:2} Started implicit monitor for [ora.LISTENER.lsnr db3 1] interval=60000 delay=60000
  51. 2013-12-03 10:31:48.037: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] (:CLSN00108:) clsn_agent::stop {
  52. 2013-12-03 10:31:48.038: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] LsnrAgent::stop {
  53. 2013-12-03 10:31:48.076: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] lsnrctl stop LISTENER
  54. 2013-12-03 10:31:48.076: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] getOracleHomeAttrib: oracle_home = /oracle/app/11.2.0/grid
  55. 2013-12-03 10:31:48.077: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] getOracleHomeAttrib: oracle_home = /oracle/app/11.2.0/grid
  56. 2013-12-03 10:31:48.077: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] Utils::getCrsHome crsHome /oracle/app/11.2.0/grid
  57. 2013-12-03 10:31:48.077: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] Utils::execCmd 1 USR_ORA_ENV:ORACLE_BASE=/oracle/app/11.2.0/app oracleHome:/oracle/app/11.2.0/grid CrsHome:/oracle/app/11.2.0/grid
  58. 2013-12-03 10:31:48.077: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] Utils::getCrsHome crsHome /oracle/app/11.2.0/grid
  59. 2013-12-03 10:31:48.077: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] Utils::getCrsHome crsHome /oracle/app/11.2.0/grid
  60. 2013-12-03 10:31:48.078: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] Adding Environment Variables ORACLE_HOME=/oracle/app/11.2.0/grid
  61. 2013-12-03 10:31:48.078: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] Adding Environment Variables TNS_ADMIN=/oracle/app/11.2.0/grid/network/admin/
  62. 2013-12-03 10:31:48.078: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] Adding Environment variable from USR_ORA_ENV ORACLE_BASE=/oracle/app/11.2.0/app
  63. 2013-12-03 10:31:48.078: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] Utils:execCmd action = 2 flags = 38 ohome = (null) cmdname = lsnrctl.
  64. 2013-12-03 10:31:48.078: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] getOracleHomeAttrib: oracle_home = /oracle/app/11.2.0/grid
  65. 2013-12-03 10:31:48.194: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] (:CLSN00010:)
  66. 2013-12-03 10:31:48.195: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] (:CLSN00010:)LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 03-DEC-2013 10:31:48
  67. 2013-12-03 10:31:48.195: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] (:CLSN00010:)
  68. 2013-12-03 10:31:48.195: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] (:CLSN00010:)Copyright (c) 1991, 2011, Oracle.  All rights reserved.
  69. 2013-12-03 10:31:48.195: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] (:CLSN00010:)
  70. 2013-12-03 10:31:48.195: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] (:CLSN00010:)Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
  71. 2013-12-03 10:31:48.195: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] (:CLSN00010:)
  72. 2013-12-03 10:31:49.850: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] (:CLSN00010:)The command completed successfully
  73. 2013-12-03 10:31:49.850: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] (:CLSN00010:)
  74. 2013-12-03 10:31:49.851: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] execCmd ret = 0
  75. 2013-12-03 10:31:49.851: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] LsnrAgent::stop }
  76. 2013-12-03 10:31:49.851: [ora.LISTENER.lsnr][1291] {0:2:12916} [stop] (:CLSN00108:) clsn_agent::stop }
  77. 2013-12-03 10:31:49.851: [    AGFW][1291] {0:2:12916} Command: stop for resource: ora.LISTENER.lsnr db3 1 completed with status: SUCCESS
  78. 2013-12-03 10:31:49.853: [    AGFW][2314] {0:2:12916} Agent sending reply for: RESOURCE_STOP[ora.LISTENER.lsnr db3 1] ID 4099:535051
  79. 2013-12-03 10:31:49.855: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] LsnrAgent::check {
  80. 2013-12-03 10:31:49.855: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] lsnrctl status LISTENER
  81. 2013-12-03 10:31:49.856: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] getOracleHomeAttrib: oracle_home = /oracle/app/11.2.0/grid
  82. 2013-12-03 10:31:49.857: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] getOracleHomeAttrib: oracle_home = /oracle/app/11.2.0/grid
  83. 2013-12-03 10:31:49.857: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] Utils::getCrsHome crsHome /oracle/app/11.2.0/grid
  84. 2013-12-03 10:31:49.857: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] Utils::execCmd 1 USR_ORA_ENV:ORACLE_BASE=/oracle/app/11.2.0/app oracleHome:/oracle/app/11.2.0/grid CrsHome:/oracle/app/11.2.0/grid
  85. 2013-12-03 10:31:49.858: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] Utils::getCrsHome crsHome /oracle/app/11.2.0/grid
  86. 2013-12-03 10:31:49.858: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] Utils::getCrsHome crsHome /oracle/app/11.2.0/grid
  87. 2013-12-03 10:31:49.858: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] Adding Environment Variables ORACLE_HOME=/oracle/app/11.2.0/grid
  88. 2013-12-03 10:31:49.858: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] Adding Environment Variables TNS_ADMIN=/oracle/app/11.2.0/grid/network/admin/
  89. 2013-12-03 10:31:49.858: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] Adding Environment variable from USR_ORA_ENV ORACLE_BASE=/oracle/app/11.2.0/app
  90. 2013-12-03 10:31:49.858: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] Utils:execCmd action = 3 flags = 38 ohome = (null) cmdname = lsnrctl.
  91. 2013-12-03 10:31:49.858: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] getOracleHomeAttrib: oracle_home = /oracle/app/11.2.0/grid
  92. 2013-12-03 10:31:50.075: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] (:CLSN00010:)
  93. 2013-12-03 10:31:50.075: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] (:CLSN00010:)LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 03-DEC-2013 10:31:49
  94. 2013-12-03 10:31:50.075: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] (:CLSN00010:)
  95. 2013-12-03 10:31:50.075: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] (:CLSN00010:)Copyright (c) 1991, 2011, Oracle.  All rights reserved.
  96. 2013-12-03 10:31:50.076: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] (:CLSN00010:)
  97. 2013-12-03 10:31:50.076: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] (:CLSN00010:)Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
  98. 2013-12-03 10:31:50.076: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] (:CLSN00010:)TNS-12541: TNS:no listener
  99. 2013-12-03 10:31:50.076: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] (:CLSN00010:) TNS-12560: TNS:protocol adapter error
  100. 2013-12-03 10:31:50.077: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] (:CLSN00010:)  TNS-00511: No listener
  101. 2013-12-03 10:31:50.077: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] (:CLSN00010:)   IBM/AIX RISC System/6000 Error: 2: No such file or directory
  102. 2013-12-03 10:31:50.077: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] (:CLSN00010:)
  103. 2013-12-03 10:31:50.077: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] (:CLSN00010:)Utils:execCmd scls_process_join() uret 1
  104. 2013-12-03 10:31:50.078: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] execCmd ret = 1
  105. 2013-12-03 10:31:50.078: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] (:CLSN00010:)
  106. 2013-12-03 10:31:50.078: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] (:CLSN00010:)LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production on 03-DEC-2013 10:31:49
  107. 2013-12-03 10:31:50.078: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] (:CLSN00010:)
  108. 2013-12-03 10:31:50.078: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] (:CLSN00010:)Copyright (c) 1991, 2011, Oracle.  All rights reserved.
  109. 2013-12-03 10:31:50.078: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] (:CLSN00010:)
  110. 2013-12-03 10:31:50.078: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] (:CLSN00010:)Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
  111. 2013-12-03 10:31:50.078: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] (:CLSN00010:)TNS-12541: TNS:no listener
  112. 2013-12-03 10:31:50.079: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] (:CLSN00010:) TNS-12560: TNS:protocol adapter error
  113. 2013-12-03 10:31:50.079: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] (:CLSN00010:)  TNS-00511: No listener
  114. 2013-12-03 10:31:50.079: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] (:CLSN00010:)   IBM/AIX RISC System/6000 Error: 2: No such file or directory
  115. 2013-12-03 10:31:50.079: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] (:CLSN00010:)
  116. 2013-12-03 10:31:50.079: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] return val (clsagfwret) = 1
  117. 2013-12-03 10:31:50.079: [ora.LISTENER.lsnr][2829] {0:2:12916} [check] LsnrAgent::check }
  118. 2013-12-03 10:31:50.080: [    AGFW][2314] {0:2:12916} ora.LISTENER.lsnr db3 1 state changed from: ONLINE to: OFFLINE
  119. 2013-12-03 10:31:50.081: [    AGFW][2314] {0:2:12916} Agent sending last reply for: RESOURCE_STOP[ora.LISTENER.lsnr db3 1] ID 4099:535051
复制代码
就oraagent_grid.log  看没有看到 listener 频发停止，仅有的停止也是人为 STOP的

回复 只看该作者 道具 举报

4#
发表于 2013-12-3 17:12:34
刘大这个只是今天的agent日志，我把以往的上传上来。一个月有非人为的4次左右stop。怀疑是某种冲突或者bug引起的。

oraagent_grid.log2.rar

273.25 KB, 下载次数: 999

回复 只看该作者 道具 举报

5#
发表于 2013-12-3 17:21:55
Liu Maclean(刘相兵 发表于 2013-12-3 16:50
就oraagent_grid.log  看没有看到 listener 频发停止，仅有的停止也是人为 STOP的

4楼附件中有详细日志。

回复 只看该作者 道具 举报

返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-6-14 20:34 , Processed in 0.071608 second(s), 23 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569