Python论坛  - 讨论区

返回群组主页

标题：[python-chinese] cx_Oracle问题

分享
徐继哲

徐继哲

2007年11月22日 星期四 09:18

mpouse_005 mpouse_005在163.com
星期四 十一月 22 09:18:27 HKT 2007

ÔÚwindowsÏ°²×°ÁËOracle 10g£¬Ê¹ÓõÄ2.5.1python¡£¶þ½øÖÆ°²×°Íêºóimportʱ³öÏÖ


import cx_Oracle

Traceback (most recent call last):
  File "", line 1, in 
    import cx_Oracle
ImportError: DLL load failed: ÕÒ²»µ½Ö¸¶¨µÄÄ£¿é¡£

ÓÐË­Óöµ½¹ýÇëÖ¸µãÖ¸µã




mpouse_005
2007-11-22
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20071122/f044b40f/attachment.html

[导入自Mailman归档：http://www.zeuux.org/pipermail/zeuux-python]
徐继哲

徐继哲

2007年11月22日 星期四 10:18

richardlee richardlee在e28.com
星期四 十一月 22 10:18:09 HKT 2007

一个HTML附件被移除...
URL: http://python.cn/pipermail/python-chinese/attachments/20071122/d9b8bc18/attachment.htm

[导入自Mailman归档：http://www.zeuux.org/pipermail/zeuux-python]
徐继哲

徐继哲

2007年11月22日 星期四 14:35

mpouse_005 mpouse_005在163.com
星期四 十一月 22 14:35:45 HKT 2007

ÎÒÊÇÔÚwindowsÏÂÓÃexe°²×°µÄ£¬ÔÚsite-packagesÏÂÖ»ÓÐcx_Oracle-4.3.1-py2.5.egg-info
ºÍcx_Oracle.pydÁ½¸öÓëOracleÏà¹ØµÄÎļþ£¬ÔÚµçÄÔÖÐҲûÓÐËÑË÷µ½OCi.dllÕâÑùµÄÎļþ¡£




mpouse_005
2007-11-22



·¢¼þÈË£º richardlee
·¢ËÍʱ¼ä£º 2007-11-22 10:18:39
ÊÕ¼þÈË£º python-chinese在lists.python.cn
³­ËÍ£º 
Ö÷Ì⣺ Re: [python-chinese]cx_OracleÎÊÌâ

1. install cx_Oracle python module;
2. install oracle client;
3. copy C:\oracle\ora92\bin\oci.dll to C:\Python25\Lib\site-packages
4. modify the SQLNET.AUTHENTICATION_SERVICES' value from NTS to NONE in oracle\ora92\network\ADMIN\sqlnet.ora

ÄãÓ¦¸ÃÊǵÚÈý²½Ã»×öºÃ°É¡£

richard lee

mpouse_005 wrote: 
ÔÚwindowsÏ°²×°ÁËOracle 10g£¬Ê¹ÓõÄ2.5.1python¡£¶þ½øÖÆ°²×°Íêºóimportʱ³öÏÖ


import cx_Oracle

Traceback (most recent call last):
  File "", line 1, in 
    import cx_Oracle
ImportError: DLL load failed: ÕÒ²»µ½Ö¸¶¨µÄÄ£¿é¡£

ÓÐË­Óöµ½¹ýÇëÖ¸µãÖ¸µã




mpouse_005
2007-11-22

_______________________________________________
python-chinese
Post: send python-chinese在lists.python.cn
Subscribe: send subscribe to python-chinese-request在lists.python.cn
Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn
Detail Info: http://python.cn/mailman/listinfo/python-chinese
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20071122/c87c075c/attachment.htm

[导入自Mailman归档：http://www.zeuux.org/pipermail/zeuux-python]
周琦

周琦

2007年11月22日 星期四 14:47

Zoom.Quiet zoom.quiet在gmail.com
星期四 十一月 22 14:47:05 HKT 2007

On Nov 22, 2007 2:35 PM, mpouse_005 <mpouse_005在163.com> wrote:
>
>
> 我是在windows下用exe安装的，在site-packages下只有cx_Oracle-4.3.1-py2.5.egg-info
> 和cx_Oracle.pyd两个与Oracle相关的文件，在电脑中也没有搜索到OCi.dll这样的文件。
>
弱问一下，你的 Oracle 是正版的？是的话，向你的客服吼，
不是的话，建议使用 PostgreSQL

>
>
>  ________________________________
>
> mpouse_005
> 2007-11-22
>  ________________________________
>
> 发件人： richardlee
> 发送时间： 2007-11-22 10:18:39
> 收件人： python-chinese在lists.python.cn
> 抄送：
> 主题： Re: [python-chinese]cx_Oracle问题
>
>
>
> 1. install cx_Oracle python module;
> 2. install oracle client;
> 3. copy C:\oracle\ora92\bin\oci.dll to C:\Python25\Lib\site-packages
> 4. modify the SQLNET.AUTHENTICATION_SERVICES' value from NTS to NONE in
> oracle\ora92\network\ADMIN\sqlnet.ora
>
> 你应该是第三步没做好吧。
>
> richard lee
>
> mpouse_005 wrote:
>
> 在windows下安装了Oracle 10g，使用的2.5.1python。二进制安装完后import时出现
>
>
> import cx_Oracle
>
> Traceback (most recent call last):
>   File "", line 1, in 
>     import cx_Oracle
> ImportError: DLL load failed: 找不到指定的模块。
>
> 有谁遇到过请指点指点
>
>  ________________________________
>
> mpouse_005
> 2007-11-22________________________________
>
> _______________________________________________
> python-chinese
> Post: send python-chinese在lists.python.cn
> Subscribe: send subscribe to python-chinese-request在lists.python.cn
> Unsubscribe: send unsubscribe to python-chinese-request在lists.python.cn
> Detail Info: http://python.cn/mailman/listinfo/python-chinese
>
>
> _______________________________________________
> python-chinese
> Post: send python-chinese在lists.python.cn
> Subscribe: send subscribe to python-chinese-request在lists.python.cn
> Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn
> Detail Info: http://python.cn/mailman/listinfo/python-chinese
>



-- 
'''Time is unimportant, only life important!
过程改进乃是开始催生可促生靠谱的人的组织!
'''http://zoomquiet.org
博 @ http://blog.zoomquiet.org/pyblosxom/
维 @ http://wiki.woodpecker.org.cn/moin/ZoomQuiet
豆 @ http://www.douban.com/people/zoomq/
看 @ http://zoomq.haokanbu.com/
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Pls. usage OOo to replace M$ Office. http://zh.openoffice.org
Pls. usage 7-zip to replace WinRAR/WinZip.  http://7-zip.org
You can get the truely Freedom 4 software.

[导入自Mailman归档：http://www.zeuux.org/pipermail/zeuux-python]
徐继哲

徐继哲

2007年11月22日 星期四 14:59

昆仑 jackyboy在163.com
星期四 十一月 22 14:59:28 HKT 2007

windowsϵÄoracle·ÇÉÌÒµÓ¦ÓúÃÏñÊÇÃâ·ÑµÄ°É¡£¡£¡£


2007-11-22 



À¥ÂØ 



·¢¼þÈË£º Zoom.Quiet 
·¢ËÍʱ¼ä£º 2007-11-22  14:51:00 
ÊÕ¼þÈË£º python-chinese在lists.python.cn 
³­ËÍ£º 
Ö÷Ì⣺ Re: [python-chinese]cx_OracleÎÊÌâ 
 
On Nov 22, 2007 2:35 PM, mpouse_005  <mpouse_005在163.com > wrote:
>
>
> ÎÒÊÇÔÚwindowsÏÂÓÃexe°²×°µÄ£¬ÔÚsite-packagesÏÂÖ»ÓÐcx_Oracle-4.3.1-py2.5.egg-info
> ºÍcx_Oracle.pydÁ½¸öÓëOracleÏà¹ØµÄÎļþ£¬ÔÚµçÄÔÖÐҲûÓÐËÑË÷µ½OCi.dllÕâÑùµÄÎļþ¡£
>
ÈõÎÊһϣ¬ÄãµÄ Oracle ÊÇÕý°æµÄ£¿ÊǵĻ°£¬ÏòÄãµÄ¿Í·þºð£¬
²»ÊǵĻ°£¬½¨ÒéʹÓà PostgreSQL

>
>
>  ________________________________
>
> mpouse_005
> 2007-11-22
>  ________________________________
>
> ·¢¼þÈË£º richardlee
> ·¢ËÍʱ¼ä£º 2007-11-22 10:18:39
> ÊÕ¼þÈË£º python-chinese在lists.python.cn
> ³­ËÍ£º
> Ö÷Ì⣺ Re: [python-chinese]cx_OracleÎÊÌâ
>
>
>
> 1. install cx_Oracle python module;
> 2. install oracle client;
> 3. copy C:\oracle\ora92\bin\oci.dll to C:\Python25\Lib\site-packages
> 4. modify the SQLNET.AUTHENTICATION_SERVICES' value from NTS to NONE in
> oracle\ora92\network\ADMIN\sqlnet.ora
>
> ÄãÓ¦¸ÃÊǵÚÈý²½Ã»×öºÃ°É¡£
>
> richard lee
>
> mpouse_005 wrote:
>
> ÔÚwindowsÏ°²×°ÁËOracle 10g£¬Ê¹ÓõÄ2.5.1python¡£¶þ½øÖÆ°²×°Íêºóimportʱ³öÏÖ
>
>
> import cx_Oracle
>
> Traceback (most recent call last):
>   File " ", line 1, in  
>     import cx_Oracle
> ImportError: DLL load failed: ÕÒ²»µ½Ö¸¶¨µÄÄ£¿é¡£
>
> ÓÐË­Óöµ½¹ýÇëÖ¸µãÖ¸µã
>
>  ________________________________
>
> mpouse_005
> 2007-11-22________________________________
>
> _______________________________________________
> python-chinese
> Post: send python-chinese在lists.python.cn
> Subscribe: send subscribe to python-chinese-request在lists.python.cn
> Unsubscribe: send unsubscribe to python-chinese-request在lists.python.cn
> Detail Info: http://python.cn/mailman/listinfo/python-chinese
>
>
> _______________________________________________
> python-chinese
> Post: send python-chinese在lists.python.cn
> Subscribe: send subscribe to python-chinese-request在lists.python.cn
> Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn
> Detail Info: http://python.cn/mailman/listinfo/python-chinese
>



-- 
'''Time is unimportant, only life important!
¹ý³Ì¸Ä½øÄËÊÇ¿ªÊ¼´ßÉú¿É´ÙÉú¿¿Æ×µÄÈ˵Ä×éÖ¯!
'''http://zoomquiet.org
²© @ http://blog.zoomquiet.org/pyblosxom/
ά @ http://wiki.woodpecker.org.cn/moin/ZoomQuiet
¶¹ @ http://www.douban.com/people/zoomq/
¿´ @ http://zoomq.haokanbu.com/
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Pls. usage OOo to replace M$ Office. http://zh.openoffice.org
Pls. usage 7-zip to replace WinRAR/WinZip.  http://7-zip.org
You can get the truely Freedom 4 software.
_______________________________________________
python-chinese
Post: send python-chinese在lists.python.cn
Subscribe: send subscribe to python-chinese-request在lists.python.cn
Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn
Detail Info: http://python.cn/mailman/listinfo/python-chinese
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20071122/947bdcd0/attachment.html

[导入自Mailman归档：http://www.zeuux.org/pipermail/zeuux-python]
徐继哲

徐继哲

2007年11月22日 星期四 15:07

richardlee richardlee在e28.com
星期四 十一月 22 15:07:32 HKT 2007

一个HTML附件被移除...
URL: http://python.cn/pipermail/python-chinese/attachments/20071122/fd7372ae/attachment.htm

[导入自Mailman归档：http://www.zeuux.org/pipermail/zeuux-python]
徐继哲

徐继哲

2007年11月22日 星期四 17:58

mpouse_005 mpouse_005在163.com
星期四 十一月 22 17:58:06 HKT 2007

ÎÒÊÇÔÚ  http://www.python.net/crew/atuining/cx_Oracle/
ϵÄwindow 10gºÍ9i python25ʹÓõÄÁ½¸ö°æ±¾£¬¶¼ÊÔÁËÊÔ»¹ÊDz»ÐУ¬ÒÔǰûÓÐÈËÓöµ½¹ýÕâÖÖÎÊÌâÂð£¿



mpouse_005
2007-11-22



·¢¼þÈË£º À¥ÂØ
·¢ËÍʱ¼ä£º 2007-11-22 15:03:30
ÊÕ¼þÈË£º python-chinese在lists.python.cn
³­ËÍ£º 
Ö÷Ì⣺ Re: [python-chinese]cx_OracleÎÊÌâ

windowsϵÄoracle·ÇÉÌÒµÓ¦ÓúÃÏñÊÇÃâ·ÑµÄ°É¡£¡£¡£


2007-11-22 



À¥ÂØ 



·¢¼þÈË£º Zoom.Quiet 
·¢ËÍʱ¼ä£º 2007-11-22  14:51:00 
ÊÕ¼þÈË£º python-chinese在lists.python.cn 
³­ËÍ£º 
Ö÷Ì⣺ Re: [python-chinese]cx_OracleÎÊÌâ 
On Nov 22, 2007 2:35 PM, mpouse_005  <mpouse_005在163.com > wrote:
>
>
> ÎÒÊÇÔÚwindowsÏÂÓÃexe°²×°µÄ£¬ÔÚsite-packagesÏÂÖ»ÓÐcx_Oracle-4.3.1-py2.5.egg-info
> ºÍcx_Oracle.pydÁ½¸öÓëOracleÏà¹ØµÄÎļþ£¬ÔÚµçÄÔÖÐҲûÓÐËÑË÷µ½OCi.dllÕâÑùµÄÎļþ¡£
>
ÈõÎÊһϣ¬ÄãµÄ Oracle ÊÇÕý°æµÄ£¿ÊǵĻ°£¬ÏòÄãµÄ¿Í·þºð£¬
²»ÊǵĻ°£¬½¨ÒéʹÓà PostgreSQL

>
>
>  ________________________________
>
> mpouse_005
> 2007-11-22
>  ________________________________
>
> ·¢¼þÈË£º richardlee
> ·¢ËÍʱ¼ä£º 2007-11-22 10:18:39
> ÊÕ¼þÈË£º python-chinese在lists.python.cn
> ³­ËÍ£º
> Ö÷Ì⣺ Re: [python-chinese]cx_OracleÎÊÌâ
>
>
>
> 1. install cx_Oracle python module;
> 2. install oracle client;
> 3. copy C:\oracle\ora92\bin\oci.dll to C:\Python25\Lib\site-packages
> 4. modify the SQLNET.AUTHENTICATION_SERVICES' value from NTS to NONE in
> oracle\ora92\network\ADMIN\sqlnet.ora
>
> ÄãÓ¦¸ÃÊǵÚÈý²½Ã»×öºÃ°É¡£
>
> richard lee
>
> mpouse_005 wrote:
>
> ÔÚwindowsÏ°²×°ÁËOracle 10g£¬Ê¹ÓõÄ2.5.1python¡£¶þ½øÖÆ°²×°Íêºóimportʱ³öÏÖ
>
>
> import cx_Oracle
>
> Traceback (most recent call last):
>   File " ", line 1, in  
>     import cx_Oracle
> ImportError: DLL load failed: ÕÒ²»µ½Ö¸¶¨µÄÄ£¿é¡£
>
> ÓÐË­Óöµ½¹ýÇëÖ¸µãÖ¸µã
>
>  ________________________________
>
> mpouse_005
> 2007-11-22________________________________
>
> _______________________________________________
> python-chinese
> Post: send python-chinese在lists.python.cn
> Subscribe: send subscribe to python-chinese-request在lists.python.cn
> Unsubscribe: send unsubscribe to python-chinese-request在lists.python.cn
> Detail Info: http://python.cn/mailman/listinfo/python-chinese
>
>
> _______________________________________________
> python-chinese
> Post: send python-chinese在lists.python.cn
> Subscribe: send subscribe to python-chinese-request在lists.python.cn
> Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn
> Detail Info: http://python.cn/mailman/listinfo/python-chinese
>



-- 
'''Time is unimportant, only life important!
¹ý³Ì¸Ä½øÄËÊÇ¿ªÊ¼´ßÉú¿É´ÙÉú¿¿Æ×µÄÈ˵Ä×éÖ¯!
'''http://zoomquiet.org
²© @ http://blog.zoomquiet.org/pyblosxom/
ά @ http://wiki.woodpecker.org.cn/moin/ZoomQuiet
¶¹ @ http://www.douban.com/people/zoomq/
¿´ @ http://zoomq.haokanbu.com/
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Pls. usage OOo to replace M$ Office. http://zh.openoffice.org
Pls. usage 7-zip to replace WinRAR/WinZip.  http://7-zip.org
You can get the truely Freedom 4 software.
_______________________________________________
python-chinese
Post: send python-chinese在lists.python.cn
Subscribe: send subscribe to python-chinese-request在lists.python.cn
Unsubscribe: send unsubscribe to  python-chinese-request在lists.python.cn
Detail Info: http://python.cn/mailman/listinfo/python-chinese
-------------- 下一部分 --------------
Ò»¸öHTML¸½¼þ±»ÒƳý...
URL: http://python.cn/pipermail/python-chinese/attachments/20071122/51112aca/attachment.html

[导入自Mailman归档：http://www.zeuux.org/pipermail/zeuux-python]
徐继哲

徐继哲

2007年11月22日 星期四 21:27

Xie Yanbo xieyanbo在gmail.com
星期四 十一月 22 21:27:56 HKT 2007

On Nov 22, 2007 9:18 AM, mpouse_005 <mpouse_005在163.com> wrote:
> 在windows下安装了Oracle 10g，使用的2.5.1python。二进制安装完后import时出现
>
> import cx_Oracle
>
> Traceback (most recent call last):
>   File "", line 1, in 
>     import cx_Oracle
> ImportError: DLL load failed: 找不到指定的模块。

$ORACLE_HOME/bin目录需要添加到环境变量$PATH中，cx_Oracle需要从
这个目录里寻找oci.dll文件。

[导入自Mailman归档：http://www.zeuux.org/pipermail/zeuux-python]

如下红色区域有误，请重新填写。

    你的回复：

    请 登录 后回复。还没有在Zeuux哲思注册吗？现在 注册 ！
    反馈意见 帮助中心 服务条款 版权声明 关于哲思

    Zeuux © 2025

    京ICP备05028076号