Home » RDBMS Server » Security » Oracle wallet with Instant Client (Oracle 11gR1 (11.1.0.7), REHL 5.5)
Oracle wallet with Instant Client [message #557397] Tue, 12 June 2012 07:59 Go to next message
santoshorcl
Messages: 24
Registered: August 2007
Location: pune
Junior Member

Hi Friends,
In my organization I have suggested oracle wallet to store passwords instead of hard coding with cofig file, code etc. here all applications connecting with oracle through instant clients. I have some basic questions on Oracle wallet.
1] does oracle wallet comes with Oracle Instant client or I need full Oracle client installation?
2] is there anyway to use Oracle wallet with instant client? i.e. any binary etc.

Please give me any link, doc related with this.

Env: Oracle 11gR1, REHL

Your quick response is highly appreciated.

Thanks in advance.

Santoshkumar.
Re: Oracle wallet with Instant Client [message #557404 is a reply to message #557397] Tue, 12 June 2012 08:20 Go to previous messageGo to next message
Michel Cadot
Messages: 58612
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1] I don't know but you don't need the full client to use the wallet.
2] As long as you use tnsnames.ora (and sqlnet.ora) for your connection string you can use the wallet.

Regards
Michel
Re: Oracle wallet with Instant Client [message #557475 is a reply to message #557404] Wed, 13 June 2012 01:29 Go to previous messageGo to next message
santoshorcl
Messages: 24
Registered: August 2007
Location: pune
Junior Member

Thanks a lot Michel.

I'll try to configure wallet with existing setup. update this post once done.
Thanks again.
Re: Oracle wallet with Instant Client [message #559152 is a reply to message #557475] Fri, 29 June 2012 04:47 Go to previous message
santoshorcl
Messages: 24
Registered: August 2007
Location: pune
Junior Member

Instant client does not come with wallet required binaries. Hense you have to create wallet store+entries on any server and client and move files on client machindes. and move files on client. see following:

1] on server
mkstore -wrl "/etc/oraWallet" -create

2] mkstore -wrl "<wallet file locaiton>" -createCredential tnsalise username password

3] sqlnet.ora entry on client
SQLNET.ORA
==============
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = /etc/oraWallet)
)
)

SQLNET.WALLET_OVERRIDE = TRUE
SSL_CLIENT_AUTHENTICATION = FALSE
SSL_VERSION = 0


4] add entry with tnsnames.ora with tnsalise

tnsalise =
(DESCRIPTION =
(LOAD_BALANCE = ON)
(FAILOVER = ON)
(ADDRESS = (PROTOCOL = TCP)(HOST = prodbox00-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = prodbox01-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = prod01)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 20)
(DELAY = 1)
)
)
)

5] use with sql
sqlplus /@tnsalise

regards,
Santoshkumar.
Previous Topic: Fine-Grained Audit issue
Next Topic: Truncate aud$ table
Goto Forum:
  


Current Time: Tue Jul 29 14:34:32 CDT 2014

Total time taken to generate the page: 0.08025 seconds