clicksor ad

Thursday, July 08, 2010

Killing sniped sessions in UNIX

http://www.orsweb.com/downloads/source/424.html
#!/bin/ksh
#* filename==>cleanup_sniped.ksh
#*
#* Name: cleanup_sniped.ksh
#*
#* Date: 13 December, 2001
#*
#* Purpose:
#* A script to clean up sniped sessions at the OS level.
#* The database sessions will dissappear after the
#* OS process is killed.
#* This script is based on Oracle NOTE: 96170.1
#*
#* Prepared/
#* CopyRighted By: TheOracleResourceStop Script Archive
#*
#* Dependancies:
#* The SID must be in the oratab file and it is necessary to edit this file
#* and to replace the following:
#* {userid} --> Change to the user name to use connect to your database instance
#* {password} --> Change to the password of userid
#* {logfile directory} --> Change to the destination directory for
#* log files
#*
#* Assumptions: NONE
#*
#* Parameters: SID name
#*
#* Output: cleanup_sniped.log
#*
#* Exceptions: No handled errors.
#*
#* Usage: cleanup_sniped.ksh SID
#*
#* Modifications:
#****************************************************************
.
.
echo "$1 SNIPED session removal is complete: "`date`
echo "********************************************"
exit 0

You can get this code and more in the above mentioned address


But the URL is not working now (22/07/10)

No comments: