Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there anyway I could update Host in a specific TNS entry, by way of an Batch File(sqlplus via command prompt)?

A change in the IP address have been raised and we need to update the TNS across several terminals. Any easy way to handle it rather than editing the TNSnames.ora file?

Your expertise in this is very much appreciated?

share|improve this question
up vote 0 down vote accepted

You will do it one time; but i suggest to use dns names entry in the tnsnames and if a change have to be made it will be on a centralized place.

share|improve this answer
Yes, I regret myself not applying DNS names, but Thanks for your suggestion; more or less it the answer way forward! – hiFI Aug 1 '13 at 14:04

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.