Here is a detailed information about the scripts I have written.  I do not consider myself a programmer, I create these little programs as experiments to have a play with the language, or to solve a problem for myself.  I would gladly accept pointers from others to improve the code and make it more efficient, or simplify the code.  If you would like to make any comments then please feel free to email me at [email protected].

In the scripts the comments etc are lined up correctly when they are viewed in Notepad++ or vi. This is what I use to code Shell scripts.

arch_check.ksh - This script checks the archive location for any log files that have not yet been compressed and compresses them.

backup.ksh - Backup script for root disk

batch_file_rename.sh - This will batch rename all files from one extension to another

check_alert_log.sh - Start/stop the perl script to monitor the Oracle Alert Log

check_oracle.ksh - This script checks the pmon and the listener processes are running on the server

coalesce.ksh - This script gets the list of the tablespaces within the database and then coalesces them

create_me.ksh - I use this to create me on new Solaris builds

current_users.ksh - This will gather information about the users that are currently attached to the database.

exp_using_pipes.ksh - An example of running an export, compressing on the fly using a pipe

homedir_backup.ksh - Backs up the user that is running the script home directory, and copy it to another machine

kill_oracle.sh - This will kill all the oracle processes associated with a given sid

last_5_mins.sh - Captures just the last five minutes of a given logfile

loginlog.ksh - This creates the file which tracks failed login attempts after five failed attempts

modified_today.sh - Lists all the files that have been modified that day 

monitor_slice.ksh - Shows the slice, as well as the GB of space used, as well as the space left, it will loop round and round until you cancel it running

myping.sh - Prefixes the ping command with a date stamp, you then prove when it was run, works on Solaris and Linux

mysql_backup.sh - Backup MySQL database, either the full database or just a single database

nddchecker.ksh - Get Network Card information on Solaris

network.ksh - Get Network Information

newuser.ksh - A simple script to create a new OS account

oracle_connections.sh - This will show all of the client connections to the database

rename_files.sh - This will rename all of the files in a directory by removing the word you pass to it

show_eri.sh - Get network information for eri cards

show_hme.sh - Get network information for hme cards

test_network.ksh - A quick network test to test the network

transfer_script.sh - This will send a given script to a certain server once prompted, if it can't find the script it searches for scripts with a similar name

unix_users_to_sql.ksh - Export UNIX users to sql, you can change the last line if you want the output to go to a file, rather than be inserted straight into the database

vosstat.sh - Gather OS statistics to place in to the database

world_writable.ksh - Gather OS statistics to place in to the database