Connect to Oracle Express Edition from Remote Machine

November 20, 2008
For development purposes and small applications I prefer using Oracle Database 10g Express Edition instead of the heavyweight Oracle Database 10g / 11g Enterprise. It can be installed and run for just 2-3 minutes but it has a small problem: by default the TNS Listener listens for connections on port 1521 from the local machine