ORA-12541 Local vs Remote Problem

[bringolf]

Have a Centos 4 machine with 10g xe installed. Works fine from the server but cannot connect from a remote machine.

From the server I can log into Oracle directly and through the listener, example:

sqlplus name/password << Connects OK
sqlplus name/password@XE << Connects OK

But, from a remote machine (using instant client connection):

sqlplus name/password@theservername/xe << ORA-12541 TNS:no listener error?



Worked fine after "server" install but later added gnome desktop and it broke the remote Oracle listener.

Could it be network configuration connected?

[NedSlider]

Moved to the CentOS 4 section :-)

[pschaff]

[quote]
bringolf wrote:
...
Could it be network configuration connected?[/quote]

Yes, and/or firewall, or possibly selinux. Try after a temporary "service iptables stop".