I referred to the post at –> https://help.ubuntu.com/community/Oracl ... t%20Client
There are certain additional steps that I took to get the Oracle client up and running.
My laptop is running Ubuntu 14.04 64bit.
1. First download the *.zip file–> “instance client basic lite” from Oracle website
http://www.oracle.com/technetwork/topic ... 92277.html
2. Unzip the file into /usr/lib/oracle/11.2/client64
3. Prepare .bash_profile file
cat $HOME/.bash_profile
export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib/:$LD_LIBRARY_PATH
export ORACLE_HOME=/usr/lib/oracle/11.2/client64
export PATH=$PATH:$ORACLE_HOME/bin
4. Create a “bin” folder. Move sqlplus into the bin folder.
5. Create a “lib” folder. Move all lib* files into “lib” folder.
6. Create network/admin folder. And put your tnsnames.ora into it. This way your sqlplus will know which alias to call.
7. Ultimately, the structure should be as followed
/usr/lib/oracle/11.2/client64$ ls -ltr
total 5076
-rw——- 1 des des 192365 Aug 24 2013 uidrvci
-rw——- 1 des des 47860 Aug 24 2013 genezi
-rw——- 1 des des 449 Aug 24 2013 BASIC_LITE_README
-rw——- 1 des des 25420 Aug 24 2013 adrci
-rw——- 1 des des 66779 Aug 24 2013 xstreams.jar
-rw——- 1 des des 2739616 Aug 24 2013 ojdbc6.jar
-rw——- 1 des des 2091135 Aug 24 2013 ojdbc5.jar
-rw——- 1 des des 443 Aug 24 2013 SQLPLUS_README
drwxrwxr-x 2 des des 4096 Sep 23 14:03 bin
drwxrwxr-x 2 des des 4096 Sep 23 14:05 lib
drwxrwxr-x 3 des des 4096 Sep 23 14:16 network
8. I need to run the following as well.
sudo apt-get install libaio1
9. It should work now.
代碼: 選擇全部
instantclient-basic-linux.x64-11.2.0.4.0.zip
instantclient-sqlplus-linux.x64-11.2.0.4.0.zip