Nortel Networks Standard MCP 1.1 FP1 (02.02) manual

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96

Go to page of

A good user manual

The rules should oblige the seller to give the purchaser an operating instrucion of Nortel Networks Standard MCP 1.1 FP1 (02.02), along with an item. The lack of an instruction or false information given to customer shall constitute grounds to apply for a complaint because of nonconformity of goods with the contract. In accordance with the law, a customer can receive an instruction in non-paper form; lately graphic and electronic forms of the manuals, as well as instructional videos have been majorly used. A necessary precondition for this is the unmistakable, legible character of an instruction.

What is an instruction?

The term originates from the Latin word „instructio”, which means organizing. Therefore, in an instruction of Nortel Networks Standard MCP 1.1 FP1 (02.02) one could find a process description. An instruction's purpose is to teach, to ease the start-up and an item's use or performance of certain activities. An instruction is a compilation of information about an item/a service, it is a clue.

Unfortunately, only a few customers devote their time to read an instruction of Nortel Networks Standard MCP 1.1 FP1 (02.02). A good user manual introduces us to a number of additional functionalities of the purchased item, and also helps us to avoid the formation of most of the defects.

What should a perfect user manual contain?

First and foremost, an user manual of Nortel Networks Standard MCP 1.1 FP1 (02.02) should contain:
- informations concerning technical data of Nortel Networks Standard MCP 1.1 FP1 (02.02)
- name of the manufacturer and a year of construction of the Nortel Networks Standard MCP 1.1 FP1 (02.02) item
- rules of operation, control and maintenance of the Nortel Networks Standard MCP 1.1 FP1 (02.02) item
- safety signs and mark certificates which confirm compatibility with appropriate standards

Why don't we read the manuals?

Usually it results from the lack of time and certainty about functionalities of purchased items. Unfortunately, networking and start-up of Nortel Networks Standard MCP 1.1 FP1 (02.02) alone are not enough. An instruction contains a number of clues concerning respective functionalities, safety rules, maintenance methods (what means should be used), eventual defects of Nortel Networks Standard MCP 1.1 FP1 (02.02), and methods of problem resolution. Eventually, when one still can't find the answer to his problems, he will be directed to the Nortel Networks service. Lately animated manuals and instructional videos are quite popular among customers. These kinds of user manuals are effective; they assure that a customer will familiarize himself with the whole material, and won't skip complicated, technical information of Nortel Networks Standard MCP 1.1 FP1 (02.02).

Why one should read the manuals?

It is mostly in the manuals where we will find the details concerning construction and possibility of the Nortel Networks Standard MCP 1.1 FP1 (02.02) item, and its use of respective accessory, as well as information concerning all the functions and facilities.

After a successful purchase of an item one should find a moment and get to know with every part of an instruction. Currently the manuals are carefully prearranged and translated, so they could be fully understood by its users. The manuals will serve as an informational aid.

