Error: DPI-1047: Cannot locate a 64-bit Oracle Client library: "問題
參考:
https://blog.csdn.net/zhaoyq008/article/details/94018743
python 打包後,在別的機器遇上執行,提示報錯,報錯內容為:
Error: DPI-1047: Cannot locate a 64-bit Oracle Client library: "The specified module could not be found". See for help
根本問題:打包時未將oracle dll檔案打包進去,導致執行找不到連結庫。
臨時解決辦法:
方法一:
1、安裝oracle 64位客戶端
2、配置環境path,將客戶端的目錄,比如d:\oracle\product\11.2.0\client_1\bin 配置到path中
3、前面兩步做完,執行報了另一個錯 ora-01804 ,將 ORACLE_HOME目錄設定為 d:\oracle\product\11.2.0\client_1 後,問題解決。
方法二:
1、下載輕量級的Oracle客戶端: 比如 instantclient-basic-windows.x64-11.2.0.4.0.zip
2、配置環境變數path: 將客戶端的目錄,比如 D:\oracle\instantclient_11_2 新增到 path
3、配置環境變數ORACL_HOME: 將客戶端的上一級目錄 ,比如 D:\oracle 設定為ORACLE_HOME的值
4、上面3步做完,執行報錯:```nls_lan python Error: 'ascii' codec can't encode characters in position 28-31: ordinal not in range(128),```; 然後新增環境變數NLS_LANG,設定為:AMERICAN_AMERICA.ZHS16GBK,其值是資料庫nls_database_parameters中NLS_LANGUAGE,NLS_TERRITORY,NLS_CHARACTERSET分別對應的值; 設定完成後執行成功。
方法三: linux 解決方法
1、下載輕量級的oracle客戶端並解壓安裝
2、配置環境變數LD_LIBRARY_PATH=[oracle客戶端安裝目錄]:$LD_LIBRARY_PATH ,NLS_LANG=[oracle資料庫NLS_LANGUAGE_NLS_TERRITORY.NLS_CHARACTERSET] ,並新增到 ~/.bash_profile 中
3、重新登入系統 或 source ~/.bash_profile 使環境變數生效
4、重新執行後成功
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29519108/viewspace-2683542/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- FTP Client library in C# (轉)FTPclientC#
- Oracle DataGuard FAL[client, ARC2]: Error 16191 connecting to 問題處理過程記錄OracleclientError
- 限定client端IP訪問oracle!clientOracle
- 限定client段ip訪問oracle!clientOracle
- Fatal Error: TXK Install Service,Cannot install Oracle Database HomeErrorOracleDatabase
- Uncaught Error: Cannot instantiate interfaceError
- ‘error: ‘‘this‘‘ cannot be implicitly captured in this context‘ErrorAPTContext
- error:package mysql-client is not relocatableErrorPackageMySqlclient
- 【scala】問題cannot resolve symbol sparkSymbolSpark
- 500 OOPS: cannot change directory問題OOP
- pl/sql + client 版本位數問題SQLclient
- 如何查詢 library locking 問題
- Library Hit %: -986.64 負數的問題
- ?Error: Can't locate /etc/centreon/conf.pm in @INC (@INError
- Jquery DataTables解決 Cannot reinitialise DataTable 問題jQuery
- Cannot access a disposed object.問題根源所在.....Object
- ERROR: Cannot uninstall ‘PyYAML‘. It is a distutils installed project and thus we cannot accuratelyErrorYAMLProject
- "locate: can not open `/var/lib/mlocate/mlocate.db"問題解決
- xtrabackup: Error: cannot open /../../base/xtrabackup_checkpointsError
- 一次library cache lock 問題分析
- 【ERROR】儲存鏈路問題造成oracle錯誤,ora-600[4193] 問題處理ErrorOracle
- 用JDBC THIN CLIENT能訪問oracle cluster嗎?JDBCclientOracle
- TypeError: Descriptors cannot not be created directly問題的解決Error
- 關於action的error問題Error
- ID 361468.1 HugePages on Oracle Linux 64-bitOracleLinux
- Import Error: cannot import name ‘export_saved_modelImportErrorExport
- Memory Notification: Library Cache Object loaded into SGA問題Object
- Library cache pin問題的處理過程
- Oracle Library cacheOracle
- cannot read prpperty ‘start‘ of undefined(問題記錄)Undefined
- Cannot connect on socket(25)_NetBackup 問題解決
- android studio Cannot reload AVD list問題Android
- VFS: Cannot open root device “nfs“ or unknown-block(2,0): error -6 NFS掛載不上,核心配置問題devNFSBloCError
- Spark —— Spark OOM Error問題排查定位SparkOOMError
- HugePages on Oracle Linux 64-bit (Doc ID 361468.1)OracleLinux
- 關於java.lang.Error: Probable fatal error:No fonts found問題JavaError
- O/S-Error: (OS 33) The process cannot access the fileError
- Oracle OER 7451 in Load Indicator : Error Code = OSD-04500的問題處理OracleIndicatorError