Linux installation OracleClient

1, prepare the required installation package, http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html this URL has a variety of operating system client

oracle-instantclient-basic-10.2.0.5-1.i386.rpm
oracle-instantclient-devel-10.2.0.5-1.i386.rpm
oracle-instantclient-jdbc-10.2.0.5-1.i386.rpm
oracle-instantclient-sqlplus-10.2.0.5-1.i386.rpm

Install oracle-instantclient-basic-10.2.0.5-1.i386.rpm first. Other installation in turn

2. Create users, groups, and folders

[Email protected] oracle]# Groupadd Oinstall
[[email protected] oracle]# Groupadd DBA
[Email protected] oracle]# useradd-g oinstall-g dba Oracle
[Email protected] oracle]# passwd Oracle
Changing password for user Oracle.
New UNIX Password:
Bad Password:it are based on a dictionary word
Retype new UNIX Password:
Passwd:all authentication tokens updated successfully.
[Email protected] oracle]# mkdir-p/home/oracle/network/admin
[Email protected] oracle]# chown-r oracle:oinstall/home/oracle
[Email protected] oracle]# chmod-r 755/home/oracle

3, the oracleserver above the Tnsnames.ora copy out. Put the following in the/home/oracle/network/admin folder.

This step does not need to be
4. Change environment variables

[Email protected] ~]$ Vi. bash_profile

Export Oracle_home=/home/oracle
Export Sqlpath=/home/oracle/network/admin
Export Tns_admin=/home/oracle/network/admin
Export nls_lang= "simplified Chinese_china. ZHS16GBK "
Export Ld_library_path=/usr/lib/oracle/10.2.0.5/client/lib/:/usr/lib/oracle/10.2.0.5/client/lib: $LD _LIBRARY_PA
TH
Export path= $PATH: $ORACLE _home: $LD _library_path

[[email protected] ~]$ source. Bash_profile environment variable takes effect immediately

5, can connect the oracleserver normally

[Email protected] ~]$ sqlplus zhgy/[email protected]/ORCL

Linux installation OracleClient