Re: ORA-12514: TNS error

Thanks for your reply. Per your suggestion I checked the service name in the connect_data sections of tnsnames.ora on my client, on the server and in init<sid>.ora for the database. They all match....

Client (tnsnames.ora)
...
stage =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = stage-klump)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = stage)
    )
  )

Server (tnsnames.ora)
...
stage =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = stage-klump)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = stage)
    )
  )

Server (init.ora)
...
db_name = "stage"
instance_name = stage
service_names = stage

Sybrand Bakker <gooiditweg_at_nospam.demon.nl> wrote in message news:<ff1q5v89r174tj2gvm3ls9j10ng578b2m2_at_4ax.com>...
> 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
>
>
> The service_name in the connect_data section in tnsnames.ora doesn't
> match the service_name in init<sid>.ora for the database.
>
> Has NOTHING to do with firewalls, and TCP/IP ports!!!!
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Thu Feb 27 2003 - 07:47:24 CST