用MTKD工具迁移Oracle到MogDB

1. 迁移

1.1 配制Oracle客户端

1.1.1 解压Oracle客户端

cd /opt
unzip instantclient-basic-linux.x64-19.20.0.0.0dbru.zip
unzip instantclient-sqlplus-linux.x64-19.20.0.0.0dbru.zip

1.1.2 配制环境变量

export ORACLE_HOME=/opt/instantclient_19_20
export PATH=$ORACLE_HOME:$PATH
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH
export NLS_LANG='AMERICAN_AMERICA.AL32UTF8'

export PATH

1.1.3 配制动态链接库

在 etc/ld.so.conf里添加 /opt/instantclient_19_20

[root@mogdb-01 ~]# cat /etc/ld.so.conf
include ld.so.conf.d/*.conf
/usr/local/lib
/opt/instantclient_19_20

执行 ldconfig

[root@mogdb-01 ~]# ldconfig 

1.1.4 处理报错

sqlplus: error while loading shar