alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)
点击数：2008发布日期：2020-05-23 16:47:35 来源：alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)
新闻摘要:alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)
老鹰（北京）有限公司
北京市公安局
数据库故障处理报告
作者: 付培利
创建日期: 2010年08月26日
最后修改日期: 2010年08月26日
修改记录
|
日期 |
作者 |
版本 |
修改记录 |
|
|
|
|
|
|
2010-08-26 |
付培利 |
1.0 |
Initial |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
分发者
|
姓名 |
公司 |
|
|
北京移动 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
审阅记录
|
姓名 |
职位 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
相关文档
1.
TOC \o "1-4" \h \z 1. 文档控制. PAGEREF _Toc270673262 \h ii
修改记录 PAGEREF _Toc270673263 \h ii
分发者 PAGEREF _Toc270673264 \h ii
审阅记录 PAGEREF _Toc270673265 \h ii
相关文档 PAGEREF _Toc270673266 \h ii
2. 目录 PAGEREF _Toc270673267 \h iii
3. 总结 PAGEREF _Toc270673268 \h 4
4. 现场处理. PAGEREF _Toc270673269 \h 5
5. 建议 PAGEREF _Toc270673270 \h 8
应首信公司要求。诊断北京丰台公安局数据库连接报错。数据库出现的报错和vip有关。关于loacl_listener vip的指定已经修改。
解决此问题已执行的几个动作：
1、 修改local_listener配置
alter system set local_listener='(ADDRESS=(PROTOCOL=TCP) (HOST = db1-vip )(PORT = 1521 ))' scope=both sid='ejxx1';
alter system set local_listener='(ADDRESS=(PROTOCOL=TCP) (HOST = db2-vip )(PORT = 1521 ))' scope=both sid='ejxx2';
2、将实例1、2分别停止。测试应用的连接性。
结果通过验证。
SUCCESS: diskgroup ARCH was mounted
SUCCESS: diskgroup ARCH was dismounted
SUCCESS: diskgroup ARCH was mounted
SUCCESS: diskgroup ARCH was dismounted
SUCCESS: diskgroup ARCH was mounted
SUCCESS: diskgroup ARCH was dismounted
SUCCESS: diskgroup ARCH was mounted
SUCCESS: diskgroup ARCH was dismounted
SUCCESS: diskgroup ARCH was mounted
SUCCESS: diskgroup ARCH was dismounted
这是oracle一个bug.目前oracle没有发布关于此bug的补丁。可以提交一个tar。参考oracle support的回复。
2、alert_ejxx1.log报错
Wed Aug 25 17:16:09 2010
Submitted all GCS remote-cache requests
Post SMON to start 1st pass IR
Fix write in gcs resources
Reconfiguration complete
Thu Aug 26 00:14:42 2010
Thread 1 advanced to log sequence 533 (LGWR switch)
Current log# 1 seq# 533 mem# 0: +DATA/ejxx/onlinelog/group_1.257.714248911
Thu Aug 26 05:29:51 2010
ALTER SYSTEM SET service_names='' SCOPE=MEMORY SID='ejxx1';
Thu Aug 26 05:29:51 2010
Immediate Kill Session#: 1055, Serial#: 280
Immediate Kill Session: sess: c000000561a04c50 OS pid: 12237
Immediate Kill Session#: 1057, Serial#: 46
Immediate Kill Session: sess: c000000561a061b8 OS pid: 12640
Immediate Kill Session#: 1058, Serial#: 2043
Immediate Kill Session: sess: c0000005649f4e88 OS pid: 12298
Immediate Kill Session#: 1060, Serial#: 180
Immediate Kill Session: sess: c0000005649f63f0 OS pid: 12291
Immediate Kill Session#: 1063, Serial#: 95
Immediate Kill Session: sess: c000000561a0a1f0 OS pid: 12190
Immediate Kill Session#: 1064, Serial#: 97
Immediate Kill Session: sess: c0000005649f8ec0 OS pid: 7370
Immediate Kill Session#: 1065, Serial#: 1
Immediate Kill Session: sess: c000000561a0b758 OS pid: 5591
Immediate Kill Session#: 1066, Serial#: 59
Immediate Kill Session: sess: c0000005649fa428 OS pid: 5821
Immediate Kill Session#: 1068, Serial#: 63
Immediate Kill Session: sess: c0000005649fb990 OS pid: 5639
Immediate Kill Session#: 1069, Serial#: 3698
Immediate Kill Session: sess: c000000561a0e228 OS pid: 12616
Immediate Kill Session#: 1072, Serial#: 15
Immediate Kill Session: sess: c0000005649fe460 OS pid: 5471
Immediate Kill Session#: 1082, Serial#: 5057
Immediate Kill Session: sess: c000000564a04f68 OS pid: 11714
Immediate Kill Session#: 1086, Serial#: 9690
Immediate Kill Session: sess: c000000564a07a38 OS pid: 12199
Thu Aug 26 08:04:46 2010
ALTER SYSTEM SET service_names='ejxx' SCOPE=MEMORY SID='ejxx1';
Thu Aug 26 08:45:29 2010
ALTER SYSTEM SET service_names='' SCOPE=MEMORY SID='ejxx1';
Thu Aug 26 08:45:29 2010
Immediate Kill Session#: 1058, Serial#: 2398
Immediate Kill Session: sess: c0000005649f4e88 OS pid: 9488
Immediate Kill Session#: 1059, Serial#: 5529
Immediate Kill Session: sess: c000000561a07720 OS pid: 8276
Immediate Kill Session#: 1066, Serial#: 63
Immediate Kill Session: sess: c0000005649fa428 OS pid: 8278
Thu Aug 26 09:34:13 2010
Shutting down instance: further logons disabled
Thu Aug 26 09:34:13 2010
Stopping background process CJQ0
Thu Aug 26 09:34:13 2010
Stopping background process QMNC
Thu Aug 26 09:34:16 2010
Stopping background process MMNL
Thu Aug 26 09:34:17 2010
Stopping background process MMON
Thu Aug 26 09:34:18 2010
Shutting down instance (immediate)
License high water mark = 25
Thu Aug 26 09:34:18 2010
Stopping Job queue slave processes, flags = 7
Thu Aug 26 09:34:18 2010
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Thu Aug 26 09:34:21 2010
ALTER DATABASE CLOSE NORMAL
Thu Aug 26 09:34:21 2010
SMON: disabling tx recovery
SMON: disabling cache recovery
Thu Aug 26 09:34:21 2010
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 533
Successful close of redo thread 1
Thu Aug 26 09:34:26 2010
Completed: ALTER DATABASE CLOSE NORMAL
Thu Aug 26 09:34:26 2010
ALTER DATABASE DISMOUNT
Thu Aug 26 09:34:27 2010
SUCCESS: diskgroup DATA was dismounted
Thu Aug 26 09:34:27 2010
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thu Aug 26 09:34:41 2010
freeing rdom 0
Thu Aug 26 10:05:51 2010
由于vip错误导致listener和 asm相继出错。修改local_listener之后。
3、crs日志错误alertdb1.log
2010-03-21 19:32:45.480
[cssd(24699)]CRS-1612:node db2 (0) at 50% heartbeat fatal, eviction in 0.000 seconds
2010-03-21 19:32:46.490
[cssd(24699)]CRS-1612:node db2 (0) at 50% heartbeat fatal, eviction in 0.000 seconds
2010-03-21 19:32:53.560
[cssd(24699)]CRS-1611:node db2 (0) at 75% heartbeat fatal, eviction in 0.000 seconds
2010-03-21 19:32:57.600
[cssd(24699)]CRS-1610:node db2 (0) at 90% heartbeat fatal, eviction in 0.000 seconds
2010-03-21 19:32:58.610
[cssd(24699)]CRS-1610:node db2 (0) at 90% heartbeat fatal, eviction in 0.000 seconds
2010-03-21 19:32:59.620
[cssd(24699)]CRS-1610:node db2 (0) at 90% heartbeat fatal, eviction in 0.000 seconds
2010-03-21 19:33:00.272
[cssd(24699)]CRS-1607:CSSD evicting node db2. Details in /oracle/crs/product/10.2.0/log/db1/cssd/ocssd.log.
[cssd(24699)]CRS-1601:CSSD Reconfiguration complete. Active nodes are db1 .
2010-03-21 19:33:37.585
[crsd(24493)]CRS-1204:Recovering CRS resources for node db2.
[cssd(24699)]CRS-1601:CSSD Reconfiguration complete. Active nodes are db1 db2 .
[cssd(24699)]CRS-1603:CSSD on node db1 shutdown by user.
2010-03-21 19:49:59.641
[cssd(22397)]CRS-1605:CSSD voting file is online: /dev/rdisk/disk41. Details in /oracle/crs/product/10.2.0/log/db1/cssd/ocssd.log.
4、crs日志错误alertdb2.log
2010-08-23 10:16:41.333
[crsd(2457)]CRS-1201:CRSD started on node db2.
2010-08-23 10:17:27.280
[cssd(2666)]CRS-1612:node db1 (0) at 50% heartbeat fatal, eviction in 0.000 seconds
2010-08-23 10:17:34.350
[cssd(2666)]CRS-1611:node db1 (0) at 75% heartbeat fatal, eviction in 0.000 seconds
2010-08-23 10:17:38.390
[cssd(2666)]CRS-1610:node db1 (0) at 90% heartbeat fatal, eviction in 0.000 seconds
2010-08-23 10:17:39.400
[cssd(2666)]CRS-1610:node db1 (0) at 90% heartbeat fatal, eviction in 0.000 seconds
2010-08-23 10:17:40.410
[cssd(2666)]CRS-1610:node db1 (0) at 90% heartbeat fatal, eviction in 0.000 seconds
2010-08-23 10:17:41.342
[cssd(2666)]CRS-1607:CSSD evicting node db1. Details in /oracle/crs/product/10.2.0/log/db2/cssd/ocssd.log.
[cssd(2666)]CRS-1601:CSSD Reconfiguration complete. Active nodes are db2 .
2010-08-23 10:17:41.452
[crsd(2457)]CRS-1005:The OCR upgrade was completed. Version has changed from 169870336 to 169870336. Details in /oracle/crs/product/10.2.0/log/db2/crsd/crsd.log.
心跳线不稳定会导致此错误发生。
1、将心跳线网卡连接到交换机上。确保心跳线传输速度和稳定性。
2、将数据库升级至10.2.0.5。
3、建议观察asm日志和数据库压力。
图文推荐
序言
2020-04-19 查看：2271
第十五章：Oracle 12c介绍
2020-04-19 查看：2208
第十四章：常用Oracle工具
2020-04-19 查看：1934
第十三章：Oracle Golde...
2020-04-19 查看：2199
第十二章：DataGuard
2020-04-19 查看：1796
