Re: 19c ezconnect and wallets

Hi.

You can use a tnsnames.ora file with SQLcl or the instant client. You don't need the full client. You just point to the location of the config files using TNS_ADMIN.

https://oracle-base.com/articles/misc/sqlcl-installation#tns_admin

If you need to use a wallet for the connection, then you just use this method, and put the relevant config sqlnet.ora and tnsnames.ora in that location. Obviously, the sqlnet.ora will explain where the wallet is. This is essentially what you do when connecting to Oracle Cloud service from SQL*Plus or SQLcl. That's explained here.

https://oracle-base.com/articles/vm/oracle-cloud-autonomous-transaction-processing-atp-create-service#connecting-to-the-atp-service

Never tried to do this from the EZ connect string directly. Not sure it's possible. Maybe too many working parts involved. I'll take a look, but I suspect Seth is correct here. He usually is. :)

Cheers

Tim...

On Tue, May 7, 2019 at 10:53 PM Chris Stephens <cstephens16_at_gmail.com> wrote:
>
> Well that would explain things.
>
> On Tue, May 7, 2019 at 4:49 PM Seth Miller <sethmiller.sm_at_gmail.com> wrote:
>>
>> I think that is only for TLS, not for password store.
>>
>>
>>
>>
>>
>> On Tue, May 7, 2019 at 3:27 PM Chris Stephens <cstephens16_at_gmail.com> wrote:
>>>
>>> 19c allows you to specify wallet location w/ ezconnect but I can't figure out how to pass the name of the credential in addition to the wallet location. I've tried every iteration i can think of.
>>>
>>> has anyone had any luck with this? can you post generic syntax? docs to show credential name that I can tell.
>>>
>>> i can't believe oracle-base doesn't have an article on this yet. how dare you Tim!! :)
>>>
>>> thanks!
>>>

--
http://www.freelists.org/webpage/oracle-l