Linux database Oracle client installation, used for shell scripts to connect to the database with sqlplus

Linux environment: Redhat6.8 64bit

Oracle: Oracle 11.2.0.4 IP=192.168.*.208

Client Environment: Linux Redhat6.8 IP=192.168.*.186

Requirements: Now you need to use shell script on the client to monitor system process, CPU and other information, and write the monitoring information to the database, you need to connect to the database, butThe client does not have a database environment and needs to connect to the database remotely to write data

Download the installation package on oracle official website, download address:

Download and upload the installation package:

oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm (required)

oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm (required)

oracle-instantclient11.2-jdbc-11.2.0.4.0-1.x86_64.rpm

oracle-instantclient11.2-tools-11.2.0.4.0-1.x86_64.rpm

Run the install command:

rpm -ivh oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm

Rpm -ivh oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm

Configure environment variables:

vim /etc/profile

export NLS_LANG="AMERICAN_AMERICA.UTF8"

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

export TNS_ADMIN=$ORACLE_HOME

export PATH=$PATH:$ORACLE_HOME/bin

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

source /etc/profile

Check the sqlplus command:

Enter sqlplus If "command not found" appears, it is an environment variable setting problem, please confirm

Login to database: sqlplus user/[email protected]:/1521/SID

Connection succeeded