Contribution on article on Oracle Instant Client

[Kevin Godby]

Hello, Barry.

On Fri, Aug 2, 2013 at 10:25 AM, Barry Luijten <barry at bytescience.com> wrote:
> Hi,
>
> I have an addition for the wiki page regarding the Oracle Instant Client
> setup.
> https://help.ubuntu.com/community/Oracle%20Instant%20Client
>
> I ran into an issue that was not covered by the instructions on this page.
> After following the guide, and installing the latest Oracle client (12.1) on
> my Ubuntu Server 12.04 x64, my sqlplus still complained about a missing
> library:
>
> sqlplus: error while loading shared libraries: libaio.so.1: cannot open
> shared object file: No such file or directory
>
> I did a ldd on the executable:
> ldd /usr/lib/oracle/12.1/client64/bin/sqlplus
>         linux-vdso.so.1 =>  (0x00007fffcdfff000)
>         libsqlplus.so => /usr/lib/oracle/12.1/client64/lib/libsqlplus.so
> (0x00007fb792ac9000)
>         libclntsh.so.12.1 =>
> /usr/lib/oracle/12.1/client64/lib/libclntsh.so.12.1 (0x00007fb78fddc000)
>         libclntshcore.so.12.1 =>
> /usr/lib/oracle/12.1/client64/lib/libclntshcore.so.12.1 (0x00007fb78f88b000)
>         libnnz12.so => /usr/lib/oracle/12.1/client64/lib/libnnz12.so
> (0x00007fb78f175000)
>         libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007fb78ef71000)
>         libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007fb78ec74000)
>         libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0
> (0x00007fb78ea57000)
>         libnsl.so.1 => /lib/x86_64-linux-gnu/libnsl.so.1
> (0x00007fb78e83d000)
>         librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007fb78e634000)
>         libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007fb78e275000)
>         libons.so => /usr/lib/oracle/12.1/client64/lib/libons.so
> (0x00007fb78e031000)
>         /lib64/ld-linux-x86-64.so.2 (0x00007fb792dc9000)
>         libaio.so.1 => not found
>         libaio.so.1 => not found
>
> After doing some research I found out that the libaio-dev package should be
> installed:
>
> sudo apt-get install libaio-dev
>
> This solved the issue for me and resulted in a working sqlplus client.
>
> I thought this would be a nice contribution to the wiki page, but it seems
> to be locked (uneditable). Would you consider updating it?

The wiki page you cite suggests installing the libaio1 package if you
encounter the error you mentioned. That package provides the
libaio.so.1 file.  The libaio1-dev package depends on the libaio1
package but isn't required to run the program. (It's only required if
you're a programming who is using the libaio1 library.)

If you uninstall the libaio1-dev package and install the libaio1
package, does the program still work as expected?

—Kevin Godby