Install Oracle SQL Plus on Ubuntu

Recently, I switched my development environment from CentOS to Ubuntu. I have difficulties of running Oracle SQL Plus. The installation went fine by following my previous post. However, when I tried to run sqlplus,it complains that libsqlplus.so is missing "error while loading shared libraries: libsqlplus.so": Here is the solution I used to fix the problem: Create a file oracle.conf in /etc/ld.so.conf.d 
# create file oracle.conf
sudo vim /etc/ld.so.conf.d/oracle.conf
# add the following line to the file
/usr/lib/oracle/11.2/client64/lib
# then run ldconfig to update the configuration
sudo ldconfig
But when you run sqlplus again you may find it shows another error: "missing libaio.so.1, to fix that you need install libaio1" 
sudo apt-get install libaio1
Now you may be able to connect to Oracle: 
sqlplus user/password@//oracle_server:port/SID
By -
Labels:

2 comments:

  1. Install cx_Oracle on Ubuntu from rpm package | Here is What I Saw and What I LearnedAugust 5, 2013 at 10:28 AM

    […] Make sure that you have installed oracle instant client, if not please follow this post: http://b2ctran.wordpress.com/2013/08/05/install-oracle-sql-plus-on-ubuntu/ […]

    ReplyDelete
  2. Enable batch upload to Oracle from client site | Here is What I Saw and What I LearnedAugust 6, 2013 at 7:12 AM

    […] 1. make sure that Oracle Client was installed, following this link to install" http://b2ctran.wordpress.com/2013/08/05/install-oracle-sql-plus-on-ubuntu/ […]

    ReplyDelete

Subscribe to: Post Comments (Atom)

Datatable static image not found on the server

When you use ```datatables.min.css``` and ```datatables.min.js``` locally, instead of datatables CDN, you may have encountered that ```sort...