Linux 快速安裝 Oracle Client 使用 sqlplus

Linux 快速安裝 Oracle Client 使用 sqlplus

在 Linux 上大家一定都覺得使用 rpm 是最快的軟體安裝方式,因為工作上的需求,我也曾經胡搞瞎搞把 Oralce Client 裝起來了,最主要要能使用 sqlplus,而如今面臨到了要轉移的問題,我自己試了幾次 rpm 安裝都沒搞定,後來發現更快的安裝方式,也提供給大家參考。

Oracle Instant Client 選擇需要的版本,本文以 x86-64 為例子

Linux Oracle Client

只需要下載三個檔案
  1. instantclient-basic-linux.x64-11.2.0.3.0.zip
  2. instantclient-sqlplus-linux.x64-11.2.0.3.0.zip
  3. instantclient-sdk-linux.x64-11.2.0.3.0.zip

下載之後在同一個位置 unzip 解壓縮,會將全部的東西解壓縮在 instantclient_11_2 的目錄下,只要還就變數設定好就可以使用。

設定環境變數:

# vi ~/.bash_profile

export ORACLE_HOME=/home/oracle/instantclient_11_2
export TNS_ADMIN=$ORACLE_HOME
export LD_LIBRARY_PATH=$ORACLE_HOME:/usr/local/lib:${LD_LIBRARY_PATH}
export SQLPATH=$ORACLE_HOME
export PATH=$PATH:$ORACLE_HOME

基本上就看大家把目錄放在哪裡,只要環境變數設定妥當,這個 Oracle Client 與 sqlplus 就像免安裝版一樣!設定完成之後重新登出在登入套用環境變數,這樣一來執行 sqlplus 應該就沒有問題囉!

Linux Oracle Client sqlplus

Linux Oracle Client sqlplus 相關文章

糟糕!怎麼會沒有~會努力加油的!

參考內容推薦

SQL*Plus Instant Client

SQL*Plus Instant Client is a standalone product with all the functionality of SQL*Plus command-line. It connects to existing remote Oracle databases, but does not include its own database. It is easy to install and uses significantly less disk space than

Instant Client downloads for Linux x86

Subject to the Oracle Technology Network License Agreement for Oracle Instant Client software, ... instantclient-sqlplus-linux-x86-64-10.2.0.3-20070103.zip (789,884 bytes) (cksum - 3288276695) oracle-instantclient-sqlplus-10.2.0.3-1.x86_64.rpm Instant Cli

Oracle Instant Client

Oracle Instant Client is a free Oracle database client. The current version is 12.1.0.2.0, ... Everyone needs either "Basic" or "Basic lite", and most users will want "SQL*Plus" and the "SDK". Convert these .rpm fil

oracle - sqlplus client for linux

Can anybody tell me oracle has sql client for linux? what us the size of it. and performance issues with that. Regards & Thanks Uday Skip navigation Oracle Community Directory Oracle Community FAQ Log in Register My Oracle Support Community (MOSC) ...

sqlplus with Instant Client?

Hi, Here is a link with info how to configure an instant sqlplus client for linux. http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ape.htm#CHDJCDFA Hope this help ...

linux - Accessing Oracle Wallet using Oracle sqlplus Instant client

I've configured Oracle wallet successfully in my Linux server(Linux 2.6.32-642.4.2.el6.x86_64 GNU/Linux). ... Note: Any way, When I use the Instant sqlplus client to connect using username and password, it works fine. /oracle/instantclient/11.1.0.6.0-

想請教從linux client端用sqlplus連 oracle server的? / Oracle / 程式設計俱樂部

想請教從linux client端用sqlplus連 oracle server的? 更改我的閱讀文章字型大小 大 小 作者 : abu0703(abu0703) [ 貼文 3 | 人氣 473 | 評價 0 | 評價/貼文 0 | 送出評價 0 次 ] [ 給個讚] [ 給個讚] ...

connecting to Oracle with Instant Client

I just installed Oracle Instant Client on a machine that has no Oracle client on it. I would like to now hook up to a remote Oracle database, either using

amazon web services - How to install SQL * PLUS client in linux

How to install SQL * PLUS client in linux up vote 11 down vote favorite 4 I am working on AWS services. I have an ec2 ( centos ) instance. ...

SQL*Plus Instant Client

Installing SQL*Plus Instant Client from Linux RPM Packages. Download .... is a symbolic link to the SQL*Plus binary at /usr/lib/oracle/10.2.0.1/client/bin/sqlplus.