windows 下
方法是：使用Oracle InstantClient連接oracle數據庫
1 下載相應的程序，如是10204的instantclient-basic-win32-10.2.0.4.zip (34,742,358 bytes)
或者instantclient-basic-win32-10.2.0.3-20061115.zip
WIN64位系統
2 將Oracle Instatnt Client解壓。如，至D:\test\instantclient_10_2
3 環境變量配置： "控制面板"-"系統"-"高級"-"環境變量"-"系統變量"添加
NLS_LANG = AMERICAN_AMERICA.ZHS16GBK(或SIMPLIFIEDCHINESE_CHINA.ZHS16GBK) TNS_ADMIN = D:\test\instantclient_10_2 LD_LIBRARY_PATH = D:\test\instantclient_10_2 SQLPATH = D:\test\instantclient_10_2 Path變量結尾添加;D:\test\instantclient_10_2 |
4 在D:\test\instantclient_10_2中用添加如下內容的文件，文件名為tnsnames.ora
5 可以下載單獨的Oracle SDK 和Oracle SQL PLUS到安裝目錄中，解壓即可運行
附ORA文件內容與格式
tnsnames.ora #D:/instantclient_10_2/tnsname.ora ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.0.47)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = dedicated) (SERVICE_NAME = mydb1) ) ) |
如果執行完以上步驟之后報錯：
ORA_12705:Cannot access NLS data files orinvalid environment specified的錯誤
則執行NLS_LANG = AMERICAN_AMERICA.ZHS16GBK(或SIMPLIFIEDCHINESE_CHINA.ZHS16GBK)
的時候替換另一種字符集
linux下
1、 去官網下載安裝包
比如對應11gr2的
oracle-instantclient11.2-basic-11.2.0.1.0-1.i386.rpm oracle-instantclient11.2-devel-11.2.0.1.0-1.i386.rpm oracle-instantclient11.2-sqlplus-11.2.0.1.0-1.i386.rpm |
2、 copy到linux上執行安裝
rpm -ivh XXX.rpm
3、 配置環境變量
編輯vi .bashrc,追加
export ORACLE_HOME=/usr/lib/oracle/11.2/client export TNS_ADMIN=$ORACLE_HOME/network/admin export NLS_LANG='simplified chinese_china'.ZHS16GBK export LD_LIBRARY_PATH=$ORACLE_HOME/lib export PATH=$ORACLE_HOME/bin:$PATH |
手動創建目錄$ORACLE_HOME/network/admin
并在這個目錄下創建編輯文件tnsnames.ora
添加鏈接串
ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.9.76)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) |
4、 執行命令source .bashrc生效修改內容，測試連接sqlplus
5、 如果出現sqlplus: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
則安裝相應包即可