Friday, August 15, 2008

Oracle External Password Store

sqlplus xxx/yyy@qd01bie1

#sqlnet.ora

WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = /opt/oracle/product/10.2.0/db_1/network/admin)
)
)

SQLNET.WALLET_OVERRIDE = TRUE
SSL_CLIENT_AUTHENTICATION = FALSE
SSL_VERSION = 0

# create the wallet

mkstore -wrl "/opt/oracle/product/10.2.0/db_1/network/admin" -create
Enter password:
Enter password again:

# add the login entry
mkstore -wrl "/opt/oracle/product/10.2.0/db_1/network/admin" -createCredential qd01bie1 xxx yyy
Enter password:
Create credential oracle.security.client.connect_string2

# list the entry

mkstore -wrl "C:\app\rgeier\product\11.1.0\db_1\network\admin" -listCredential

# test the login

[prod-oranode-50:qd01bie1]$ sqlplus /@qd01bie1

SQL*Plus: Release 10.2.0.3.0 - Production on Wed Jul 30 12:15:47 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL>


http://www.oracle-base.com/articles/10g/SecureExternalPasswordStore_10gR2.php