blocks|key|2872017|text|如果缺少ExtUtils-MakeMaker模块，则安装Perl+DBI模块，安装低于3+RPM+($+yum+install+perl-DBI)|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2872018|Manually+|unordered-list-item|2872019|+instant+client+(来自Instant+Client+Downloads+for+Linux+x86-64。示例用于v11.2.0.3.0-1:将以下命令改写为实际版本。)|2872020|2872021|2872022|oracle-即时客户端11.2-basic-11.2.0.3.0-1+oracle-即时客户端11.2-devel+11.2.0.3.0-1+oracle-instantclient11.2-sqlplus-11.2.0.3.0-1|2872023|我使用的是64位Linux+box，因此请相应地选择您的RPM文件名。像sudo+yum+-y+install+oracle-instantclient*rpm应该做的事情)|2872024|2872025|设置在变量下面：|2872026|2872027|导出LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib导出ORACLE_HOME=/usr/lib/oracle/11.2/client64|2872028|MacOS用户需要：|2872029|DYLD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/|2872030|另外，从CPAN|2872031|untar模块将ORACLE_HOME添加到PATH+PATH+DBD::Oracle中，并按给定的顺序运行以下命令：|BOLD|2872032|2872033|perl+Makefile.PL+make+sudo+make+install|2872034|如果您收到关于缺少gcc的投诉，您可以(临时)安装它，然后将其删除。|2872035|完成！|2872036|我遇到的问题是由于错误的LD_LIBRARY_PATH造成的。我将其设置为/usr/lib/oracle/11.2/client64，而正确的值是/usr/lib/oracle/11.2/client64/lib。|2872037|当然，对于像我这样的新手来说，这是一次很好的学习。|2872038|entityMap|0|LINK|mutability|MUTABLE|url|http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html|1|http://search.cpan.org/^0|1E|M|0|0|J|15|0|0|0|0|0|10|18|0|0|0|0|0|0|0|4|4|1|0|8|B|M|4|R|4|W|B|0|0|0|0|0|C|F|11|T|21|X|0|0^^$0|@$1|2|3|4|5|6|7|1Q|8|@$9|1R|A|1S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|1T|8|@]|D|@]|E|$]]|$1|I|3|J|5|H|7|1U|8|@]|D|@$9|1V|A|1W|1|1X]]|E|$]]|$1|K|3|-4|5|6|7|1Y|8|@]|D|@]|E|$]]|$1|L|3|-4|5|6|7|1Z|8|@]|D|@]|E|$]]|$1|M|3|N|5|6|7|20|8|@]|D|@]|E|$]]|$1|O|3|P|5|6|7|21|8|@$9|22|A|23|B|C]]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|24|8|@]|D|@]|E|$]]|$1|R|3|S|5|H|7|25|8|@]|D|@]|E|$]]|$1|T|3|-4|5|6|7|26|8|@]|D|@]|E|$]]|$1|U|3|V|5|6|7|27|8|@]|D|@]|E|$]]|$1|W|3|X|5|6|7|28|8|@]|D|@]|E|$]]|$1|Y|3|Z|5|6|7|29|8|@]|D|@]|E|$]]|$1|10|3|11|5|6|7|2A|8|@]|D|@$9|2B|A|2C|1|2D]]|E|$]]|$1|12|3|13|5|H|7|2E|8|@$9|2F|A|2G|B|C]|$9|2H|A|2I|B|C]|$9|2J|A|2K|B|C]|$9|2L|A|2M|B|14]]|D|@]|E|$]]|$1|15|3|-4|5|6|7|2N|8|@]|D|@]|E|$]]|$1|16|3|17|5|6|7|2O|8|@]|D|@]|E|$]]|$1|18|3|19|5|6|7|2P|8|@]|D|@]|E|$]]|$1|1A|3|1B|5|6|7|2Q|8|@]|D|@]|E|$]]|$1|1C|3|1D|5|6|7|2R|8|@$9|2S|A|2T|B|C]|$9|2U|A|2V|B|C]|$9|2W|A|2X|B|C]]|D|@]|E|$]]|$1|1E|3|1F|5|6|7|2Y|8|@]|D|@]|E|$]]|$1|1G|3|-4|5|6|7|2Z|8|@]|D|@]|E|$]]]|1H|$1I|$5|1J|1K|1L|E|$1M|1N]]|1O|$5|1J|1K|1L|E|$1M|1P]]]]

