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

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

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

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

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

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-

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

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 client端用sqlplus連oracle server的?

小弟的環境是有兩台server , 1台是oracle server(windows2000,192.168.100.1),另一台是linux(192.168.100.2) 安裝sqlplus想登入oracle server下指令,目前遇到的 ...

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.

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

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

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


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

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