Create tnsnames.ora :
sqlplus username/password@//dbhost:1521/SID Or for tnsnames: oracle 64 bit client
| Type | Size | Use Case | |------|------|-----------| | | ~80–150 MB | Lightweight, no installer, simple apps | | Administrator Client | ~1.2 GB | Full DBA tools (SQL*Plus, Data Pump, Exp/Imp) | | Runtime Client | ~300 MB | Just OCI, OCCI, JDBC-OCI, ODBC | | Custom | varies | Choose components manually | Create tnsnames
sqlplus username/password@MYDB # Download RPM or ZIP from Oracle sudo yum install oracle-instantclient19.14-basic-19.14.0.0.0-1.x86_64.rpm # Or unzip to /opt/oracle/instantclient echo 'export LD_LIBRARY_PATH=/opt/oracle/instantclient:$LD_LIBRARY_PATH' >> ~/.bashrc echo 'export PATH=/opt/oracle/instantclient:$PATH' >> ~/.bashrc source ~/.bashrc ~/.bashrc source ~/.bashrc