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

First, download

Oracle linux_x86-64 client download address: http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

Download the components of the client as needed. Usually, we only need to use sqlplus connection and query commands on the client, so we only need to download two rpm packages, basic and sqlplus. What is installed here is version 11.2.0.3 under redhat linux7.

Second, install by root user

Rpm-ivh oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm

Rpm-ivh oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64.rpm

Add oracle users and directories

[chenyj@backup-server home] $su-

Password:

[root@app-server ~] #

[root@app-server ~] # groupadd oinstall

[root@app-server ~] # groupadd dba

[root@app-server] # useradd-g oinstall-G dba oracle

[root@app-server ~] # passwd oracle

Changing password for user oracle.

New password:

BAD PASSWORD: it is based ona dictionary word

BAD PASSWORD: is too simple

Retype new password:

Passwd: all authentication tokens updated successfully.

[root@app-server] # mkdir-p / usr/lib/oracle/11.2/client64/network/admin

[root@app-server] # chown-R oracle:oinstall / usr/lib/oracle/

[root@app-server] # chmod-R 755 / usr/lib/oracle/

III. Configuration

[root@app-server ~] # su-oracle

[oracle@app-server ~] $vi .bash _ profile

Umask 022

ORACLE_BASE=/usr/lib/oracle

Export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/11.2/client64

Export ORACLE_HOME

PATH=$ORACLE_HOME/bin:/usr/lib/oracle:$PATH

Export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib

Export LD_LIBRARY_PATH

SQLPATH=/usr/lib/oracle

TNS_ADMIN=/usr/lib/oracle/11.2/client64/network/admin

NLS_LANG= "SimplifiedChinese_China.ZHS16GBK"

Export SQLPATH TNS_ADMIN NLS_LANG

Create configuration files tnsname.ora and libs

Previously, you have created the directory network/admin under the ORACLE_HOME directory. Just copy the tnsnames.ora from the database server.

[oracle@app-server admin] $su

Password:

[root@app-server admin] # vi / etc/ld.so.conf

Include ld.so.conf.d/*.conf

/ usr/lib/oracle/11.2/client64/lib/ add this line

[root@app-server admin] # ldconfig

5. Testing

[oracle@app-server admin] $sqlplus test/123456@MYDATA

SQL*Plus: Release 10.2.0.1.0-Production on Wednesday January 4 10:18:48 2017

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connect to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

And Real Application Testing options

SQL >

The test was successful!

Note:

If the following error occurs:

Sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

Indicates that the environment variable is not in effect!

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.