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
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."
I'm getting errors while installing the Database Configuration Assistant.
Can I use /var/opt/oracle/oratab to specify listener information?