Oracle Clients

From Lolly's Wiki
Revision as of 17:00, 25 November 2021 by Lollypop (talk | contribs) (Text replacement - "<source" to "<syntaxhighlight")
Jump to navigationJump to search

Ubuntu

Download

oracle-instantclient12.2-basiclite-12.2.0.1.0-1.x86_64.rpm
oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm

from Oracle Instant Client download page

<syntaxhighlight lang=bash> $ sudo apt install alien libaio1 $ sudo alien -i oracle-instantclient12.2-basiclite-12.2.0.1.0-1.x86_64.rpm $ sudo alien -i oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm $ for i in $(dpkg -L $(dpkg -l oracle-instantclient\* | awk '$1=="ii"{print $2;}') | grep .so ) do

 BASENAME=${i##*/}
 sudo update-alternatives --install /usr/lib/${BASENAME} ${BASENAME} ${i} 10

done $ dpkg -L $(dpkg -l oracle-instantclient*-basiclite | awk '$1=="ii"{print $2;}') | \

   awk '
     /client64$/{
       oracle_home=$1;
       printf "ORACLE_HOME=%s\nPATH=${PATH}:${ORACLE_HOME}/bin\nexport ORACLE_HOME PATH\n",oracle_home;
     }' | \
   sudo tee /etc/profile.d/oracle.sh

</source>