Oracle 19 User Interface Authentication using ODP.Net Core

Asked

Viewed 22 times

0

We are developing an . Net Core 3.1 application that connects to an Oracle 19 database. During authentication with an Oracle User Enterprise we are receiving the following error: "ORA-01017: invalid username/password; logon denied". I have created a small program to test this behavior. I am using Oracle.ManagedDataAccess.Core (2.19.90) as Provider.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace TestConsoleCore
{
    class Program
    {
        const string dataSource = "(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = schema.example.com)(PORT = 1522))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = service.example.com)))";
        const string userID = "user.test";
        const string password = "password";


        static string connectionString;
        static void Main(string[] args)
        {

            connectionString = string.Format("Data Source={0};User ID={1};Password={2}", dataSource, userID, password);

            var con = new Oracle.ManagedDataAccess.Client.OracleConnection(connectionString);
            {
                con.Open();
            }
        }
    }
}

If authenticating me with a normal database user works perfectly.

We also successfully authenticate with both users with this implementation of system.data.oracleclient for . Net Core. But we have some problems with mapping some DB types.

Someone’s had this problem before?

  • Have you checked if you are mounting the Connectionstring correctly? can log in with it in an udl, for example?

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.