Sample Header Ad - 728x90

Configure wallet location in sqlnet.ora and listener.ora

0 votes
1 answer
3872 views
I have a host containing multiple DBs and the connection to the DBs need to be SSL enabled. Since each DB has a unique wallet, I specify the wallet location in sqlnet.ora as: WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=wallet_folder/$ORACLE_UNQNAME))) This way the listener can use the correct wallet depending on the value of ORACLE_UNQNAME variable. But I have two issues with this method. 1. Since ORACLE_UNQNAME is a shell environment variable a client has no control over it. 2. Even when connecting from the same machine I have to bounce the listener after exporting ORACLE_UNQNAME value. What is the solution for such a scenario ?
Asked by Newstein (123 rep)
Nov 28, 2017, 11:00 AM
Last activity: Jan 13, 2025, 04:10 AM