如何在 OSX Snow Leopard 10.6 上安装 perl DBD::Oracle
我正在尝试从运行 OSX 10.6 雪豹的英特尔 Mac 连接到远程系统上的 Oracle 10.2.0.4。我尝试使用 perl CPAN 安装 DBD::Oracle (DBI 工作正常),但出现编译错误。有人可以提供一个易于遵循的指南吗?
I'm trying to connect to Oracle 10.2.0.4 on a remote system from my intel mac running OSX 10.6 snow leopard. I've tried using perl CPAN to install DBD::Oracle (DBI worked ok) but get compilation errors. Could someone provide an easy to follow guide?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(5)
在 mac 上安装 perl 来与 oracle 很好地配合是有点痛苦 - 一旦它运行起来就很棒了,让它运行起来有点令人沮丧..
下面的内容对我来说在一些不同的 intel mac 上工作,很可能那里是多余的步骤,对于其他平台来说可能不会相同。
这将需要使用 shell、root 用户和一些 CPANing - 没什么太繁琐的
首先为 oracle pap 创建一个目录 - 库、即时客户端等
从 oracle 到上述目录
在该目录中为其中的文件之一创建符号链接
以下目录被硬编码到 oracle 即时客户端中 - 天知道为什么 - 所以需要创建并符号链接它
需要添加几个环境变量,因此编辑 /etc/profile 并添加它们,以便它们对所有用户都存在:
现在尝试并通过 CPAN 安装 DBD::Oracle - 这将失败,但这意味着将下载所有依赖项并为我们检索模块
当此失败时退出 CPAN 并前往您的 .cpan/build 目录 - 如果您使用 CPAN 的自动配置'二如果
你没有自动配置,你可以在 CPAN 中使用以下命令找到你的构建目录
一旦在构建目录中查找刚刚创建的 DBD::Oracle 目录(它将被称为类似 DBD-Oracle- 1.28-?)并进入它。
现在我们需要切换到root用户。 osx 中默认未启用 Root - 有关启用的详细信息,请参阅 Apple 网站 上的这篇文章
以 root 身份登录后,我们需要为 root 设置上述环境变量:
现在,当仍然以 root 身份登录时,我们需要运行模块的 makefile,然后 make,然后安装
假设一切正常,没有错误从 root 注销:我们是 DBD 向上!如果这不起作用,那么是时候在 google 上搜索您所看到的任何错误了
现在只需安装 DBI 模块
现在您已准备就绪 - 享受您的 perly oracley 新生活
来自 user852637 的附加信息:
对此的更正步骤
最后一步应该是
make install
在make的时候,可能会遇到错误看起来像:
<块引用>
lipo:无法打开输入文件:/var/tmp//ccIevTzM.out(没有这样的文件或目录)
要纠正此问题,您必须编辑在“perl Makefile.pl”步骤之后创建的文件“Makefile”,并删除所有出现的以下文本:
<前><代码>-arch ppc
这将消除错误。
在安装 DBI 模块期间,会发生与 (2.) 中描述的相同错误。您必须编辑在
perl Makefile.pl
步骤之后创建的Makefile
,并删除所有出现的以下文本:<前><代码>-arch ppc
Getting a mac install of perl to play nicely with oracle is a bit of a pain - once it's running it is fantastic, getting it running is a little frustrating..
The below has worked for me on a few different intel macs, there could well be superfluous steps in there and it is likely not going to be the same for other platforms.
This will require use of shell, the root user and a bit of CPANing - nothing too onerous
First off create a directory for the oracle pap - libraries, instant client etc
Download and extract all 64 bit instant client packages from oracle to the above directory
Create a symlink within that directory for one of the files in there
The following dir is hardcoded into the oracle instant client - god knows why - so need to create and symlink it
Need to add a couple of environment variables, so edit /etc/profile and add them so they exist for all users:
Now try and install DBD::Oracle through CPAN - this will fail, but it means any dependencies will be downloaded and it retrieves the module for us
When this fails exit CPAN and head to your .cpan/build dir - if you used automatic config of CPAN it'll be
if you didn't auto configure you can find your build directory with the following command in CPAN
Once in the build dir look for the DBD::Oracle dir which has just been created (it'll be called something like DBD-Oracle-1.28-?) and cd into it.
Now we need to switch to the root user. Root isn't enabled as default in osx - for details on enabling see this post on the apple website
Once logged in as root we need to set the above environment variables for root:
Now while still logged in as root we need to run the makefile for the module, then make, then install
Assuming that all worked without error log out of root: we're DBD'd up! If this didn't work it's time to bust out google on whatever errors you're seeing
Now just to install the DBI module
Now you're all set - enjoy your perly oracley new life
Additional info from user852637:
Correction to this step
The last step should be
make install
During make, you may encounter an error that looks like :
To correct this you must edit the file "Makefile" created after the "perl Makefile.pl" step and remove all occurrences of the following text :
This will eliminate the error.
The same error described in (2.) will occur during the installation of the DBI module. You must edit the
Makefile
created after theperl Makefile.pl
step and remove all occurrences of the following text :看起来随着 XCode4 的更改(删除 PPC arch 支持),Perl 安装在任何 10.6.X 更新中都没有更新以删除 PPC 二进制文件(可能是因为 Rosetta 仍然存在)。
因此,配置文件保留“-arch ppc”,导致所有使用 C 库的 CPAN 模块编译失败,因为 MakeMaker 的输出 Makefile 包含 -arch ppc。
要解决此问题,可以编辑以下文件:
在第 1219 行,您将看到:
将其更改为:
一旦执行此操作,生成的 Makefile 将是正确的。
It looks with the XCode4 change (removal of PPC arch support) the Perl installation was not updated in any of the 10.6.X updates to also remove PPC binaries (probably because Rosetta is still present).
Because of this, the configuration files retain "-arch ppc" causing all CPAN module compiles with C libraries to fail because MakeMaker's output Makefile contains -arch ppc.
To fix this one can edit the following file:
at line 1219 you'll see:
change that to:
Once you do this the generated Makefile will be correct.
这是一组很棒的说明。我对潜在的“陷阱”还有一些其他评论。
此步骤的更正
最后一步应该是
make install
在make的时候,可能会遇到错误看起来像:
<块引用>
lipo:无法打开输入文件:/var/tmp//ccIevTzM.out(没有这样的文件或目录)
要纠正此问题,您必须编辑在“perl Makefile.pl”步骤之后创建的文件“Makefile”,并删除所有出现的以下文本:
<前><代码>-arch ppc
这将消除错误。
在安装 DBI 模块期间,会发生与 (2.) 中描述的相同错误。您必须编辑在
perl Makefile.pl
步骤之后创建的Makefile
,并删除所有出现的以下文本:<前><代码>-arch ppc
These are a great set of instructions. I have a few other comments about potential "gotchas".
Correction to this step
The last step should be
make install
During make, you may encounter an error that looks like :
To correct this you must edit the file "Makefile" created after the "perl Makefile.pl" step and remove all occurrences of the following text :
This will eliminate the error.
The same error described in (2.) will occur during the installation of the DBI module. You must edit the
Makefile
created after theperl Makefile.pl
step and remove all occurrences of the following text :似乎“Perl MakeFile.pl”命令没有正确找到 Perl 的版本,并且我收到此错误消息:
如果我像这样强制版本号:
它完成,但在运行“make”时收到错误消息:
我意识到这是因为需要从 Makefile 中删除“-arch ppc”参数,但即使在删除所有 32 位引用后,我仍然看到错误消息。
使用 Oracle 驱动程序版本 10.2.0.4 运行 10.6.8 Snow Leopard
我发现此问题的关键是确保 MakeFile.pl 可以找到 Oracle 版本。
我遇到的问题是 Safari 正在从 Oracle.com 下载 zip 文件,但解压缩它们并以某种方式损坏了库。
相反,我使用了不同的浏览器并将所有 zip 文件下载到一个目录中。然后我运行以下 tar 命令:
将文件夹“instantclient_10_2”中的所有内容复制到 $ORACLE_HOME(之前设置)
另外,我不需要编辑由 MakeFile.pl 脚本生成的 Makefile 来删除“-arch ppc” “ 参考。
It seems as though the "Perl MakeFile.pl" command is not finding the version of Perl correctly and I get this error message:
If I force the version number like this:
It completes, but I receive the error message when running "make":
I realize this is because of the "-arch ppc" argument that needs to be removed from Makefile, but even after removal the removal of all 32-bit references, I still saw the error message.
Running 10.6.8 Snow Leopard with Oracle Driver version 10.2.0.4
I found that the key to this issue was making sure that MakeFile.pl could find the Oracle version.
The problem I ran into was that Safari was downloading the zip files from Oracle.com, but unzipping them and somehow corrupting the library.
Instead, I used a different browser and downloaded all the zip files into one directory. Then I ran the following tar commands:
The copy all the contents in the folder "instantclient_10_2" to $ORACLE_HOME (set previously)
Also, I did not need to edit the Makefile generated by the MakeFile.pl script to remove the "-arch ppc" references.
您不应在计算机上重新创建与客户端库打包程序相同的目录结构。
不要使用
mkdir -p /b/227/rdbms/
使用 MacOSX 库头管理工具:
otool
和install_name_tool
例如,我有将库标头更新到我的部署体系结构:
检查 Oracle instantclient 库附带的所有文件并修复所有依赖库的路径
然后,将动态库链接到它们应该所在的位置。
您可以避免使用
export DYLD_LIBRARY_PATH
因为您知道如何设置系统You should not recreate on your machine the same directory structure as of the client libraries packager.
Don't do
mkdir -p /b/227/rdbms/
Use MacOSX library header management tools:
otool
andinstall_name_tool
For instance, I have updated the library headers to my deployment architecture:
Check all files that come with the Oracle instantclient libraries and fix the path of all dependent libs
Then, you link your dynamic libraries to the place they're supposed to be.
And you can avoid using that
export DYLD_LIBRARY_PATH
because you know how to setup your system