Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12514: TNS error
dmagnatek_at_yahoo.com said...
> 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
>
See Metalink Note 125021.1 "Oracle Connectivity with Firewalls". Basically, your incoming connection is on port 1521, but your outgoing (over which client/server communicate) is on another, random port. Some firewalls know about Oracle's behavior and can be configured. Others mean you have to do something special. Several workarounds are in the Note.
-- /Karsten DBA > retired > DBAReceived on Wed Feb 26 2003 - 11:52:17 CST