Hi, I try to authenticate on a remote database with an Oracle Wallet and connect via SQLcl 24.3:
# tnsnames.ora
tns_alias =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = host)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = service)
)
)
# sqlnet.ora
WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = /path/to/wallet)))
SQLNET.WALLET_OVERRIDE = TRUE
# ojdbc.properties
oracle.net.wallet_location=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=${TNS_ADMIN})))
sql -thin /@tns_alias throws ORA-01017 Authentication failed.
sql /@jdbc:oracle:thin:@tns_alias works
What am I missing? Is it a bug or am I using it wrong? @thatjeffsmith-oracle