linux下oracle客户端&&sqlldr命令安装

oracle-instantclient11.2-basic-11.2.0.2.0.x86_64.rpm oracle-instantclient11.2-devel-11.2.0.2.0.x86_64.rpm oracle-instantclient11.2-jdbc-11.2.0.2.0.x86_64.rpm oracle-instantclient11.2-odbc-11.2.0.2.0.x86_64.rpm oracle-instantclient11.2-sqlplus-11.2.0.2.0.x86_64.rpm 网盘

rpm -ivh oracle-instantclient11.2-basic-11.2.0.2.0.x86_64.rpm rpm -ivh oracle-instantclient11.2-devel-11.2.0.2.0.x86_64.rpm rpm -ivh oracle-instantclient11.2-jdbc-11.2.0.2.0.x86_64.rpm rpm -ivh oracle-instantclient11.2-odbc-11.2.0.2.0.x86_64.rpm rpm -ivh oracle-instantclient11.2-sqlplus-11.2.0.2.0.x86_64.rpm

安装默认目录在：/usr/lib/oracle，该目录下的目录结构为如下 └── 11.2 └── client64 ├── bin │ ├── adrci │ ├── genezi │ └── sqlplus ├── lib │ ├── glogin.sql │ ├── libclntsh.so -> libclntsh.so.11.1 │ ├── libclntsh.so.11.1 │ ├── … │ └── xstreams.jar ├── network ├── admin （自行创建）

现在需要在/usr/lib/oracle/11.2/client64/network/admin 新建一个tnsnames.ora文件，文件内容如下格式： 根据自己实际情况配置 RCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL) ) )

export ORACLE_HOME=/usr/lib/oracle/11.2/client64 export TNS_ADMIN= O R A C L E H O M E / n e t w o r k / a d m i n e x p o r t N L S L A N G = " a m e r i c a n a m e r i c a . z h s 16 g b k " ; e x p o r t L D L I B R A R Y P A T H = ORACLE_HOME/network/admin export NLS_LANG="american_america.zhs16gbk" ; export LD_LIBRARY_PATH= ORACLEH​OME/network/adminexportNLSL​ANG="americana​merica.zhs16gbk";exportLDL​IBRARYP​ATH=ORACLE_HOME/lib export PATH= O R A C L E H O M E / b i n : ORACLE_HOME/bin: ORACLEH​OME/bin:PATH

本地：sqlplus /nolog 远程：sqlplus name/[email protected]/oracl

rdbms文件夹 network/mesg文件夹 文件来源于 oracle完全安装版本里面的文件。

将rdbms文件导入到/usr/lib/oracle/11.2/client64 mesg文件夹导入到/usr/lib/oracle/11.2/client64/network sqlldr 文件导入到/usr/lib/oracle/11.2/client64/bin

└── /usr/lib/oracle/11.2 └── client64 ├── bin │ ├── adrci │ ├── genezi │ ├── sqlldr │ └── sqlplus ├── lib │ ├── glogin.sql │ ├── libclntsh.so -> libclntsh.so.11.1 │ ├── libclntsh.so.11.1 │ ├── libheteroxa11.so │ ├── libnnz11.so │ ├── libocci.so -> libocci.so.11.1 │ ├── … │ ├── ottclasses.zip │ └── xstreams.jar ├── network │ ├── admin │ │ └── tnsnames.ora │ └── mesg │ ├── naukus.msb │ ├── naukus.msg │ ├── ncrus.msb │ ├── … │ ├── tnsus.msb │ └── tnsus.msg └── rdbms └── mesg ├── amduus.msb ├── amduus.msg ├── dbfsus.msb ├── dbvus.msb ├── … ├── udius.msb ├── udius.msg ├── ulus.msb └── ulus.msg

如果出现如下信息证明安装成功

如果上述步骤仍然有问题， 可能问题一：oracle 环境变量配置 比如：每次使用需要source /etc/profile 问题一解决方法：source /etc/profile 写入/etc/rc.d/rc.local 可能问题二：命令权限问题 问题二解决办法：chmod -R 增加/usr/lib/oracle文件权限