Install Dbd::oracle, DBI, and ORA2PG under Linux

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 higher, perl-v view version

Install using the root user

1. Installing DBI

[Email protected] dbi-1.627]$ perl makefile.pl

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

This could cause problems for some Perl installations.

If you get the 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 is 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

......

[[email protected] 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

......

[[email protected] 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/*.t

T/01BASICS.T .... Ok.------No.

t/02dbidrv.t .... Ok.------No.

t/03handle.t .... Ok.------No.

T/04MODS.T .... Ok.-------No.

t/05concathash.t .... OK, no, no, no.

T/06ATTRS.T .... Ok.-------No.

T/07KIDS.T .... Ok.-------No.

[[email protected] 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, Installation Dbd:oracle

Configuring 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

[Email protected] 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 had 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: '

......

[[email protected] 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

......

[[email protected] 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/*.t

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

#

# Generated by Dist::zilla::P lugin::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)

......

[[email protected] 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 Script list.pl

[email protected] ~]# 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; [[Email protected] ~]# perl list.pl dbd::oracle--1.74DBI--1.627Perl--5.10.1

Dbd::oracle and DBI Installation complete

4, Installation ora2pt

[Email protected] 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

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

Now Type:make && make install

[[email protected] 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 Complete

[Email protected] ~]# Perl list.pl

dbd::oracle--1.74

DBI--1.627

ORA2PG--17.6b

Perl--5.10.1

Reference Documentation:

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

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

This article is from the "DBA fighting!" blog, so be sure to keep this source http://hbxztc.blog.51cto.com/1587495/1879227

Install Dbd::oracle, DBI, and ORA2PG under Linux