Shulou(Shulou.com)06/01 Report--

Media download path:

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/

Requirements: perl version 5.8 or above, perl-v view version

Use root users for installation

1. Install 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 dbi-dev@perl.org 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 (optional)

PERL_DL_NONLAZY=1 / usr/bin/perl "- MExtUtils::Command::MM"-e "" test_harness (0, 'blib/lib',' blib/arch') "t _ Universe. 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. Install DBD:Oracle

Configure environment variables

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

Installation

[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'/ u02Gap appActionoracleUniverse produce 11.2.4Uniplex db1OnLIBRAPR'

.

[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 (optional)

PERL_DL_NONLAZY=1 / usr/bin/perl "- MExtUtils::Command::MM"-e "" test_harness (0, 'blib/lib',' blib/arch') "t _ Universe. 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. Check the script list.pl

[root@rhel6 ~] # cat list.pl #! / usr/bin/perluse 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.74DBI-- 1.627Perl-- 5.10.1

DBD::Oracle and DBI installation complete

4. Install 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

Check, DBD::Oracle DBI Ora2Pg installation is complete

[root@rhel6 ~] # perl list.pl

DBD::Oracle-1.74

DBI-1.627

Ora2Pg-17.6b

Perl-5.10.1

Use Ora2Pg to import data from Oracle to PostgreSQL reference: http://hbxztc.blog.51cto.com/1587495/1880339

Reference documentation:

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

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.