与ODP.Net连接的ORA-01005错误 [英] ORA-01005 error connecting with ODP.Net

问题描述

我正在尝试使用以下代码访问Oracle数据库(版本10.2.0.4.0)，但是在调用open方法时，连接会引发"ORA-01005:提供空密码；拒绝登录"异常.

I am trying to access an Oracle database (version 10.2.0.4.0) using the following code but an "ORA-01005: Null password given; logon denied" exception is raised by the connection when it's open method is called.

        var connBuilder = new OracleConnectionStringBuilder();
        connBuilder.DataSource = "(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = MyHost.Address)(PORT = ####)) )(CONNECT_DATA =(SERVICE_NAME = MyService)))";
        connBuilder.UserID = "validUserId";
        connBuilder.Password = "validPassword";
        connBuilder.PersistSecurityInfo = true;
        var connString = connBuilder.ToString();
        using (var con = new OracleConnection(connString))
        {
            con.Open();
        }

如果更改用户名，则会收到以下消息； "ORA-01017:无效的用户名/密码；登录被拒绝"，如果我使用con.OpenWithNewPassword("validPassword");

If I change the username then I receive the following instead; "ORA-01017: invalid username/password; logon denied" and this is also the case if I change the open call on the connection with con.OpenWithNewPassword("validPassword");

如果我尝试使用不建议使用的Oracle客户端，那么它将毫无问题地连接:

If I try with the deprecated Oracle client it connects with no problems:

        using (var depCon = new System.Data.OracleClient.OracleConnection
           ("Data Source=MyHost.Address:####/MyService;Persist Security Info=True;
             User ID=validUsername;Password=validPassword;Unicode=True"))
        {
            depCon.Open();
        } 

(显然)我想使用最新的Odp.Net驱动程序，但似乎无法解决此问题.有人有想法吗?

I'd (obviously) like to use the latest Odp.Net drivers but can't seem to get past this issue. Has anybody got any ideas?

推荐答案

在此线程中查看有关FIPS合规性的问题:

Take a look at this thread for an issue regarding FIPS compliance:

https://community.oracle.com/thread/2557592 ?start = 0& tstart = 0

也: Oracle.ManagedDataAccess和ORA-01017:无效的用户名/密码;登录被拒绝

这篇关于与ODP.Net连接的ORA-01005错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！