Page 1 of 1

ORA-12541 Local vs Remote Problem

Posted: 2009/06/13 17:23:20
by 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?

ORA-12541 Local vs Remote Problem

Posted: 2009/06/14 12:10:47
by NedSlider
Moved to the CentOS 4 section :-)

Re: ORA-12541 Local vs Remote Problem

Posted: 2009/06/14 12:21:08
by 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".