Re: Tnsnames.ora /Listener.ora config probs...Urgent

From: Haximus <e_at_t.me>
Date: Mon, 28 Feb 2005 10:14:43 GMT
Message-ID: <naCUd.12019$LN5.529@edtnps90>

"Ariji Chatterjee" <arijitchatterjee123_at_yahoo.co.in> wrote in message news:1109584576.783155.237670_at_l41g2000cwc.googlegroups.com...
> Dear Sir,
> sqlnet.ora is only containing these lines
> ==============================
> #static sqlnet.ora for Oracle8i Cache v1.0.0.0
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
> NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
> =================================

Looks good, then probably you need to add a SERVICE_NAME parameter to your connect descriptor in tnsnames.ora:

SYSDB.SHANTA.LOCAL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = systel1.shanta.local)(PORT = 1521))     )
    (CONNECT_DATA =

      (SERVICE_NAME = sysdb) <= put service name here
      (SID = sysdb)
      (SRVR = DEDICATED)

    )
 ) Received on Mon Feb 28 2005 - 04:14:43 CST