GoldenGate - libnnz11.so: cannot open shared object file

While login into Goldengate command line interface we faced below error. Resolution or error is not that much complicated but many time we are not able to find out what can be the issue while working in under pressure situation so thought to write this piece.

[oracle@ggtest ogg]$ ./ggsci
./ggsci: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory

Only need to export library from oracle home to resolve this error. It is better to append this in .bash_profile of Oracle user.

[oracle@ggtest ogg]$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib
[oracle@ggtest ogg]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.

GGSCI>

Comparison between Exadata X4-2 and X5-2

Obliviously ED X5 would be faster and flexible compare to earlier version of ED. Here we have given comparison between X5 and X4 full configuration ED rack based on datasheet provided by Oracle.



Now from X5-2 Oracle introduced Oracle Virtual Machine to do the virtualization on ED machine, if there is any requirement of hard limits on CPUs and memory or required independent OS/Admin than we can use this virtualization feature.

There is no licence cost for OVM , it's free of cost with ED X5-2.

From ED X5-2 High performance disk has been replaced with Extream Flash (EF).

What is Exacheck in Exadata and what it does?

Exacheck:

Exacheck is designed to audit configuration of Oracle Exadata Machine which includes DB Server, Cell Storage, Infiniband switch, Software, Database, and Ethernet Network.

When to execute:

Exachek report should be fetched after the initial Oracle Exadata Database Machine deployment, as a part of the routine maintenance schedule (at least monthly),before and after any system configuration change and patching activity.

Phases:

There are four phase in exachek execution.

1) Minimal Input 
2) Data Collection
3) Analysis
4) HTML Report Generation

Steps to Install OEM 12c Client on Target Host

Listed down required steps to install OEM 12c client on target host by push method from EM console.

1. Log in to the EM Console
2. From setup menu (Upper Right) select Add Target > Add Target Manually
3. Select Add Host Targets and click on Add Host button
4. Provide session name 
Input the hostname and select appropriate platform

(If more than one clients need to deploy than add more host by clicking on +Add button)

click Next...

5. Input the credentials of Host server

Click Ok than Next

6. Review provided information

7. Click the deploy agent buttoin in upper right of console

DB Node Patching Error : Total amount of free space in the volume group is less than 2GB

Faced below issue while patching on Exadata DB node.

While running dbnodeupdate.sh we got below warning.

./dbnodeupdate.sh -u -l /u01/19625719/Infrastructure/11.2.3.3.1/ExadataDatabaseServer/p18876946_112331_Linux-x86-64.zip -v
Continue ? [Y/n]
y
(*) 2015-02-03 19:33:28: Unzipping helpers (/u01/19625719/Infrastructure/ExadataDBNodeUpdate/3.60/dbupdate-helpers.zip) to /opt/oracle.SupportTools/dbnodeupdate_helpers
(*) 2015-02-03 19:33:28: Initializing logfile /var/log/cellos/dbnodeupdate.log
(*) 2015-02-03 19:33:29: Collecting system configuration details. This may take a while...
(*) 2015-02-03 19:33:56: Validating system details for known issues and best practices. This may take a while...
(*) 2015-02-03 19:33:56: Checking free space in /u01/19625719/Infrastructure/11.2.3.3.1/ExadataDatabaseServer/iso.stage.030215193245
(*) 2015-02-03 19:33:57: Unzipping /u01/19625719/Infrastructure/11.2.3.3.1/ExadataDatabaseServer/p18876946_112331_Linux-x86-64.zip to /u01/19625719/Infrastructure/11.2.3.3.1/ExadataDatabaseServer/iso.stage.030215193240, this may take a while
(*) 2015-02-03 19:34:08: Original /etc/yum.conf moved to /etc/yum.conf.030215193240, generating new yum.conf
(*) 2015-02-03 19:34:08: Generating Exadata repository file /etc/yum.repos.d/Exadata-computenode.repo

Warning: Total amount of free space in the volume group is less than 2GB. Unable to make a snapshot

Warning: Backup functionality will not be provided by dbnodeupdate.sh and need to be made separately

Issue: