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!

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.

wallet_location in ODP Managed Provider config has no effect

Niels JespersenNov 25 2015 — edited Jan 15 2016

Hello all

Has anyone had any luck specifying the location of an Oracle Wallet in the configuration  of the managed provider. I can get Oracle Wallets working with both the managed provider and the unmanaged one, but only by specifying wallet_location in sqlnet.ora.

The setting in e.g. the configuration for managed provider does not seem to have any effect. My working example stops to work if i remove wallet_location from sqlnet.ora. c:\snot\wallet includes ewallet.p12, cwallet.sso, ewallet.lck, and cwallet.lck These were made using mkstore -create and mkstore -createcredential. The wallet works, if just sqlnet.ora references it, but I would rather prefer this configuration to be app-specific.

Here is my config, just for reference:

<?xml version="1.0" encoding="utf-8" ?>

<configuration>

  <oracle.manageddataaccess.client>

    <version number="4.121.2.0">

      <settings>

        <setting name="WALLET_LOCATION" value="(SOURCE = (METHOD = FILE)(METHOD_DATA =(DIRECTORY = c:\snot\wallet)))"/>

        <setting name="TNS_ADMIN" value="c:\snot" />

      </settings>

    </version>

  </oracle.manageddataaccess.client>

</configuration>

Regards Niels Jespersen
This post has been answered by Niels Jespersen on Nov 26 2015
Jump to Answer

Comments

Alex Keh-Oracle

Are you seeing any ODP.NET or Oracle errors, such as ORA-01017 invalid password?

Is this for ODP.NET from ODAC 12c Release 4?

1 person found this helpful
Niels Jespersen

If I point tns_admin in my configuration to a location, where sqlnet.ora has a wallet_location, it reads username, password from the wallet and logs on. If tns_admin points to a location where sqlnet.ora has no wallet_location, then logon fails with ORA-1017, as it tries external logon and my windows user has no counterpart on Oracle that is identified externally. Since tns_admin is interpreted correctly, I conclude that my configuration-file is read ok.

Yes, this is ODAC 12c Release 4. The Productversion of Oracle.managedDataAccess.dll is 4.121.2.20150926 ODAC RELEASE 4.

I am on Windows 7 Enterprise x64, and my .net-project is compiled as x64. ODAC is installed/configured both as x86 and x64.

Niels Jespersen
Answer

Added details, found out that wallet_override fooled me.

If sqlnet.wallet_override = true is in sqlnet.ora then  wallet_location in the config seems to work.  Now I just need support for wallet_override in the .net config. That is not there, as of now, is it? 

Regards Niels

Marked as Answer by Niels Jespersen · Sep 27 2020
1 person found this helpful
Alex Keh-Oracle

WALLET_OVERRIDE is not yet supported in the .NET config.

1 person found this helpful
Niels Jespersen

Thank you for helping me get to the bottom of this. I will consider if I dare put wallet_override=true in a sqlnet.ora shared between 600 users. I may end up doing that and hoping it it will not break anything (I don't think it will).

I consider this resolved.

Regards Niels Jespersen

Alex Keh-Oracle

I need to correct myself. WALLET_OVERRIDE is supported. Oracle just hasn't documented it yet. That will be done with the next iteration of the doc.

The config file should like the following:

<?xml version="1.0" encoding="utf-8" ?>

<configuration>

  <oracle.manageddataaccess.client>

  <version number="*">

  <settings>

  <setting name="sqlnet.WALLET_OVERRIDE" value="true"/>

  </settings>

  </version>

  </oracle.manageddataaccess.client>

</configuration>

2 people found this helpful
Niels Jespersen

Wow. Cool. I will try this out.

/Niels

Niels Jespersen

Wallet.override works like a charm. Great!

Best Regards Niels Jespersen

1 - 8
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 12 2016
Added on Nov 25 2015
#odp-net
8 comments
3,442 views