Skip to Main Content
Forums

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

EF Core 3.1 - Exception when trying to use TnsAdmin

TridusAug 26 2020 — edited Sep 18 2020

I'm getting the following error when trying to set a TnsAdmin path: OracleConfiguration.TnsAdmin = @"c:\oracle\client\19c\network\admin";

System.IO.FileNotFoundException

  HResult=0x80070002

  Message=Could not load file or assembly 'System.DirectoryServices.Protocols, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. The system cannot find the file specified.

  Source=Oracle.ManagedDataAccess

  StackTrace:

   at OracleInternal.Network.LDAP..ctor(SqlNetOraConfig SNOConfig, Hashtable ObLdapHT)

   at OracleInternal.Network.AddressResolution.SetNewLDAP(Hashtable SQLNetHT, Hashtable LdapHT)

   at Oracle.ManagedDataAccess.Client.OracleConfiguration.set_TnsAdmin(String value)

   at GNB.ELG.WellVoucher.Website.External.Startup.ConfigureServices(IServiceCollection services) in C:\workarea\Startup.cs:line 32

   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor, Boolean wrapExceptions)

   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

   at Microsoft.AspNetCore.Hosting.ConfigureServicesBuilder.InvokeCore(Object instance, IServiceCollection services)

   at Microsoft.AspNetCore.Hosting.ConfigureServicesBuilder.<>c__DisplayClass9_0.<Invoke>g__Startup|0(IServiceCollection serviceCollection)

   at Microsoft.AspNetCore.Hosting.ConfigureServicesBuilder.Invoke(Object instance, IServiceCollection services)

   at Microsoft.AspNetCore.Hosting.ConfigureServicesBuilder.<>c__DisplayClass8_0.<Build>b__0(IServiceCollection services)

   at Microsoft.AspNetCore.Hosting.GenericWebHostBuilder.UseStartup(Type startupType, HostBuilderContext context, IServiceCollection services)

   at Microsoft.AspNetCore.Hosting.GenericWebHostBuilder.<>c__DisplayClass12_0.<UseStartup>b__0(HostBuilderContext context, IServiceCollection services)

   at Microsoft.Extensions.Hosting.HostBuilder.CreateServiceProvider()

   at Microsoft.Extensions.Hosting.HostBuilder.Build()

   at GNB.ELG.WellVoucher.Website.External.Program.Main(String[] args) in C:\workarea\Program.cs:line 16

This is a brand new ASP.net Core 3.1 project that isn't really doing much of anything yet. Scaffolding the dbcontext from the database works fine, however trying to run the project results in this error.

I've got the same thing in an ASP.net Core 2 project and that works without issue pointing to the same path, so I'm not sure what changed. I don't have an ldap.ora defined at all, and sqlnet.ora is as follows:

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES)

SQLNET.CRYPTO_SEED = "X"

NAMES.DEFAULT_DOMAIN = X

NAME.DEFAULT_ZONE = X

Thanks

Message was edited by: Tridus (removed beta tag as it is still an issue in production)
This post has been answered by Alex Keh-Oracle on Oct 22 2020
Jump to Answer

Comments

User_LYSW0

I'm facing the same issue after 20.2 upgrade as well..

1 person found this helpful
Answer

Hi,
Thanks for reporting this, and apologies for the delay in responding. This was easy to reproduce, and I've filed bug #32122067 to track it. We'll also update the thread with any workaround, when we have it.
Regards,
Anthony

Marked as Answer by tvbishan · Nov 6 2020
Tim Kimberl-Oracle

Until this is patched, here is a temporary bit of css you can add to your app to fix this issue.

.a-GV-columnItem .apex-item-group--auto-complete {
  display: flex;
}

.a-GV-columnItem .apex-item-group--auto-complete .oj-form-control,
.a-GV-columnItem .apex-item-group--auto-complete .oj-inputsearch-choice {
  display: flex;
  flex-grow: 1;
}

Thanks,
Tim

1 person found this helpful
User_Y6MKJ 
Hello, I would like to know how I apply the code above, 
through the page itself in the CSS part and call the class in the Css Classes of the column, 
or in the General theme?

Sincerely, Mariangela

Leon_M

Copy and paste the code in your Page Inline CSS

User_Y6MKJ

Thank you!

Leon_M

@tim-kimberl-oracle Thanks for the fix!
Can you also have a look at another issue with autocomplete please:
https://community.oracle.com/tech/developers/discussion/4483380/apex-20-2-autocomplete-issue-need-solution#latest

1 - 7

Post Details

Added on Aug 26 2020
#odp-net
13 comments
1,181 views