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@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 @/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@xxxxxxxxx> 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@xxxxxxxxx>
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@xxxxxxxxx>
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!