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.
Dig Deeper on Oracle database installation, upgrades and patches
Can I use /var/opt/oracle/oratab to specify listener information?
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ...
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error:
"Error in invoking target install of makefile /opt/oracle/...../*.mk."
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.