RE: SQL net help please

Not sure about Oracle 8, however I would assume it would be the same. Your TNSNAMES.ora should look like this: (what I changed is in red)

DEV01 =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = DEV01))     )
(CONNECT_DATA =

      (SERVICE_NAME = dev01)
    )
  )

I would try that, it should work.

Cheers!
Christine Turner
Database Administrator
IPS-Sendero
Scottsdale, Arizona
Phone: (800) 321-6899 ext. 3286
Fax: (480) 946-8224
E-mail: christine.turner_at_ips-sendero.com

-----Original Message-----

From:	Gopal, Umesh [SMTP:ugopal_at_proxicom.com]
Sent:	Monday, June 19, 2000 7:24 PM
To:	Multiple recipients of list ORACLE-L
Subject:	SQL net help please

Hi ,

I am trying to test the trace and log file of the tnsnames.ora file on an oracle 8 client on a sun solaris box ,
however I cannot get the client to write to the log or trc files, can anyone suggest what I can do to make it work

my tnsnames.ora is as follows :

DEV01 =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(PORT = 1521)(HOST = clove))     )
(CONNECT_DATA =

      (SERVICE_NAME = dev01)
    )
  )

my sqlnet.ora is as follows :

trace_level_client = 16
trace_directory_client = $ORACLE_HOME/network/trace
trace_file_client =  $ORACLE_HOME/network/trace/cli.trc
trace_unique_client = on
log_directory_client = $ORACLE_HOME/network/log
log_file_client = $ORACLE_HOME/network/log/sqlnet.log            

Any help appreciated .

Thanks
Umesh

-- 
Author: Gopal, Umesh
  INET: ugopal_at_proxicom.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may