Oracle SQLPlus under Ubuntu 12.10

I needed the Oracle SQLPlus client. Here are the steps to get it running:

  • Go to http://www.oracle.com/technetwork/database/features/index.html. There you find a link named Database Instant Client. Follow that link and choose x86 or x86-64. Download the following 3 packages: basic, sqlplus, devel.
  • The install these packages with alien:
  • ┬áThen create a file /etc/ld.so.conf.d/oracle.conf with the content
    /usr/lib/oracle/11.2/client64/lib/

    and reload the dynamic linker with sudo ldconfig.
  • NOTICE: Make sure to use the wright folder! I just used mine.
  • Also create a file /etc/profile.d/oracle.sh in your profile to set ORACLE_HOME. Here the content of the file (don’t forget to make it executable with chmod +x after creating it):
  • NOTICE: Make sure you use the correct folder here. I just used mine here.
  • Then create a link to the includes in your ORACLE_HOME:
  • NOTICE: Also make sure to use the wright paths here!
  • After all that you should be able to connect to a database with

Error: Can’t open display: :0.0

I recently tried to install oracle under ubuntu. I added a new user and could not start any x-windows as this new user. “xhost +” was the solution.