Oracle Wallet configuration


10 May

Set Oracle environment variables

ORACLE_HOME

ORACLE_SID

PATH

[oracle@rac-nodea /u01/app/oracle/admin/scripts/18/wallet/rac-nodea]$ export ORACLE_HOME=/u01/app/oracle/product/18/dbhome_1
[oracle@rac-nodea /u01/app/oracle/admin/scripts/18/wallet/rac-nodea]$ export ORACLE_SID=orclrac1
[oracle@rac-nodea /u01/app/oracle/admin/scripts/18/wallet/rac-nodea]$ export PATH=$ORACLE_HOME/bin:$PATH

Create wallet

[oracle@rac-nodea /u01/app/oracle/admin/scripts]$ cd /u01/app/oracle/admin/scripts/18/wallet/`uname -n | cut -f 1 -d "."`
[oracle@rac-nodea /u01/app/oracle/admin/scripts/18/wallet/rac-nodea]$ orapki wallet create -wallet . -auto_login_local
Oracle PKI Tool Release 18.0.0.0.0 - Production
Version 18.1.0.0.0
Copyright (c) 2004, 2017, Oracle and/or its affiliates. All rights reserved.


Enter password:
Enter password again:
Operation is successfully completed.


Check destination database connection

[oracle@rac-nodea /u01/app/oracle/admin/scripts/18/wallet/rac-nodea]$ export TNS_ADMIN=/u01/app/oracle/admin/scripts/18/tnsadmin
[oracle@rac-nodea /u01/app/oracle/admin/scripts/18/wallet/rac-nodea]$ tnsping orcl


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = host-orcl)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))
OK (10 msec)

Add connection entry in wallet

[oracle@rac-nodea /u01/app/oracle/admin/scripts/18/wallet/rac-nodea]$ cd /u01/app/oracle/admin/scripts/18/wallet/`uname -n | cut -f 1 -d "."`
[oracle@rac-nodea /u01/app/oracle/admin/scripts/18/wallet/rac-nodea]$ mkstore -wrl . -createCredential orcl orcl_user
Enter wallet password:
[oracle@rac-nodea /u01/app/oracle/admin/scripts/18/tnsadmin]$ export TNS_ADMIN=/u01/app/oracle/admin/scripts/18/tnsadmin

Configure wallet access

[oracle@rac-nodea /u01/app/oracle/admin/scripts/18/tnsadmin]$ vi sqlnet.ora
SQLNET.EXPIRE_TIME=10
SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 12
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 12

SQLNET.WALLET_OVERRIDE=TRUE
WALLET_LOCATION=
        (SOURCE=
                (METHOD=FILE)
                        (METHOD_DATA=(DIRECTORY=/u01/app/oracle/admin/scripts/18/wallet/rac-nodea)
                        )
        )



Comments
* The email will not be published on the website.