Install the Oracle client on Ubuntu

Source: Internet
Author: User
Tags unpack

Install the Oracle client on Ubuntu

There are a lot of graphical tools on the Ubuntu Desktop to connect to the Oracle database, such as DBeaver, but sometimes you still need to connect to the remote database through sqlplus, then you need to install the Oracle client. This document describes how to install the Oracle 12.2.0.5 client in Ubuntu.

-- Download

Http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

Note: Download the client of the corresponding version as needed.

-- Download the following rpm package

Bkjia @ bkjia :~ /Downloads $ ll *. rpm
-Rw-r -- 1 bkjia 34 M August 26 09: 40 oracle-instantclient-basic-10.2.0.5-1.x86_64.rpm
-Rw-r -- 1 bkjia 284 K August 26 09: 58 oracle-instantclient-devel-10.2.0.5-1.x86_64.rpm
-Rw-r -- 1 bkjia 776 K August 26 09: 57 oracle-instantclient-sqlplus-10.2.0.5-1.x86_64.rpm

-- Installation: alien

Bkjia @ bkjia :~ /Downloads $ sudo alien-I *. rpm
Dpkg -- no-force-overwrite-I oracle-instantclient-basic_10.2.0.5-2_amd64.deb
Selecting previusly unselected package oracle-instantclient-basic.
(Reading the database... the system currently has 309521 files and directories installed .)
Preparing to unpack oracle-instantclient-basic_10.2.0.5-2_amd64.deb...
Unpacking oracle-instantclient-basic (10.2.0.5-2 )...
Setting oracle-instantclient-basic (10.2.0.5-2 )...
Processing triggers for libc-bin (2.19-0ubuntu6. 1 )...
Dpkg -- no-force-overwrite-I oracle-instantclient-devel_10.2.0.5-2_amd64.deb
Selecting previusly unselected package oracle-instantclient-devel.
(Reading the database... the system currently has 309536 files and directories installed .)
Preparing to unpack oracle-instantclient-devel_10.2.0.5-2_amd64.deb...
Unpacking oracle-instantclient-devel (10.2.0.5-2 )...
Setting oracle-instantclient-devel (10.2.0.5-2 )...
Dpkg -- no-force-overwrite-I oracle-instantclient-sqlplus_10.2.0.5-2_amd64.deb
Selecting previusly unselected package oracle-instantclient-sqlplus.
(Reading the database... the system currently has 309579 files and directories installed .)
Preparing to unpack oracle-instantclient-sqlplus_10.2.0.5-2_amd64.deb...
Unpacking oracle-instantclient-sqlplus (10.2.0.5-2 )...
Setting oracle-instantclient-sqlplus (10.2.0.5-2 )...

Note: the installation is complete.

-- Run sqlplus

Bkjia @ bkjia:/usr/lib/oracle/10.2.0.5/client64/bin $./sqlplus
./Sqlplus: error while loading shared libraries: libsqlplus. so: cannot open shared object file: No such file or directory

Note: The lib environment variable is not added.

-- Add the following environment variables

Bkjia @ bkjia :~ $ Vim ~ /. Bashrc
# Env
Export ORACLE_HOME =/usr/lib/oracle/10.2.0.5/client64
Export PATH = $ ORACLE_HOME/bin: $ PATH
Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib: $ LD_LIBRARY_PATH

-- Test again

Bkjia @ bkjia :~ $ Source. bashrc

Bkjia @ bkjia :~ $ Which sqlplus
/Usr/lib/oracle/10.2.0.5/client64/bin/sqlplus

Sqlplus username/password @ // dbhost: 1521/SID

Note: sqlplus is successfully connected to the remote oracle database. If the libaio. so.1 file is missing in this step, run the "sudo apt-get install libaio1" command.

This article permanently updates link: http://www.bkjia.com/Linux/2016-04/130447tm

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.