Table of contents for the manual

  • Page 1

    NN10031-1 1 1 Succession Mul timedia Com munications Portfolio MCP Dat abase Module Basics S tandard MCP 1.1 F P1 (02.02) April 20 03[...]

  • Page 2

    [...]

  • Page 3

    3 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial Overview The Dat abase M odule uses the O racle En terprise Ma nager t o config ure, adminis ter , and monitor provisione d subscriber and config uration dat a. How this gu ide is organized This docum ent provide s an overvie w of Data base Module arch[...]

  • Page 4

    4 Overv iew NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential Architecture As shown in Figure 1, the Database Mo dule cons ists of Oracle Servers having a primary da tabase a nd a repl icated secon dary dat abase manag ed from th e Oracl e Enterp rise Man ager (OEM ) Conso le.[...]

  • Page 5

    Overvi ew 5 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial For info rmation about th e communi catio n p rotocol s and in te raction s betwe en the Dat abase M odule an d network com ponent s, see Figure 2, “SQL over JDBC,” on p age 1 1 . Each dat abase in cludes re plicated obj ects and non-re p[...]

  • Page 6

    6 Overv iew NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential while the secon dary database operates in a limited write state at all times. T able 1 D at abase operational st ates Database states Description Normal (Primary databa se) Fully writable for a p plica t ions. Inser[...]

  • Page 7

    Overvi ew 7 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial Dat a tran sf er When da ta trans ac tions o ccur , updat es to th e primary database are queued for tra nsfer to the secondary d atabase. Similar ly , changes made to the seco ndary dat abase are queue d for transfer to the primary dat abase[...]

  • Page 8

    8 Overv iew NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential Dat abase rec overy Recovery r estores a d ataba se to it s original st ate a fter a failu re. See “Database r ecovery ” on page 8 4. Manage replication transaction errors The OEM C onsole pr ovides tools fo r r[...]

  • Page 9

    Overvi ew 9 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial • Event s : Dat abase event s are proces sed by the Or acle Ente r pri se Manage r and alerts are genera ted when spec ified e rror thre shold s are re ac hed. Mo nitor eve nts as requ ired and re spond to alerts as appro priate. Se e “Ev[...]

  • Page 10

    10 Overvi ew NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential MCP hardware The Da ta base M odule is de ployed on a p air of Sun Netra t1400 /1405 s servers c onfigur ed in an Ora cle master -master r eplicati on mode for redund ancy . Note: Minimal co nfiguratio ns use a sin[...]

  • Page 11

    Over view 11 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial Network i nterfac es and protocols User in terfaces wh ich access th e Dat abase Mo dule are: • SQL over JDBC : The Dat abase Module communicates with network co mponen ts usin g S tructur ed Query La nguage (SQL) over Java Dat abase Conne[...]

  • Page 12

    12 Overvi ew NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential the System Managem ent Console . The Oracle Monitor extr acts (using SN MP ge ts and SQL qu eries) inf ormati on concer ning the health of the dat ab ase. This information is then transformed into alarms/ logs/OMs,[...]

  • Page 13

    13 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial Upgrades Str at eg y The following deploymen t tasks related to the Da tabas e Module are perform ed by your next level of supp ort: • Adds and confi gu r es the serv er (s) host ing the Dat ab ase Module • Installs Oracle • Deploys t he Dat aba[...]

  • Page 14

    14 Upgr ades NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential T o ols and utilit ies Dat abase Mod ule main tenance updates a re deploye d from the System Manage ment Conso le. For details, s ee MCP S ystem Managem ent Console Ba sics. Dat abase Module up dates Dat a base Mod[...]

  • Page 15

    Upgr ades 15 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial Reverting to a previous version of the dat abase If you w ant to reve rt to a pre vious versi on of the da tabase, you must redep loy a previ ous versio n of t he dat abase o ver the cur rent da tabase . In such a sce nar io, the user is fi [...]

  • Page 16

    16 Upgr ades NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential[...]

  • Page 17

    17 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial Fault management Str at eg y Data base Mod ule fault manageme nt consist s of m onitoring and respon ding to l ogs and a larms from the Oracle Enterp rise Manage r (OEM) C onsole an d the Syste m Managem ent Conso le. See MC P Syst em Manage ment Cons[...]

  • Page 18

    18 Faul t management NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential T ask flows T able 3 outline s Datab ase Module p erformance m anageme nt tasks. T able 3 Performance mana gement task flows Topic Subtopic Procedure Dat abase monitoring Backu ps “Monit oring ba ckups”[...]

  • Page 19

    Fault managemen t 19 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial T o ols and utilit ies Use the f ollowi ng tool s to perfor m Databas e Module fa ult mon itoring tasks: • Oracl e Ent erpris e Manage r (OEM ) Console : Used by the database adminis trator fo r backup an d recov ery and databas e [...]

  • Page 20

    20 Faul t management NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential Dat abase monitoring from the Oracle Enterprise Manager Console T o laun ch t he OEM C ons ol e, se e “ L ogg i ng in to the OEM Con sole” o n pag e 45. Monitoring backup s When a d atabase ba ckup star[...]

  • Page 21

    Fault managemen t 21 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial 3 In the History p ane, doubl e-click the appropriat e job to disp lay it s properties. The Edit Job > Progress window open s, showing when the job started an d complet ed.[...]

  • Page 22

    22 Faul t management NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential 4 T o see th e output of t he job, sel ect the a Completed or Failed job and click Show Output. The Job Output wi ndow opens, displaying the job st atus, t arget node, and th e da te and time th e job exec [...]

  • Page 23

    Fault managemen t 23 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial Event monitoring When a re gistere d event exceeds a specifie d thresh old , an aler t displa ys on the O EM Console and an em ail is sent to the adm inistr ator . Alert s have progressively highe r severity levels as sh own in the f[...]

  • Page 24

    24 Faul t management NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential Monitoring event s Monitor and respond to events as r equired to e nsure smooth da tabase opera tion. Se e “Event mo nitorin g” on p age 23. For login in structions, see “O EM Console lo gin” on pa [...]

  • Page 25

    Fault managemen t 25 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial T able 4 lists data base event types and descriptions. T able 4 D ata base events Events Type Description Aler t Fault New error s were shown in alert.log file. Archiver Hung Fault The arch ive process is hung . Broken Jobs Fault Bro[...]

  • Page 26

    26 Faul t management NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential Archiv e full Space The archi ve device is full. Dump Full Space The dump destin ation is ful l. Index Reb uild Space Some indexes may benefit fro m being rebuilt. Maximum Extents S pa ce The seg ments maxi[...]

  • Page 27

    Fault managemen t 27 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial Monitor replication jobs The DBM S Jobs tab list s all the active jobs in t he system. In the DBMS Jobs screen shown in Figure 3, three norm al jobs are l isted. If a job f ails to execute, d etails of the failure display in the # Fa[...]

  • Page 28

    28 Faul t management NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential Monitoring replication Oracl e replicat ion should be monito red regula rly for c onflict ale rts. For det ails abou t replicat ion, see “D ata re plication” on p age 5. For login in structions, see “[...]

  • Page 29

    Fault managemen t 29 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial 4 Click Legend to di spla y a l is ting of th e dat aba se st ate to pol o gy icons a nd what they mea n. The Legend window op ens.[...]

  • Page 30

    30 Faul t management NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential 5 If a rep licati on job is broken, then the o perator must corre ct and resched ule the job as foll ows : a T o correct and resc hedule a re plicatio n job, select the DBMS Jobs ta b. b Selec t the requir [...]

  • Page 31

    Fault managemen t 31 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial d Beside the Next Date field, click Set . The Set Date wind ow open s. e Selec t a Now and click OK . The job is no w resched uled to run every 30 seconds. Monitoring regist ration deletions Apart fro m re plicatio n jobs, on e other[...]

  • Page 32

    32 Faul t management NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential 4 If the job is broken for any re ason, you can corre ct it as follows: a Select the job a nd click Edit . The Edit Job window opens. b In the E dit Job windo w , c hange th e job status to Normal .[...]

  • Page 33

    Fault managemen t 33 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial c Beside the Next Date field, click Set . The Set Date wind ow open s. d Select Now and click OK .[...]

  • Page 34

    34 Faul t management NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential Alarm monitoring Database a l ar ms displa y from the S ystem Mana gement Co nsole. For details ab out usin g the Alarm Browser , see MCP System Manage ment Cons ole Bas i cs . Monitoring alarms Alar ms pro[...]

  • Page 35

    Fault managemen t 35 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial Alert log and trac e file monitoring When a new error m essage appe ars in the alert_imsdb1.log file, an even t is displa yed on the O EM Consol e, as expla ined in “M onitoring events ” on page 24 . Operat ors can also ob serve [...]

  • Page 36

    36 Faul t management NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential Monitoring disk usage Regular ly moni tor table spaces to ensur e that t hey do not run o ut of d isk spac e. When archive lo gs are tur ned on, re gular back ups ar e necess a ry to ensu re that t he logs [...]

  • Page 37

    Fault managemen t 37 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial Report s Y ou can gene rate repo rts a bout config uration, current st atus, event s, and ba ckup jobs from the OE M Consol e as requi red. See “Reco mmended re port s” on p age 39. Generating report s For login in structions, se[...]

  • Page 38

    38 Faul t management NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential 2 Double- click th e name of th e report yo u want to v iew to open it . The Edit Report > General tab op ens. 3 Select Creat e a Single R eport for the T a rget s Select ed Below . 4 Selec t the appr op[...]

  • Page 39

    Fault managemen t 39 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial 5 Click View Report . The chos en report is display ed in the def ault web br owser . Recommended re port s It is recommende d that the o perator generate the followin g report s regula rly . T able 5 Performance mana gement task flo[...]

  • Page 40

    40 Faul t management NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential Disk space used by tables Current Stat us Shows disk sp ace used by table s Instance Current Statu s Displays insta nce statistics and process state Outstand ing Alerts Sorted by Target Event s Displays det[...]

  • Page 41

    Fault managemen t 41 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial The Oracle Monitor component On the S ystem Manag ement Co nsole, the O racle Moni tor compon ent provid es r eporti ng info rmation abou t the follow ing ar eas: •t h e IMS main dat abase (s ee “IMS Main and Backu p Database t a[...]

  • Page 42

    42 Faul t management NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential Figure 4 Oracle Monitor: Gener al Information Area (GIA) p ane The Alarms t ab shown in Figure 5, “O racle Moni tor: GIA Alarms t ab pane” lists th e number of Critical, Major , and Mino r alarms . Figu[...]

  • Page 43

    43 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial Configuration management Str at eg y Nortel Netw orks performs initial conf ig uration of the Oracle Re plicatio n Server and Oracle Enterpri se Manager duri ng installation. Th e sys- man and oracl e accoun ts are also part of initial installation. T[...]

  • Page 44

    44 Con figuration m anagement NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential T o ols and utilit ies Use the follo wing tool s for Dat abase M odule confi guratio n: • System Man agement C onsole: Launches the OEM Co nsole a nd Orac le M o ni tor i ng A pplica ti on. Prov [...]

  • Page 45

    Configur ation manage ment 45 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial OEM Cons ole lo gin This s ection explai ns how to logi n to the OEM Cons ole fr om the Syste m Manage ment Cons ole. Logging in to the OEM Console Login to the OE M Consol e from the System Manage ment Conso le or from a we[...]

  • Page 46

    46 Con figuration m anagement NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential 3 Ente r the imssip db dat abase I P addre ss provided durin g installation. The Launch the Oracl e Enterp rise Manager Console web pag e ope ns. a Bookmark the OEM Console URL fo r future use fro [...]

  • Page 47

    Configur ation manage ment 47 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial 4 In the O racle Ma nagement Ser ver box shown i n step 3, enter the nod e name of t he server co ntaini ng the pr imary dat abase and click Launch Console . The Oracle E nterprise Manager Console login win dow opens. Figure[...]

  • Page 48

    48 Con figuration m anagement NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential 5 Ente r the sysma n user name an d pa ssword provi ded during inst all a tion and click OK .The O racle Enterprise Mana ger Console opens a s shown in F igure 7. Figure 7 Oracle Enterpri se Manage[...]

  • Page 49

    Configur ation manage ment 49 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial Configuration t asks This sec tion inc l ud es the f ollowing procedu res: • “Configu ring the sysman user in OEM to receive email notifications” on p age 49 • “Confi guring a dat aba se obser ver a ccount from the[...]

  • Page 50

    50 Con figuration m anagement NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential 3 From the OEM Confi guration menu, select Configure Paging and E mail . The Configure Paging/Emai l dialog box opens. 4 T ype in the SMTP Mail Gateway and Sende r ’ s SMT P Mail Address (pro vid[...]

  • Page 51

    Configur ation manage ment 51 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial The Manage Administ rator Account s wind ow opens as s hown in Figu re 8 . Figure 8 Manage Admini strator Accounts window 6 Select SYSMAN and click Edit . The Edit Administrator Preferences > Gene ral window o pens.[...]

  • Page 52

    52 Con figuration m anagement NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential 7 Selec t the Noti ficatio n tab a nd click Email . 8 T ype in the Receiver's Email a nd Subject Prefix , then click T est . This st e p send s a test em ail to th e receiv er . 9 Do either of[...]

  • Page 53

    Configur ation manage ment 53 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial 10 Selec t the Schedule tab. The Edit Administrator Pref e rence s > Sche dul e tab opens. 11 Click the Ema il icon and select al l days of the wee k and all hours of the da y as foll ows: Click th e top lef t-hand cell o[...]

  • Page 54

    54 Con figuration m anagement NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential 12 Selec t the Access ta b. The Edit Adm inist ra tor Pref e rence s > Ac ce ss tab open s.[...]

  • Page 55

    Configur ation manage ment 55 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial 13 Selec t the Noti fy op tion for the sysman us er and click th e Preferre d Credenti als tab. The Ed it Administrator Pref erences > Pre ferred Credenti als t ab opens. 14 Under Ta r g e t s , select the <DEF AUL T&g[...]

  • Page 56

    56 Con figuration m anagement NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential Configuring a dat aba se observer account from the OEM Console The follow ing procedure e xplains how t o set up observer accou nts from the OEM Console for the Dat abase M odule. Obser ver account[...]

  • Page 57

    Configur ation manage ment 57 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial 4 Select SYSMAN and click Add . The Create Admini strator Account window opens. 5 Ente r a Use rname and Passw ord for th e observ er accoun t and click OK . Application database connection configuration The followin g appli[...]

  • Page 58

    58 Con figuration m anagement NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential T able 7 Application database configuration properties Property name Format Desc ription Primary Ho st Type: Strin g Range: Not ap plicable Defaul t IP address: 0.0 .0.0 Designate s the IP addres s[...]

  • Page 59

    Configur ation manage ment 59 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial Querying or modifying Oracle Monitor conf iguration proper ties The System Managemen t Console displays admi nistrative and opera tional st ates, as wel l as snap shot alarm information . Admini strative st ate information r[...]

  • Page 60

    60 Con figuration m anagement NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential IMS Main a nd B ackup Dat abase t abs The foll owing figur es show t he fiel ds availab le for quer y or modi ficatio n from the IMS Main Dat abase and IMS Backup Dat abase tabs of the Query or Mod[...]

  • Page 61

    Configur ation manage ment 61 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial[...]

  • Page 62

    62 Con figuration m anagement NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential Dat abase Ba se t ab The foll owing figur e shows t he fiel ds availab le for quer y or modi ficatio n from the Dat aba se Base tab o f the Query or Modify Oracle Monitor dialo g b ox: Oracl e Serv[...]

  • Page 63

    Configur ation manage ment 63 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial Oracl e Listener t ab The foll owing figur e shows t he fiel ds availab le for quer y or modi ficatio n from the Oracle Li stener t ab of the Query or Modify Oracle Monitor dialo g b ox:[...]

  • Page 64

    64 Con figuration m anagement NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential[...]

  • Page 65

    65 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial Accounting management Str at eg y Some information sto red in the dat abase is prop agated to the Accounti ng Module. For detai ls, see MCP Ac counting Mod ule Basics .[...]

  • Page 66

    66 Acc ounting ma nagement NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential[...]

  • Page 67

    67 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial Performance management Str at eg y Databas e logs, a larms, an d opera tional mea surem ents are dis played in the Syste m Manageme nt Console. Fo r detai ls, see MCP Syste m Manage ment Cons ole Bas i cs .[...]

  • Page 68

    68 Perfo rmanc e mana geme nt NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential[...]

  • Page 69

    69 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial Security and Administration How this chapter is organized This chapte r is or ga ni zed as follows : • “Security” on page 69 • “Admi n ist ra ti on ” on page 70 The secur ity and adm inistra tion proce dures are performe d prima rily throu[...]

  • Page 70

    70 Se curity and Administrati on NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential For more information ab out network and Database Module security , see MCP Basics . Administration Database Mo dule admin istratio n consis ts of ba ckup, re covery , resynchronizatio n, and opt[...]

  • Page 71

    Secur ity and Admini stratio n 71 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial T ools and utilities The Dat abase M odule uses the followin g administrat ive tools: • Oracl e Ent erpris e Manage r (OEM ) Console : Used by the database adminis trator fo r backup an d recov ery and databas e fault [...]

  • Page 72

    72 Se curity and Administrati on NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential The fol lowing two t ypes of backu ps are supported i n the Dat abase Module : • Backup a nd restor e using e xport and i mport of d ata OR • Back u p and rest o re using Re covery Ma nager [...]

  • Page 73

    Secur ity and Admini stratio n 73 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial Backup s should b e scheduled during of f-peak h ours. The defau lt time is 2 :00 a.m. If a backu p fails, th e log file s display th e probable cause of th e failure and an y available explanator y information . T o vie[...]

  • Page 74

    74 Se curity and Administrati on NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential At the pri mary database server comm and line 1 Backup th e in itims db1. ora fi le a s follows: cd /opt/app/oracle/adm in/imsdb1/pfile cp initimsdb1.ora initimsdb1.ora.keep 2 Backup th e tnsnam[...]

  • Page 75

    Secur ity and Admini stratio n 75 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial Creating a backup job Set general b ackup properties 1 From the Ne two rk tre e, select Jobs . The Jobs > Acti ve pane disp la ys the lis t of ac tive bac kup jobs that ha ve been schedu led. 2 From the Job menu, sele[...]

  • Page 76

    76 Se curity and Administrati on NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential 3 In the Job Name box , type a ba ckup na me as fol lows: 4 Under Ta r g e t Ty p e , select Node . 5 In the A vailable T arget s box, s el ect t he node na me wher e t he Oracle server resides [...]

  • Page 77

    Secur ity and Admini stratio n 77 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial Set backup task properties 6 Click the T asks tab. The Create Job > T ask p ane open s.[...]

  • Page 78

    78 Se curity and Administrati on NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential 7 Select Run OS command and click Add . The Run OS command task is added to the Job T asks pane. Define back up parameters 8 Click the Parameters t ab. The Create Job > Parameters p ane op en[...]

  • Page 79

    Secur ity and Admini stratio n 79 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial 9 In the Comma nd box, enter a comma nd as appro priate: 10 In the Argument s box, ente r the ap propria te argu ment form at, where db_t ype can be P RIMARY or S ECONDARY , If Do Perf orm an Im port/Export backup (recom[...]

  • Page 80

    80 Se curity and Administrati on NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential name_of_backup is the name o f the bac kup file , and media_type is DISK o r T APE. Schedule back up frequ ency 11 Click the Schedule tab . The Create Job > Schedule pane o pens. If Do Perf o[...]

  • Page 81

    Secur ity and Admini stratio n 81 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial 12 Do one of the followin g: Note: The Export backu p method is re commend ed. See “Dat abase ba ckups” on pag e 71 Note: For RMAN back ups, full (level 0) backup jobs mu st be creat e d separat el y and pr ior to in[...]

  • Page 82

    82 Se curity and Administrati on NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential 15 Make sure the Notify box is se lected to ensure that b ackup report s are emailed to SYSMAN database adm inis trators . Submit and add the backup job to the library 16 Once al l of the ab ove[...]

  • Page 83

    Secur ity and Admini stratio n 83 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial For login in structions, see “O EM Console lo gin” on pa ge 45. From the OEM Console 1 From the Ne two rk tre e, select Jobs . The Jobs >Active tab di splays th e list of a ctive ba ckup job s that have been sche [...]

  • Page 84

    84 Se curity and Administrati on NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential 4 Click an y tab in the Edit Job d ialog bo x to modify backup job prop erties . Note: For de tails about ap propria te back u p job prop erties, see “Se t general backup pro perties” on pa [...]

  • Page 85

    Secur ity and Admini stratio n 85 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial Restoring exporte d backup files Use the follow ing proced ure to re store oth er files. Note: S t op all IMS a pplica tions be fore perf orming t his pro cedure. On the pri mary data ba se serve r 1 Shut do wn both the [...]

  • Page 86

    86 Se curity and Administrati on NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential c Repeat the previous step on the se condary dat abase ser ver . 4 Restore t he primar y databa se server as f ollows: a Login to the prim ary dat abase serv er oracle . b Execut e the follow in[...]

  • Page 87

    Secur ity and Admini stratio n 87 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial 2 T o perf orm the r ecovery pro cedure lis ted in colum n 1, exec ute the comm ands in colu mn 2. Note: db_t ype ca n b e PRIMA R Y or S ECONDARY and media_t ype can be DISK or T APE. If Do Restore contr ol files fr om [...]

  • Page 88

    88 Se curity and Administrati on NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential Restoring control files Use the follo wing pr ocedure to r estore con trol fil es. Note: S t op all IMS a pplica tions be fore perf orming t his pro cedure. The ex amples use d in this pr ocedur[...]

  • Page 89

    Secur ity and Admini stratio n 89 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial /opt/app/ oracle/oradat a/ i msdb1/ control02.ctl", "/var/opt/oracle /imsdb1/control03.ctl") with these lines: control_files =("/backup/orabac kup/imsdb1/contr ol01.ctl", /opt/app/ oracle/oradat [...]

  • Page 90

    90 Se curity and Administrati on NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential 3 Select Distributed > Advanced Re plication > Ad ministration . The Administration > T opology pane op ens, disp laying t he two da taba ses set up in replicat ion mode .[...]

  • Page 91

    Secur ity and Admini stratio n 91 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial 4 Click the Errors tab . The Administration > Erro rs pane ope ns, displa ying Destination , De stination ID , Source , Sta rt Tim e , and # of Calls , wher e Destination is the prima ry or sec ondary da tabase, Star [...]

  • Page 92

    92 Se curity and Administrati on NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential Resynchronization As exp lained in “Dat a replica tion” on p age 5, the D atab ase Modul e norm ally opera tes in replic ated mode, wh erein IMS ap plication s write to and re ad from th e p[...]

  • Page 93

    Secur ity and Admini stratio n 93 Copyright © 2003, Nor tel Networks MCP Data base Modu le Basics Nortel Ne tworks Confiden tial Resynchronizi ng dat abases In the u nlikely even t that chan ges to the p rimary dat abase are n ot prop agated to the secondar y datab ase, the two databa ses must b e manually resynch ronized as follows: In a telnet w[...]

  • Page 94

    94 Se curity and Administrati on NN10031-1 11 Standa rd MCP 1. 1 FP1 (02.02) April 2 003 Copyright © 2003, Nor tel Networks Nortel Netw orks Confid ential Optimizing dat abase disk usage In a telnet window 1 Login to the prim ary dat abase as oracle . 2 Navigate to the dire ctory cont aining the o ptimization sc ript as follows: cd /IMS/i mssip db[...]

  • Page 95

    [...]

  • Page 96

    Succes sion Multi media Comm unications Portfolio MCP Dat abase Module Basics Copyright © 2003 Nortel Networks, All Rights Reserved NORTEL NETWORKS CONFIDENTIAL: T he information contained in this document is the property of Nortel N etworks. Except as specifically authorized in writing by Nortel Networks, the holder of this document shall keep th[...]