Oracle 迁移LightDB用例.pdf

小小亮

1656

9页

10次

2021-09-03

免费下载

Oracle 迁移LightDB用例

1.ora2pg简介

ora2pg是一款免费迁移工具，能将Oracle迁移到LightDB，简单使用并记录过程如下

官方文档：http://ora2pg.darold.net/

2.ora2pg部署

2.1 安装perl依赖

ora2pg是Perl语言编写的，所以需要先安装相关环境依赖

2.2 安装DBI模块

DBI，Database Independent Interface，是Perl语言连接数据库的接口

下载地址https://metacpan.org/release/DBI 下载出DBI-1.643.tar.gz

然后解压安装

[root@localhost ~]$ yum install -y perl perl-ExtUtils-CBuilder perl-ExtUtils-MakeMaker

Loaded plugins: langpacks, ulninfo

Resolving Dependencies

--> Running transaction check

---> Package perl.x86_64 4:5.16.3-294.el7_6 will be updated

---> Package perl.x86_64 4:5.16.3-297.el7 will be an update

(省略中间...)

Dependency Installed:

gdbm-devel.x86_64 0:1.10-8.el7 libdb-devel.x86_64 0:5.3.21-25.el7

perl-ExtUtils-Install.noarch 0:1.58-297.el7 perl-ExtUtils-Manifest.noarch 0:1.61-244.el7

perl-ExtUtils-ParseXS.noarch 1:3.18-3.el7 perl-IPC-Cmd.noarch 1:0.80-4.el7

perl-Locale-Maketext.noarch 0:1.23-3.el7 perl-Locale-Maketext-Simple.noarch 1:0.21-297.el7

perl-Module-CoreList.noarch 1:2.76.02-297.el7 perl-Module-Load.noarch 1:0.24-3.el7

perl-Module-Load-Conditional.noarch 0:0.54-3.el7 perl-Module-Metadata.noarch 0:1.000018-2.el7

perl-Params-Check.noarch 1:0.38-2.el7 perl-Perl-OSType.noarch 0:1.003-3.el7

perl-Test-Harness.noarch 0:3.28-3.el7 perl-devel.x86_64 4:5.16.3-297.el7

perl-version.x86_64 3:0.99.07-6.el7 pyparsing.noarch 0:1.5.6-9.el7

systemtap-sdt-devel.x86_64 0:4.0-13.0.1.el7

Updated:

perl.x86_64 4:5.16.3-297.el7

Dependency Updated:

perl-libs.x86_64 4:5.16.3-297.el7

Complete!

[root@localhost /usr/local]$ tar -xzvf DBI-1.643.tar.gz

[root@localhost /usr/local/DBI-1.643]$ cd DBI-1.643/

[root@localhost /usr/local/DBI-1.643]$ perl Makefile.PL

[root@localhost /usr/local/DBI-1.643]$ make

[root@localhost /usr/local/DBI-1.643]$ make install

2.3 安装DBD::Oracle模块

添加环境变量

安装DBD-Oracle驱动，下载地址https://metacpan.org/pod/release/PYTHIAN/DBD-Oracle-1.74/lib/DBD/Oracle.pm，下载出

DBD-Oracle-1.74.tar.gz

2.4 安装DBD::Pg模块

安装DBD-Pg驱动，下载地址https://metacpan.org/release/DBD-Pg，下载出DBD-Pg-3.14.2.tar.gz

2.5 安装ORA2PG

下载地址https://sourceforge.net/projects/ora2pg/

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1

export PATH=$PATH:$ORACLE_HOME/bin

export LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/dbhome_1/lib

[root@localhost /usr/local/DBD-Oracle-1.74]$ tar -zxvf DBD-Oracle-1.74.tar.gz

[root@localhost /usr/local/DBD-Oracle-1.74]$ cd DBD-Oracle-1.74/

[root@localhost /usr/local/DBD-Oracle-1.74]$ perl Makefile.PL

[root@localhost /usr/local/DBD-Oracle-1.74]$ make

[root@localhost /usr/local/DBD-Oracle-1.74]$ make install

[root@localhost /usr/local]$ cd DBD-Pg-3.14.2/

[root@localhost /usr/local]$ perl Makefile.PL

[root@localhost /usr/local]$ make

[root@localhost /usr/local]$ make install

[root@localhost /usr/local]$ cd ora2pg-21.0/

[root@localhost /usr/local/ora2pg-21.0]$ ls

changelog doc INSTALL lib LICENSE Makefile.PL MANIFEST packaging README scripts

[root@localhost /usr/local/ora2pg-21.0]$ perl Makefile.PL

Checking if your kit is complete...

Looks good

Writing Makefile for Ora2Pg

Done...

------------------------------------------------------------------------------

Please read documentation at http://ora2pg.darold.net/ before asking for help

------------------------------------------------------------------------------

Now type: make && make install

[root@localhost /usr/local/ora2pg-21.0]$ make

cp lib/Ora2Pg.pm blib/lib/Ora2Pg.pm

cp lib/Ora2Pg/GEOM.pm blib/lib/Ora2Pg/GEOM.pm

cp lib/Ora2Pg/PLSQL.pm blib/lib/Ora2Pg/PLSQL.pm

cp lib/Ora2Pg/MySQL.pm blib/lib/Ora2Pg/MySQL.pm

cp scripts/ora2pg blib/script/ora2pg

/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/ora2pg

cp scripts/ora2pg_scanner blib/script/ora2pg_scanner

/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/ora2pg_scanner

Manifying blib/man3/ora2pg.3

[root@localhost /usr/local/ora2pg-21.0]$ make install

Installing /usr/local/share/perl5/Ora2Pg.pm

Installing /usr/local/share/perl5/Ora2Pg/GEOM.pm

Installing /usr/local/share/perl5/Ora2Pg/PLSQL.pm

Installing /usr/local/share/perl5/Ora2Pg/MySQL.pm

Installing /usr/local/share/man/man3/ora2pg.3

Installing /usr/local/bin/ora2pg

of 9

免费下载

lightdb

关注

评论