<div>
please provide me the script which i can run in all databases
</div>


please provide me the script which i can run in all databases

<div>
- do you mean the phyisical file in the machine? you can create a dos .BAT file with command as follows:<br />
@echo off<br />
del c:\folder\sqlnettrace.trc<br />
del c:\folder\sqlnet.log<br />
<br />
- then save it somewhere and schedule to run that .BAT file daily/at your desired period using Windows Task Scheduler.<br />
&nbsp;
</div>


- do you mean the phyisical file in the machine? you can create a dos .BAT file with command as follows:
@echo off
del c:\folder\sqlnettrace.trc
del c:\folder\sqlnet.log

- then save it somewhere and schedule to run that .BAT file daily/at your desired period using Windows Task Scheduler.
 

<div>
- for trace file, the filename is generated automatically therefore you can issue a delete all command such as del c:\folder\*.trc
</div>


- for trace file, the filename is generated automatically therefore you can issue a delete all command such as del c:\folder\*.trc

<div>
I'm sorry. &nbsp;But, I did not get your OS.<br />
In Linux/AIX starting with Oracle 11g, Oracle automatically rotates the listener log file. &nbsp;Hence, we need not write any script for doing the same.<br />
I presume the same behviour with Windows too.<br />

</div>


I'm sorry.  But, I did not get your OS.
In Linux/AIX starting with Oracle 11g, Oracle automatically rotates the listener log file.  Hence, we need not write any script for doing the same.
I presume the same behviour with Windows too.


<div>
it is linux envirinment...<br />
<br />
please can you help me with &nbsp;the script how to truncate the listiner <br />

</div>


it is linux envirinment...

please can you help me with  the script how to truncate the listiner


<div>
please provide me the script to run &nbsp;ksh to run on Linux schedule 
</div>


please provide me the script to run  ksh to run on Linux schedule

<div>
<div class="content wysiwyg-content">
we should be doing this on any Network/Listener/SQLnet.lo<wbr />g files on all the DB servers.at this point .we need a automated process to perform this process. So can you please &nbsp;work on writing a script to perform this 
</div>
</div>


we should be doing this on any Network/Listener/SQLnet.log files on all the DB servers.at this point .we need a automated process to perform this process. So can you please  work on writing a script to perform this 

script to delete listner log automated process

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.