I have two Oracle databases, 9i and 8i, running on separate Windows 2003 and NT servers. Because of IP address configurations these databases can't talk. Recently I decided to add an additional network card at each server so that the two servers can talk via crossed configured UTP cables (not through switch or hub). Now I can ping successfully from either end. But to my surprise all clients connected through the Oracle 9i database couldn't access the database until I changed their interface to the newly installed card.
What was the cause of the problem? Does Oracle 9i on Windows 2003 record hardware address + IP address of the network interface card? Does it also take default hardware address + IP address in a multihome system? Please help.
The only place that holds the database IP address is your database Listener config file (listener.ora) and possibly your tnsnames.ora config file. Typically, these do not use IP addresses, but rather a name that needs to be resolved through DNS. Since you did add a network card with a new IP address, you'll probably want to configure your tnsnames.ora config file to point to that new IP address.
Dig Deeper on Oracle database backup and recovery
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs.
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command.
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.