Re: is it possible to use and oracle wallet w/ ezconnect?

Hi,
Yes, you can but a wallet entry is dedicated to a user, so it is difficult to differentiate with EZConnect.
Except maybe in 19 as in this example:
https://medium.com/_at_FranckPachot/19c-ezconnect-and-wallet-easy-connect-and-external-password-file-8e326bb8c9f5?source=friends_link&sk=cad0ffda90ee7ae8a0c5a920924021a9 Regards,
Franck.

On Thu, Apr 4, 2019 at 9:08 PM Andy Klock <andy_at_oracledepot.com> wrote:

> I couldn't think of any reason why EZConnect wouldn't work so I ran a
> quick.
>
> Each credential (TNS entry) needs to be unique.
>
> C:\Users\Andy>sqlplus andy/andypass_at_dbhost:1521/db1.usps.gov
>
> SQL*Plus: Release 12.1.0.1.0 Production on Thu Apr 4 14:59:57 2019
>
> Copyright (c) 1982, 2013, Oracle. All rights reserved.
>
> Last Successful login time: Thu Apr 04 2019 12:08:52 -04:00
>
> Connected to:
> Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
>
> SQL> exit
> Disconnected from Oracle Database 18c Enterprise Edition Release
> 18.0.0.0.0 - Production
>
> C:\Users\Andy>mkstore -wrl C:/oracle/wallet -createCredential dbhost:1521/
> db1.usps.gov andy andypass
> Oracle Secret Store Tool : Version 12.1.0.1
> Copyright (c) 2004, 2012, Oracle and/or its affiliates. All rights
> reserved.
>
> Enter wallet password:
>
> Create credential oracle.security.client.connect_string51
>
> C:\Users\Andy>sqlplus _at_/dbhost:1521/db1.usps.gov
>
> SQL*Plus: Release 12.1.0.1.0 Production on Thu Apr 4 15:00:43 2019
>
> Copyright (c) 1982, 2013, Oracle. All rights reserved.
>
> Last Successful login time: Thu Apr 04 2019 14:59:58 -04:00
>
> Connected to:
> Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
>
> SQL>
>
>
>
>
> On Thu, Apr 4, 2019 at 2:56 PM Chris Stephens <cstephens16_at_gmail.com>
> wrote:
>
>> but there doesn't appear to be a way to use the same credential against
>> different host/port/service correct?
>>
>> On Thu, Apr 4, 2019 at 1:49 PM Chris Stephens <cstephens16_at_gmail.com>
>> wrote:
>>
>>> ah! you can store the connection string AS the credential name and it
>>> work w/out tns entry.
>>>
>>> mkstore -wrl scott_wallet -createCredential
>>> \(DESCRIPTION=\(ADDRESS=\(PROTOCOL=tcp\)\(HOST=yourHost\)\(PORT=1521\)\)\(CONNECT_DATA=\(SERVICE_NAME=orcl\)\)\)
>>> scott tiger
>>>
>>> On Thu, Apr 4, 2019 at 1:12 PM Chris Stephens <cstephens16_at_gmail.com>
>>> wrote:
>>>
>>>> we would like to be able to specify host/port/service in the connection
>>>> string as w/ easy connect but still use a wallet.
>>>>
>>>> i don't think that's possible after some googling and documentation
>>>> reading but wanted to confirm with others.
>>>>
>>>> thanks for feedback!
>>>>
>>>>
>>>>

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