介質下載路徑：

成都創新互聯-專業網站定制、快速模板網站建設、高性價比寧強網站開發、企業建站全套包干低至880元,成熟完善的模板庫,直接使用。一站式寧強網站制作公司更省心,省錢,快速模板網站建設找我們，業務覆蓋寧強地區。費用合理售后完善，十年實體公司更值得信賴。

DBI:http://www.cpan.org/modules/by-module/DBI/

DBD:http://www.cpan.org/modules/by-module/DBD/

Ora2Pg:https://sourceforge.net/projects/ora2pg/files/

要求：perl 版本5.8以上， perl -v查看版本

使用root用戶進行安裝

1、安裝DBI

    [root@rhel6 DBI-1.627]$ perl Makefile.PL

    

    *** Your LANG environment variable is set to 'en_US.UTF-8'

    *** This may cause problems for some perl installations.

    *** If you get test failures, please try again with LANG unset.

    *** If that then works, please email [email protected] with details

    *** including the output of 'perl -V'

    

    Your perl was compiled with gcc (version 4.4.7 20120313 (Red Hat 4.4.7-14)), okay.

    Creating test wrappers for DBD::Gofer:

    t/zvg_01basics.t

    t/zvg_02dbidrv.t

    t/zvg_03handle.t

    t/zvg_04mods.t

    t/zvg_05concathash.t

    t/zvg_06attrs.t

    ......

    [root@rhel6 DBI-1.627]$ make

    /usr/bin/perl -MExtUtils::Command -e 'mkpath' -- blib/lib/DBI

    rm -f blib/lib/DBI/Changes.pm

    cp Changes blib/lib/DBI/Changes.pm

    cp Driver_xst.h blib/arch/auto/DBI/Driver_xst.h

    cp lib/DBD/Proxy.pm blib/lib/DBD/Proxy.pm

    cp lib/DBI/Gofer/Response.pm blib/lib/DBI/Gofer/Response.pm

    cp lib/DBI/Util/_accessor.pm blib/lib/DBI/Util/_accessor.pm

    cp lib/DBI/Gofer/Transport/Base.pm blib/lib/DBI/Gofer/Transport/Base.pm

    cp lib/DBD/DBM.pm blib/lib/DBD/DBM.pm

    cp DBIXS.h blib/arch/auto/DBI/DBIXS.h

    cp dbixs_rev.pl blib/lib/dbixs_rev.pl

    cp lib/DBI/Gofer/Serializer/DataDumper.pm blib/lib/DBI/Gofer/Serializer/DataDumper.pm

    cp lib/DBI/Const/GetInfoType.pm blib/lib/DBI/Const/GetInfoType.pm

    cp lib/DBI/DBD/Metadata.pm blib/lib/DBI/DBD/Metadata.pm

    cp lib/DBD/Gofer/Transport/pipeone.pm blib/lib/DBD/Gofer/Transport/pipeone.pm

    cp lib/DBI/Const/GetInfo/ODBC.pm blib/lib/DBI/Const/GetInfo/ODBC.pm

    cp lib/DBI/ProfileDumper/Apache.pm blib/lib/DBI/ProfileDumper/Apache.pm

    cp lib/DBD/File/Roadmap.pod blib/lib/DBD/File/Roadmap.pod

    ......

    [oracle@rhel6 DBI-1.627]$ make test(可選)

    PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t

    t/01basics.t .................... ok

    t/02dbidrv.t .................... ok

    t/03handle.t .................... ok

    t/04mods.t ...................... ok

    t/05concathash.t ................ ok

    t/06attrs.t ..................... ok

    t/07kids.t ...................... ok

    [root@rhel6 DBI-1.627]# make install

    Files found in blib/arch: installing files in blib/lib into architecture dependent library tree

    Installing /usr/local/lib64/perl5/auto/DBI/DBI.bs

    Installing /usr/local/lib64/perl5/auto/DBI/dbixs_rev.h

    Installing /usr/local/lib64/perl5/auto/DBI/dbivport.h

    Installing /usr/local/lib64/perl5/auto/DBI/DBIXS.h

    Installing /usr/local/lib64/perl5/auto/DBI/DBI.so

    Installing /usr/local/lib64/perl5/auto/DBI/dbipport.h

    Installing /usr/local/lib64/perl5/auto/DBI/dbi_sql.h

    Installing /usr/local/lib64/perl5/auto/DBI/dbd_xsh.h

    Installing /usr/local/lib64/perl5/auto/DBI/Driver_xst.h

    Installing /usr/local/lib64/perl5/auto/DBI/Driver.xst

    Installing /usr/local/lib64/perl5/dbixs_rev.pl

    ......

