Q
Manage Learn to apply best practices and optimize your operations.

How to connect to Oracle 10g server from client machines

I am able to ping the server from my client machines, but the tnsping shows timeout. How can I connect to the server from the client machines?

Hi Maria. I am relatively new to Oracle. I have a workgroup of four computers. I've made one of them a server and have installed Oracle 10g Database. I've installed client components in the other machines. I am able to ping the server from the client machines, but the tnsping shows timeout. How can I connect to the server from the client machines? Is it necessary that the client machines be added as external users to the database? Should the systems be in a domain instead of workgroup?
Check that the firewall on the database server is not blocking the listener port. The default port is usually 1521 but I would recommend changing that. In any case, the listener port must be able to accept connections but this may be blocked by a firewall. Also, the listener must be running to accept connections.

Dig Deeper on Oracle database installation, upgrades and patches

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