RE: SQL net help please

--openmail-part-095da25d-00000001

Content-Type: text/plain; charset=US-ASCII; name="BDY.TXT"
Content-Disposition: inline; filename="BDY.TXT"
Content-Transfer-Encoding: 7bit

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-----
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

--openmail-part-095da25d-00000001
Content-Type: application/ms-tnef; name="WINMAIL.DAT"
Content-Disposition: attachment; filename="WINMAIL.DAT"
Content-Transfer-Encoding: base64

eJ8+Iv5wAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5N
aWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEDkAYADAAAAAEAAAADABcAAQAA
ABwAAQOQBgAMAAAAAQAAAAMANgAAAAAAOgABBIABABgAAABSRTogU1FMIG5ldCBoZWxwIHBs
ZWFzZQCrBwEDkAYADAAAAAEAAAALAAIAAQAAAA8AAQOQBgAQAAAAAQAAAEAAOQDQy3JW6du/
AWEFAQOQBgAkAAAAAQAAAB4AQgABAAAAEgAAAEpvaG4gSi4gS2FuYWdhcmFqAAAAOwYBA5AG
ABAAAAABAAAAQABIAHCB+Ffp278BTQUBA5AGACgAAAABAAAAHgBwAAEAAAAYAAAAUkU6IFNR
TCBuZXQgaGVscCBwbGVhc2UAUwgBA5AGACgAAAABAAAAAgFxAAEAAAAWAAAAAb/b6VZjVqKy
I0fLEdSTXwBgl5kRswAA0woBA5AGAAwAAAABAAAAAwAGEFUG0UuRAQEDkAYADAAAAAEAAAAD
AAcQCAUAACgAAQOQBgB4AAAAAQAAAB4ACBABAAAAZQAAAEdPUEFMLFRXT0VSUk9SUyxBQ1RV
QUxMWShBKVlPVUNBTk5PVFVTRUVOVklST05NRU5UVkFSSUFCTEVTSU5USEVTUUxORVRPUkFG
SUxFKE5PVEVWRU4/QVNTT01FT05FTUVOVEkAAAAAyR0BA5AGAAwAAAABAAAAAwAQEAAAAAAk
AAEDkAYADAAAAAEAAAADABEQAAAAACUAAQOQBgAQAAAAAQAAAEAABzCw4jTk6Nu/AaUFAQOQ
BgAQAAAAAQAAAEAACDCw4jTk6Nu/AaYFAQOQBgAgAAAAAQAAAAIBCzABAAAAEAAAACKyolbL
R9QRk18AYJeZEbNZBwEDkAYADAAAAAEAAAADAN4/r28AAD8CAQOQBgAkAAAAAQAAAAMA5YEI
IAYAAAAAAMAAAAAAAABGAAAAABCFAAAAAAAAMwMBA5AGACQAAAABAAAAAwDmgQggBgAAAAAA
wAAAAAAAAEYAAAAAAYUAAAAAAAAlAwEDkAYAJAAAAAEAAAADAOeBCCAGAAAAAADAAAAAAAAA
RgAAAAARhQAAAAAAADYDAQOQBgAkAAAAAQAAAAMA6IEIIAYAAAAAAMAAAAAAAABGAAAAAFKF
AADjFQAAcAQBA5AGACwAAAABAAAAHgDpgQggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAE
AAAAOC41ADYEAQOQBgAkAAAAAQAAAAsA6oEIIAYAAAAAAMAAAAAAAABGAAAAAAaFAAAAAAAA
NgMBA5AGACQAAAABAAAACwDrgQggBgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAA/AwEDkAYA
JAAAAAEAAAADAOyBCCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAEIDAQOQBgAsAAAAAQAA
AB4A7YEIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAB+AwEDkAYALAAAAAEA
AAAeAO6BCCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAgAMBA5AGACwAAAAB
AAAAHgDvgQggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAIIDAQOQBgAkAAAA
AQAAAAsA8IELIAYAAAAAAMAAAAAAAABGAAAAAACIAAAAAAAAPAMBA5AGACQAAAABAAAACwDx
gQsgBgAAAAAAwAAAAAAAAEYAAAAABYgAAAAAAABCAwEDkAYAFAAAAAEAAAAeAD0AAQAAAAEA
AAAAAAAAXgABA5AGAAwAAAABAAAAAwCAEP////+QBAEJAAQAAgAAAAAAAAABA5AGAAwAAAAB
AAAACwAjAAAAAAAvAAEDkAYADAAAAAEAAAALACkAAAAAADUAAQSQBgD8AwAAAgAAABIAAAAD
AAAwBAAAAAsADw4AAAAAAgH/DwEAAABHAAAAAAAAAIErH6S+oxAZnW4A3QEPVAIAAAEAb3Jh
Y2xlLWxAZmF0Y2l0eS5jb20AU01UUABvcmFjbGUtbEBmYXRjaXR5LmNvbQAAHgACMAEAAAAF
AAAAU01UUAAAAAAeAAMwAQAAABUAAABvcmFjbGUtbEBmYXRjaXR5LmNvbQAAAAADABUMAQAA
AAIB+Q8BAAAARwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAABEG9yYWNsZS1sQGZhdGNpdHku
Y29tAFNNVFAAb3JhY2xlLWxAZmF0Y2l0eS5jb20AAAMA/g8GAAAAHgABMAEAAAAXAAAAJ29y
YWNsZS1sQGZhdGNpdHkuY29tJwAAAgELMAEAAAAaAAAAU01UUDpPUkFDTEUtTEBGQVRDSVRZ
LkNPTQAAAAMAADkAAAAACwBAOgAAAAADAHE6AAAAAB4A9l8BAAAAFQAAAG9yYWNsZS1sQGZh
dGNpdHkuY29tAAAAAAIB918BAAAARwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAABAG9yYWNs
ZS1sQGZhdGNpdHkuY29tAFNNVFAAb3JhY2xlLWxAZmF0Y2l0eS5jb20AAAMA/V8BAAAAAwD/
XwAAAAACAfYPAQAAAAQAAAAAAAAEEgAAAAMAADAFAAAACwAPDgAAAAACAf8PAQAAAEUAAAAA
AAAAgSsfpL6jEBmdbgDdAQ9UAgAAAQB1Z29wYWxAcHJveGljb20uY29tAFNNVFAAdWdvcGFs
QHByb3hpY29tLmNvbQAAAAAeAAIwAQAAAAUAAABTTVRQAAAAAB4AAzABAAAAFAAAAHVnb3Bh
bEBwcm94aWNvbS5jb20AAwAVDAIAAAACAfkPAQAAAEUAAAAAAAAAgSsfpL6jEBmdbgDdAQ9U
AgAAARB1Z29wYWxAcHJveGljb20uY29tAFNNVFAAdWdvcGFsQHByb3hpY29tLmNvbQAAAAAD
AP4PBgAAAB4AATABAAAAFgAAACd1Z29wYWxAcHJveGljb20uY29tJwAAAAIBCzABAAAAGQAA
AFNNVFA6VUdPUEFMQFBST1hJQ09NLkNPTQAAAAADAAA5AAAAAAsAQDoAAAAAAwBxOgAAAAAe
APZfAQAAABQAAAB1Z29wYWxAcHJveGljb20uY29tAAIB918BAAAARQAAAAAAAACBKx+kvqMQ
GZ1uAN0BD1QCAAABAHVnb3BhbEBwcm94aWNvbS5jb20AU01UUAB1Z29wYWxAcHJveGljb20u