1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 |
#!/bin/sh export LANG=C echo "________________________________________________________________________" echo "Diagnostic Target system H/W information" echo " " echo " " echo " " echo "1. H/W Platformation" echo "_______________________________________________________" echo " " /bin/uname -a echo " " echo " " echo "2. H/W CPU Infomation" echo "_______________________________________________________" echo " " /bin/grep -c processor /proc/cpuinfo echo " " echo " " echo "3. H/W MEMORY Infomation" echo "_______________________________________________________" echo " " /usr/bin/free -m echo " " echo " " echo " " echo "________________________________________________________________________" echo "Diagnostic Target system O/S information" echo " " echo " " echo " " echo "4. OS Version Check" echo "_______________________________________________________" /bin/cat /etc/redhat-release echo " " echo " " echo "5. OS Disk / Storage Information" echo "_______________________________________________________" /bin/df -h echo " " echo " " echo " " echo " " echo "________________________________________________________________________" echo "O/S Requirements Check for Oracle DBMS" echo " " echo " " echo "6. O/S Packages Information" echo "_______________________________________________________" /bin/rpm -qa | grep ^binutils- /bin/rpm -qa | grep ^compat-libstdc++- /bin/rpm -qa | grep ^elfutils-libelf- /bin/rpm -qa | grep ^gcc- /bin/rpm -qa | grep ^glibc- /bin/rpm -qa | grep ^libaio- /bin/rpm -qa | grep ^libgcc- /bin/rpm -qa | grep ^libstdc++- /bin/rpm -qa | grep ^make- /bin/rpm -qa | grep ^numactl- /bin/rpm -qa | grep ^sysstat- /bin/rpm -qa | grep ^unixODBC- echo " " echo " " echo " " echo "7. Kernel Parameter Recommendations" echo "_______________________________________________________" echo " " echo "@semmsl semmns semopm semmni" /bin/cat /proc/sys/kernel/sem echo "@shmall" /bin/cat /proc/sys/kernel/shmall echo "@shmmax" /bin/cat /proc/sys/kernel/shmmax echo "@shmmni" /bin/cat /proc/sys/kernel/shmmni echo "@file-max" /bin/cat /proc/sys/fs/file-max echo "ip_local_port_range" /bin/cat /proc/sys/net/ipv4/ip_local_port_range echo "@rmem_default" /bin/cat /proc/sys/net/core/rmem_default echo "@rmem_max" /bin/cat /proc/sys/net/core/rmem_max echo "@wmem_default" /bin/cat /proc/sys/net/core/wmem_default echo "@wmem_max" /bin/cat "/proc/sys/net/core/wmem_max" echo "@aio-max-nr" /sbin/sysctl -a|grep aio-max-nr echo " " echo " " echo " " echo "8. Ulimit" echo "_______________________________________________________" /bin/cat /etc/security/limits.conf 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 " " |