大数据架构师指南 pdf_数据大挪移之ora2pg使用指南

数据大挪移之ora2pg使用指南

作者  Iris   (PG深度爱好者)

一、    安装ora2pg

1.1下载安装包

[root@oracleora2gp]#

-rwxrwxr-x1 oracle   oinstall  448855 Jun 9 12:18 DBD-Oracle-1.74.tar.gz

-rwxrwxr-x1 oracle   oinstall  276607 Jun 9 12:18 DBD-Pg-3.12.3.tar.gz

-rwxrwxr-x1 oracle   oinstall  612372 Jun 9 12:18 DBI-1.643.tar.gz

-rwxrwxr-x1 oracle   oinstall  319638 Jun 9 12:18 ora2pg-20.0.tar.bz2

1.2 安装OS依赖软件包

[root@oracle~]# yum install perl-DBD-Pg perl perl-devel perl-DBI  perl-CPAN bzip2 perl-ExtUtils-eBuilderperl-ExtUtils-MakeMaker

1.3 安装Oracle瘦客户端

1.3.1方法一

从Oracle官方网站下载oracle 12c的瘦客户端，然后进行安装并配置。

[root@oracleu01]# la /u01/software/oracle/

total55M

drwxr-xr-x2 root root 4.0K Dec  3 15:04 .

drwxr-xr-x7 root root   76 Dec  3 15:04 ..

-rw-r--r—1root root 51M Nov 28 14:34oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm

-rw-r--r--1root root 593K Nov 28 14:32oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm

-rw-r--r--1root root 1.5M Nov 28 14:32 oracle-instantclient12.2-jdbc-12.2.0.1.0-1.x86_64.rpm

-rw-r--r--1root root 692K Nov 28 14:32oracle-instantclient12.2-sqlplus-12.2.0.1.0-1.x86_64.rpm

-rw-r--r--1root root 922K Nov 28 14:35oracle-instantclient12.2-tools-12.2.0.1.0-1.x86_64.rpm

[root@oracle~]# yum -y localinstall /u01/software/oracle/oracle-instantclient12.2-*.rpm

[root@oracle~]# mkdir -p /usr/lib/oracle/12.2/client64/network/admin

编辑root环境变量，加入以下内容：

[root@oracle~]# vi .bash_profile

exportLD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib

exportNLS_LANG=AMERICAN_AMERICA.ZHS16GBK

exportTNS_ADMIN=/usr/lib/oracle/12.2/client64/network/admin

exportORACLE_HOME=/usr/lib/oracle/12.2/client64/

exportPATH=$PATH:$ORACLE_HOME/bin:$HOME/bin

[root@oracle~]# source .bash_profile

1.3.2方法二

直接在oracle服务器端安装ora2pg工具，直接调用oracle服务端包即可。并用root用户配置环境变量：

exportLD_LIBRARY_PATH=/u01/app/oracle/product/12.1.0/db_1/lib

exportNLS_LANG=AMERICAN_AMERICA.ZHS16GBK

exportTNS_ADMIN=/u01/app/oracle/product/12.1.0/db_1/network/admin

exportORACLE_HOME=//u01/app/oracle/product/12.1.0/db_1

exportPATH=$PATH:$ORACLE_HOME/bin:$HOME/bin

1.4 安装ora2pg

[root@oracle~]# tar -xjf ora2pg-20.0.tar.bz2

[root@oracle~]# cd ora2pg-20.0

[root@oracleora2pg-20.0]# perl Makefile.PL

Checkingif your kit is complete...

Looksgood

WritingMakefile for Ora2Pg

Done...

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

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

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

Nowtype: make && make install

[root@oracleora2pg-20.0]# make && make install

cplib/Ora2Pg.pm blib/lib/Ora2Pg.pm

cplib/Ora2Pg/GEOM.pm blib/lib/Ora2Pg/GEOM.pm

cplib/Ora2Pg/PLSQL.pm blib/lib/Ora2Pg/PLSQL.pm

cplib/Ora2Pg/MySQL.pm blib/lib/Ora2Pg/MySQL.pm

cpscripts/ora2pg blib/script/ora2pg

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