Contribution on article on Oracle Instant Client

[Barry Luijten]

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?

Thanks in advance!

Best regards,
Barry
 Luijten
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/ubuntu-doc/attachments/20130802/15c0018a/attachment.html>