Ref:
http://heliosguneserol.wordpress.com/2012/10/19/how-to-relocate-scan_listener-from-one-node-to-another-node-on-rac-system/
透過host-vip,1521 port可以連至DB,
但透過scan-ip, 1521 port就連接失敗, 感覺跟上面連結的文章描述有點像, 於是想到有幾個方法
1.stop listener, start listener
==>無效
2.stop listener, stop scan vip, start scan vip, start listener
==>無效
3.relocate three scan listener (考量有可能scan ip 從node1 transfer到node2, 但listener 於各nodes運作正常)
As grid:
srvctl relocate scan -i 1
srvctl relocate scan -i 2
srvctl relocate scan -i 3
大概觀察了一分鐘, 再用rac-scan 去連接, 結果還是不行
最後才發現, 是scan listener log 達到4gb 大小, 真是傻眼...
看來越簡單的細節, 我們越容易忽略...Sigh.....
==============================================
[grid@rac2 ~]$ps -ef|grep tnsl
oracle 5830 1 0 12:38 ? 00:00:00 /u01/app//grid/grid112/bin/tnslsnr LISTENER_SCAN3 -inherit
oracle 5833 1 0 12:38 ? 00:00:00 /u01/app//grid/grid112/bin/tnslsnr LISTENER_SCAN2 -inherit
oracle 5836 1 0 12:38 ? 00:00:00 /u01/app//grid/grid112/bin/tnslsnr LISTENER -inherit
oracle 7423 7372 0 15:14 pts/1 00:00:00 grep tnsl
[grid@rac2 ~]$
[grid@rac2 ~]$lsnrctl status LISTENER_SCAN2
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 15-DEC-2011 15:14:04
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SCAN2
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 15-DEC-2011 12:38:45
Uptime 0 days 2 hr. 35 min. 19 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/grid/grid112/network/admin/listener.ora
Listener Log File /u01/app/grid/grid112/log/diag/tnslsnr/rac2/listener_scan2/alert/log.xml
ls -lh /u01/app//grid/grid112/log/diag/tnslsnr/rac2/listener_scan2/trace/*.log ==> 4GB
=============================================
沒有留言:
張貼留言