Amazon books

Wednesday, July 30, 2014

Tracing EM Grid 12c for Performance Issues on a specific target/page

This is what I have done:


1-Login to EM
./emcli login -username=sysman

2-List sessions
./emcli  list_active_sessions -details

3-Enable trace
./emcli trace -enable=true -user=F2C_PAULO_PORTUGAL

4-Access the slow page on Grid 12c

5-Disable Trace
./emcli trace -enable=false -user=F2C_PAULO_PORTUGAL

6-Generate the report from raw file

./emctl genreport oms -file_name f2c_paulo_portugal_1406760005606.trace



Best Regards,
Paulo Portugal

Tuesday, July 29, 2014

Using LOGDUMP GoldenGate Example

This is what I do to find the line where the replicat golden gate process abended:


Logdump 277 >open ./dirdat/pa000376
Current LogTrail is /ggshop/glete/gghome/dirdat/pa000376
Logdump 278 >ghdr on
Logdump 279 >detail data
Logdump 280 >usertoken detail
Logdump 281 >ggstokens detail
Logdump 282 >ghdr on
Logdump 283 >detail on
Logdump 284 >detail data
Logdump 285 >usertoken detail
Logdump 286 >ggstoken detail
Logdump 287 >pos 19930247
Reading forward from RBA 19930247
Logdump 288 >n
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 46 (x002e) IO Time : 2014/07/25 16:09:52.963.776
IOType : 15 (x0f) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 38756 AuditPos : 144659472
Continued : N (x00) RecCount : 1 (x01)

2014/07/25 16:09:52.963.776 FieldComp Len 46 RBA 19930247
Name: SALES_SHOP_ADMIN.FN_PROPERTY_CONFIG
After Image: Partition 4 G s
0000 0016 0000 0012 5553 455f 494e 5355 5241 4e43 | ........USE_INSURANC
455f 4c49 5354 0001 0008 0000 0004 7472 7565 0004 | E_LIST........true..
0004 ffff 0000 | ......
Column 0 (x0000), Len 22 (x0016)
0000 0012 5553 455f 494e 5355 5241 4e43 455f 4c49 | ....USE_INSURANCE_LI
5354 | ST
Column 1 (x0001), Len 8 (x0008)
0000 0004 7472 7565 | ....true
Column 4 (x0004), Len 4 (x0004)
ffff 0000 | ....

GGS tokens:
TokenID x52 'R' ORAROWID Info x00 Length 20
4141 4178 5a45 4141 7441 414a 6149 4d41 4145 0001 | AAAxZEAAtAAJaIMAAE..
TokenID x4c 'L' LOGCSN Info x00 Length 13
3832 3834 3735 3335 3036 3637 38 | 8284753506678
TokenID x36 '6' TRANID Info x00 Length 13
3134 342e 3234 2e33 3738 3536 35 | 144.24.378565

Logdump 289 >exit



Best Regards,
Paulo Portugal

Monday, July 7, 2014

CELL-02625: Interface eth2 refers to device name "eth2".

CellCLI> create cell stocell1 interconnect1=eth2

CELL-02625: Interface eth2 refers to device name "eth2".
Device name must be same as Interface name.


To fix that, change the interface name in your network file /etc/sysconfig/network-scripts/ifcfg-eth2


This field:
NAME="System eth2" must be changed to NAME="eth2"


Best Regards,
Paulo Portugal

CELL-01514: Connect Error. Verify that Management Server is listening at the specified HTTP port: 8888.

CellCLI> list cell detail

CELL-01514: Connect Error. Verify that Management Server is listening at the specified HTTP port: 8888.
cellsrvStatus:     stopped
msStatus:           running
rsStatus:           running


Edit your /etc/hosts file and comment out this line below:

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6



Best Regards,
Paulo Portugal