linux 安装org2pg_ora2pg安装及卸载

--ora2pg安装

tar xzf ora2pg-10.x.tar.gz

or

tar xjf ora2pg-10.x.tar.bz2

cd ora2pg-10.x/

perl Makefile.PL

make && make install

--ora2pg卸载

rm -rf /usr/bin/ora2pg

rm -rf /usr/lib/perl5/site_perl/5.8.8/Ora2Pg.pm

rm -rf /usr/lib/perl5/site_perl/5.8.8/Ora2Pg/PLSQL.pm

rm -rf /usr/share/man/man3/ora2pg.3

rm -rf /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/Ora2Pg/.packlist

--安装DBD::oracle

export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib

export ORACLE_HOME=/usr/lib/oracle/11.2/client64/

perl -MCPAN -e 'install DBD::Oracle'

or

--DBI模块的安装

# tar xvzf DBI-1.617.tar.gz

# cd DBI-1.617

# vi README

# perl Makefile.PL

# make

# make test

# make install

--DBD::Oracle::模块的安装

--安装DBD::Oracle模块前要先安装oracle example

--设置环境变量

# export ORACLE_HOME=/u01/app/oracle/product/10.2.0

# export ORACLE_USERID='test/test@ora10g'

# export PATH=$ORACLE_HOME/bin:$PATH

# export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

--安装DBD::Oracle模块

# tar xzvf DBD-Oracle-1.38.tar.gz

# cd DBD-Oracle-1.38

# perl Makefile.PL

# make

# make test

# make install