Oracle迁移至openGauss的工具：ora2op的安装配置

前言

1. ora2op的下载

1.1 下载地址

1.2 ora2op 介绍

2. ora2op的安装

2.1 安装perl的依赖包

2.2 安装连接Oracle数据库的模块

2.3 安装ora2op

2.4 安装连接openGauss数据库的模块

前言

本工具是使用perl，在安装时会遇到各种问题，解决方式也是一点一点摸索，各种包依赖安装不成功。大家在参考使用时需结合实际情况。使用的操作系统是centos7.9。其中

perl -MCPAN -e &#39;install DBD::Pg&#39;

安装这个模块是各种报错

1. ora2op的下载

1.1 下载地址

在openGauss官方网站上没有直接的下载地址，但是可以找到下载的链接网站。地址（https://opengauss.org/zh/supporttools/）

进入后是gitee官方网站。 https://gitee.com/opengauss/openGauss-tools-ora2og

进入后直接点下载、这个网站下载需要账号登录。下载后的包是这样的 openGauss-tools-ora2og-master.zip

大小为474kb 或者直接从这里下载也行墨天轮文档：openGauss-tools-ora2og-master.zip 把下载的包上传到操作系统上面

1.2 ora2op 介绍

openGauss-tools-ora2og 介绍 ora2og是一个将Oracle数据库迁移至openGauss的工具，主要编程语言为perl，通过perl DBI模块连接Oracle数据库，自动扫描并提取其中的对象结构及数据，产生SQL脚本，通过手动或自动的方式应用到openGauss。此外，工具还提供丰富配置项，用户可以自定义迁移行为。

ora2og初始代码源自ora2pg，版本为release v21.1：https://github.com/darold/ora2pg/tree/v21.1。

优秀特性 支持导出数据库绝大多数对象类型，包括表、视图、序列、索引、外键、约束、函数、存储过程等。

提供PL/SQL到PL/PGSQL语法的自动转换，一定程度避免了人工修正。

可生成迁移报告，包括迁移难度评估、人天估算。

可选对导出数据进行压缩，节约磁盘开销。

配置选项丰富，可自定义迁移行为。

2. ora2op的安装

2.1 安装perl的依赖包

yum install perl-ExtUtils-CBuilder perl-ExtUtils-MakeMaker perl-Time-HiRes perl-devel perl-DBI perl-Compress-Zlib perl-open

2.2 安装连接Oracle数据库的模块

这个模块的使用需要先配置oracle客户端下载oracle 19.10的客户端官网下载地址 oracle-instantclient19.10-jdbc-19.10.0.0.0-1.x86_64.rpm oracle-instantclient19.10-sqlplus-19.10.0.0.0-1.x86_64.rpm oracle-instantclient19.10-devel-19.10.0.0.0-1.x86_64.rpm oracle-instantclient19.10-basic-19.10.0.0.0-1.x86_64.rpm 在root用户下使用rpm进行安装

rpm -ivh oracle-instantclient19.10-basic-19.10.0.0.0-1.x86_64.rpmrpm -ivh oracle-instantclient19.10-devel-19.10.0.0.0-1.x86_64.rpm rpm -ivh oracle-instantclient19.10-jdbc-19.10.0.0.0-1.x86_64.rpm rpm -ivh oracle-instantclient19.10-sqlplus-19.10.0.0.0-1.x86_64.rpm

在root家目录下配置环境变量

cd /rootvi .base_profileexport ORACLE_HOME=/usr/lib/oracle/19.10/client64export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATHexport PATH=$ORACLE_HOME/bin:$PATH

使变量生效

source .base_profile

获取安装包、然后进行编译安装

