Discussion Locked

regarding Oracle

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
When you change the name of the machine on which the database /oracle is installed which control file have to be made changes so that the change does not hamper the database ?

1 reply

by ambily

You will have to edit the HOST entry in your TNSNames.ora and Listener.ora file which are located under the oracle_home\network\admin directory to avoid any connectivity problems.

You do not have to make any change to the control file if you haveonly changed the machine name and not the database name.

Hope this helps

This discussion is closed to new replies.