Oracle Clients: Difference between revisions
From Lolly's Wiki
Jump to navigationJump to search
m (Text replacement - "<source" to "<syntaxhighlight") |
m (Text replacement - "</source" to "</syntaxhighlight") |
||
Line 23: | Line 23: | ||
}' | \ | }' | \ | ||
sudo tee /etc/profile.d/oracle.sh | sudo tee /etc/profile.d/oracle.sh | ||
</ | </syntaxhighlight> |
Revision as of 01:53, 26 November 2021
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
$ 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