[root@master01 DBD-Oracle-1.80]# perl Makefile.PLMultiple copies of Driver.xst found in: /usr/local/lib64/perl5/auto/DBI/ /usr/lib64/perl5/vendor_perl/auto/DBI/ at Makefile.PL line 36.Using DBI 1.643 (for perl 5.016003 on x86_64-linux-thread-multi) installed in /usr/local/lib64/perl5/auto/DBI/Configuring DBD::Oracle for perl 5.016003 on linux (x86_64-linux-thread-multi)If you encounter any problem, a collection of troubleshootingguides are available under lib/DBD/Oracle/Troubleshooting.&#39;DBD::Oracle::Troubleshooting&#39; is the general troubleshootingguide, while platform-specific troubleshooting hintslive in their labelled sub-document (e.g., Win32hints are gathered in &#39;lib/DBD/Oracle/Troubleshooting/Win32.pod&#39;).Trying to find an ORACLE_HOMEYour LD_LIBRARY_PATH env var is set to &#39;/opt/huawei/install/om/lib:/opt/huawei/install/om/script/gspylib/clib:&#39;Found /usr/lib/oracle/19.10/client64WARNING: Setting ORACLE_HOME env var to /usr/lib/oracle/19.10/client64 for you.WARNING: If these tests fail you may have to set ORACLE_HOME yourself!Installing on a linux, Ver#3.10Using Oracle in /usr/lib/oracle/19.10/client64DEFINE _SQLPLUS_RELEASE = &quot;1910000000&quot; (CHAR)Oracle Version 19.10.0.0 (19.10)Found direct-link candidates: libclntsh.soOracle sysliblist:Found header files in /usr/include/oracle/19.10/client64.Your LD_LIBRARY_PATH env var is set to &#39;/opt/huawei/install/om/lib:/opt/huawei/install/om/script/gspylib/clib:&#39;WARNING: Your LD_LIBRARY_PATH env var doesn&#39;t include &#39;/usr/lib/oracle/19.10/client64/lib&#39; but probably needs to.client_version=19.10DEFINE= -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\&quot;19.10.0.0\&quot; -DORA_OCI_102 -DORA_OCI_112Checking for functioning wait.phSystem: perl5.016003 linux x86-02.bsys.centos.org 3.10.0-957.1.3.el7.x86_64 #1 smp thu nov 29 14:49:43 utc 2018 x86_64 x86_64 x86_64 gnulinuxCompiler:   gcc -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64Linker:     /usr/bin/ldSysliblist:Linking with -lclntsh.Checking if your kit is complete...Looks goodLD_RUN_PATH=/usr/lib/oracle/19.10/client64/libUsing DBD::Oracle 1.80.Using DBD::Oracle 1.80.Multiple copies of Driver.xst found in: /usr/local/lib64/perl5/auto/DBI/ /usr/lib64/perl5/vendor_perl/auto/DBI/ at Makefile.PL line 1807.Using DBI 1.643 (for perl 5.016003 on x86_64-linux-thread-multi) installed in /usr/local/lib64/perl5/auto/DBI/Generating a Unix-style MakefileWriting Makefile for DBD::OracleWriting MYMETA.yml and MYMETA.json