<ul>
<li>Install if missing ExtUtils-MakeMaker module (<code>sudo yum install perl-ExtUtils-MakeMaker</code>)</li>
<li>Install Perl DBI module (<code>$ yum install perl-DBI</code>)</li>
<li>Manually install below three RPMs for Oracle instant client (from <a href="http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html" rel="noreferrer">Instant Client Downloads for Linux x86-64</a>. The example is for v11.2.0.3.0-1: adapt the commands below to the actual version.)

<pre><code>oracle-instantclient11.2-basic-11.2.0.3.0-1
oracle-instantclient11.2-devel-11.2.0.3.0-1
oracle-instantclient11.2-sqlplus-11.2.0.3.0-1
</code></pre></li>
</ul>

I am using 64 bit Linux box, so select your RPM filenames accordingly. Something like <code>sudo yum -y install oracle-instantclient*rpm</code> should do)

<ul>
<li>set below variables:

<pre><code>export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib
export ORACLE_HOME=/usr/lib/oracle/11.2/client64
</code></pre>

MacOS users will need:

<pre><code>DYLD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/
</code></pre>

Also add <code>ORACLE_HOME</code> to your <code>PATH</code> variable.</li>
<li>download DBD::Oracle from <a href="http://search.cpan.org/" rel="noreferrer">CPAN</a></li>
<li>untar the module and run below commands in given sequence:

<pre><code>perl Makefile.PL
make
sudo make install
</code></pre></li>
</ul>

In case you get complaints about missing gcc you can (temporarily) install it and then remove it.

DONE !!!

Issues I had faced were due to the wrong <code>LD_LIBRARY_PATH</code>. I had set it to <code>/usr/lib/oracle/11.2/client64</code> whereas the correct value is <code>/usr/lib/oracle/11.2/client64/lib</code>.

Certainly, this was a great learning for a newbie like me.

blocks|key|218812|text|您还可以阅读我的文章How+to+install+DBD::Oracle，其中包含安装DBD::Oracle+CPAN模块所需的所有步骤，这不是一个简单的安装。这样做的目的是减少头痛，并将其转变为可重复的过程。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|218813|entityMap|0|LINK|mutability|MUTABLE|url|http://g14n.info/2013/07/how-to-install-dbdoracle^0|A|Q|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

you can also read my article <a href="http://g14n.info/2013/07/how-to-install-dbdoracle" rel="noreferrer">How to install DBD::Oracle</a> which contains all the steps required to install DBD::Oracle CPAN module, which is not a straightforward installation. The purpose is to reduce headache and turn it into a repeatable process.

blocks|key|3085927|text|对slayedbylucifer的回答有一点补充。我遇到了与问题中提到的相同的问题。我已经完成了slayedbylucifer所描述的所有步骤。但是我还是遇到了像前面提到的here这样的问题|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3085928|/usr/lib64/gcc/x86_64-suse-linux/4.3/../../../../x86_64-suse-linux/bin/ld:+skipping+incompatible+/opt/oracle/app/oracle/product/11.2.0/client_1/lib//libclntsh.so+when+searching+for+-lclntsh
/usr/lib64/gcc/x86_64-suse-linux/4.3/../../../../x86_64-suse-linux/bin/ld:+cannot+find+-lclntsh|code-block|syntax|javascript|3085929|因此，我创建了以下符号链接：|3085930|ln+-s+/opt/oracle/app/oracle/product/<YOUR_ORACLE_VERSION>/client_1/lib/libclntsh.so+$ORACLE_HOME/libclntsh.so*|3085931|在这一步之后，上面的错误(找不到-lclntsh)被修复了。make命令的执行没有任何错误。|3085932|我仍然有的唯一问题是我不明白为什么这个符号链接是必要的。|3085933|entityMap|0|LINK|mutability|MUTABLE|url|http://g14n.info/2013/07/how-to-install-dbdoracle/^0|2E|4|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@$A|Z|B|10|1|11]]|C|$]]|$1|D|3|E|5|F|7|12|8|@]|9|@]|C|$G|H]]|$1|I|3|J|5|6|7|13|8|@]|9|@]|C|$]]|$1|K|3|L|5|F|7|14|8|@]|9|@]|C|$G|H]]|$1|M|3|N|5|6|7|15|8|@]|9|@]|C|$]]|$1|O|3|P|5|6|7|16|8|@]|9|@]|C|$]]|$1|Q|3|-4|5|6|7|17|8|@]|9|@]|C|$]]]|R|$S|$5|T|U|V|C|$W|X]]]]

