ORACLE WALLET

Hello Firend's,

In This post we will discuss about the steps to create and configure oracle wallet.

so let's get started.

Step1 :

cd $ORACLE_HOME/bin

ORACLE_HOME : /oracle/app/orawork/product/12.1.0.2/db_1/bin

Method 1 : 
[oracle@dm01db01 bin]$ orapki wallet create -wallet /oracle/app/orawork/db_wallet -pwd Password1 -auto_login_local
Oracle PKI Tool : Version 12.1.0.1
Copyright (c) 2004, 2012, Oracle and/or its affiliates. All rights reserved.


Method 2 : 

[oracle@dm01db02 admin]$ mkstore -wrl /oracle/app/orawork/db_wallet -create
Oracle Secret Store Tool : Version 12.1.0.1
Copyright (c) 2004, 2012, Oracle and/or its affiliates. All rights reserved.

Enter password:
Enter password again:

Files created after running the command for orapki :

[oracle@dm01db01 bin]$ cd /oracle/app/orawork/db_wallet
[oracle@dm01db01 db_wallet]$
[oracle@dm01db01 db_wallet]$ ls -ltr
total 8
-rw-------. 1 oracle oinstall    0 Jul  9 12:24 ewallet.p12.lck
-rw-------. 1 oracle oinstall 2856 Jul  9 12:24 ewallet.p12
-rw-------. 1 oracle oinstall    0 Jul  9 12:24 cwallet.sso.lck
-rw-------. 1 oracle oinstall 2901 Jul  9 12:24 cwallet.sso

Step 2: ##Display Wallet Information:

[oracle@dm01db01 db_wallet]$ orapki wallet display -wallet /oracle/app/orawork/db_wallet
Oracle PKI Tool : Version 12.1.0.1
Copyright (c) 2004, 2012, Oracle and/or its affiliates. All rights reserved.

Requested Certificates:
User Certificates:
Trusted Certificates:
Subject:        OU=Class 2 Public Primary Certification Authority,O=VeriSign\, Inc.,C=US
Subject:        OU=Class 3 Public Primary Certification Authority,O=VeriSign\, Inc.,C=US
Subject:        CN=GTE CyberTrust Global Root,OU=GTE CyberTrust Solutions\, Inc.,O=GTE Corporation,C=US
Subject:        OU=Class 1 Public Primary Certification Authority,O=VeriSign\, Inc.,C=US

Change Wallet Password :

[oracle@dm01db01 db_wallet]$ orapki wallet change_pwd -wallet /oracle/app/orawork/db_wallet -oldpwd Password1 -newpwd Qwas#zx12
Oracle PKI Tool : Version 12.1.0.1
Copyright (c) 2004, 2012, Oracle and/or its affiliates. All rights reserved.

[oracle@dm01db01 db_wallet]$

Enter wallet information in your sqlnet.ora

WALLET_LOCATION =
   (SOURCE =
     (METHOD = FILE)
     (METHOD_DATA =
       (DIRECTORY = /oracle/app/orawork/db_wallet)
     )
   )
SQLNET.WALLET_OVERRIDE = TRUE
SSL_CLIENT_AUTHENTICATION = FALSE
SSL_VERSION = 0

Add database to wallet :

[oracle@dm01db01 admin]$ mkstore -wrl /oracle/app/orawork/db_wallet -createCredential Findb1 SYS
Oracle Secret Store Tool : Version 12.1.0.1
Copyright (c) 2004, 2012, Oracle and/or its affiliates. All rights reserved.

Your secret/Password is missing in the command line
Enter your secret/Password:   Qwas#z
Re-enter your secret/Password:   Qwas#z

Enter wallet password:   Qwas#z

Create credential oracle.security.client.connect_string1

Commnad to modify credential of database :

[oracle@dm01db01 admin]$  mkstore -wrl /oracle/app/orawork/db_wallet -modifyCredential Findb1 SYS
Oracle Secret Store Tool : Version 12.1.0.1
Copyright (c) 2004, 2012, Oracle and/or its affiliates. All rights reserved.

Your secret/Password is missing in the command line
Enter your secret/Password:
Re-enter your secret/Password:

Enter wallet password:   Qwas#z
Modify credential
Modify 1

Command to list credential

[oracle@dm01db01 admin]$ mkstore -wrl /oracle/app/orawork/db_wallet -listCredential
Oracle Secret Store Tool : Version 12.1.0.1
Copyright (c) 2004, 2012, Oracle and/or its affiliates. All rights reserved.

Enter wallet password:   Qwas#z
List credential (index: connect_string username)
1: Findb1 SYS

• Tweet
• Share
• Share
• Share
• Share

Related Post