Репликация базы данных CUCM

  • Published on
    13-Apr-2017

  • View
    726

  • Download
    3

Embed Size (px)

Transcript

  • Cisco TAC (Krakow)

    24, 2015

    CUCM

    Cisco Support Community

    Expert Series Webcast

  • 22, 2015 11:00

    , Cisco , . , Cisco ISE, .

    Cisco ISE

  • ? !

    , ,

    , .

    ,

    , .

    , ,

    Cisco Support Community.

    " Cisco"

    https://supportforums.cisco.com/ru/community/2036/luchshie-avtory-top-contributors?qt-leaderboards_qt=1#qt-leaderboards_qthttps://supportforums.cisco.com/ru/community/2036/luchshie-avtory-top-contributors?qt-leaderboards_qt=1#qt-leaderboards_qt

  • .

    ? . , .

    , , .

    https://supportforums.cisco.com/ru/community/4926/pomoshch-help

    https://supportforums.cisco.com/ru/community/4926/pomoshch-helphttps://supportforums.cisco.com/ru/community/4926/pomoshch-helphttps://supportforums.cisco.com/ru/community/4926/pomoshch-helphttps://supportforums.cisco.com/ru/community/4926/pomoshch-help

  • 16 2015 27 2015

    UCCX

    https://supportforums.cisco.com/ru/discussion/12700966 , , : https://supportforums.cisco.com/community/russian/expert-corner

    https://supportforums.cisco.com/ru/discussion/12700966https://supportforums.cisco.com/ru/discussion/12700966https://supportforums.cisco.com/community/russian/expert-cornerhttps://supportforums.cisco.com/community/russian/expert-cornerhttps://supportforums.cisco.com/community/russian/expert-corner

  • 24 2015 04 2015

    , , : https://supportforums.cisco.com/community/russian/expert-corner Q&A 5 https://supportforums.cisco.com/community/russian/expert-corner/webcast https://supportforums.cisco.com/ru/discussion/12712436

    https://supportforums.cisco.com/community/russian/expert-cornerhttps://supportforums.cisco.com/community/russian/expert-cornerhttps://supportforums.cisco.com/community/russian/expert-cornerhttps://supportforums.cisco.com/community/netpro/ask-the-expert/webcastshttps://supportforums.cisco.com/community/russian/expert-corner/webcasthttps://supportforums.cisco.com/community/russian/expert-corner/webcasthttps://supportforums.cisco.com/community/russian/expert-corner/webcasthttps://supportforums.cisco.com/community/russian/expert-corner/webcasthttps://supportforums.cisco.com/ru/discussion/12712436https://supportforums.cisco.com/ru/discussion/12712436

  • CUCM

    24 14:00

    , CUCM

    Cisco-TAC

    csc-russian@external.cisco.com

    (14-00)

    https://supportforums.cisco.com/ru/document/12711846https://supportforums.cisco.com/ru/document/12711846https://supportforums.cisco.com/ru/document/12711846mailto:csc-russian@external.cisco.commailto:csc-russian@external.cisco.commailto:csc-russian@external.cisco.com

  • :

    https://supportforums.cisco.com/ru/document/12712411

    , !

    https://supportforums.cisco.com/ru/document/12712411https://supportforums.cisco.com/ru/document/12712411

  • ! Q&A, .

    ,

    !

  • Cisco TAC (Krakow)

    24, 2015

    Cisco Support Community Expert Series Webcast

    CUCM

  • 1

    CUCM?

    1.

    2.

    3. ?

  • CUCM

  • CUCM

  • LDAP

    CCM

    IMDB LDAPSync

    Publisher

    CCMAdmin

    DBLj (TCP)

    DBLj (TCP)

    DBL (TCP)

    CCM

    IMDB

    TFTP

    Subscriber

    CCMAdmin

    DBLj (TCP)

    DBL (TCP) DBLj (TCP)

    HTTP HTTP

    IDS (TCP)

  • (fully meshed). .

    UFF Subscriber, Subscriber.

    , hub-and-spoke , Publisher.

    :

  • UFF

    Publisher

    Subscriber Subscriber

    Subscriber Subscriber

    :

    Call Forward All (CFA)

    Message Waiting Indication (MWI)

    Privacy Enable/Disable

    Do Not Disturb Enable/Disable (DND)

    Extension Mobility Login (EM)

    Hunt Group Logout

    Device Mobility

    UFF

  • . utils dbreplication reset all, .

    1. Publisher .

    2. Publisher .

    : Publisher

  • 3. Subsriber.

    4. Subsriber Subscriber /.

    5. cdr sync.

    : Subscriber

  • Pub Pub = 0 Sub1

    Sub1

    Sub1 = 0

    Pub

    ?

    Pub

    Pub, c

    Pub Pub

    Sub1

    Pub

    Pub = 2

    Pub

    Pub

    Sub

    (

    Sub2)

    Subs, cdr check

    Subs

    Sub1 = 2

  • : Subscriber

  • [64], .

  • Host

    8500/UDP/TCP

    DNS (forward/reverse lookup)

    NTP

    A Cisco DB A Cisco DB Replicator

    Dbmon /

  • 0:

    1: .

    : .

    2: .

    3: real-time .

    4: .

    :

  • :

    Aug 14 23:57:17 SWMBH1CM01 local7 2 : 1: SWMBH1CM01: Aug 15 2015 03:57:17

    AM.690 UTC : %UC_RTMT-2-RTMT_ALERT:

    %[AlertName=DBReplicationFailure][AlertDetail= On Fri Aug 14 23:57:17 EDT

    2015, alert DBReplicationFailure has occured. Counter Replicate_State of

    Number of Replicates Created and State of Replication(ReplicateCount) on

    node 10.100.243.129 has state value of 3. ReasonCode: Replication data

    transfer is bad in the cluster.#012 ][AppID=Cisco AMC

    Service][ClusterID=][NodeID=SWMBH1CM01]: RTMT Alert

    ( )

  • RTMT

  • CM Database Status Report Unified Reporting

    CLI dbreplication status , Dropped:

    Tue Apr 7 14:21:51 2015 main() DEBUG: -->

    Tue Apr 7 14:22:07 2015 main() DEBUG: Replication cluster summary:

    SERVER ID STATE STATUS QUEUE CONNECTION CHANGED

    -----------------------------------------------------------------------

    g_bldr_ccm4_ccm 2 Active Local 0

    g_bldr_ccm5_ccm 3 Active Dropped 636 Sep 11 14:01:20

  • utils dbreplication runtimestate

  • CM Database Status Report

  • host

    1500/TCP, 8500/TCP/UDP

    NTP

  • :

    DB = A Cisco DB - .

    RPC = A Cisco DB Replicator .

    DbMon = Cisco Database Layer Monitor - .

    :

  • utils network connectivity

    This command can take up to 3 minutes to complete.

    Continue (y/n)?y

    Running test, please wait ...

    .

    Network connectivity test with the publisher completed successfully.

    DNS:

    utils network host

    :

    utils network ping

    :

  • /etc/hosts

    , Server, .

    Cluster Manager hosts firewall.

    .

    /etc/services

    .

    :

  • /home/informix/.rhost

    , Informix ( Informix ).

    FQDN.

    A Cisco DB HOSTS .

    .

    :

  • /usr/local/cm/db/informix/etc/sqlhosts

    .

    ID (i=X) .

    A Cisco DB.

    .

    :

  • admin:show tech network hosts

    -------------------- show platform network --------------------

    /etc/hosts File:

    #This file was generated by the /etc/hosts cluster manager.

    #It is automatically updated as nodes are added, changed, removed from the cluster.

    127.0.0.1 localhost

    ::1 localhost

    10.48.52.66 cucm10-sub

    10.48.52.65 cucm10-pub

    :

  • admin:show tech dbstateinfo

    ------------------------ Show tech dbstateinfo -------------------

    Database State Info

    Output is in /cm/trace/dbl/showtechdbstateinfo182555.txt

    Please use "file view activelog /cm/trace/dbl/showtechdbstateinfo182555.txt" to see the contents of File

    Error Output is in /cm/trace/dbl/showtechdbstateinfo_cdr_err182555.out

    Please use "file view activelog /cm/trace/dbl/showtechdbstateinfo_cdr_err182555.out" command to see the contents of File

    :

  • admin:file view activelog /cm/trace/dbl/showtechdbstateinfo182555.txt

    ( e, )

    ====================Executing cdr list server ====================

    SERVER ID STATE STATUS QUEUE CONNECTION CHANGED

    -----------------------------------------------------------------------

    g_2_ccm10_5_2_12010_1 2 Active Local 0

    g_3_ccm10_5_2_12010_1 3 Active Connected 0 Sep 9 08:34:34

    ***********************************************************************

    :

  • No of SQL Hosts

    ---------------

    g_hdr group - - i=1

    LOCAL onsoctcp 127.0.0.1 cucm10_pub_ccm10_5_2_12010_1 b=32767,rto=300

    g_2_ccm10_5_2_12010_1 group - - i=2

    cucm10_pub_ccm10_5_2_12010_1 onsoctcp 10.48.52.65 cucm10_pub_ccm10_5_2_12010_1 g=g_2_ccm10_5_2_12010_1 b=32767,rto=300

    g_3_ccm10_5_2_12010_1 group - - i=3

    cucm10_sub_ccm10_5_2_12010_1 onsoctcp 10.48.52.66 cucm10_sub_ccm10_5_2_12010_1 g=g_3_ccm10_5_2_12010_1 b=32767,rto=300

    ###NOTE: Need to use ipv4 address in host column of sqlhosts file and not hostname

    cucm10_pub_car10_5_2_12010_1 onsoctcp 10.48.52.65 cucm10_pub_car10_5_2_12010_1 b=32767,rto=300

    cucm10_pub_car10_5_2_10000_5 onsoctcp 10.48.52.65 cucm10_pub_car10_5_2_10000_5 b=32767,rto=300

    ************************************************************************

    :

  • No of rhosts

    ------------

    ### IDS BEGIN - DO NOT REMOVE

    localhost

    cucm10-sub

    cucm10-sub

    cucm10-pub

    cucm10-pub

    ### IDS END - DO NOT REMOVE

    :

  • :

  • :

  • :

  • (ACCEPT 1500/TCP ).

    admin:utils firewall ipv4 list

    ACCEPT tcp -- 10.48.52.66 0.0.0.0/0 tcp dpt:1500 flags:0x02/0x02 limit: up to 50/sec burst 7500 mode srcip-dstport

    Publisher (10.48.52.65), 10.48.52.66 Subscriber. Subscriber IP Publisher.

    Cluster Manager:

    file list activelog platform/log/clustermgr* date detail

    file view activelog platform/log/

    12:42:33.844 |clm|HMAC_SHA1 match failed IP(10.44.11.22) ()

    08:33:25.104 |hostname: cucm10-sub state POLICY_INJECTED ()

    admin:utils network capture port 8500

    , .

    : IPSec

  • : NTP

  • 2

    CUCM?

    1. ,

    2. , TAC

    3. ,

  • 1

    utils dbreplication runtimestate Publisher , 2.

    , Cluster Replication State .

    : 1

  • ( ) utils dbreplication status.

    : 1

    utils dbreplication runtimestate.

  • 1.

    2

    CM Database Status Cisco Unified Reporting:

    1. Cisco Unified Reporting.

    2. System Reports > Unfied CM Database Status.

    3. .

    : Cisco TAC TAC.

    : 2

  • 3

    .

    , Local Publisher .

    , A Cisco DB utils service list. utils service start A Cisco DB. Cisco TAC.

    : 3

  • , Replication Server List (cdr list serv) .

    8.

    : 3

  • , hosts, rhosts, sqlhosts .

    :

    Hosts utils service restart A Cisco DB.

    Rhosts utils service restart A Cisco DB utils service restart Cluster Manager.

    Sqlhosts utils system restart A Cisco DB.

    . / Cisco TAC.

    8.

    : 3

  • , DBL RPC hello .

    :

    Subscriber Publisher.

    , 1515/TCP .

    8.

    : 3

  • , .

    :

    .

    , .

    8.

    : 3

  • 4

    utils diagnose test.

    validate_network .

    :

    test validate_network: Error, intra-cluster communication is broken, unable to connect to []

    test validate_network: Reverse DNS lookup failed , DNS utils network eth0 all IP / utils network host

    : 4

  • NTP c utils diagnose test:

    utils ntp status:

    : 4

  • 5

    4 utils network connectivity , , .

    Cannot send TCP/UDP packets TCP/UDP .

    : 5

    , security show network cluster.

  • 6

    utils dbreplication runtimestate out of sync not requested.

    , :

    RTT (Round Trip Time);

    WAN: , 80ms;

    ;

    show tech repltimeout .

    utils dbreplication setrepltimeout .

    [Server 1-5 = 1 Minute Per Server] + [Servers 6-10 = 2 Minutes Per Server] + [Servers >10 = 3 Minutes Per Server]

    : 6

  • 7 8 :

    5.

    RPC 3.

    Cisco TAC 7 8, 8 .

    .

    : 7 8

  • 7

    utils dbreplication runtimestate .

    utils dbreplication repair all.

    utils dbreplication runtimetate.

    8, .

    : 7

  • 8

    , :

    utils dbreplication stop all ( Publisher);

    utils dbreplication dropadmindb ( Subscriber Publisher);

    utils dbreplication reset all ( Publisher);

    RTMT/ utils dbreplication runtimestate.

    :

    utils dbreplication stop ( Publisher);

    utils dbreplcation dropadmindb ( Subscriber);

    utils dbreplication reset ( Publisher);

    : 8

  • Cisco TAC , ( ).

    :

    utils dbreplication runtimestate

    utils diagnose test

    utils network connectivity

    :

    Cisco Unified Reporting CM Database Report ( 2)

    CLI utils create report database .tar , SFTP .

    : TAC

  • : CLI

  • Troubleshooting CUCM Database Replication Linux Appliance Model (https://supportforums.cisco.com/document/52421/troubleshooting-cucm-database-replication-linux-appliance-model)

    TCP and UDP Port Usage Guide for Cisco Unified Communications Manager (http://www.cisco.com/c/en/us/support/unified-communications/unified-communications-manager-callmanager/products-maintenance-guides-list.html)

    Command Line Interface Guide for Cisco Unified Communications Solutions (http://www.cisco.com/c/en/us/support/unified-communications/unified-communications-manager-callmanager/products-maintenance-guides-list.html)

    https://supportforums.cisco.com/document/52421/troubleshooting-cucm-database-replication-linux-appliance-modelhttps://supportforums.cisco.com/document/52421/troubleshooting-cucm-database-replication-linux-appliance-modelhttps://supportforums.cisco.com/document/52421/troubleshooting-cucm-database-replication-linux-appliance-modelhttps://supportforums.cisco.com/document/52421/troubleshooting-cucm-database-replication-linux-appliance-modelhttps://supportforums.cisco.com/document/52421/troubleshooting-cucm-database-replication-linux-appliance-modelhttps://supportforums.cisco.com/document/52421/troubleshooting-cucm-database-replication-linux-appliance-modelhttps://supportforums.cisco.com/document/52421/troubleshooting-cucm-database-replication-linux-appliance-modelhttps://supportforums.cisco.com/document/52421/troubleshooting-cucm-database-replication-linux-appliance-modelhttps://supportforums.cisco.com/document/52421/troubleshooting-cucm-database-replication-linux-appliance-modelhttps://supportforums.cisco.com/document/52421/troubleshooting-cucm-database-replication-linux-appliance-modelhttps://supportforums.cisco.com/document/52421/troubleshooting-cucm-database-replication-linux-appliance-modelhttps://supportforums.cisco.com/document/52421/troubleshooting-cucm-database-replication-linux-appliance-modelhttps://supportforums.cisco.com/document/52421/troubleshooting-cucm-database-replication-linux-appliance-modelhttps://supportforums.cisco.com/document/52421/troubleshooting-cucm-database-replication-linux-appliance-modelhttp://www.cisco.com/c/en/us/support/unified-communications/unified-communications-manager-callmanager/products-maintenance-guides-list.html)http://www.cisco.com/c/en/us/support/unified-communications/unified-communications-manager-callmanager/products-maintenance-guides-list.html)http://www.cisco.com/c/en/us/support/unified-communications/unified-communications-manager-callmanager/products-maintenance-guides-list.html)http://www.cisco.com/c/en/us/support/unified-communications/unified-communications-manager-callmanager/products-maintenance-guides-list.html)http://www.cisco.com/c/en/us/support/unified-communications/unified-communications-manager-callmanager/products-maintenance-guides-list.html)http://www.cisco.com/c/en/us/support/unified-communications/unified-communications-manager-callmanager/products-maintenance-guides-list.html)http://www.cisco.com/c/en/us/support/unified-communications/unified-communications-manager-callmanager/products-maintenance-guides-list.html)http://www.cisco.com/c/en/us/support/unified-communications/unified-communications-manager-callmanager/products-main...

Recommended

View more >