Shell script killoracle Database specified user

Step One:

Locate the session information for the specified user, and draw up the execution script:

#!/bin/ksh
echo "conn Sys/sys as SYSDBA
select ' Alter system kill session ' ' | | Sid | | |  serial# | | | ' From  sys.gv\ $session where username= ' SCOTT ';
Exit; "> Sel.sql
sqlplus-silent/nolog <<eof @sel. sql  1>tmp.sql 2>&1
EOF
Cat tmp.sql|sed  ' 1,3d '  1>exc.sql 2>&1

Step Two:

To execute a script in a step file:

#!/bin/ksh
sqlplus-silent/nolog <<eof
conn/as sysdba
@exc. SQL  1>result.log 2> &1
exit
EOF

Note:

Because I am not familiar with Shell script, can not give two scripts put together to implement the method;

The script will be described in a separate blog because it requires the local server (the server where the application resides) to go to the remote machine (the server where the database resides).