Re: WAN Connection Issue
From: bdbafh <bdbafh_at_gmail.com>
Date: Tue, 10 Nov 2009 11:35:41 -0800 (PST)
Message-ID: <c9c49467-6b2f-4817-8885-993c4fcbe8b1_at_j24g2000vbl.googlegroups.com>
On Nov 10, 2:24 pm, Alinux <alijaw..._at_gmail.com> wrote:
> Hi All
>
> 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.
>
> 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.
>
> 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
> - 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 ?
>
> Regards
Date: Tue, 10 Nov 2009 11:35:41 -0800 (PST)
Message-ID: <c9c49467-6b2f-4817-8885-993c4fcbe8b1_at_j24g2000vbl.googlegroups.com>
On Nov 10, 2:24 pm, Alinux <alijaw..._at_gmail.com> wrote:
> Hi All
>
> 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.
>
> 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.
>
> 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
> - 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 ?
>
> Regards
congrats on listing the version of the database server software as 8i. is that:
8.1.5 8.1.6 8.1.7
version of the Oracle client software?
e.g. 10.2.0.1 client
Operating system of the client and server?
If you upgrade both client and server to 10.2.0.4 this problem will (likely) magically go away and you won't have to delve any further, like into a non-accessible Metalink Oracle Support site.
-bdbafh Received on Tue Nov 10 2009 - 13:35:41 CST