Hello All,
I've create an oracle wallet and everything works fine so long as a script is lauched by the user OS oracle. (same user the one the one who created the store)
I use external store authentication and inside my script I do somethign like a sqlplus /@MYSECURE_TNS.
However, when i launch a script another OS user such a "data_loading_user" I get the error: Oracle Database Vault connection error ORA-12578: TNS:wallet open failed
I woudl like to know, how I can enable any user on the localhost to access the secure wallet to connect to the database.
Here my current ENV:
==================
Oracle Linux 6.5
Oracle Standard One 11.2.0.4
Oracle Webtier 11g
Database and thin client SQLNET.ORA
=============================
SQLNET.WALLET_OVERRIDE = TRUE
SSL_CLIENT_AUTHENTICATION = FALSE
SSL_VERSION = 0
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = /u01/app/oracle/owm/wallets)
)
)
Thanks in advance for any assistance.
JS