HP_UX OS 의 Oracle 관련 정보 확인 스크립트

haisins

7년 ago

#!/bin/sh
export LANG=C
echo "________________________________________________________________________"   
echo "Diagnostic Target system H/W information"
echo " "
echo " "
echo " "
echo "1. H/W CPU & MEMORY & Platformation & OS Version"  
echo "_______________________________________________________"
echo " "
/usr/contrib/bin/machinfo
echo " "
echo " "
echo "________________________________________________________________________"   
echo "Diagnostic Target system O/S information"
echo " "
echo " "
echo "5. OS Disk / Storage  Information"  
echo "_______________________________________________________"
/usr/bin/bdf
echo " "
echo " "
echo " "
echo "________________________________________________________________________"   
echo "O/S Requirements Check for Oracle DBMS"
echo " "
echo " "
echo "6. O/S Packages  Information"  
echo "_______________________________________________________"
/usr/sbin/swlist -l patch |grep PHCO_43503
/usr/sbin/swlist -l patch |grep PHCO_41479
/usr/sbin/swlist -l patch |grep PHKL_38038
/usr/sbin/swlist -l patch |grep PHKL_38938
/usr/sbin/swlist -l patch |grep PHKL_40941
/usr/sbin/swlist -l patch |grep PHSS_36354
/usr/sbin/swlist -l patch |grep PHSS_37042
/usr/sbin/swlist -l patch |grep PHSS_37959
/usr/sbin/swlist -l patch |grep PHSS_39094
/usr/sbin/swlist -l patch |grep PHSS_39100
/usr/sbin/swlist -l patch |grep PHSS_39102
/usr/sbin/swlist -l patch |grep PHSS_38141
/usr/sbin/swlist -l patch |grep PHSS_39824  
echo " "
echo " "
echo " "
echo "7. Kernel Parameter Recommendations"  
echo "_______________________________________________________"
echo "                 "
echo " "
echo " "
/usr/sbin/kctune | egrep "ksi_alloc_max|max_thread_proc|maxdsiz|maxdsiz_64|maxssiz|maxssiz_64bit|maxswapchunks|maxuprc|msgmap|msgmni|msgseg|msgtql|ncallout|ncsize|nfile|nflocks|ninode|nkthread|nproc|semmap|semmni|semmns|semmnu|semvmx|shmmax|shmmni|shmseg|vps_ceiling|tcp_largest_anon_port|udp_largest_anon_port"
echo " "
echo " "
echo " "
echo "8. Ulimit"  
echo "_______________________________________________________"
/usr/bin/ulimit -a
echo " "
echo " "
echo " "
echo "________________________________________________________________________"   
echo "Database Patches"
echo " "
echo " "
echo "Patch installed in the database is as follows. "
echo " "
echo " "
echo "9. Database Patch Information"  
echo "_______________________________________________________"
   
$ORACLE_HOME/OPatch/opatch lsinventory -detail 

echo " "
echo " "
echo " "
echo "_______________________________________________________________________________________________________________________________________"
echo " "
echo " "

#!/bin/sh

export LANG=C

echo "________________________________________________________________________"

echo "Diagnostic Target system H/W information"

echo " "

echo "1. H/W CPU & MEMORY & Platformation & OS Version"

echo "_______________________________________________________"

echo " "

/usr/contrib/bin/machinfo

echo " "

echo "________________________________________________________________________"

echo "Diagnostic Target system O/S information"

echo " "

echo "5. OS Disk / Storage Information"

echo "_______________________________________________________"

/usr/bin/bdf

echo " "

echo "________________________________________________________________________"

echo "O/S Requirements Check for Oracle DBMS"

echo " "

echo "6. O/S Packages Information"

echo "_______________________________________________________"

/usr/sbin/swlist -l patch |grep PHCO_43503

/usr/sbin/swlist -l patch |grep PHCO_41479

/usr/sbin/swlist -l patch |grep PHKL_38038

/usr/sbin/swlist -l patch |grep PHKL_38938

/usr/sbin/swlist -l patch |grep PHKL_40941

/usr/sbin/swlist -l patch |grep PHSS_36354

/usr/sbin/swlist -l patch |grep PHSS_37042

/usr/sbin/swlist -l patch |grep PHSS_37959

/usr/sbin/swlist -l patch |grep PHSS_39094

/usr/sbin/swlist -l patch |grep PHSS_39100

/usr/sbin/swlist -l patch |grep PHSS_39102

/usr/sbin/swlist -l patch |grep PHSS_38141

/usr/sbin/swlist -l patch |grep PHSS_39824

echo " "

echo "7. Kernel Parameter Recommendations"

echo "_______________________________________________________"

echo " "

echo " "

echo "8. Ulimit"

echo "_______________________________________________________"

/usr/bin/ulimit -a

echo " "

echo "________________________________________________________________________"

echo "Database Patches"

echo " "

echo "Patch installed in the database is as follows. "

echo " "

echo "9. Database Patch Information"

echo "_______________________________________________________"

$ORACLE_HOME/OPatch/opatch lsinventory -detail

echo " "

echo "_______________________________________________________________________________________________________________________________________"

echo " "