Wednesday, July 13, 2011

Install oracle client and sql loader on ubuntu 1104


  1. Install the client and verify that it is working
  2. Download the 11g beta version of the database. Take the RPM of course and not .exe ;)
  3. Extract the rpm, then cpio and then contents of the cpio (I know, how insane is that?).
  4. copy the u01/app/oracle/product/11.2.0/xe/bin/sqlldr to /usr/lib/oracle/11.2/client64/bin/ (or /usr/lib/oracle/11.2/client/bin/ depending on your arch)
  5. copy the u01/app/oracle/product/11.2.0/xe/rdbms/mesg to /usr/lib/oracle/11.2/client64/rdbms/mesg/
Voila!

2 comments:

  1. I downloaded the ZIP file ...
    In the end I had to install the system on another server, and then copy the files you mentioned into the relevant places.

    ReplyDelete
  2. The instructions above worked for me on Ubuntu 14 (64 bit) with an Oracle installed using these instructions (http://mikesmithers.wordpress.com/2011/04/03/oracle-instant-client-on-ubuntu-with-added-aliens/). I had to make the following small changes to get it to work:

    1) the link to the Oracle DB is no longer valid. I found Oracle Database Express Edition 11g by searching on the Oracle site for "11g Express" and clicking on the downloads link

    2) After copying the sqlldr binary and mesg folder I got the following error:

    "Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found; No message file for product=RDBMS, facility=UL"

    I ran 'strace sqlldr' and found the path that the program was using to load a message file was a slighty different path from where I had installed the 'mesg' folder. So, I moved the mesg folder where sqlldr wanted it and the program seemed to work fine.

    ReplyDelete