Skip to Main Content

Oracle Developer Tools for Visual Studio

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Trouble with Oracle Wallet specifically via the .Net ODBC Data Provider

For custom fetchsize reasons, I'd like to get the .Net Provider\ODBC Data Provider working for an Oracle connection that uses an Oracle Wallet. This would be a connection from Visual Studio, but anything using ADO.NET would apply, such as the Import/Export wizard.

I'm able to connect fine to that Wallet-using database via SQL Plus, standard ODBC, SQL Developer (Native driver), and from Visual Studio using the ODP.Net managed and unmanaged drivers, but I can't connect using specifically the ODBC Data Provider where wallets are involved. (Sidenote: ODBC Data provider works fine for other on-prem Oracle databases where not wallet is involved.)

As far as why, it's because I have a remote database I must connect to for large scale downloads. Setting the FETCHSIZE to a very high value works wonders for that remote database, but the only way to set Fetchsize for the ODP.Net managed/unmanaged driver is server-wide. There's some risk to that change, and I doubt I'll persuade people to make that change to our busy and heavily used (for lots of other db connections too) server.

ODBC drivers, however, provides a connection by connection way to set Fetchsize. If I could get it working, I could have the best of both worlds.

My problem is, It doesn't work. Although I do get an ORA-29024, turning trace on shows things like below, which I believe are happening before (aka these are the root cause of the ORA-29024.)

(21732) [16-OCT-2024 18:54:50:532] SSL_Alert: write - fatal - unknown certificate authority
(21732) [16-OCT-2024 18:54:50:532] SSL_Alert: write - fatal - unknown certificate authority
(21732) [16-OCT-2024 18:54:50:532] SSL_Info: error in SSL3 certificate verify A
(21732) [16-OCT-2024 18:54:50:532] nzos_Handshake: Handshake returned failure code -1
(21732) [16-OCT-2024 18:54:50:532] nzos_Handshake: Handshake error(cb=0,rc=0,rer=1,ser=336134278) - error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed
(21732) [16-OCT-2024 18:54:50:532] nzos_ContextDetails: Dumping the NZ context details

I do have environment variables for ORACLE_HOME and TNS_Admin, and during my troubleshooting, I feel safe in saying it isn't permission to those folders. (I've gone to some extremes making sure of that.) Any thoughts or suggestions?

This post has been answered by John_in_Florida_5646 on Oct 17 2024
Jump to Answer
Comments
Post Details
Added on Oct 17 2024
2 comments
62 views