netappcore3.1
dotnet add package Oracle.ManagedDataAccess.Core
рабочий пример строки соединения C# для тестового пользователя hr.
string ConnectionString = "Data Source=//localhost:1521/orclpdb; User Id=hr; Password=hr;";
sqlora.net
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
tsnnames.ora
ORCLPDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orclpdb)
)
)