Oracle Client 18xe on Ubuntu 18 - 64bit

1.download and install ALL 3 THIS:
oracle-instantclient19.3-basic-19.3.0.0.0-1.x86_64.rpm
oracle-instantclient19.3-sqlplus-19.3.0.0.0-1.x86_64.rpm
oracle-instantclient19.3-devel-19.3.0.0.0-1.x86_64.rpm

2.quick test:

export LD_LIBRARY_PATH=/usr/lib/oracle/19.3/client64/lib

sqlplus System/manager@192.168.122.205:1521/XE




3.add these lines (~/.bash_profile, ~/.profile, ~/.bashrc)

export LD_LIBRARY_PATH=/usr/lib/oracle/19.3/client64/lib

export ORACLE_HOME=/usr/lib/oracle/19.3/client64

export PATH=$PATH:$ORACLE_HOME/bin

export TNS_ADMIN=/usr/lib/oracle/19.3/client64/network/admin

[/etc/profile.d/oracle.sh]

export ORACLE_HOME=/usr/lib/oracle/19.3/client64

export PATH=$PATH:$ORACLE_HOME/bin




4.setup tnsnames.ora and sqlnet.ora

cd /usr/lib/oracle/19.3/client64

sudo mkdir network

cd network

sudo mkdir admin

cd admin




[tnsnames.ora]

XE =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.122.205)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = XE)

    )

  )

[sqlnet.ora]

SQLNET.AUTHENTICATION_SERVICES=(NTS)

NAMES.DIRECTORY_PATH=(LDAP,TNSNAMES,ONAMES,HOSTNAME) 

DEFAULT_SDU_SIZE=8761




sudo chmod a+w *.ora




5.reboot, run:

sqlplus System/manager@192.168.122.205:1521/XE




6.done