Re: WAN Connection Issue

From: Robert Klemme <>
Date: Tue, 10 Nov 2009 21:21:51 +0100
Message-ID: <>

On 10.11.2009 20:24, Alinux wrote:
> I have a OCI client on a LAMP server where PHP creates a connection to
> a Oracle 8i server on a remote location through a WAN link.

 From what you write I assume it is a Windows server (AFAIK USE_SHARED_SOCKET is an option available on Windows only, for Unixes this is not needed).

> If I take my laptop which contains a virtual machine that is a clone
> of the LAMP server I can connect at the client's remote WAN link.

Is that really an identical clone or did you maybe change tnsnames.ora?

> However, if I do try to create an Oracle connection on the LAMP server
> or through my Laptop on the LAMP server location. I get the following
> error:
> ORA-12514: TNS:listener does not currently know of service requested
> in connect descriptor
> I doubt it is a config error since it does work on the remote client's
> location. So I am looking more towards some network issue.
> The client has opened port 1521. However, when I do a tcpdump I also
> notice that the php client is trying to access the server on another
> random port. I did some googeling and there seem to be some
> workarounds on this. One thing that is out of question is to open all
> ports on the firewall. The solutions I found are:
> There are three workarounds
> - set up connection manager on the database server
> - set up mts on the database server to a fixed port

What's "mts"?

> - set use_shared_sockets = true
> I am not much of a Oracle guy, however I need to provide some concrete
> instructions to the db admins about what they should do on the server
> side to solve this.
> Which of the 3 solutions above is a server side solution and any more
> detailed instructions about it ?

I'd go with option 3:

(no the same version but was the quickest google hit, see also

Kind regards


remember.guy do |as, often| as.you_can - without end
Received on Tue Nov 10 2009 - 14:21:51 CST

Original text of this message