External password stores are useful in situations in which you want to prevent the connection credentials from being exposed in scripts or application code. In this recipe, we will create a password store that will contain the password for the HR
user.
The steps in this recipe will be performed on the HACKDB
database and the client node nodeorcl5
.
During this recipe, we will use the mkstore
utility for wallet management:
Create the wallet by using the
mkstore
utility. Usely8T%QX;r
for the wallet password as follows:mkstore -wrl /security/wallets/pass_store -create Oracle Secret Store Tool : Version 11.2.0.3.0 - Production Copyright (c) 2004, 2011, Oracle and /or its affiliates. All rights reserved. Enter password: Enter password again:
Create a net service name used for working with the password store, as follows:
HACKDB_PASS_STORE = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL ...