Re: 19c ezconnect and wallets

Thanks Tim/Seth! Yeah, the goal would be to get rid of tnsnames.ora and sqlnet.ora an just provide the wallet and connection string details to our users. Anything to make the process simpler for them, makes life simpler for me. :)

chris

On Wed, May 8, 2019 at 4:37 AM Tim Hall <tim_at_oracle-base.com> wrote:

> But that still requires sqlnet.ora and TNS_ADMIN, which I guess you
> are trying to avoid. :)
>
> On Wed, May 8, 2019 at 10:25 AM Tim Hall <tim_at_oracle-base.com> wrote:
> >
> > 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