Using Sqlplus to remotely access Oracle on Linux

Centos6.4

Find instant Client from Oracle website:

Http://www.oracle.com/technetwork/cn/topics/linuxsoft-100466-zhs.html

Download Basic and Sqlplus

What I'm downloading here is

Instantclient-basic-linux32-11.2.00.1.zip

Instantclient-sqlplus-linux32-11.2.00.1.zip

Unzip to the same directory

This is what I've extracted here.

Ll/home/www/oracle_client_linux

Then you need to add the directory to the environment variable

VI ~/.BASHRC

#. bashrc# Source Global Definitions if  Then /etc/bashrcfi# User specific aliases and functionspath= $PATH: $HOME/           Binexport PATHld_library_path=/home/www/oracle_client_linuxexport ld_library_path

The red part is the newly added environment variable

Then use the command to log in directly

$user _name/$password@hostname:$port/$service _name

The marked red part is the variable

Change to a string that corresponds to the meaning of it.

Enter after the following interface:

Well, you can execute the command on it.

Using Sqlplus to remotely access Oracle on Linux