ORA-12541 when connecting to Oracle10 on a (vmware host) fc2 linux

hi @ all

within my studies i've got to "play" with databases. so i set up a oracle 10g server.

operating system is a fedora core 2 linux (as vmware guest on a windows 2000 host). all my boxes are connected through a zyxel prestige 324 router. vmware uses bridged networking.

oracle installation worked well.

i set up a listener on port 1521 and started the database. i'm able to log into the database with sqlplus from the server succesfully. tnsping from the server
also says that the listener works well.

now my problem: if i try to connect to the database from everywhere else i get a ORA-12541 NO LISTENER error. i don't know why.

i did a portscan with nmap of the server box: a) from the server with the result that port 1521/tcp oracle is open. b) from anywhere else with the result that port 1521 is closed.

i checked the listener.ora and tnsnames.ora and sql.ora a view times. i think they are correct. linux iptables are stopped.

i've got no idea anymore. i'm not sure if i only don't see the wood for the trees.

hope anyone has an idea ...

thanks uwe Received on Sun Feb 06 2005 - 12:43:09 CST