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

Source: Internet
Author: User
Tags odbc win32

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.