Oracle 11.2 instant client installation in RHEL5.6

Oracle 11.2 instant client installation in RHEL5.6

Download the installation file as needed:

I only need two files: oracle-instantclient11.2-basic.rpm and sqlplus. rpm.

View the path information in the rpm:

Rpm-qpl download rpm package name

Configure the environment variable:/etc/bashrc. Add:

LD_LIBRARY_PATH =/usr/lib/oracle/11.2/client/lib

Add the following content to/etc/ld. so. conf:

/Usr/lib/oracle/11.2/client/lib

Command to make the configuration take effect:

/Sbin/ldconfig

It should be okay to use SQLPLUS now.

Create a TNS connection to a remote ORACLE database:

Mkdir-p/usr/lib/oracle/11.2/network/admin/

Edit tnsnames. ora to add your own string:

Modify the environment variable (/etc/bashrc) and add the following information:

Export ORACLE_HOME =/usr/lib/oracle/11.2
Export TNS_ADMIN =/usr/lib/oracle/11.2/network/admin

Restart to make the variable take effect:

Source/etc/bashrc

Use the SYSTEM user logon test:

Sqlplus system/***** @ orcl

Select count from V $ SYSTEM_EVENT;

If you see the result, the configuration is successful.