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

0
oracle 迁移lightdb用例.pdf
71
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
of 9
【利来手机国际的版权声明】本文为墨天轮用户原创内容,转载时必须标注文档的来源(墨天轮),文档链接,文档作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:[email protected]进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论

关注
最新上传
暂无内容,敬请期待...
下载排行榜
周榜 月榜