2、安裝DBD:Oracle

    配置環境變量

    export ORACLE_BASE=/u02/app/oracle

    export ORACLE_HOME=$ORACLE_BASE/product/11.2.4/db1

    export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

    安裝

    [root@rhel6 DBD-Oracle-1.74]# perl Makefile.PL

    Multiple copies of Driver.xst found in: /usr/local/lib64/perl5/auto/DBI/ /usr/lib64/perl5/auto/DBI/ at Makefile.PL line 39

    Using DBI 1.627 (for perl 5.010001 on x86_64-linux-thread-multi) installed in /usr/local/lib64/perl5/auto/DBI/

    

    Configuring DBD::Oracle for perl 5.010001 on linux (x86_64-linux-thread-multi)

    

    Remember to actually *READ* the README file! Especially if you have any problems.

    

    Installing on a linux, Ver#2.6

    Using Oracle in /u02/app/oracle/product/11.2.4/db1

    DEFINE _SQLPLUS_RELEASE = "1102000400" (CHAR)

    Oracle version 11.2.0.4 (11.2)

    Found /u02/app/oracle/product/11.2.4/db1/rdbms/lib/ins_rdbms.mk

    Using /u02/app/oracle/product/11.2.4/db1/rdbms/lib/ins_rdbms.mk

    Your LD_LIBRARY_PATH env var is set to '/u02/app/oracle/product/11.2.4/db1/lib:'

    ......

    [root@rhel6 DBD-Oracle-1.74]# make

    cp lib/DBD/Oracle/Troubleshooting/Cygwin.pod blib/lib/DBD/Oracle/Troubleshooting/Cygwin.pod

    cp lib/DBD/Oracle.pm blib/lib/DBD/Oracle.pm

    cp Oracle.h blib/arch/auto/DBD/Oracle/Oracle.h

    cp lib/DBD/Oracle/Troubleshooting/Hpux.pod blib/lib/DBD/Oracle/Troubleshooting/Hpux.pod

    cp lib/DBD/Oracle/Troubleshooting/Vms.pod blib/lib/DBD/Oracle/Troubleshooting/Vms.pod

    cp lib/DBD/Oracle/Troubleshooting/Linux.pod blib/lib/DBD/Oracle/Troubleshooting/Linux.pod

    cp lib/DBD/Oracle/GetInfo.pm blib/lib/DBD/Oracle/GetInfo.pm

    cp lib/DBD/Oracle/Troubleshooting.pod blib/lib/DBD/Oracle/Troubleshooting.pod

    cp dbdimp.h blib/arch/auto/DBD/Oracle/dbdimp.h

    cp ocitrace.h blib/arch/auto/DBD/Oracle/ocitrace.h

    cp lib/DBD/Oracle/Troubleshooting/Sun.pod blib/lib/DBD/Oracle/Troubleshooting/Sun.pod

    cp lib/DBD/Oracle/Troubleshooting/Macos.pod blib/lib/DBD/Oracle/Troubleshooting/Macos.pod

    cp lib/DBD/Oracle/Troubleshooting/Aix.pod blib/lib/DBD/Oracle/Troubleshooting/Aix.pod

    cp lib/DBD/Oracle/Object.pm blib/lib/DBD/Oracle/Object.pm

    cp lib/DBD/Oracle/Troubleshooting/Win64.pod blib/lib/DBD/Oracle/Troubleshooting/Win64.pod

    cp lib/DBD/Oracle/Troubleshooting/Win32.pod blib/lib/DBD/Oracle/Troubleshooting/Win32.pod

    cp mk.pm blib/arch/auto/DBD/Oracle/mk.pm

    ......

    [root@rhel6 DBD-Oracle-1.74]# make test(可選)

    PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t

    t/000-report-versions-tiny.t .. #

    #

    # Generated by Dist::Zilla::Plugin::ReportVersions::Tiny v1.10

    # perl: 5.010001 (wanted 5.006) on linux from /usr/bin/perl

    #

    # B                       => 1.22    (want any version)

    # Carp                      => 1.11    (want any version)

    # DBI                      => 1.627    (want 1.51)

    ......

    [root@rhel6 DBD-Oracle-1.74]# make install

    Files found in blib/arch: installing files in blib/lib into architecture dependent library tree

    Installing /usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.h

    Installing /usr/local/lib64/perl5/auto/DBD/Oracle/dbdimp.h

    Installing /usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.bs

    Installing /usr/local/lib64/perl5/auto/DBD/Oracle/mk.pm

    Installing /usr/local/lib64/perl5/auto/DBD/Oracle/Oracle.so

    Installing /usr/local/lib64/perl5/auto/DBD/Oracle/ocitrace.h

    Installing /usr/local/lib64/perl5/DBD/Oracle.pm

    Installing /usr/local/lib64/perl5/DBD/Oracle/GetInfo.pm

    Installing /usr/local/lib64/perl5/DBD/Oracle/Object.pm

    Installing /usr/local/lib64/perl5/DBD/Oracle/Troubleshooting.pod

    Installing /usr/local/lib64/perl5/DBD/Oracle/Troubleshooting/Win64.pod

    Installing /usr/local/lib64/perl5/DBD/Oracle/Troubleshooting/Sun.pod

    Installing /usr/local/lib64/perl5/DBD/Oracle/Troubleshooting/Win32.pod

    Installing /usr/local/lib64/perl5/DBD/Oracle/Troubleshooting/Hpux.pod

    ......

