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
