{"id":2827,"date":"2018-02-03T14:28:51","date_gmt":"2018-02-03T05:28:51","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=2827"},"modified":"2018-02-03T14:28:51","modified_gmt":"2018-02-03T05:28:51","slug":"linux-os%ec%9d%98-oracle-%ea%b4%80%eb%a0%a8-%ec%a0%95%eb%b3%b4-%ed%99%95%ec%9d%b8-%ec%8a%a4%ed%81%ac%eb%a6%bd%ed%8a%b8","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=2827","title":{"rendered":"LINUX OS\uc758 Oracle \uad00\ub828 \uc815\ubcf4 \ud655\uc778 \uc2a4\ud06c\ub9bd\ud2b8"},"content":{"rendered":"<p>&nbsp;<\/p>\n<pre class=\"theme:eclipse lang:sh decode:true \">#!\/bin\/sh\r\nexport LANG=C\r\necho \"________________________________________________________________________\"   \r\necho \"Diagnostic Target system H\/W information\"\r\necho \" \"\r\necho \" \"\r\necho \" \"\r\necho \"1. H\/W Platformation\"  \r\necho \"_______________________________________________________\"\r\necho \" \"\r\n\/bin\/uname -a   \r\necho \" \"\r\necho \" \"\r\necho \"2. H\/W CPU Infomation\"  \r\necho \"_______________________________________________________\"\r\necho \" \" \r\n\/bin\/grep -c processor \/proc\/cpuinfo   \r\necho \" \"\r\necho \" \"\r\necho \"3. H\/W MEMORY Infomation\"  \r\necho \"_______________________________________________________\"\r\necho \" \" \r\n\/usr\/bin\/free -m   \r\necho \" \"\r\necho \" \"\r\necho \" \"\r\necho \"________________________________________________________________________\"   \r\necho \"Diagnostic Target system O\/S information\"\r\necho \" \"\r\necho \" \"\r\necho \" \"\r\necho \"4. OS Version Check\"  \r\necho \"_______________________________________________________\"\r\n\/bin\/cat \/etc\/redhat-release   \r\necho \" \"\r\necho \" \"\r\necho \"5. OS Disk \/ Storage  Information\"  \r\necho \"_______________________________________________________\"\r\n\/bin\/df -h\r\necho \" \"\r\necho \" \"\r\necho \" \"\r\necho \" \"\r\necho \"________________________________________________________________________\"   \r\necho \"O\/S Requirements Check for Oracle DBMS\"\r\necho \" \"\r\necho \" \"\r\necho \"6. O\/S Packages  Information\"  \r\necho \"_______________________________________________________\"\r\n\/bin\/rpm -qa | grep ^binutils-\r\n\/bin\/rpm -qa | grep ^compat-libstdc++-\r\n\/bin\/rpm -qa | grep ^elfutils-libelf-\r\n\/bin\/rpm -qa | grep ^gcc-\r\n\/bin\/rpm -qa | grep ^glibc-\r\n\/bin\/rpm -qa | grep ^libaio-\r\n\/bin\/rpm -qa | grep ^libgcc-\r\n\/bin\/rpm -qa | grep ^libstdc++-\r\n\/bin\/rpm -qa | grep ^make-\r\n\/bin\/rpm -qa | grep ^numactl-\r\n\/bin\/rpm -qa | grep ^sysstat-\r\n\/bin\/rpm -qa | grep ^unixODBC-\r\necho \" \"\r\necho \" \"\r\necho \" \"\r\necho \"7. Kernel Parameter Recommendations\"  \r\necho \"_______________________________________________________\"\r\necho \"                 \"\r\necho \"@semmsl semmns semopm semmni\"\r\n\/bin\/cat \/proc\/sys\/kernel\/sem\r\necho \"@shmall\"\r\n\/bin\/cat \/proc\/sys\/kernel\/shmall\r\necho \"@shmmax\"\r\n\/bin\/cat \/proc\/sys\/kernel\/shmmax\r\necho \"@shmmni\"\r\n\/bin\/cat \/proc\/sys\/kernel\/shmmni\r\necho \"@file-max\"\r\n\/bin\/cat \/proc\/sys\/fs\/file-max\r\necho \"ip_local_port_range\"\r\n\/bin\/cat \/proc\/sys\/net\/ipv4\/ip_local_port_range\r\necho \"@rmem_default\"\r\n\/bin\/cat \/proc\/sys\/net\/core\/rmem_default\r\necho \"@rmem_max\"\r\n\/bin\/cat \/proc\/sys\/net\/core\/rmem_max\r\necho \"@wmem_default\"\r\n\/bin\/cat \/proc\/sys\/net\/core\/wmem_default\r\necho \"@wmem_max\"\r\n\/bin\/cat \"\/proc\/sys\/net\/core\/wmem_max\"\r\necho \"@aio-max-nr\"\r\n\/sbin\/sysctl -a|grep aio-max-nr\r\necho \" \"\r\necho \" \"\r\necho \" \"\r\necho \"8. Ulimit\"  \r\necho \"_______________________________________________________\"\r\n\/bin\/cat \/etc\/security\/limits.conf  \r\necho \" \"\r\necho \" \"\r\necho \" \"\r\necho \"________________________________________________________________________\"   \r\necho \"Database Patches\"\r\necho \" \"\r\necho \" \"\r\necho \"Patch installed in the database is as follows. \"\r\necho \" \"\r\necho \" \"\r\necho \"9. Database Patch Information\"  \r\necho \"_______________________________________________________\"\r\n   \r\n$ORACLE_HOME\/OPatch\/opatch lsinventory -detail\r\n\r\necho \" \"\r\necho \" \"\r\necho \" \"\r\necho \"_______________________________________________________________________________________________________________________________________\"\r\necho \" \"\r\necho \" \"\r\n\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; #!\/bin\/sh export LANG=C echo &#8220;________________________________________________________________________&#8221; echo &#8220;Diagnostic Target system H\/W information&#8221; echo &#8221; &#8221; echo &#8221; &#8221; echo &#8221; &#8221; echo &#8220;1. H\/W Platformation&#8221; echo &#8220;_______________________________________________________&#8221; echo &#8221; &#8221; \/bin\/uname -a echo &#8221; &#8221; echo &#8221; &#8221; echo &#8220;2. H\/W CPU Infomation&#8221; echo &#8220;_______________________________________________________&#8221; echo &#8221; &#8221; \/bin\/grep -c processor \/proc\/cpuinfo echo &#8221; &#8221; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[3],"tags":[453,917],"jetpack_featured_media_url":"","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2827"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2827"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2827\/revisions"}],"predecessor-version":[{"id":2828,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/2827\/revisions\/2828"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2827"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2827"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2827"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}