[root@master01 DBD-Oracle-1.80]# make &amp;&amp; make installcp lib/DBD/Oracle/Troubleshooting/Cygwin.pod blib/lib/DBD/Oracle/Troubleshooting/Cygwin.podcp lib/DBD/Oracle.pm blib/lib/DBD/Oracle.pmcp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.hcp lib/DBD/Oracle/Troubleshooting/Vms.pod blib/lib/DBD/Oracle/Troubleshooting/Vms.podcp lib/DBD/Oracle/Troubleshooting/Hpux.pod blib/lib/DBD/Oracle/Troubleshooting/Hpux.podcp lib/DBD/Oracle/Troubleshooting/Linux.pod blib/lib/DBD/Oracle/Troubleshooting/Linux.podcp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pmcp lib/DBD/Oracle/Troubleshooting.pod blib/lib/DBD/Oracle/Troubleshooting.podcp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.hcp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.hcp lib/DBD/Oracle/Troubleshooting/Sun.pod blib/lib/DBD/Oracle/Troubleshooting/Sun.podcp lib/DBD/Oracle/Troubleshooting/Macos.pod blib/lib/DBD/Oracle/Troubleshooting/Macos.podcp lib/DBD/Oracle/Troubleshooting/Aix.pod blib/lib/DBD/Oracle/Troubleshooting/Aix.podcp lib/DBD/Oracle/Object.pm blib/lib/DBD/Oracle/Object.pmcp lib/DBD/Oracle/Troubleshooting/Win64.pod blib/lib/DBD/Oracle/Troubleshooting/Win64.podcp lib/DBD/Oracle/Troubleshooting/Win32.pod blib/lib/DBD/Oracle/Troubleshooting/Win32.podcp mk.pm blib/arch/auto/DBD/Oracle/mk.pmRunning Mkbootstrap for Oracle ()chmod 644 &quot;Oracle.bs&quot;&quot;/usr/bin/perl&quot; -MExtUtils::Command::MM -e &#39;cp_nonempty&#39; -- Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs 644&quot;/usr/bin/perl&quot; -p -e &quot;s/~DRIVER~/Oracle/g&quot; /usr/local/lib64/perl5/auto/DBI/Driver.xst &gt; Oracle.xsi&quot;/usr/bin/perl&quot; &quot;/usr/share/perl5/vendor_perl/ExtUtils/xsubpp&quot;  -typemap &#39;/usr/share/perl5/ExtUtils/typemap&#39; -typemap &#39;/root/DBD-Oracle-1.80/typemap&#39;  Oracle.xs &gt; Oracle.xscmv Oracle.xsc Oracle.cgcc -c  -I/usr/include/oracle/19.10/client64 -I/usr/local/lib64/perl5/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic   -DVERSION=\&quot;1.80\&quot; -DXS_VERSION=\&quot;1.80\&quot; -fPIC &quot;-I/usr/lib64/perl5/CORE&quot;  -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\&quot;19.10.0.0\&quot; -DORA_OCI_102 -DORA_OCI_112 Oracle.cgcc -c  -I/usr/include/oracle/19.10/client64 -I/usr/local/lib64/perl5/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic   -DVERSION=\&quot;1.80\&quot; -DXS_VERSION=\&quot;1.80\&quot; -fPIC &quot;-I/usr/lib64/perl5/CORE&quot;  -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\&quot;19.10.0.0\&quot; -DORA_OCI_102 -DORA_OCI_112 dbdimp.cgcc -c  -I/usr/include/oracle/19.10/client64 -I/usr/local/lib64/perl5/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic   -DVERSION=\&quot;1.80\&quot; -DXS_VERSION=\&quot;1.80\&quot; -fPIC &quot;-I/usr/lib64/perl5/CORE&quot;  -Wall -Wno-comment -DUTF8_SUPPORT -DORA_OCI_VERSION=\&quot;19.10.0.0\&quot; -DORA_OCI_102 -DORA_OCI_112 oci8.crm -f blib/arch/auto/DBD/Oracle/Oracle.soLD_RUN_PATH=&quot;/usr/lib/oracle/19.10/client64/lib&quot; gcc  -shared -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -Wl,-z,relro   Oracle.o dbdimp.o oci8.o  -o blib/arch/auto/DBD/Oracle/Oracle.so  \   -L/usr/lib/oracle/19.10/client64/lib -lclntsh   \chmod 755 blib/arch/auto/DBD/Oracle/Oracle.soManifying 13 pod documents&quot;/usr/bin/perl&quot; -MExtUtils::Command::MM -e &#39;cp_nonempty&#39; -- Oracle.bs blib/arch/auto/DBD/Oracle/Oracle.bs 644Manifying 13 pod documentsFiles found in blib/arch: installing files in blib/lib into architecture dependent library treeInstalling /root/perl5/lib/perl5/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.hInstalling /root/perl5/lib/perl5/x86_64-linux-thread-multi/auto/DBD/Oracle/dbdimp.hInstalling /root/perl5/lib/perl5/x86_64-linux-thread-multi/auto/DBD/Oracle/ocitrace.hInstalling /root/perl5/lib/perl5/x86_64-linux-thread-multi/auto/DBD/Oracle/mk.pmInstalling /root/perl5/lib/perl5/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.soInstalling /root/perl5/lib/perl5/x86_64-linux-thread-multi/DBD/Oracle.pmInstalling /root/perl5/lib/perl5/x86_64-linux-thread-multi/DBD/Oracle/GetInfo.pmInstalling /root/perl5/lib/perl5/x86_64-linux-thread-multi/DBD/Oracle/Troubleshooting.podInstalling /root/perl5/lib/perl5/x86_64-linux-thread-multi/DBD/Oracle/Object.pmInstalling /root/perl5/lib/perl5/x86_64-linux-thread-multi/DBD/Oracle/Troubleshooting/Cygwin.podInstalling /root/perl5/lib/perl5/x86_64-linux-thread-multi/DBD/Oracle/Troubleshooting/Vms.podInstalling /root/perl5/lib/perl5/x86_64-linux-thread-multi/DBD/Oracle/Troubleshooting/Hpux.podInstalling /root/perl5/lib/perl5/x86_64-linux-thread-multi/DBD/Oracle/Troubleshooting/Linux.podInstalling /root/perl5/lib/perl5/x86_64-linux-thread-multi/DBD/Oracle/Troubleshooting/Sun.podInstalling /root/perl5/lib/perl5/x86_64-linux-thread-multi/DBD/Oracle/Troubleshooting/Macos.podInstalling /root/perl5/lib/perl5/x86_64-linux-thread-multi/DBD/Oracle/Troubleshooting/Aix.podInstalling /root/perl5/lib/perl5/x86_64-linux-thread-multi/DBD/Oracle/Troubleshooting/Win64.podInstalling /root/perl5/lib/perl5/x86_64-linux-thread-multi/DBD/Oracle/Troubleshooting/Win32.podInstalling /root/perl5/man/man3/DBD::Oracle.3pmInstalling /root/perl5/man/man3/DBD::Oracle::GetInfo.3pmInstalling /root/perl5/man/man3/DBD::Oracle::Object.3pmInstalling /root/perl5/man/man3/DBD::Oracle::Troubleshooting.3pmInstalling /root/perl5/man/man3/DBD::Oracle::Troubleshooting::Aix.3pmInstalling /root/perl5/man/man3/DBD::Oracle::Troubleshooting::Cygwin.3pmInstalling /root/perl5/man/man3/DBD::Oracle::Troubleshooting::Hpux.3pmInstalling /root/perl5/man/man3/DBD::Oracle::Troubleshooting::Linux.3pmInstalling /root/perl5/man/man3/DBD::Oracle::Troubleshooting::Macos.3pmInstalling /root/perl5/man/man3/DBD::Oracle::Troubleshooting::Sun.3pmInstalling /root/perl5/man/man3/DBD::Oracle::Troubleshooting::Vms.3pmInstalling /root/perl5/man/man3/DBD::Oracle::Troubleshooting::Win32.3pmInstalling /root/perl5/man/man3/DBD::Oracle::Troubleshooting::Win64.3pmAppending installation info to /root/perl5/lib/perl5/x86_64-linux-thread-multi/perllocal.pod[root@master01 DBD-Oracle-1.80]#

