Re: WAN Connection Issue

 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:

http://download.oracle.com/docs/cd/B10501_01/win.920/a95492/net_conf.htm#634333

(no the same version but was the quickest google hit, see also http://tahiti.oracle.com/)

Kind regards

        robert

-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/