Re: 19c ezconnect and wallets

Hi,
With the jdbc driver >= 18.3 you can even pass the ?TNS_ADMIN= as a parameter in the url to provide the wallet location. If you have a wallet from the oracle cloud, you can mention its directory with this syntax and you can even add your passwords in the provided wallet. Then you provide a wallet to unzip and a connection url to point to it. Franck.

On Wed, May 8, 2019 at 2:21 PM Chris Stephens <cstephens16_at_gmail.com> wrote:

> 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