rename windows 2000 oracle server
i need to rename a windows 2000 advance server with oracle and databases in it
what problems will i have with the oracle services such as tns listener etc
and how can i fix them if i can??
what problems will i have with the oracle services such as tns listener etc
and how can i fix them if i can??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:
Split: BobMc {http:#8247437} & iozturk {http:#8249179}
Please leave any comments here within the next four days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
walterecook
EE Cleanup Volunteer
I will leave the following recommendation for this question in the Cleanup topic area:
Split: BobMc {http:#8247437} & iozturk {http:#8249179}
Please leave any comments here within the next four days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
walterecook
EE Cleanup Volunteer
1. You have to change your Listener.ora file if it uses comp name istead of IP.
2. If your clients uses IP in TNSNAMES.ora and you are not changing servers IP as well, then no need any change in clients. If they are using servername go your DNS server and add old name with IP (new if you are changing) (If you are not going to use old computername for another computer). (Your system admin helps you.)
Now when they start searching your old computer name they are going to ask its IP to DNS and DNS going to give its IP. They start communicating with IP.
By this way you dont need to change all clients TNSNAMES.ora file if you dont use old name anymore.