{"id":1032,"date":"2017-03-11T15:31:08","date_gmt":"2017-03-11T07:31:08","guid":{"rendered":"http:\/\/www.821121.com\/?p=1032"},"modified":"2020-12-11T15:47:17","modified_gmt":"2020-12-11T07:47:17","slug":"oracle%e6%b8%85%e7%90%86%e6%97%a5%e5%bf%97%e8%84%9a%e6%9c%ac10g%ef%bc%8c11g","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1032","title":{"rendered":"ORACLE\u6e05\u7406\u65e5\u5fd7\u811a\u672c10g\uff0c11g"},"content":{"rendered":"<p>\u4e3a\u4e86\u65b9\u4fbf\u6709\u6548\u7684\u6e05\u7406\u5197\u4f59\u65e5\u5fd7\uff0c\u5c06\u5e38\u89c4\u64cd\u4f5c\u811a\u672c\u5316\uff0c\u652f\u6301linux\u73af\u5883\u4e0b\u768410g\/11gR1\/11gR2<\/p>\n<h4>1 ----------------------ORACLE 10G DB\u73af\u5883<\/h4>\n<p>\u4f7f\u7528oracle\u7528\u6237\u6267\u884c<\/p>\n<pre><code class=\"language-shell\">ps -ef | grep pmon |sort -r| grep -v grep | grep -v ASM| awk -F &#039;_&#039; &#039;{print $3}&#039;| while read SID\n\n\u00a0 \u00a0do\n\n\u00a0 \u00a0 \u00a0export ORACLE_SID=${SID}\n\n\u00a0 \u00a0 \u00a0V_VALUE1=`sqlplus -S \/nolog &lt;&lt;EOF\n\n\u00a0 \u00a0 \u00a0connect \/as sysdba\n\n\u00a0 \u00a0 \u00a0set heading off feedback off pagesize 0 verify off echo off;\n\n\u00a0 \u00a0 \u00a0select p.value from v\\\\$parameter p where p.NAME = &#039;background_dump_dest&#039;;\n\nEOF`\n\n\u00a0 \u00a0 \u00a0V_VALUE2=`sqlplus -S \/nolog &lt;&lt;EOF\n\n\u00a0 \u00a0 \u00a0connect \/as sysdba\n\n\u00a0 \u00a0 \u00a0set heading off feedback off pagesize 0 verify off echo off;\n\n\u00a0 \u00a0 \u00a0select p.value from v\\\\$parameter p where p.NAME = &#039;user_dump_dest&#039;;\n\nEOF`\n\n\u00a0 \u00a0 \u00a0V_VALUE3=`sqlplus -S \/nolog &lt;&lt;EOF\n\n\u00a0 \u00a0 \u00a0connect \/as sysdba\n\n\u00a0 \u00a0 \u00a0set heading off feedback off pagesize 0 verify off echo off;\n\n\u00a0 \u00a0 \u00a0select p.value from v\\\\$parameter p where p.NAME = &#039;core_dump_dest&#039;;\n\nEOF`\n\n\u00a0 \u00a0 \u00a0NUM1=`ls $V_VALUE1 | wc -l`\u00a0\n\n\u00a0 \u00a0 \u00a0NUM2=`ls $V_VALUE2 | wc -l`\u00a0\n\n\u00a0 \u00a0 \u00a0NUM3=`ls $V_VALUE3 | wc -l`\u00a0\n\n\u00a0 \u00a0 \u00a0echo &#039;Old Num1 = &#039;${NUM1};\n\n\u00a0 \u00a0 \u00a0echo &#039;Old Num2 = &#039;${NUM2};\n\n\u00a0 \u00a0 \u00a0echo &#039;Old Num3 = &#039;${NUM3};\n\n\u00a0 \u00a0 \u00a0find $V_VALUE1 -name  ${ORACLE_SID}_*.trc  -type f -mtime +60 -exec rm -f {} \\;\n\n\u00a0 \u00a0 \u00a0find $V_VALUE2 -name  ${ORACLE_SID}_*.trc  -type f -mtime +60 -exec rm -f {} \\;\n\n\u00a0 \u00a0 \u00a0find $V_VALUE3 -name  core_*  -type d -mtime +60 -exec rm -rf {} \\;\n\n\u00a0 \u00a0 \u00a0NUM1=`ls $V_VALUE1 | wc -l`\u00a0\n\n\u00a0 \u00a0 \u00a0NUM2=`ls $V_VALUE2 | wc -l`\u00a0\n\n\u00a0 \u00a0 \u00a0NUM3=`ls $V_VALUE3 | wc -l`\u00a0\n\n\u00a0 \u00a0 \u00a0echo &#039;New Num1 = &#039;${NUM1};\n\n\u00a0 \u00a0 \u00a0echo &#039;New Num2 = &#039;${NUM2};\n\n\u00a0 \u00a0 \u00a0echo &#039;New Num3 = &#039;${NUM3};\n\n\u00a0 \u00a0done<\/code><\/pre>\n<h4>2 ----------------------ORACLE 11G DB\u73af\u5883<\/h4>\n<p>\u4f7f\u7528oracle\u7528\u6237\u6267\u884c<\/p>\n<pre><code class=\"language-shell\">ps -ef | grep pmon |sort -r| grep -v grep | grep -v ASM| awk -F &#039;_&#039; &#039;{print $3}&#039;| while read SID\n\n\u00a0 do\n\n\u00a0 \u00a0 \u00a0export ORACLE_SID=${SID}\n\n\u00a0 \u00a0 \u00a0V_VALUE=`sqlplus \u00a0 \u00a0-S \/nolog &lt;&lt;EOF\n\n\u00a0 \u00a0 \u00a0connect \/as sysdba\n\n\u00a0 \u00a0 \u00a0set heading off feedback off pagesize 0 verify off echo off;\n\n\u00a0 \u00a0 \u00a0select p.value from v\\\\$parameter p where p.NAME = &#039;background_dump_dest&#039;;\n\nEOF`\n\n\u00a0 \u00a0 echo $V_VALUE;\n\n\u00a0 \u00a0 find $V_VALUE -name  cdmp_*  -type d -exec rm -rf {} \\;\n\n\u00a0 \u00a0 find $V_VALUE -name  *.trc  -ctime +30 -type f -exec rm -f {} \\;\n\n\u00a0 \u00a0 find $V_VALUE -name  *.trm  -ctime +30 \u00a0-type f -exec rm -f {} \\;\n\n\u00a0 done<\/code><\/pre>\n<h4>3 ----------------------ORACLE 11G CRS<\/h4>\n<p>\u4f7f\u7528oracle\u7528\u6237\u6267\u884c<\/p>\n<pre><code class=\"language-shell\">cat &gt; $ORACLE_BASE\/diag\/tnslsnr\/`hostname`\/listener_`hostname`\/trace\/listener_`host\n\nEOF \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\n\nrm -f $ORACLE_BASE\/diag\/tnslsnr\/`hostname`\/listener_`hostname`\/alert\/log_*.xml \u00a0 \u00a0\u00a0<\/code><\/pre>\n<h4>4 ----------------------ORACLE 11GR2 CRS<\/h4>\n<p>\u4f7f\u7528grid\u7528\u6237\u6267\u884c<\/p>\n<pre><code class=\"language-shell\">BASE=`sqlplus -S \/ as sysdba &lt;&lt;EOF\n\n\u00a0 set heading off feedback off pagesize 0 verify off echo off;\n\n\u00a0 select p.value from v\\\\$parameter p where p.NAME = &#039;diagnostic_dest&#039;;\n\nEOF`\n\ncat &gt; $BASE\/diag\/tnslsnr\/`hostname`\/listener\/trace\/listener.log &lt;&lt;EOF\n\nEOF\n\ncat &gt; $GRID_HOME\/log\/diag\/tnslsnr\/`hostname`\/listener_scan1\/trace\/listener_scan1.log\n\nEOF\n\nrm -f $BASE\/diag\/tnslsnr\/`hostname`\/listener\/alert\/log_*.xml\n\nrm -f $GRID_HOME\/log\/diag\/tnslsnr\/`hostname`\/listener_scan1\/alert\/log_*.xml\n\nfind $GRID_HOME\/rdbms\/audit -type f -name  *ASM*.aud  -mtime +60 -exec rm -rf {} \\;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u4e3a\u4e86\u65b9\u4fbf\u6709\u6548\u7684\u6e05\u7406\u5197\u4f59\u65e5\u5fd7\uff0c\u5c06\u5e38\u89c4\u64cd\u4f5c\u811a\u672c\u5316\uff0c\u652f\u6301<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34],"tags":[],"class_list":["post-1032","post","type-post","status-publish","format-standard","hentry","category-34"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1032","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1032"}],"version-history":[{"count":3,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1032\/revisions"}],"predecessor-version":[{"id":1035,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1032\/revisions\/1035"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1032"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1032"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1032"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}