title: TNS Redirection?
body: <p>Is it possible to redirect a TNS declaration to another one?</p>
  
  <p>For my current project, I require "flipping" from server to server in certain circumstances. To do this I use 3 TNS entries.  </p>
  
  <p>One to hold the TNS name that my application will connect to:</p>
  
  <pre><code># application access to DB
  DB =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = SAMPLENAME)
      )
    )
  </code></pre>
  
  <p>So that I can connect "manually" to either of the databases myself, I use 2 more TNS entries:</p>
  
  <pre><code># Central_Server "Manual"
  Central_Server =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.1)(PORT = 1521))
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = SAMPLENAME)
      )
    )
  
  # Local "Manual"
  Local =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
      (CONNECT_DATA =
        (SERVER = DEDICATED)
        (SERVICE_NAME = SAMPLENAME)
      )
    )
  </code></pre>
  
  <p>Rather than tweaking the TNS entry for DB all the time, is it possible to do something along the lines of?: </p>
  
  <pre><code>DB = Local
  
  or
  
  DB = Central_Server
  </code></pre>
  
  <p>Due to deployment strategy, I'd rather not implement this logic in my application directly.</p>
  
  <p>Thanks :)</p>