Oracle sqlldr的安装配置
1. 配置环境变量:
export LD_LIBRARY_PATH=$HOME/oracle/client
export ORACLE_HOME=$HOME/oracle/home
export TNS_ADMIN=$LD_LIBRARY_PATH
2. 拷贝ulus.msb 和 ulzhs.msb 到 $HOME/oracle/home/rdbms/mesg目录
3. 解压instantclient-basic*.zip 和 instantclient-sqlplus*.zip 到$HOME/oracle/client目录
4. 拷贝sqlldr 到$HOME/oracle/client目录
5. 新增并配置tnsnames.ora文件
oracle_192.168.1.105 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = smapdb)
)
)
6. 可以开始使用sqlldr了。