Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.