Q
Manage Learn to apply best practices and optimize your operations.

Oracle hostname changed with upgrade

The hostname changed due to a computer upgrade and cloning (Symantec Ghost) of the system. How do I make Oracle change where it's looking for the database?

The hostname changed due to a computer upgrade and cloning (Symantec Ghost) of the system. How do I make Oracle change where it's looking for the database? Oracle finds the database through our network when the old computer is connected to the network. If the old computer is not connected, then I receive the error message "unable to connect to database." I hope I gave you enough information. If not, please let me know and I'll try to answer. Thanks.
Check the tnsnames.ora file residing on the machine you are attempting to connect from. The tnsnames.ora file is usually located in $ORACLE_HOME/network/admin. There is likely a service defined in this file for the database and it is likely using the old hostname. Change the hostname to the new hostname and attempt a connection. If modifying the tnsnames.ora file does not resolve the problem, another possibility is that there may be a DNS alias used as the service name for this database and it is still pointing to the old hostname and IP address.
This was last published in April 2007

Dig Deeper on Oracle database installation, upgrades and patches

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close