Re: TNS:listener Error

From: Achille Carette <achyl_at_infonie.be>
Date: Thu, 23 Nov 2000 16:53:27 +0100
Message-ID: <3a1d3ee6$0$20284$73bec57d@news.be.uu.net>

The service name in question can be defined in the instance initialization file, and should match what is in listener.ora.

for example, use :

in init.ora
service_names = SIDNAME.DOMAINNAME

in listener.ora
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME = SIDNAME.DOMAINNAME)
      (ORACLE_HOME = E:\Oracle\Ora81)
      (SID_NAME = TEST)

    )
  )

in tnsnames.ora
SERVICE =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = SERVERNAME)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = SIDNAME.DOMAINNAME)     )
  )

kush <kdhakal_at_eline.com> wrote in message news:qSFS5.3059$A26.138344_at_sjc-read.news.verio.net...
> Hi all, I just have successfully installed oracle 8i on solaris. Now when
 I
> tried to connect it through Toad(development tool) from WindowNT it gave
 me
> following error.
>
> ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
> descriptor
>
> I have checked tnsnames.ora file on my(NT) machine and it looks fine. My
> question is does tnsnames.ora in NT has to be exactly same as tnsnames.ora
> in Solaris(where the oracle database resides)? even if that is true, I
 tried
> that it also and I am getting same error. Do I need to change anything on
> listener.ora file on Solaris(where the oracle database resides)?.
> Any hint will be appreciated. thanks in advance.
>
> kush
>
>
Received on Thu Nov 23 2000 - 09:53:27 CST