RE: SQL net help please

From: <john.j.kanagaraj_at_shell.com.bn>
Date: Mon, 26 Jun 2000 08:34:33 +0800
Message-Id: <10539.110375@fatcity.com>

--openmail-part-09624bc8-00000001

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

Umesh wrote:

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

John wrote:
(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!

Hi Umesh,

I guess you missed the second part of my answer : Namely, the The trace_file_client and log_file_client are *filenames* only and are not fully qualified. Hence, change the following values :

trace_file_client = cli.trc
log_file_client = sqlnet.log

Unfortunately, if SQL*Net encounters these sort of errors in the config files, it just ignores them!

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

--openmail-part-09624bc8-00000001

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

eJ8+IuAoAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5N aWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEDkAYADAAAAAEAAAADABcAAQAA ABwAAQOQBgAMAAAAAQAAAAMANgAAAAAAOgABBIABABgAAABSRTogU1FMIG5ldCBoZWxwIHBs ZWFzZQCrBwEDkAYADAAAAAEAAAALAAIAAQAAAA8AAQOQBgAQAAAAAQAAAEAAOQAQoMJKBt+/ AdsDAQOQBgAkAAAAAQAAAB4AQgABAAAAEgAAAEpvaG4gSi4gS2FuYWdhcmFqAAAAOwYBA5AG ABAAAAABAAAAQABIAJDAwUsG378BigQBA5AGACgAAAABAAAAHgBwAAEAAAAYAAAAUkU6IFNR TCBuZXQgaGVscCBwbGVhc2UAUwgBA5AGACgAAAABAAAAAgFxAAEAAAAWAAAAAb/fBkq/ZoLU O0rxEdSTYwBgl5kRswAAmwoBA5AGAAwAAAABAAAAAwAGEPJV74TUAgEDkAYADAAAAAEAAAAD AAcQqQMAAMcAAQOQBgB4AAAAAQAAAB4ACBABAAAAZQAAAFVNRVNIV1JPVEU6VFJBQ0VMRVZF TENMSUVOVD0xNlRSQUNFRElSRUNUT1JZQ0xJRU5UPS9VU1IvTE9DQUwvVTAxL09SQUNMRS84 MTYvTkVUV09SSy9UUkFDRVRSQUNFRklMRUMAAAAAeBwBA5AGAAwAAAABAAAAAwAQEAAAAAAk AAEDkAYADAAAAAEAAAADABEQAAAAACUAAQOQBgAQAAAAAQAAAEAABzDwbIXMBd+/AckEAQOQ BgAQAAAAAQAAAEAACDDwbIXMBd+/AcoEAQOQBgAgAAAAAQAAAAIBCzABAAAAEAAAADrUgmbx StQRk2MAYJeZEbOwBwEDkAYADAAAAAEAAAADAN4/r28AAD8CAQOQBgAkAAAAAQAAAAMADYMI IAYAAAAAAMAAAAAAAABGAAAAABCFAAAAAAAAXQIBA5AGACQAAAABAAAAAwAOgwggBgAAAAAA wAAAAAAAAEYAAAAAAYUAAAAAAABPAgEDkAYAJAAAAAEAAAADAA+DCCAGAAAAAADAAAAAAAAA RgAAAAARhQAAAAAAAGACAQOQBgAkAAAAAQAAAAMAEIMIIAYAAAAAAMAAAAAAAABGAAAAAFKF AADjFQAAmgMBA5AGACwAAAABAAAAHgARgwggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAE AAAAOC41AGADAQOQBgAkAAAAAQAAAAsAEoMIIAYAAAAAAMAAAAAAAABGAAAAAAaFAAAAAAAA YAIBA5AGACQAAAABAAAACwATgwggBgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAABpAgEDkAYA JAAAAAEAAAADABSDCCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAGwCAQOQBgAsAAAAAQAA AB4AFYMIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAACoAgEDkAYALAAAAAEA AAAeABaDCCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAqgIBA5AGACwAAAAB AAAAHgAXgwggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAKwCAQOQBgAkAAAA AQAAAAsAGIMLIAYAAAAAAMAAAAAAAABGAAAAAACIAAAAAAAAZgIBA5AGACQAAAABAAAACwAZ gwsgBgAAAAAAwAAAAAAAAEYAAAAABYgAAAAAAABsAgEDkAYAFAAAAAEAAAAeAD0AAQAAAAEA AAAAAAAAXgABA5AGAAwAAAABAAAAAwCAEP////+QBAEJAAQAAgAAAAAAAAABA5AGAAwAAAAB AAAACwAjAAAAAAAvAAEDkAYADAAAAAEAAAALACkAAAAAADUAAQSQBgD8AwAAAgAAABIAAAAD AAAwBAAAAAsADw4AAAAAAgH/DwEAAABFAAAAAAAAAIErH6S+oxAZnW4A3QEPVAIAAAEAdWdv cGFsQHByb3hpY29tLmNvbQBTTVRQAHVnb3BhbEBwcm94aWNvbS5jb20AAAAAHgACMAEAAAAF AAAAU01UUAAAAAAeAAMwAQAAABQAAAB1Z29wYWxAcHJveGljb20uY29tAAMAFQwBAAAAAgH5 DwEAAABFAAAAAAAAAIErH6S+oxAZnW4A3QEPVAIAAAEQdWdvcGFsQHByb3hpY29tLmNvbQBT TVRQAHVnb3BhbEBwcm94aWNvbS5jb20AAAAAAwD+DwYAAAAeAAEwAQAAABYAAAAndWdvcGFs QHByb3hpY29tLmNvbScAAAACAQswAQAAABkAAABTTVRQOlVHT1BBTEBQUk9YSUNPTS5DT00A AAAAAwAAOQAAAAALAEA6AAAAAAMAcToAAAAAHgD2XwEAAAAUAAAAdWdvcGFsQHByb3hpY29t LmNvbQACAfdfAQAAAEUAAAAAAAAAgSsfpL6jEBmdbgDdAQ9UAgAAAQB1Z29wYWxAcHJveGlj b20uY29tAFNNVFAAdWdvcGFsQHByb3hpY29tLmNvbQAAAAADAP1fAQAAAAMA/18AAAAAAgH2 DwEAAAAEAAAAAAAABBIAAAADAAAwBQAAAAsADw4AAAAAAgH/DwEAAABHAAAAAAAAAIErH6S+ oxAZnW4A3QEPVAIAAAEAb3JhY2xlLWxAZmF0Y2l0eS5jb20AU01UUABvcmFjbGUtbEBmYXRj aXR5LmNvbQAAHgACMAEAAAAFAAAAU01UUAAAAAAeAAMwAQAAABUAAABvcmFjbGUtbEBmYXRj aXR5LmNvbQAAAAADABUMAQAAAAIB+Q8BAAAARwAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAB EG9yYWNsZS1sQGZhdGNpdHkuY29tAFNNVFAAb3JhY2xlLWxAZmF0Y2l0eS5jb20AAAMA/g8G AAAAHgABMAEAAAAXAAAAJ29yYWNsZS1sQGZhdGNpdHkuY29tJwAAAgELMAEAAAAaAAAAU01U UDpPUkFDTEUtTEBGQVRDSVRZLkNPTQAAAAMAADkAAAAACwBAOgAAAAADAHE6AAAAAB4A9l8B AAAAFQAAAG9yYWNsZS1sQGZhdGNpdHkuY29tAAAAAAIB918BAAAARwAAAAAAAACBKx+kvqMQ GZ1uAN0BD1QCAAABAG9yYWNsZS1sQGZhdGNpdHkuY29tAFNNVFAAb3JhY2xlLWxAZmF0Y2l0 eS5jb20AAAMA/V8BAAAAAwD/XwAAAAACAfYPAQAAAAQAAAAAAAAFHt8= Received on Sun Jun 25 2000 - 19:34:33 CDT