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@xxxxxxxxx> 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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxx> wrote:
https://medium.com/@FranckPachot/19c-ezconnect-and-wallet-easy-connect-and-external-password-file-8e326bb8c9f5
Hi.
I quick Google and I got this.
https://oracle-base.com/articles/vm/oracle-cloud-autonomous-transaction-processing-atp-create-service#connecting-to-the-atp-service
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@xxxxxxxxxxxxxxx> 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.
wrote:
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@xxxxxxxxx>
wrote:
Well that would explain things.
On Tue, May 7, 2019 at 4:49 PM Seth Miller <sethmiller.sm@xxxxxxxxx>
cstephens16@xxxxxxxxx> wrote:
I think that is only for TLS, not for password store.
On Tue, May 7, 2019 at 3:27 PM Chris Stephens <
can't figure out how to pass the name of the credential in addition to the
19c allows you to specify wallet location w/ ezconnect but I
wallet location. I've tried every iteration i can think of.
docs to show credential name that I can tell.
has anyone had any luck with this? can you post generic syntax?
how dare you Tim!! :)
i can't believe oracle-base doesn't have an article on this yet.
thanks!