2.3 安装ora2op

解压

[root@master01 ora2op]# unzip openGauss-tools-ora2og-master.zipArchive:  openGauss-tools-ora2og-master.zip8a98a77d57b32b836c86f82095615732d3636cc7   creating: openGauss-tools-ora2og-master/ extracting: openGauss-tools-ora2og-master/INSTALL  inflating: openGauss-tools-ora2og-master/LICENSE  inflating: openGauss-tools-ora2og-master/MANIFEST  inflating: openGauss-tools-ora2og-master/Makefile.PL  inflating: openGauss-tools-ora2og-master/README  inflating: openGauss-tools-ora2og-master/README.en.md  inflating: openGauss-tools-ora2og-master/README.md  inflating: openGauss-tools-ora2og-master/changelog   creating: openGauss-tools-ora2og-master/doc/  inflating: openGauss-tools-ora2og-master/doc/Ora2Pg.pod  inflating: openGauss-tools-ora2og-master/doc/ora2pg.3   creating: openGauss-tools-ora2og-master/lib/  inflating: openGauss-tools-ora2og-master/lib/Ora2Pg.pm   creating: openGauss-tools-ora2og-master/lib/Ora2Pg/  inflating: openGauss-tools-ora2og-master/lib/Ora2Pg/GEOM.pm  inflating: openGauss-tools-ora2og-master/lib/Ora2Pg/MySQL.pm  inflating: openGauss-tools-ora2og-master/lib/Ora2Pg/PLSQL.pm   creating: openGauss-tools-ora2og-master/packaging/  inflating: openGauss-tools-ora2og-master/packaging/README   creating: openGauss-tools-ora2og-master/packaging/RPM/  inflating: openGauss-tools-ora2og-master/packaging/RPM/ora2pg.spec   creating: openGauss-tools-ora2og-master/packaging/debian/  inflating: openGauss-tools-ora2og-master/packaging/debian/create-deb-tree.sh   creating: openGauss-tools-ora2og-master/packaging/debian/ora2pg/   creating: openGauss-tools-ora2og-master/packaging/debian/ora2pg/DEBIAN/  inflating: openGauss-tools-ora2og-master/packaging/debian/ora2pg/DEBIAN/control  inflating: openGauss-tools-ora2og-master/packaging/debian/ora2pg/DEBIAN/copyright   creating: openGauss-tools-ora2og-master/packaging/slackbuild/  inflating: openGauss-tools-ora2og-master/packaging/slackbuild/Ora2Pg.SlackBuild  inflating: openGauss-tools-ora2og-master/packaging/slackbuild/Ora2Pg.info  inflating: openGauss-tools-ora2og-master/packaging/slackbuild/README extracting: openGauss-tools-ora2og-master/packaging/slackbuild/doinst.sh  inflating: openGauss-tools-ora2og-master/packaging/slackbuild/slack-desc   creating: openGauss-tools-ora2og-master/scripts/  inflating: openGauss-tools-ora2og-master/scripts/ora2pg  inflating: openGauss-tools-ora2og-master/scripts/ora2pg_scanner[root@master01 ora2op]#

