Mac上使用Ora2Pg迁移Oracle到PostgreSQL

一、安装Ora2Pg

下载Ora2Pg

Terminal:
tar xzf ora2pg-17.6.tar.gz
cd ora2pg-17.6/
perl Makefile.PL
make && make install

这个过程会把Ora2Pg.pm装到Perl库, 把ora2pg放到/usr/local/bin/，ora2pg.conf.dist放到/etc/ora2pg/

二、安装DBD::Oracle

Terminal:
perl -MCPAN -e shell
cpan> get DBD::Oracle
cpan> quit
cd ~/.cpan/build/DBD-Oracle*
export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib
export ORACLE_HOME=/usr/lib/oracle/11.2/client64/
perl Makefile.PL
make
make install
export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib
export ORACLE_HOME=/usr/lib/oracle/11.2/client64/
perl -MCPAN -e 'install DBD::Oracle'

三、安装DBD::Pg

Terminal
perl -MCP