Hi,
I am getting error while connecting to Oracle from Websphere Server 6.1 in Linux.
I copied the Oracle client from AIX box and paste it to Linux box.
Error:
The test connection operation failed for data source TEST on server testEntApp_01 at node ws_nodename with the following exception: java.sql.SQLException: java.lang.UnsatisfiedLinkError: ocijdbc10 (/oracle/product/10.2.0/libocijdbc10.so: invalid ELF header
I google to understand what does "invalid ELP header" mean, but didn't find any convincing information.
The issue is that your libocijdbc10.so file is bad. It could be a bitness issue (you are running a 64-bit JVM and the .so is 32-bit). Or it could be that the .so is just corrupt.
If this file is part of the "client for AIX" that you copied, then no wonder it doesn't work. You should instead install the correct version of Oracle for your Linux machine.
"ELF" is a file format used for binary executable files in modern-day versions of Linux. ELF files for AIX cannot be expected to run under Linux anymore than Windows DLL files could be. AIX is not Linux, it's Unix, and Unix binary files are rarely that interchangeable even with other flavors of Unix.
Java programs would normally use the Oracle Type 4 JDBC driver. Type 4 drivers are 100% java, and therefore can be copied freely between machines regardless of what OS is in use. However, non-java programs require binary drivers, which cannot be copied freely, since they're not "Write Once/Run Anywhere" like Java is. The Oracle binary utilities such as SQL*PLUS are 100% OS-dependent, and you shouldn't even think about trying to copy them. Use the Oracle installer to install the appropriate client code for the OS that's going to be running it.
One of the most odious afflictions that Business has inflicted on the modern English language is "pro-active". Most of the time it's simply redundantly used in place of the simple old word "active". And a good deal of the rest of the time it means "You're not overworked enough yet, so go out and find more!"
0
