BizTalk Adapter Pack for Oracle:Connecting to the LOB system has failed.ORA-1017: invalid name/password
i try to add generated item for the oracle lob adapter and get this error: Connecting to the LOB system has failed.ORA-1017: invalid name/password
After a lot of searching I found the problem:
User name. The Oracle Database adapter preserves the case of the value that you enter for the user name when it opens a connection on the Oracle database. User names on the Oracle database are case-sensitive. You should ensure that you provide Oracle user names to the Oracle Database adapter in the case expected by your Oracle database. Typically, this means that the user name in the SCOTT/TIGER credential should be upper case: "SCOTT".
原来是要求用户名必须大写
from:http://itaitzur.blogspot.com/2008/08/connecting-to-lob-system-has-failedora.html
SqlPlus converts the username/password to upper case by default, while in the adapter, we don't convert them to upper case. Can you try specifying the username and/or password in upper case in the adapter and see if that works?
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步