Re: 19c ezconnect and wallets

Hi.

I quick Google and I got this.

https://medium.com/_at_FranckPachot/19c-ezconnect-and-wallet-easy-connect-and-external-password-file-8e326bb8c9f5

So it seems possible prior to 19c, but it's easier in 19c.

Cheers

Tim...

On Wed, May 8, 2019 at 10:14 AM Tim Hall <tim_at_oracle-base.com> wrote:
>
> 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