Archive

‘学习笔记’ 分类存档

Excel 小技巧

在处理工作时,常常遇到统计log,但如何高效的统计,常常需要度娘,而且查起来也很麻烦,所以统计到blog里,下次可以统一查阅:

Excel中两列数据,找出重复项

参考文章请查看:https://zhidao.baidu.com/question/546059662.html
分别对两行建立条件公式,选中A列,条件“=COUNTIF(B:B,A1)>0”;选中B列,条件“=COUNTIF(A:A,B1)>0”,如下所示:

完整阅读

INSTALL CISCO WAE 6.4.5

Introduction

After installed Centos 6.7 for CISCO WAE, I found python version is 2.6 that is much older, and I need ansible1.9, but Centos default upgrade to ansible2.2… in order to easy management ansible1.9 that is python package, I plan to install PIP. From official website, suggest not use 2.6 under pip, so I need to upgrade python to 2.7 too.

But I found WAE use 2.6 after I succeed upgrade python to 2.7…Summarized the totally steps that will help me review in future.

Upgrade Python

After checked from follow link, python 2.7.9 integrate pip, so install this version 🙂
https://pip.pypa.io/en/latest/installing/

1. Install some package that require by python

python have multi dependencie

[root@wae ~]# yum install gcc
[root@wae ~]# yum install openssl-devel

2. Install python 2.7.9

[root@wae ~]# wget http://python.org/ftp/python/2.7.9/Python-2.7.9.tgz
[root@wae ~]# mv Python-2.7.9.tgz /opt/
[root@wae ~]# cd /opt/
[root@wae opt]# tar -xvf Python-2.7.9.tgz 
[root@wae opt]# cd Python-2.7.9
[root@wae Python-2.7.9]# ./configure --prefix=/usr/local/python2.7
[root@wae Python-2.7.9]# make
[root@wae Python-2.7.9]# make install

完整阅读

How To Check BGP Memory OF ASR9k

Introduction

Refer to some CASE, customer concern why BGP take so many memory resource, and how to optimize BGP, and why memory not release after optimize, and so on. That hard to answer, in order to get answer, we need check more information. From the article, you can simple to know how to check BGP memory, and how to analyzing the BGP memory, those informaiton will help you and customer to do special optimize.

Solution

1. Default scenario, no any BGP route

完整阅读

Troubleshooting fabric FIA tail drop on ASR9k

Introduction

In TZ database, have more good documents that is troubleshooting fabric guide on ASR9k, but no analysis process that show how to troubleshooting fabric issue on real scenario/CASE. “Very lucky” ?  I matched a hot CASE that due to fabric issue cause online fail. So i summaried totally analysis process that will help CSE to narrow down similar issue.

Problem Description

  • Platform: 9922 + 4 36x10G + 2 8x100G
  • Version: 5.3.2 + SMU 

My customer online a new 9922 to replace old devices. After online, found their business have traffics drop. Base on online information, I found NP no more drop, and business traffics very less. (max 5g under 100g port, all bundle port when online ts)

完整阅读

How to troubleshooting HW FIB on ASR9k | PBTS/TE

Problem Description

Follow Topology

 

 10.200.0.24               10.200.0.26    10.200.0.32
   +------+      +------+     +------+     +------+
   |XiAn  |      | SZ   |     |HKBR  |     |Canada|
   |Huawei+------+      +-----+ASR9k +-----+ASR9k |
   +------+      +------+     +------+     +------+

For the issue, HuaWei is Head, asr9k should mid and end node. And Huawei found they put the traffics to Canada by LDP label, not TE label. So traffics should arrive to HK ASR9k by LDP label, then forwarding by LDP too from HK ASR9k to Canada. That not match normal scenario.

For normal scenario, should use TE label from head to end. And after Huawei put traffics to TE LSP, the issue will recovery to normal. Refer to why Huawei send traffics by LDP, that should their issue, will fix in future by them, but even if to do that, 9k shouldn’t drop packets. We need find whether packets drop at 9k and due to label issue first. Now set up test environment in customer site. waiting update.

完整阅读

blonde teen swallows load.xxx videos