进入解压目录

cd openGauss-tools-ora2og-master/

开始编译安装

[root@master01 openGauss-tools-ora2og-master]# perl Makefile.PLChecking if your kit is complete...Looks goodInvalid LICENSE value &#39;GPLv3&#39; ignoredGenerating a Unix-style MakefileWriting Makefile for Ora2PgInvalid LICENSE value &#39;GPLv3&#39; ignoredWriting MYMETA.yml and MYMETA.jsonDone...------------------------------------------------------------------------------Please read documentation at http://ora2pg.darold.net/ before asking for help------------------------------------------------------------------------------Now type: make &amp;&amp; make install

编译并安装

[root@master01 openGauss-tools-ora2og-master]# make &amp;&amp; make installcp lib/Ora2Pg/GEOM.pm blib/lib/Ora2Pg/GEOM.pmcp lib/Ora2Pg.pm blib/lib/Ora2Pg.pmcp lib/Ora2Pg/PLSQL.pm blib/lib/Ora2Pg/PLSQL.pmcp lib/Ora2Pg/MySQL.pm blib/lib/Ora2Pg/MySQL.pmcp scripts/ora2pg blib/script/ora2pg&quot;/usr/bin/perl&quot; -MExtUtils::MY -e &#39;MY-&gt;fixin(shift)&#39; -- blib/script/ora2pgcp scripts/ora2pg_scanner blib/script/ora2pg_scanner&quot;/usr/bin/perl&quot; -MExtUtils::MY -e &#39;MY-&gt;fixin(shift)&#39; -- blib/script/ora2pg_scannerManifying 1 pod documentManifying 1 pod documentInstalling /root/perl5/lib/perl5/Ora2Pg.pmInstalling /root/perl5/lib/perl5/Ora2Pg/GEOM.pmInstalling /root/perl5/lib/perl5/Ora2Pg/PLSQL.pmInstalling /root/perl5/lib/perl5/Ora2Pg/MySQL.pmInstalling /root/perl5/man/man3/ora2pg.3Installing /root/perl5/bin/ora2pgInstalling /root/perl5/bin/ora2pg_scannerInstalling default configuration file (ora2pg.conf.dist) to /etc/ora2pgAppending installation info to /root/perl5/lib/perl5/x86_64-linux-thread-multi/perllocal.pod[root@master01 openGauss-tools-ora2og-master]#

