#! /usr/bin/ksh
echo "ORAHOME=$ORACLE_HOME"
ls -l $ORACLE_HOME/network/admin/sqlnet.ora
function everything(){
		
	while read line; do
		temp=`perl -e '$_=shift; /^([^#]\w+) ?= ?(\w+)/; print "$1\t$2\n"' "$line"`
 		parameter=`echo $temp | awk '{print $1}'`
 		case "$parameter" in
	"break_poll_skip") value=`echo $temp | awk '{print $2}'`
            			   if [ $value != 1024 ]; then
           			      echo "break_poll_skip is currently not set to its recommended value of: 1024"
          			     fi;;
	"TCP.NODELAY") value=`echo $temp | awk '{print $2}'`
      	         if [ $value != yes ]; then
                 echo "TCP.NODELAY is currently not set to its recommended value of: yes"
               fi;;
	"bequeath_detach") value=`echo $temp | awk '{print $2}'`
               if [ $value != yes ]; then
                 echo "bequeath_detach is currently not set to its recommended value of: yes"
               fi;;
	NAMES.DEFAULT_DOMAIN) value=`echo $temp | awk '{print $2}'`
               if [ $value != world ]; then
                 echo "NAMES.DEFAULT_DOMAIN is currently not set to its recommended value of: world"
               fi;;
  esac
done < $ORACLE_HOME/network/admin/sqlnet.ora

#echo "Running Tunable_Settings"
./tunable_settings.ksh > tunableresults.txt
while read line 
do 
        echo $line | egrep "^value" | grep -v "would not be modified" 
done < tunableresults.txt

cd $cer_mgr
grep "MQ_CHANNEL_SUPPRESS_INTERVAL \"864000,0\"" mq_$(hostname)_${environment}_startup.ksh
if [ $? > 0 ]; then echo "MQ_CHANNEL_SUPPRESS_INTERVAL is missing or incorrect"; fi
grep "MQ_CHANNEL_SUPPRESS_MSGS \"9208,9209\"" mq_$(hostname)_${environment}_startup.ksh
if [ $? > 0 ]; then echo "MQ_CHANNEL_SUPPRESS_MSGS is missing or incorrect"; fi

while read line; do
  parameter=`echo $line | awk '{print $1}'`
  case $parameter in
	dml_locks) value=`echo $line | awk '{print $2}'`
               if [ $value != 2000 ]; then
                 echo "dml_locks is currently not set to its recommended value of: 2000"
               fi;;
	db_file_multiblock_read_count) value=`echo $line | awk '{print $2}'`
               if [ $value != 16 ]; then
                 echo "db_file_multiblock_read_count is currently not set to its recommended value of: 16"
               fi;;
	java_pool_size) value=`echo $line | awk '{print $2}'`
               if [ $value != 0 ]; then
                 echo "java_pool_size is currently not set to its recommended value of: 0"
               fi;;
	job_queue_processes) value=`echo $line | awk '{print $2}'`
               if [ $value != 5 ]; then
                 echo "job_queue_processes is currently not set to its recommended value of: 5"
               fi;;
	log_checkpoint_interval) value=`echo $line | awk '{print $2}'`
               if [ $value != 0 ]; then
                 echo "log_checkpoint_interval is currently not set to its recommended value of: 0"
               fi;;
	max_commit_propagation_delay) value=`echo $line | awk '{print $2}'`
               if [ $value != 0 ]; then
                 echo "max_commit_propagation_delay is currently not set to its recommended value of: 0"
               fi;;
	open_cursors) value=`echo $line | awk '{print $2}'`
               if [ $value != 2000 ]; then
                 echo "open_cursors is currently not set to its recommended value of: 2000"
               fi;;
	processes) value=`echo $line | awk '{print $2}'`
               if [ $value != 1500 ]; then
                 echo "processes is currently not set to its recommended value of: 1500"
               fi;;
	session_cached_cursors) value=`echo $line | awk '{print $2}'`
               if [ $value != 50 ]; then
                 echo "session_cached_cursors is currently not set to its recommended value of: 50"
               fi;;
	_kghdsidx_count) value=`echo $line | awk '{print $2}'`
               if [ $value != 1 ]; then
                 echo "_kghdsidx_count is currently not set to its recommended value of: 1"
               fi;;
	hpux_sched_noage) value=`echo $line | awk '{print $2}'`
               if [ $value != 178 ]; then
                 echo "hpux_sched_noage is currently not set to its recommended value of: 178"
               fi;;
	o7_dictionary_accessibility) value=`echo $line | awk '{print $2}'`
               if [ $value != True ]; then
                 echo "o7_dictionary_accessibility is currently not set to its recommended value of: True"
               fi;;
	cursor_space_for_time) value=`echo $line | awk '{print $2}'`
               if [ $value != False ]; then
                 echo "cursor_space_for_time is currently not set to its recommended value of: True"
               fi;;
	global_names) value=`echo $line | awk '{print $2}'`
               if [ $value != False ]; then
                 echo "global_names is currently not set to its recommended value of: False"
               fi;;
	enqueue_resources) value=`echo $line | awk '{print $2}'`
               if [ $value != 5000 ]; then
                 echo "enqueue_resources is currently not set to its recommended value of: 5000"
               fi;;
  esac
done < $CCLUSERDIR/asos.dat

touch /AuditScriptResultsnetwork.txt
#Find the NIC Speed
#wipe out the file
> /AuditScriptResultsnetwork.txt
i=0 
while [[ $i -le 6 ]] 
do 
         lanadmin -ax $i 2>/dev/null >> /AuditScriptResultsnetwork.txt
        ((i=i+1)) 
done
while read line 
do 
#echo $line | egrep -i '(speed)'
if [ `echo $line | grep '1000'` ]; then
isgig="true"
fi
if [ `echo $line | grep -i 'off'` ]; then
		if [ $isgig = "true" ]; then
		echo "Check NIC Speed settings. Speed = 1000 where Autonegotion should be on"
		fi
fi
done < /AuditScriptResultsnetwork.txt
	}

echo "Server Audit Script"
echo "Before you start you must do the following..."
echo "Go into CCL"
echo "select name,value from v$paramter order by name go"
echo "print as asos"
echo "run dm2_sys_hlth_chk_menu go"
echo "type 1 for Cerner Millennium Confiuration"
echo "Enter your Cerner Millennium username and password then type C to continue."
echo "print as shch"
print -n "Type Y when you have completed the task: ";print ""
echo "What type of node are you on?"
echo "Type db for Database. Type app for Application. Type both for both."
print -n "Node: ";read var

case $var in
both)
echo "do everything"
everything
;;
app)
echo "do app stuff"
;;
db)
echo "do db stuff"
;;
esac