Category Archives: Oracle

Oracle SQLPlus under Ubuntu 12.10

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

  • Go to 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:
    sudo alien -i oracle-*sqlplus*.rpm
    sudo alien -i oracle-*basic*.rpm
    sudo alien -i oracle-*devel*.rpm
  •  Then create a file /etc/ with the content

    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/ 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):
    export ORACLE_HOME=/usr/lib/oracle/11.2/client64
  • 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:
    sudo ln -s /usr/include/oracle/11.2/client64 
  • NOTICE: Also make sure to use the wright paths here!
  • After all that you should be able to connect to a database with
    sqlplus64 <username>/<password>@<host>:<port>/<sid>

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.

oracle@orabox:/home/oracle/database$ xclock
No protocol specified
Error: Can't open display: :0.0

root@orabox:/home/oracle/database# xhost +
access control disabled, clients can connect from any host
root@orabox:/home/oracle/database# su oracle
oracle@orabox:/home/oracle/database$ xclock