oracle client download https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html

ubuntuでoracle https://symfoware.blog.fc2.com/blog-entry-2378.html

https://oracledba.blogspot.com/2016/10/ubuntu-oracle-instant-client.html

sudo apt-get install alien

alien -i oracle-instantclientXX.X-basiclite-XX.X.0.0.0-1.x86_64.rpm
alien -i oracle-instantclientXX.X-sqlplus-XX.X.0.0.0-1.x86_64.rpm

sudo ldconfig

sudo sudo vi /etc/profile.d/oracle.sh && sudo chmod o+r /etc/profile.d/oracle.sh

/etc/profile.d/oracle.sh

export ORACLE_HOME=/usr/lib/oracle/12.1/client64
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib/${LD_LIBRARY_PATH:+:$LD_LIBRARY_PATH}

/usr/lib/oracle/XX.X/client64/lib/network/admin/

tnsnames.ora