RE: SQL net help please

From: Gopal, Umesh <ugopal_at_proxicom.com>
Date: Thu, 22 Jun 2000 08:16:32 -0400
Message-Id: <10536.110130@fatcity.com>

Hi,

I have two further questions ?
I have replaced the $ORACLE_HOME with the full path. What other parameters do I have to set the sql trace on, as the log client log files on my machine are still empty.

my sqlnet.ora is as follows :

trace_level_client = 16
trace_directory_client = /usr/local/u01/oracle/8.1.6/network/trace
trace_file_client =  /usr/local/u01/oracle/8.1.6/network/trace/cli.trc
trace_unique_client = on

log_directory_client = /usr/local/u01/oracle/8.1.6/network/log log_file_client = /usr/local/u01/oracle/8.1.6/network/log/sqlnet.log

Any help appreciated .

Thanks
Umesh

-----Original Message-----
From: john.j.kanagaraj_at_shell.com.bn
[mailto:john.j.kanagaraj_at_shell.com.bn]
Sent: Wednesday, June 21, 2000 10:35 PM
To: Multiple recipients of list ORACLE-L Subject: RE: SQL net help please

Gopal,

Two errors, actually!

(a) You cannot use environment variables in the sqlnet.ora file (not
even ? as someone mentioned). So change the ORACLE_HOME to it's equivalent hardcoded path
(b) The trace_file_client and log_file_client are *filenames* only, not
fully qualified (i.e path+filename). The <>_directory_client already provides the directory!

Hth,
John Kanagaraj
Brunei Shell Petroleum
http://www.geocities.com/john_sharmila

God so loved the world that He didn't send a committee! (See John 3:16 for details)
** Opinions expressed here are solely mine and not necessarily those of my employer **

-----Original Message-----
Sent: Monday, June 19, 2000 7:24 PM
To: Multiple recipients of list ORACLE-L

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 . Received on Thu Jun 22 2000 - 07:16:32 CDT