Re: SERVICE_NAME and SID can't be resolved

My tnsnames.ora is as follows:

#TNSNAMES.ORA Configuration
# Generated by Oracle configuration tools. TESTORA_SERVICE_NAME.MyDomain =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = MyIP)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = testora.MyDomain)
    )
  )

My listener.ora is:

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = MyIP)(PORT = 1521))   )

Sybrand Bakker wrote:

> Which will be very difficult without looking at the actual contents of
> listener.ora, tnsnames.ora and sqlnet.ora.
> If you want a solution, you have to post them.
> Generally speaking 12514 means your tnsnames.ora is incorrect, or doesn't
> match the listener.ora.

>

>

>
>