Linux 快速安裝 Oracle Client 使用 sqlplus
Linux 快速安裝 Oracle Client 使用 sqlplus

在Linux上大家一定都覺得使用rpm是最快的軟體安裝方式,因為工作上的需求,我也曾經胡搞瞎搞把OralceClient裝起來了,最主要要能使用sqlplus,而如今面臨到...

sqlplus with Instant Client?

Hi,Hereisalinkwithinfohowtoconfigureaninstantsqlplusclientforlinux.http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ape.htm#CHDJCDFAHopethishelp...

** 本站引用參考文章部分資訊,基於少量部分引用原則,為了避免造成過多外部連結,保留參考來源資訊而不直接連結,也請見諒 **

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

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

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.

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

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

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) ...

Instant Client downloads for Linux x86 - Oracle

Instant Client Downloads for Linux x86 You must accept the Oracle Technology Network License Agreement to download this software. ... *Instant Client Package - SQL*Plus: Additional libraries and executable for running SQL*Plus with Instant *Instant Client

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. ...

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

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-

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


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 相關文章