/lib/ld-linux.so.2: bad ELF interpreter: No such file or directory

1. ready to install oracle 10g on OracleLinux 7.

2. runInstaller, hit failed: /lib/ld-linux.so.2

3. solution:

# yum install /lib/ld-linux.so.2

it’s outside the scope of:

oracle-rdbms-server-11gR2-preinstall-1.0-4.el7.x86_64.rpm 14-Oct-2015 06:24 18.9 K
oracle-rdbms-server-12cR1-preinstall-1.0-4.el7.x86_64.rpm 14-Oct-2015 06:18 17.7 K

Exadata shows error on kfod

Following is an example which configured on Exadata issue.

kfod shows segment fault.

Dump file /oraTB/base/diag/kfod/user_oracle/host_1620649457_93/incident/incdir_81/ora_95934_140163329665856_i81.trc
Jump to table of contents
Dump continued from file: /oraTB/base/diag/kfod/user_oracle/host_1620649457_93/trace/ora_95934_140163329665856.trc
oci-24550 [11] [[si_signo=11] [si_errno=0] [si_code=1] [si_int=1364841332] [si_ptr=0x7f7a5159d374] [si_addr=0x18]] [] [] [] [] [] [] [] [] [] []
========= Dump for incident 81 (oci 24550) ========
Starting a Diag Context default dump (level=3)

—– Incident Context Dump —–
Address: 0x7fff8c1392f0
Incident ID: 81
Problem Key: oci 24550
Error: oci-24550 [11] [[si_signo=11] [si_errno=0] [si_code=1] [si_int=1364841332] [si_ptr=0x7f7a5159d374] [si_addr=0x18]] [] [] [] [] [] [] [] [] [] []
[00]: dbgePostErrorDirectVaList_int [diag_dde]
[01]: dbgePostErrorDirect [diag_dde]
[02]: kpeDbgSignalHandler []<– Signaling
[03]: skgesig_sigactionHandler []
[04]: __sighandler []
[05]: kgfdTerm [KGF]
[06]: kfodddTerm []
[07]: kfodddInit []
[08]: kfodExecute []
[09]: kfod_main []
[10]: lpmcall []
[11]: lpmpmai []
[12]: main []
[13]: __libc_start_main []

check kfod log:
Trace file /oraTB/base/diag/kfod/user_oracle/host_1620649457_93/trace/ora_95934_140163329665856.trc
OSSIPC:SKGXP:[1378fb0.0]{0}: ifconfig_int(3047a8c0) failed with 0.
OSSIPC:SKGXP:[1378fb0.1]{0}: skgxpcini: Invalid IP address [] provided
OS system dependent operation:if_not_found failed with status: 0
OS failure message: Error 0
failure occurred at: skgxpvaddr9
additional information: requested interface 192.1xx.71.48 not found. Check output from ifconfig command
DDE: Flood control is not active
Incident 81 created, dump file: /oraTB/base/diag/kfod/user_oracle/host_1620649457_93/incident/incdir_81/ora_95934_140163329665856_i81.trc
oci-24550 [11] [[si_signo=11] [si_errno=0] [si_code=1] [si_int=1364841332] [si_ptr=0x7f7a5159d374] [si_addr=0x18]] [] [] [] [] [] [] [] [] [] []


check that this ip 71.48 is on 1st node, while current ip should be 71.49.

change following cellinit ip to 49

#cat /etc/oracle/cell/network-config/cellinit.ora

A Best Practice to Prepare EL6 Linux for Oracle RDBMS Installation

following is not a guide to install RDBMS, but a quick environment preparation before that.
this text works on both Linux/Windows host.

0. to setup Oracle RDBMS 12c on EL6.3 vbox.  for testing purpose.

1. prepare virtualbox.
setup a new linux machine, with harddisk 40G,  network using NAT.

2. attach image on CD. boot

