Here I try to explain most simple and short way to login with a oracle wallen / without password.
create wallet:
mkstore -wrl
configure client side sqlnet.ora:
SQLNET.WALLET_OVERRIDE = TRUE
WALLET_LOCATION=(
SOURCE=(METHOD=FILE) (METHOD_DATA=(DIRECTORY=
)
configure tns alias in tnsnames.ora:
mydbservice_al.example.ch =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1.example.ch)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mydbservice.achat.example.ch)
)
)
If the oracle instant client is used the location of sqlnet.ora and tnsnames.ora needs to defined with the TNS_ADMIN environment variable .
example::
LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib
TNS_ADMIN=/etc/oracle/tnsnames