托管在Oracle数据库上的后端（详见下文）。 [英] backend which is hosted on Oracle database (below details).

问题描述

Hi Team，

请提供我在Oracle数据库上托管的建议

Please provide me the suggestions

后端（详情如下）。 />
必须使用Microsoft Azure数据工厂的集成运行时建立此连接。我们在尝试获取数据并低于错误时遇到问题。

请注意，建立了与DB的连接，并且在获取数据时出错。

backend which is hosted on Oracle database (below details).
This connection has to be established using Microsoft Azure data factory's integration runtime. We are running into issues when trying to fetch data and getting below error.
Please note, connection to DB is established and the error is when fetching data.

错误：
$
活动OracleDBConnection失败："源"端发生故障。 'Type = Microsoft.DataTransfer.Common.Shared.HybridDeliveryException，Message = ODBC error'HY000'。，Source = Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector，''Type = System.Data.Odbc.OdbcException，Message = ERROR
[HY000] [Microsoft] [ODBC Oracle Wire Protocol驱动程序] [Oracle] ORA-22288：文件或LOB操作失败ERROR [HY000] [Microsoft] [ODBC Oracle Wire Protocol驱动程序] [Oracle] ORA-22275：无效指定了LOB定位器，Source = msora28.dll，'

Error:
Activity OracleDBConnection failed: Failure happened on 'Source' side. 'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ODBC error 'HY000'.,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=System.Data.Odbc.OdbcException,Message=ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-22288: file or LOB operation failed ERROR [HY000] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-22275: invalid LOB locator specified,Source=msora28.dll,'

推荐答案

Hi Srinu，

源端发生故障 - "指定了无效的LOB定位器"。

为了成功完成DBMS_LOB子程序，必须提供一个输入定位器，表示数据库表空间或外部
文件系统中已存在的LOB。有关详细信息，请参阅" ORA-22275 - 无效的LOB定位器指定"。

For the successful completion of DBMS_LOB subprograms, you must provide an input locator that represents a LOB that already exists in the database tablespaces or external file system. For more details, refer "ORA-22275 – Invalid LOB locator specified".

这个
文章概述了如何使用复制活动在Azure数据工厂中从Oracle数据库复制数据。

This article outlines how to use Copy Activity in Azure Data Factory to copy data from and to an Oracle database.

希望这会有所帮助。

这篇关于托管在Oracle数据库上的后端（详见下文）。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！