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

Client machines not connecting to server

I have installed Oracle 9i Client on a PC and configured it to the 9i server and it is working successfully. But when I installed and configured 9i Client on any other machine in the client network, they are not connecting to the server. When I try to connect to the server through SQL* Plus, the error I get is "ORA-12535: TNS:operation timed out."

We have Oracle 9i Database Server. I have installed Oracle 9i Client on a PC and configured it to the 9i server and it is working successfully. But when I installed and configured 9i Client on any other machine in the client network, they are not connecting to the server. When I try to connect to the server through SQL* Plus, the error I get is "ORA-12535: TNS:operation timed out." The server is on one network and clients on another. (Let's call them the server network and client network.) There are two 9i servers in the server network and a number of PCs in the client network. The two networks are connected to each other. All client network machines are configured successfully to one of the servers, but only one machine in the client network can be configured successfully to the second server and the rest of the machines are giving the error I mentioned above. I want to know when one machine is successfully connected to both servers, why are the other client machines not connecting and giving the errors? We have Windows 2000 Server OS for the server network and 2000 Professional for the client network. I want a solution for this problem as soon as possible.
You may want to change the CONNECT_TIMEOUT parameter in your database server's LISTENER.ORA configuration file. Either set this parameter to a larger value so that timeouts do not occur so fast, or set this parameter to 0 so that the Listener will not time out connection requests. Once you have changed your LISTENER.ORA config file, either reload the listener or restart it.

Dig Deeper on Oracle database design and architecture

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