Linux Install Oracle Client

1, ready 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 the oracle-instantclient-basic-10.2.0.5-1.i386.rpm first, and install the others sequentially

2. Create users, groups, and directories

[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. Copy the Tnsnames.ora above the Oracle server and place it under the/home/oracle/network/admin directory.
4. Modify 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, the Oracle server can be connected properly

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

Linux Install Oracle Client