rpm -ivh *.rpm
数据拷贝工具 ora2mysql
上传到/usr/local/ora2mysql/下
环境变量 修改/etc/profile,在末尾增加如下
export ORACLE_HOME=/usr/lib/oracle/10.2.0.4/client64
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/oracle/10.2.0.4/client64/lib:/usr/local/ora2mysql/
export TNS_ADMIN=/usr/lib/oracle/10.2.0.4/client64
运行 source /ect/profile
运行
1. 进入ora2mysql目录/usr/local/ora2mysql/下
运行
./ora2mysql
显示如下
DataCopy: Fast Oracle Data Copy Utility, Release 3.0.1
(c) Copyright Lou Fangxin (AnySQL.net) 2010, all rights reserved.
Support by Wang Guang You() or WeChat(onesoft007)
Usage: ora2mysql keyword=value [,keyword=value,...]
Valid Keywords:
user1 = username/password@host