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

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