3、檢查腳本list.pl

[root@rhel6 ~]# cat list.pl  #!/usr/bin/perl use strict; use ExtUtils::Installed; my $inst= ExtUtils::Installed->new(); my @modules = $inst->modules(); foreach(@modules) {         my $ver = $inst->version($_) || "???";         printf("%-12s --  %s\n", $_, $ver);   } exit; [root@rhel6 ~]# perl list.pl  DBD::Oracle  --  1.74 DBI          --  1.627 Perl         --  5.10.1

  DBD::Oracle和DBI安裝完成

4、安裝ora2pt

    [root@rhel6 ora2pg-17.6]$ 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

    [root@rhel6 ora2pg-17.6]# make && make install

    Installing /usr/local/share/perl5/Ora2Pg.pm

    Installing /usr/local/share/perl5/Ora2Pg/PLSQL.pm

    Installing /usr/local/share/perl5/Ora2Pg/MySQL.pm

    Installing /usr/local/share/perl5/Ora2Pg/GEOM.pm

    Installing /usr/local/share/man/man3/ora2pg.3

    Installing /usr/local/bin/ora2pg

    Installing /usr/local/bin/ora2pg_scanner

    Installing default configuration file (ora2pg.conf.dist) to /etc/ora2pg

    Appending installation info to /usr/lib64/perl5/perllocal.pod

檢查,DBD::Oracle DBI Ora2Pg安裝完成

    [root@rhel6 ~]# perl list.pl

    DBD::Oracle  --  1.74

    DBI      --  1.627

    Ora2Pg    --  17.6b

    Perl     --  5.10.1

使用Ora2Pg從Oracle導數據到PostgreSQL參考：http://hbxztc.blog.51cto.com/1587495/1880339

參考文檔：

http://www.askoracle.org/oracle/backup/1009.html

http://blog.sina.com.cn/s/blog_a32eff280102vmpn.html

另外有需要云服務器可以了解下創新互聯cdcxhl.cn，海內外云服務器15元起步，三天無理由+7*72小時售后在線，公司持有idc許可證，提供“云服務器、裸金屬服務器、高防服務器、香港服務器、美國服務器、虛擬主機、免備案服務器”等云主機租用服務以及企業上云的綜合解決方案，具有“安全穩定、簡單易用、服務可用性高、性價比高”等特點與優勢，專為企業上云打造定制，能夠滿足用戶豐富、多元化的應用場景需求。

網站欄目：Linux下安裝DBD::Oracle、DBI和Ora2Pg-創新互聯
分享URL：http://www.2m8n56k.cn/article0/pcgio.html

成都網站建設公司_創新互聯，為您提供定制網站、網站排名、微信公眾號、品牌網站設計、Google、移動網站建設

廣告

聲明：本網站發布的內容（圖片、視頻和文字）以用戶投稿、用戶轉載內容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網站立場，如需處理請聯系客服。電話：028-86922220；郵箱：[email protected]。內容未經允許不得轉載，或轉載時需注明來源： 創新互聯