“ORA-01005：给出空密码;登录被拒绝“尝试时出错 [英] "ORA-01005: null password given; logon denied" Error when trying

问题描述

我正在将数据从Oracle数据库暂存到SQL Server。我在一个项目参数中提到了orcle连接字符串，在单独的参数中提到了密码。我正确地将字符串和密码连接到相应的项目参数。
密码标记为敏感。 所有包都设置为"EncryptSensitiveWithUserKey"。保护级别并在64位运行时运行。当我在Visual Studio 2015上运行SSIS包时，我能够运行该包。但是，当我在SSIS服务器上部署
软件包然后安排通过Tidal运行软件包时，我收到了以下错误

 

包裹名称：XXXXXXXXXXXXXXXXXXXX

        MessageTime：03/04/2019 20:22:57

        Message_Source_Name：XXXXXXXXXXXXXXXXXXXX

        Event_Name：OnError

        消息：ExtractContact_Ulysses：错误：SSIS错误代码DTS_E_OLEDBERROR。 
发​​生了OLE DB错误。错误代码：0x80004005。

OLE DB记录可用。  来源："OraOLEDB" 
Hresult：0x80004005   描述：" ORA-01005：给出空密码;登录被拒绝"。

请告知。

解决方案

Hi AshutoshAtre，

您可能只需要将凭据重新键入包连接管理器打开这些包含目录和/或作业

Hi,

I am staging the data in to the SQL Server from Oracle database. I mentioned the orcle connection string in one project parameter and the password in the separate parameter. I properly connection string and password to respective project parameters. The password in marked as sensitive.  All the packages are set to "EncryptSensitiveWithUserKey" protection level and running on 64 bit runtime. When I run the SSIS package on Visual Studio 2015, I am able to run the package. But, whn I deploy the package on the SSIS server and then schedule the package run via Tidal, I am getting below error

 

Package Name: XXXXXXXXXXXXXXXXXXXX

        MessageTime: 03/04/2019 20:22:57

        Message_Source_Name: XXXXXXXXXXXXXXXXXXXX

        Event_Name: OnError

        Message: ExtractContact_Ulysses:Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.

An OLE DB record is available.  Source: "OraOLEDB"  Hresult: 0x80004005  Description: "ORA-01005: null password given; logon denied".

Please advise.

解决方案

Hi AshutoshAtre,

You likely need to just re-key the credentials to the package connection managers Open these up from withing the Catalog and/or job

这篇关于“ORA-01005：给出空密码;登录被拒绝“尝试时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！