2.4 安装连接openGauss数据库的模块

wget -c https://cpan.metacpan.org/authors/id/T/TU/TURNSTEP/DBD-Pg-3.14.2.tar.gzgunzip DBD-Pg-3.14.2.tar.gztar -xvf DBD-Pg-3.14.2.tarcd DBD-Pg-3.14.2/vi .bash_profileexport ORACLE_HOME=/usr/lib/oracle/19.10/client64export GAUSSHOME=/opt/huawei/install/appexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:$GAUSSHOME/lib:$LD_LIBRARY_PATHexport PATH=$ORACLE_HOME/bin:$GAUSSHOME/bin:$PATHsource .bash_profileperl Makefile.PLyum install /usr/include/libpq-fe.hmake &amp;&amp; make install

[root@master01 DBD-Pg-3.14.2]# perl Makefile.PLConfiguring DBD::Pg 3.14.2PostgreSQL version: 90204 (default port: 5432)POSTGRES_HOME: (not set)POSTGRES_INCLUDE: /opt/huawei/install/app/includePOSTGRES_LIB: /opt/huawei/install/app/libOS: linuxMultiple copies of Driver.xst found in: /usr/local/lib64/perl5/auto/DBI/ /usr/li                                                                                                                              b64/perl5/vendor_perl/auto/DBI/ at Makefile.PL line 182.Checking if your kit is complete...Looks goodMultiple copies of Driver.xst found in: /usr/local/lib64/perl5/auto/DBI/ /usr/li                                                                                                                              b64/perl5/vendor_perl/auto/DBI/ at Makefile.PL line 284.Using DBI 1.643 (for perl 5.016003 on x86_64-linux-thread-multi) installed in /u                                                                                                                              sr/local/lib64/perl5/auto/DBI/Generating a Unix-style MakefileWriting Makefile for DBD::PgWriting MYMETA.yml and MYMETA.json

