Reason for the problem

By default, when an Oracle server connects to a network, the server will have a binding with that particular network through the interface card. When another network tries to connect to the same server, the server will not respond as it is bound with the earlier network. So the clients of the second network cannot access the server because the primary network interface card of the server machine is bound with the first network.

Analysis

•.Studied the logical and physical structures of company’s network architectures, which included the full details of the logical structure of network architecture.

• Studied the technical requirements.

• Identified the source of the problem.

•.Studied the existing reports to get a clear view.

• Identified the real problem.

When clients from the second network try to connect to the Oracle server, the connection was not detected. The reason for this was because the server was already bound with one particular network.

• Identified the additional resource
requirements

Required additional client computer to check how oracle TNS Listener is visible to the clients.

Assessment

After implementing the proper technical solutions to the above identified problems, we managed to establish a connection with the Database Server which was much more reliable and stable than it was.