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
Can I use /var/opt/oracle/oratab to specify listener information?
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ...
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error:
"Error in invoking target install of makefile /opt/oracle/...../*.mk."
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.