Q
Problem solve Get help with specific problems with your technologies, process and projects.

8i and 9i databases running on separate servers

I have two Oracle databases, 9i and 8i, running on separate Windows 2003 and NT servers. I decided to add an additional network card at each server so that the two servers can talk via crossed configured UTP cables. All clients connected through the 9i database couldn't access the database until I changed their interface to the newly installed card. What was the cause of the problem?

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

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.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close