Connecting to multiple servers

[cptngrb]

There are several servers. it is necessary to connect alternately to each server. a list of servers is requested every minute. Prompt n how it is better to realize?

 

[Marco Kalter]

You can create a TOracleSession instance for each connection that your application needs. The sessions can be connected simultaneously.

 

[cptngrb]

That's understandable. But I meant that I sent the IP address to the new servers. How to connect to them? You probably need to overwrite the tnsnames file every tnsnames.ora?
No other way?

 

[cptngrb]

*every time

 

[Marco Kalter]

If the tnsnames.ora file in no longer up-to-date then you should indeed update it. You can alternatively use the EZCONNECT naming method to explicitly use host names or ip addresses in the connect strings in your application.
http://www.orafaq.com/wiki/EZCONNECT

 

[cptngrb]

Thanks