Shulou(Shulou.com)06/01 Report--

1. Download the installation package:

oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.rpm oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64.rpm

2.rpm installation

[root@www ~]# rpm -ihv oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.rpm --nodeps[root@www ~]# rpm -ihv oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64.rpm --nodeps

3. Configure connection information

[root@www ~]# vi /usr/lib/oracle/11.2/client64/tnsnames.ora Oracletest= #Library name to which Oracle library is to be connected (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 110.103.211.310)(PORT = 1521)) #Database IP, Open Port ) (CONNECT_DATA = (SERVICE_NAME=Oracletest ) #Library name to which Oracle library to connect ) )

4. environment variable configuration

[root@www ~]# vi /etc/profile #Add the following configuration at the end of the file export ORACLE_HOME=/usr/lib/oracle/11.2/client64export TNS_ADMIN=$ORACLE_HOMEexport PATH=$PATH:$ORACLE_HOME/binexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

5. verify the configuration

[root@www ~]# sqlplus account name/password as role name #login data indicates successful configuration.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.