13 Replies Latest reply on Oct 7, 2019 6:53 AM by user5317405

Connection error: The type initializer for 'OracleInternal.Network.AddressResolution

user5317405 Oct 1, 2019 7:47 AM

Hello,

After I upgraded to 19.3.2 I get:

"Error opening connection 'dev'.Details: The type initializer for 'OracleInternal.Network.AddressResolution' threw an exception."

It worked with previous version. I reinstalled .Net Core, but no success. Any idea what I am doing wrong?

OS: WIndows_NT x64 6.1.7601

Connection type: TNS alias or Basic

Thanks for your help.

1. Re: Connection error: The type initializer for 'OracleInternal.Network.AddressResolution

Christian.Shay -Oracle Oct 1, 2019 7:50 AM (in response to user5317405)

Could it be that you copied over a SQLNET.ORA?

If it is there, try removing LDAP from NAMES.DIRECTORY_PATH in SQLNET.ORA
Like Show 0 Likes(0)

Actions
2. Re: Connection error: The type initializer for 'OracleInternal.Network.AddressResolution

user5317405 Oct 1, 2019 8:02 AM (in response to Christian.Shay -Oracle)

It is and I have:
NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, ONAMES)

But I think the sqlnet.ora has been there before... I tried renaming it, but the error persist.
Like Show 0 Likes(0)

Actions
3. Re: Connection error: The type initializer for 'OracleInternal.Network.AddressResolution

Christian.Shay -Oracle Oct 1, 2019 3:10 PM (in response to user5317405)

Let's make sure the SQLNET.ORA and TNSNAMES.ORA you think you are using are what are actually being used:

In the list of extensions, find Oracle Developer Tools, then right click the "gear" icon and select Configure Extension Settings.

In the settings for ODT you will see: Network Configuration: Config Files Location

Using Windows Explorer or command line, go to the path location set there and see if there is a SQLNET.ORA and/or LDAP.ORA. If there is, temporarily rename the SQLNET.ORA and LDAP.ORA file name and restart Visual Studio Code.
Like Show 0 Likes(0)

Actions
4. Re: Connection error: The type initializer for 'OracleInternal.Network.AddressResolution

Christian.Shay -Oracle Oct 1, 2019 3:12 PM (in response to user5317405)

I just noticed that you seem to have said that you are also attempting to create a "Basic" connection (with just host, port, and service name). Is that true? Do you get the same error with a Basic connection?
Like Show 0 Likes(0)

Actions
5. Re: Connection error: The type initializer for 'OracleInternal.Network.AddressResolution

user5317405 Oct 2, 2019 11:43 AM (in response to Christian.Shay -Oracle)

Yes, I tried with no success. The error persists.

Same with basic connection, I made a new connection, hostname and servicename, default port..., it should work, but same error.

Even "Connection string" (Advanced conn)... no success, same error...
Like Show 0 Likes(0)

Actions
6. Re: Connection error: The type initializer for 'OracleInternal.Network.AddressResolution

user5317405 Oct 3, 2019 8:46 AM (in response to user5317405)

I downgraded to 19.3.1 and it works out of the box.
Like Show 0 Likes(0)

Actions
7. Re: Connection error: The type initializer for 'OracleInternal.Network.AddressResolution

Christian.Shay -Oracle Oct 3, 2019 9:27 AM (in response to user5317405)

Hm, this doesn't sound good.

Can you please let me know what is the path set in Network Configuration: Config Files Location?

Also, can you successfully ping the "Database Host Name" used in the basic connection? (I assume so because you can connect with 19.3.1)

Can you confirm you are using Windows? Is it Windows 7?
Like Show 0 Likes(0)

Actions
8. Re: Connection error: The type initializer for 'OracleInternal.Network.AddressResolution

user5317405 Oct 3, 2019 11:29 AM (in response to Christian.Shay -Oracle)

Config file location: C:/oracle/product/11.2.0/client_1/network/admin

I confirm that pinging works.

OS: WIndows_NT x64 6.1.7601 (Windows 7 Enterprise)

I am in the process of migrating to Windows 10, so hopefully it will work there.
Like Show 0 Likes(0)

Actions
9. Re: Connection error: The type initializer for 'OracleInternal.Network.AddressResolution

Christian.Shay -Oracle Oct 3, 2019 1:41 PM (in response to user5317405)

Thanks. I'm not sure if it matters, but you are using forward slashes in the path while Windows uses backslashes.

Can you try the following?

1) Change the config file location setting to the correct Wndows format (use backslashes), close VS Code and reopen it and try again.
2) Try creating a new directory, such as c:\odtvscode and copy only the tnsnames.ora file there. Change the config file location to point there (using backslashes). Close VS Code and reopen it and try again.
Like Show 0 Likes(0)

Actions
10. Re: Connection error: The type initializer for 'OracleInternal.Network.AddressResolution

user5317405 Oct 4, 2019 1:32 PM (in response to Christian.Shay -Oracle)

I cannot make it work.

I did exaclty as you suggested with Windows style path format, etc... TNS alias dropdown is succesfully populated (as it was before with old directory), but still fails with exact same error message.

I tried unnistalling and installing again, remove all settings, started from scratch... failed.
Like Show 0 Likes(0)

Actions
11. Re: Connection error: The type initializer for 'OracleInternal.Network.AddressResolution

Christian.Shay -Oracle Oct 4, 2019 1:52 PM (in response to user5317405)

I see what else I can find out we can try.

Is there anything else that is different in your configuration between the 19.3.1 install and the 19.3.2?

Are you running this in a Virtualbox VM and are reverting to a snapshot that still has 19.3.1 installed? Is that how you are "downgrading"?
Like Show 0 Likes(0)

Actions
12. Re: Connection error: The type initializer for 'OracleInternal.Network.AddressResolution

Christian.Shay -Oracle Oct 5, 2019 1:08 AM (in response to user5317405)

One additional request:

Can you zip up the *.log files generated in the %USERPROFILE%\.vscode\extensions\oracle.oracledevtools-19.3.2 directory and attach them to this thread, or email them to christian (dot) shay (at) oracle (dot) com?
Like Show 0 Likes(0)

Actions
13. Re: Connection error: The type initializer for 'OracleInternal.Network.AddressResolution

user5317405 Oct 7, 2019 6:53 AM (in response to Christian.Shay -Oracle)

There is nothing different in my environment. I downgraded with "Install Another Version..." command in VS Code.
No snapshots, VM or anything like that...
I sent logs by the mail.
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.