数据库生态圈(RDB & NoSQL & Bigdata)——专注于关系库优化(Oracle & Mysql & Postgresql & SQL Server )

https://www.cnblogs.com/lhdz_bj
http://blog.itpub.net/8484829
https://blog.csdn.net/tuning_optmization
https://www.zhihu.com/people/lhdz_bj

导航

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

posted on 2018-04-10 13:25  lhdz_bj  阅读(552)  评论(0编辑  收藏  举报