OraFAQ Forum: Security » Oracle wallet with Instant Client

Home » RDBMS Server » Security » Oracle wallet with Instant Client (Oracle 11gR1 (11.1.0.7), REHL 5.5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle wallet with Instant Client [message #557397]

Tue, 12 June 2012 07:59

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.

Report message to a moderator

Re: Oracle wallet with Instant Client [message #557404 is a reply to message #557397]

Tue, 12 June 2012 08:20

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Oracle wallet with Instant Client [message #557475 is a reply to message #557404]

Wed, 13 June 2012 01:29

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.

Report message to a moderator

Re: Oracle wallet with Instant Client [message #559152 is a reply to message #557475]

Fri, 29 June 2012 04:47

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.

Report message to a moderator

Previous Topic:	Fine-Grained Audit issue
Next Topic:	Truncate aud$ table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Mar 08 01:49:01 CST 2025