A little addition to slayedbylucifer answer. I had the same problem like mentioned in the question. I've done all the steps described by slayedbylucifer. But still I got the problem like mentioned <a href="http://g14n.info/2013/07/how-to-install-dbdoracle/" rel="nofollow noreferrer">here</a>:
<pre><code>/usr/lib64/gcc/x86_64-suse-linux/4.3/../../../../x86_64-suse-linux/bin/ld: skipping incompatible /opt/oracle/app/oracle/product/11.2.0/client_1/lib//libclntsh.so when searching for -lclntsh
/usr/lib64/gcc/x86_64-suse-linux/4.3/../../../../x86_64-suse-linux/bin/ld: cannot find -lclntsh
</code></pre>
So I created the following symbolic link:
<pre><code>ln -s /opt/oracle/app/oracle/product/&lt;YOUR_ORACLE_VERSION&gt;/client_1/lib/libclntsh.so $ORACLE_HOME/libclntsh.so*
</code></pre>
After that step the error from above (cannot find -lclntsh) was fixed. The execution of the make command was without any errors.
The only problem I still have is that I don't understand why this symbolic link is necessary.

blocks|key|2872075|text|下面是我在CentOS+7.2上使用yum包和CPAN所做的工作。这假设您使用的是Oracle+12.1版，但我认为大多数版本都是这样工作的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2872076|安装Oracle+Instant+Client|offset|length|style|BOLD|2872077|yum+install+oracle-instantclient12.1-basic-12.1.0.2.0-1+oracle-instantclient12.1-devel-12.1.0.2.0-1+oracle-instantclient12.1-sqlplus-12.1.0.2.0-1|code-block|syntax|javascript|2872078|Copy演示制作文件|2872079|安装时期望演示文件位于/usr/share/oracle/12.1/client64中，但是yum包安装将它们放在/usr/share/oracle/12.1/client64/+*.mk中。|2872080|sudo+cp+/usr/share/oracle/12.1/client64/demo/*+/usr/share/oracle/12.1/client64|2872081|修改.bashrc|2872082|将以下行添加到您的~/.bashrc|2872083|export+ORACLE_HOME=/usr/lib/oracle/12.1/client64
export+LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib
export+PATH=$ORACLE_HOME:$PATH|2872084|现在创建文件源文件|2872085|source+~/.bashrc|2872086|更新CPAN和DBI|2872087|将CPAN和DBI更新为最新版本|2872088|cpan>+install+CPAN
cpan>+reload+cpan
cpan>+install+DBI|2872089|Oracle安装DBD：：|2872090|cpan>+install+DBD::Oracle|2872091|entityMap^0|0|0|N|0|0|0|A|0|0|0|0|9|0|0|0|0|0|0|A|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1E|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1F|8|@$D|1G|E|1H|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|1I|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|1J|8|@$D|1K|E|1L|F|G]]|9|@]|A|$]]|$1|O|3|P|5|6|7|1M|8|@]|9|@]|A|$]]|$1|Q|3|R|5|J|7|1N|8|@]|9|@]|A|$K|L]]|$1|S|3|T|5|6|7|1O|8|@$D|1P|E|1Q|F|G]]|9|@]|A|$]]|$1|U|3|V|5|6|7|1R|8|@]|9|@]|A|$]]|$1|W|3|X|5|J|7|1S|8|@]|9|@]|A|$K|L]]|$1|Y|3|Z|5|6|7|1T|8|@]|9|@]|A|$]]|$1|10|3|11|5|J|7|1U|8|@]|9|@]|A|$K|L]]|$1|12|3|13|5|6|7|1V|8|@$D|1W|E|1X|F|G]]|9|@]|A|$]]|$1|14|3|15|5|6|7|1Y|8|@]|9|@]|A|$]]|$1|16|3|17|5|J|7|1Z|8|@]|9|@]|A|$K|L]]|$1|18|3|19|5|6|7|20|8|@]|9|@]|A|$]]|$1|1A|3|1B|5|J|7|21|8|@]|9|@]|A|$K|L]]|$1|1C|3|-4|5|6|7|22|8|@]|9|@]|A|$]]]|1D|$]]

Here's what I did on CentOS 7.2 using yum packages and CPAN. This assumes you're using Oracle version 12.1 but I would imagine most versions will work this way.

Install Oracle Instant Client

<pre><code>yum install oracle-instantclient12.1-basic-12.1.0.2.0-1 oracle-instantclient12.1-devel-12.1.0.2.0-1 oracle-instantclient12.1-sqlplus-12.1.0.2.0-1
</code></pre>

Copy demo make files

The install expects the *.mk file to be in /usr/share/oracle/12.1/client64 but the yum package install puts them in /usr/share/oracle/12.1/client64/demo.

<pre><code>sudo cp /usr/share/oracle/12.1/client64/demo/* /usr/share/oracle/12.1/client64
</code></pre>

Modify .bashrc

Add the following lines to your ~/.bashrc

<pre><code>export ORACLE_HOME=/usr/lib/oracle/12.1/client64
export LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib
export PATH=$ORACLE_HOME:$PATH
</code></pre>

Now source the file

<pre><code>source ~/.bashrc
</code></pre>

Update CPAN and DBI

Update CPAN and DBI to the latest

<pre><code>cpan&gt; install CPAN
cpan&gt; reload cpan
cpan&gt; install DBI
</code></pre>

Install DBD::Oracle

<pre><code>cpan&gt; install DBD::Oracle
</code></pre>

Could someone guide me how to install the Perl <code>DBD::Oracle</code> module?

Here is what I have done so far:

<ul>
<li>Platform: RHEL 5.8 64 bit</li>
<li>Installed Perl DBI package</li>
<li>Installed Oracle Instant client for Linux 64 bit (basi + sdk + sqlplus component for the instant client</li>
<li>Have set the correct <code>$ORACLE_HOME</code> and <code>$LD_LIBRARY_PATH</code></li>
<li>Then when I do <code>perl Makefile.pl</code> it fails with the following error:

<pre class="lang-none prettyprint-override"><code>I'm having trouble finding your Oracle version number... trying harder

WARNING: I could not determine Oracle client version so I'll just
default to version 8.0.0.0. Some features of DBD::Oracle may not work.
Oracle version based logic in Makefile.PL may produce erroneous results.
You can use "perl Makefile.PL -V X.Y.Z" to specify a your client version.

Oracle version 8.0.0.0 (8.0)
DBD::Oracle no longer supports Oracle client versions before 9.2
 Try a version before 1.25 for 9 and 1.18 for 8! at Makefile.PL line 271.
</code></pre></li>
<li>The instant client version: 11.1.0</li>
<li>The <code>DBD::Oracle</code> version is 1.44</li>
</ul>

If you have installed successfully with the Oracle instant client, then could you please let me know what am I missing?

Is it possible to install <code>DBD::Oracle</code> without using the Oracle instant client?

Perl DBD::Oracle Module installation

有人能指导我如何安装Perl DBD::Oracle模块吗？以下是我到目前为止所做的工作：Platform: RHEL 5.8 64位安装了Perl DBI packageInstalled Oracle Instant client for Linux64位(基本+ sdk + sqlplus组件 instant c...

问Perl DBD::Oracle模块安装
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Perl DBD::Oracle模块安装EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Perl DBD::Oracle模块安装
EN