oracle 迁移lightdb用例.pdf

小小亮

9页

3次

墨值0

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

然后解压安装

[[email protected] ~]$ 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!

[[email protected] /usr/local]$ tar -xzvf dbi-1.643.tar.gz

[[email protected] /usr/local/dbi-1.643]$ cd dbi-1.643/

[[email protected] /usr/local/dbi-1.643]$ perl makefile.pl

[[email protected] /usr/local/dbi-1.643]$ make

[[email protected] /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

[[email protected] /usr/local/dbd-oracle-1.74]$ tar -zxvf dbd-oracle-1.74.tar.gz

[[email protected] /usr/local/dbd-oracle-1.74]$ cd dbd-oracle-1.74/

[[email protected] /usr/local/dbd-oracle-1.74]$ perl makefile.pl

[[email protected] /usr/local/dbd-oracle-1.74]$ make

[[email protected] /usr/local/dbd-oracle-1.74]$ make install

[[email protected] /usr/local]$ cd dbd-pg-3.14.2/

[[email protected] /usr/local]$ perl makefile.pl

[[email protected] /usr/local]$ make

[[email protected] /usr/local]$ make install

[[email protected] /usr/local]$ cd ora2pg-21.0/

[[email protected] /usr/local/ora2pg-21.0]$ ls

changelog doc install lib license makefile.pl manifest packaging readme scripts

[[email protected] /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

[[email protected] /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

[[email protected] /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

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

[[email protected] /usr/local/dbd-oracle-1.74]$ tar -zxvf dbd-oracle-1.74.tar.gz

[[email protected] /usr/local/dbd-oracle-1.74]$ cd dbd-oracle-1.74/

[[email protected] /usr/local/dbd-oracle-1.74]$ perl makefile.pl

[[email protected] /usr/local/dbd-oracle-1.74]$ make

[[email protected] /usr/local/dbd-oracle-1.74]$ make install

[[email protected] /usr/local]$ cd dbd-pg-3.14.2/

[[email protected] /usr/local]$ perl makefile.pl

[[email protected] /usr/local]$ make

[[email protected] /usr/local]$ make install

[[email protected] /usr/local]$ cd ora2pg-21.0/

[[email protected] /usr/local/ora2pg-21.0]$ ls

changelog doc install lib license makefile.pl manifest packaging readme scripts

[[email protected] /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

[[email protected] /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

[[email protected] /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

关注

oracle 迁移lightdb用例.pdf -利来国际app

评论