ORA-12541 Local vs Remote Problem

Installation and support for Oracle DB on CentOS.
bringolf
Posts: 1
Joined: 2009/06/13 17:19:33

ORA-12541 Local vs Remote Problem

Postby bringolf » 2009/06/13 17:23:20

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
Forum Moderator
Posts: 2886
Joined: 2005/10/28 13:11:50
Location: UK

ORA-12541 Local vs Remote Problem

Postby NedSlider » 2009/06/14 12:10:47

Moved to the CentOS 4 section :-)

pschaff
Retired Moderator
Posts: 18276
Joined: 2006/12/13 20:15:34
Location: Tidewater, Virginia, North America
Contact:

Re: ORA-12541 Local vs Remote Problem

Postby pschaff » 2009/06/14 12:21:08

bringolf wrote:
...
Could it be network configuration connected?


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