Re: ORA-12514: TNS error

If you did not change listener usual IP ports it is 1521, but if both your PC and server are behind the firewall it should not be a problem if they are on the same switch/hub. It would be if you have the firewall in between without opening 1521 port of course. Dispatchers are used only for MTS configured servers, that's beyond the point. If the only modification in your system is that firewall, try open 1521 ports in both direction on it.

On 26 Feb 2003 08:57:12 -0800, dmagnatek_at_yahoo.com (David) wrote:

>Hey all,
>
>I have having trouble connecting my client PC to our Oracle server
>using SQL*Plus. I am getting the "ORA-12514: TNS: listener could not
>resolve SERVICE_NAME given in connect descriptor" error. It worked
>Friday, Firewall installed Sunday, does not work on Monday. Obviously
>the firewall (as none of the client or server .ORA files have been
>changed in months). My TNS uses the standard 1521 port. Do I need to
>open this port on the firewall? If so, will that work? What about
>the dispatcher? I am under the impression it needs a range of ports
>open. I am not a DBA here but have been given the responsibility to
>get the thing working. Any direction you can provide would be
>helpful. BTW, Oracle is running on a Win2000 box.
>
>My client PC and Server are both behind the firewall. No external
>access currently (however, I would like to get this working at some
>future point).
>
>Thanks in advance for your insight.
>
>David
Received on Wed Feb 26 2003 - 11:26:23 CST