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
ORA-12541 Local vs Remote Problem
Moved to the CentOS 4 section :-)
-
- Retired Moderator
- Posts: 18276
- Joined: 2006/12/13 20:15:34
- Location: Tidewater, Virginia, North America
- Contact:
Re: ORA-12541 Local vs Remote Problem
[quote]
bringolf wrote:
...
Could it be network configuration connected?[/quote]
Yes, and/or firewall, or possibly selinux. Try after a temporary "service iptables stop".
bringolf wrote:
...
Could it be network configuration connected?[/quote]
Yes, and/or firewall, or possibly selinux. Try after a temporary "service iptables stop".