TNS_ADMIN / TNSNAMES location failover

1 vote

1 answer

1779 views

                          Is there a way to have multiple tnsnames.ora locations defined? We currently use a server path like TNS_ADMIN=\\192.168.1.100\infosys\oracle\tnsnames but are in a situation this week where that server had to be taken offline for a couple days.

I've tried stacking locations similar to PATH variable but it doesn't work:

    > set TNS_ADMIN=z:\Common\oracle;\\192.168.1.100\infosys\oracle\tnsnames
    > mctnsping ora-server

    McTnsping Utility by Michel Cadot: Version 2018.08.17 on 18-OCT-2018 11:16:33
    Copyright (c) Michel Cadot, 2016-2018. All rights reserved.

    *** TNS-03514: Failed to find tnsnames.ora file

Single location is fine:

    > set TNS_ADMIN=Z:\Common\oracle
    > mctnsping ora-server
    
    Used parameter files:
    Z:\Common\oracle\tnsnames.ora
    ...snip...    
    Attempting to contact ora-server:1521
    OK (201 msec)



How to have an alternate location without touching every client to change TNS_ADMIN?
                        

Asked by matt wilkie (111 rep)

Oct 18, 2018, 06:23 PM
Last activity: Oct 18, 2018, 07:43 PM

TNS_ADMIN / TNSNAMES location failover

Related Questions