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

Friday, June 27, 2014

ERROR Applying patch Database 12c Prerequisite check "CheckActiveFilesAndExecutables" failed.

The file that the installation is complaining is :

Following executables are active :
/dbgc/products/12.1.0/rdbms/lib/libclntsh.so.12.1
Log file location: /dbgc/products/12.1.0/rdbms/cfgtoollogs/opatch/opatch2014-06-27_15-55-45PM_1.log


1-Check who is using this file

fuser /dbgc/products/12.1.0/rdbms/lib/libclntsh.so.12.1

2-Kill all PIDs using this file

3-Restart patching :

opatchauto apply /opt/oracle/binarios/18139660 -oh /dbgc/products/12.1.0/rdbms/ -ocmrf /opt/oracle/12.1.0/grid/OPatch/ocm/bin/ocm.rsp




Best Regards,
Paulo Portugal

Wednesday, June 25, 2014

Quickly create and mount ACFS DB 12c - Manually

1-Create volume
volcreate -G DG_GRID -s 20G ACFS_VOL1

2-Check volume created

ASMCMD> volinfo --all
Diskgroup Name: DG_GRID

Volume Name: ACFS_VOL1
Volume Device: /dev/asm/acfs_vol1-131
State: ENABLED
Size (MB): 20480
Resize Unit (MB): 32
Redundancy: UNPROT
Stripe Columns: 4
Stripe Width (K): 128
Usage:
Mountpath:

ASMCMD>


3-Create ACFS

[grid@bwdhdbpr106 ~]$ /sbin/mkfs -t acfs /dev/asm/acfs_vol1-131
mkfs.acfs: version                   = 12.1.0.1.0
mkfs.acfs: on-disk version           = 39.0
mkfs.acfs: volume                    = /dev/asm/acfs_vol1-131
mkfs.acfs: volume size               = 21474836480
mkfs.acfs: Format complete.
[grid@bwdhdbpr106 ~]$


4-Mount ACFS (login as root)

/bin/mount -t acfs /dev/asm/acfs_vol1-131 /ACFS


Best Regards,
Paulo Portugal

Check the Health of your GI and DB 12c Installation with a single command

Use this simple command to check the health of your installation (GI and DB 12c):

[grid@xxxxxx bwdhdbpr106]$ cluvfy comp health

Verifying Health Check
Total memory check passed
Available memory check passed
Swap space check failed
Check failed on nodes:
bwdhdbpr106
Free disk space check passed for "bwdhdbpr106:/tmp"
Check for multiple users with UID value 500 passed
User existence check passed for "grid"
Group existence check passed for "oinstall"
Membership check for user "grid" in group "oinstall" [as Primary] passed
Run level check passed
Hard limits check passed for "maximum open file descriptors"
Soft limits check passed for "maximum open file descriptors"
Hard limits check passed for "maximum user processes"
Soft limits check passed for "maximum user processes"
System architecture check passed
Kernel version check passed
Kernel parameter check passed for "semmsl"
Kernel parameter check passed for "semmns"
Kernel parameter check passed for "semopm"
Kernel parameter check passed for "semmni"
Kernel parameter check passed for "shmmax"
Kernel parameter check passed for "shmmni"
Kernel parameter check passed for "shmall"
Kernel parameter check passed for "file-max"
Kernel parameter check passed for "ip_local_port_range"
Kernel parameter check passed for "rmem_default"
Kernel parameter check passed for "rmem_max"
Kernel parameter check passed for "wmem_default"
Kernel parameter check passed for "wmem_max"
Kernel parameter check passed for "aio-max-nr"
Package existence check passed for "make"
Package existence check passed for "binutils"
Package existence check passed for "gcc(x86_64)"
Package existence check passed for "libaio(x86_64)"
Package existence check passed for "glibc(x86_64)"
Package existence check passed for "compat-libstdc++-33(x86_64)"
Package existence check passed for "glibc-devel(x86_64)"
Package existence check passed for "gcc-c++(x86_64)"
Package existence check passed for "libaio-devel(x86_64)"
Package existence check passed for "libgcc(x86_64)"
Package existence check passed for "libstdc++(x86_64)"
Package existence check passed for "libstdc++-devel(x86_64)"
Package existence check passed for "sysstat"
Package existence check passed for "ksh"
Check for multiple users with UID value 0 passed

Starting check for consistency of primary group of root user

Check for consistency of root user's primary group passed

Checking if Clusterware is installed on all nodes...
Check of Clusterware install passed

Checking if CTSS Resource is running on all nodes...
CTSS resource check passed


Querying CTSS for time offset on all nodes...
Query of CTSS for time offset passed

Check CTSS state started...
CTSS is in Observer state. Switching over to clock synchronization checks using NTP


Starting Clock synchronization checks using Network Time Protocol(NTP)...

NTP Configuration file check started...
NTP Configuration file check passed

Checking daemon liveness...
Liveness check passed for "ntpd"
Check for NTP daemon or service alive passed on all nodes

NTP common Time Server Check started...
Check of common NTP Time Server passed

Clock time offset check from NTP Time Server started...
Clock time offset check passed

Clock synchronization check using Network Time Protocol(NTP) passed


Oracle Cluster Time Synchronization Services check passed

Checking OHASD integrity...

OHASD integrity check passed

Checking CRS integrity...

Clusterware version consistency passed.

CRS integrity check passed

Checking Single Client Access Name (SCAN)...

Checking TCP connectivity to SCAN Listeners...
TCP connectivity to SCAN Listeners exists on all cluster nodes

Checking name resolution setup for "oemgt-scan.b2w"...

Checking integrity of name service switch configuration file "/etc/nsswitch.conf" ...
Check for integrity of name service switch configuration file "/etc/nsswitch.conf" passed


ERROR:
PRVG-1101 : SCAN name "oemgt-scan.b2w" failed to resolve

ERROR:
PRVF-4657 : Name resolution setup check for "oemgt-scan.b2w" (IP address: 10.13.0.227) failed

ERROR:
PRVF-4664 : Found inconsistent name resolution entries for SCAN name "oemgt-scan.b2w"

Checking SCAN IP addresses...
Check of SCAN IP addresses passed

Verification of SCAN VIP and Listener setup failed

Checking node application existence...

Checking existence of VIP node application (required)
VIP node application check passed

Checking existence of NETWORK node application (required)
NETWORK node application check passed

Checking existence of ONS node application (optional)
ONS node application check passed

The disk free space for file system path "/opt/oracle/12.1.0/grid" is sufficient on all nodes

Verification of Health Check was unsuccessful on all the specified nodes.
[grid@xxxxx bwdhdbpr106]$



Best Regards,
Paulo Portugal