3. install option.
a) using the full disk, using default dynamic lv settings(means you can adjust disk sizes whenever you want)
b) install option: Desktop (or you may have to using vnc or inst other Xwindow options if you choose “Database Server”).
c) reboot after installation. using account: oracle/oracle

4.  we need to manually install vboxtools (for a better display and operation experience enhancement)
before that we need to :

5.   keep the sys image mount.  manually install kernel-uek-devel, the # should be the same to your currently running version.

6.  check your yum repo setting. (you need uln repo, or simple public-yum is ok)
or you have to manually install dependency in the package folder.
# yum install gcc

7.  detach the sys-image. choose “Install Guest Additions”
run as prompt, or in cmd.

8.  ignore following warning, as the package already re-named to kernel-uek-devel

9. about the necessary packages you can use following cmd:

10. choosing “System”->”Preference”->”Startup Applications”
remove item “PackageKit Update Applet” , so that you should update your pkgs whenever you want and need.
remove any other items you dont like.

11. disable SELinux and firewall.
edit /etc/selinux/config  to –>”disabled”
system-config-firewall  –> “Disable”

12. let eth0 connect automatically.
either 1) using desktop network-manager, edit connection–>eth0–> connect automatically.
or 2) edit /etc/sysconfig/network-scripts/ifcfg-eth0
add following like:  “ONBOOT=yes”

reboot the node.

F.  setups already done.  you can now following guide to complete the installation

Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 6


the steps are simple but, wish it saves time you read this post before the installation.







ASMLib support on RedHat EL6

recently oracle adds support on ASMlib+RHEL6 kernel.

will seems some policies already being changed.

if someone interested, refer to


To enable ASMlib supports, please download following file from oracle web-site

and get supports ‘kmod-oracleasm’ from RedHat RHN or related support.

good luck.

Oracle CHM(IPD/OS) graphical report with gnuplot

another post on sar graphical report with gnuplot

ipd/os is a very useful tool to monitor/collect system resource status, and from release, it’s now merged as a standard component of oracle clusterware.

the new name: oracle CHM(Cluster Healthy Monitor) shows it’s now a tool for clusterware/rac, it’s very useful to record resource usage and status upto 3days.

but ipd/os report is just plain txt with boring data, it’s a better way to show as a graphical report, gnuplot helps.


here’s a sample data from classic ipd/os output(the newest chm output may contains tiny different on formatting), it contains sample data from 07:00:00-10:00:00 for node01.

ipdos_data_node01 <this sample file is very large 100M+…. not upload on this server…>
Whoever would like to get the sample data and want to try, please click here:

#1.  get the time column.

Sample: time_node01


Following, to retrieve necessary data on cpu/mem usage and iowait #.

#2. format the text, just collect usable data.



#3. get the cpu usage column.



#4. get the iowait number column.



#5. get memory usage column.
ipd/os just provide column memory free/total/cache,  like:

to calculate the usage%, need to use (physmemtotal – physmemfree – mcache) / physmemtotal *100%

so we need to get the 3 columns.


run the file to get result..

Sample: mem_node01

#6 get the report for cpu/mem usage.

Sample: ipdos_cpu_mem_gnuplot_node01
run gnuplot with following cmd:








#7 get report for iowait usage.

Sample: ipdos_iow_gnuplot_node01

run gnuplot with following cmd:








#8. comparison on different nodes.
we can show data on 1node for a duration, and also it helps to compare different node status.
following is a sample to show a four-node cluster running cpu usage:
4 samples, each records the cpu usage,

*** why not combine the 4 samples, merge  into 1 text file?
well, if you watch into the 4files, they’re of different size(line#),  different issues matter…
when some node evicted/rebooted, os data that time may lose on that node,
or when the sys stress is very very high, ipd/os will dump data using a longer interval (>1s).
So it’s fine to use different files,  of course they all dumps the same duration 07:00:00-10:00:00.
gnuplot accepts different file inputs.
run gnuplot with following cmd:








well seems it’s not very clear to put all data in this graphic, we can also just compare a short time.

and then plot the line…