title: Connect to two DB using Oracle wallet without TNS_ADMIN path change
body: <pre><code>-bash-4.1$ export TNS_ADMIN="/tmp/PKI/DB_A"
  -bash-4.1$ sqlplus /@DB_A
  </code></pre>
  
  <p>Connects fine</p>
  
  <pre><code>-bash-4.1$ export TNS_ADMIN="/tmp/PKI/DB_B"
  -bash-4.1$ sqlplus /@DB_B
  </code></pre>
  
  <p>Connects fine</p>
  
  <pre><code>-bash-4.1$ sqlplus /@DB_A
  </code></pre>
  
  <p>Error logon denied (since the last TNS_ADMIN path points to the DB_A)</p>
  
  <p>There is an option of using TNS Names with the JDBC, i.e. set the oracle.net.TNS_ADMIN property to the directory that contains your tnsnames.ora file ( java -Doracle.net.tns_admin=$ORACLE_HOME/network/admin). </p>
  
  <p>The situation is, I will not be able to change TNS_ADMIN Path. Is there any option in Oracle sqlplus <em>NOT</em> to specify TNS_ADMIN path but seemlessly connect to both DB_A and DB_B ?</p>