[root@master01 DBD-Pg-3.14.2]# makeSkip blib/lib/Bundle/DBD/Pg.pm (unchanged)Skip blib/lib/DBD/Pg.pm (unchanged)Running Mkbootstrap for Pg ()chmod 644 &quot;Pg.bs&quot;&quot;/usr/bin/perl&quot; -MExtUtils::Command::MM -e &#39;cp_nonempty&#39; -- Pg.bs blib/arch/auto/DBD/Pg/Pg.bs 644gcc -c  -I/opt/huawei/install/app/include -I/usr/local/lib64/perl5/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPGLIBVERSION=90204 -DPGDEFPORT=5432 -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic  -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\&quot;3.14.2\&quot; -DXS_VERSION=\&quot;3.14.2\&quot; -fPIC &quot;-I/usr/lib64/perl5/CORE&quot;   Pg.cgcc -c  -I/opt/huawei/install/app/include -I/usr/local/lib64/perl5/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPGLIBVERSION=90204 -DPGDEFPORT=5432 -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic  -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\&quot;3.14.2\&quot; -DXS_VERSION=\&quot;3.14.2\&quot; -fPIC &quot;-I/usr/lib64/perl5/CORE&quot;   dbdimp.cgcc -c  -I/opt/huawei/install/app/include -I/usr/local/lib64/perl5/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPGLIBVERSION=90204 -DPGDEFPORT=5432 -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic  -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\&quot;3.14.2\&quot; -DXS_VERSION=\&quot;3.14.2\&quot; -fPIC &quot;-I/usr/lib64/perl5/CORE&quot;   quote.cIn file included from Pg.h:58:0,                 from quote.c:10:/usr/local/lib64/perl5/auto/DBI/DBIXS.h:493:25: warning: ‘dbi_get_state’ defined but not used [-Wunused-function]     static dbistate_t** dbi_get_state(pTHX) {                               \                         ^/usr/local/lib64/perl5/auto/DBI/DBIXS.h:506:27: note: in expansion of macro ‘_DBISTATE_DECLARE_COMMON’ # define DBISTATE_DECLARE _DBISTATE_DECLARE_COMMON                           ^Pg.h:64:1: note: in expansion of macro ‘DBISTATE_DECLARE’ DBISTATE_DECLARE; ^gcc -c  -I/opt/huawei/install/app/include -I/usr/local/lib64/perl5/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPGLIBVERSION=90204 -DPGDEFPORT=5432 -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic  -DPERL_EXTMALLOC_DEF -Dmalloc=Perl_malloc -Dfree=Perl_mfree -Drealloc=Perl_realloc -Dcalloc=Perl_calloc -DVERSION=\&quot;3.14.2\&quot; -DXS_VERSION=\&quot;3.14.2\&quot; -fPIC &quot;-I/usr/lib64/perl5/CORE&quot;   types.cIn file included from Pg.h:58:0,                 from types.c:15:/usr/local/lib64/perl5/auto/DBI/DBIXS.h:493:25: warning: ‘dbi_get_state’ defined but not used [-Wunused-function]     static dbistate_t** dbi_get_state(pTHX) {                               \                         ^/usr/local/lib64/perl5/auto/DBI/DBIXS.h:506:27: note: in expansion of macro ‘_DBISTATE_DECLARE_COMMON’ # define DBISTATE_DECLARE _DBISTATE_DECLARE_COMMON                           ^Pg.h:64:1: note: in expansion of macro ‘DBISTATE_DECLARE’ DBISTATE_DECLARE; ^rm -f blib/arch/auto/DBD/Pg/Pg.soLD_RUN_PATH=&quot;/opt/huawei/install/app/lib&quot; gcc  -shared -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector-strong --param=ssp-buffer-size=4 -grecord-gcc-switches -m64 -mtune=generic -Wl,-z,relro   Pg.o dbdimp.o quote.o types.o  -o blib/arch/auto/DBD/Pg/Pg.so  \   -L/opt/huawei/install/app/lib -lpq -lm   \chmod 755 blib/arch/auto/DBD/Pg/Pg.soManifying 2 pod documents[root@master01 DBD-Pg-3.14.2]# make install&quot;/usr/bin/perl&quot; -MExtUtils::Command::MM -e &#39;cp_nonempty&#39; -- Pg.bs blib/arch/auto/DBD/Pg/Pg.bs 644Manifying 2 pod documentsFiles found in blib/arch: installing files in blib/lib into architecture dependent library treeInstalling /root/perl5/lib/perl5/x86_64-linux-thread-multi/auto/DBD/Pg/Pg.soInstalling /root/perl5/lib/perl5/x86_64-linux-thread-multi/DBD/Pg.pmInstalling /root/perl5/lib/perl5/x86_64-linux-thread-multi/Bundle/DBD/Pg.pmInstalling /root/perl5/man/man3/DBD::Pg.3pmInstalling /root/perl5/man/man3/Bundle::DBD::Pg.3pmAppending installation info to /root/perl5/lib/perl5/x86_64-linux-thread-multi/perllocal.pod[root@master01 DBD-Pg-3.14.2]#

至此，ora2op安装成功，接下来我们便可以创建迁移项目，进行数据库迁移。