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