select * from v$encryption_wallet
mkdir -p /home/oracle/wallet
export TNS_ADMIN=/u01/app/oracle/product/19.0.0/dbhome_1/network/admin
Add the following entries into the client "/u01/app/oracle/product/19.0.0/dbhome_1/network/admin" file, with your preferred wallet location.
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = /home/oracle/wallet)
)
)
SQLNET.WALLET_OVERRIDE = TRUE
SSL_CLIENT_AUTHENTICATION = FALSE
SSL_VERSION = 0
orapki wallet create -wallet "/home/oracle/wallet" -pwd "password" -auto_login_local
or
mkstore -wrl "/home/oracle/wallet" -create
mkstore -wrl "/home/oracle/wallet" -createCredential orcl test test
mkstore -wrl "/home/oracle/wallet" -createCredential orcl2 test2 test2
mkstore -wrl "/home/oracle/wallet" -listCredential
mkstore -wrl <wallet_location> -modifyCredential <dbase_alias> <username> <password>
mkstore -wrl <wallet_location> -deleteCredential <db_alias>
Connection syntax "/@db_alias"
sqlplus /@orcl
sqlplus /@orcl2
