centos7 ÉÏ°²×°orcal

<h1> </h1>
<p> </p>
<p><a href="https://www.cnblogs.com/colmeluna/p/5686142.html">https://www.cnblogs.com/colmeluna/p/5686142.html</a>  6.5»·¾³Ï°²×°</p>
<p><a href="https://www.cnblogs.com/bingo1024/p/9008483.html">https://www.cnblogs.com/bingo1024/p/9008483.html</a></p>
<p> </p>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td> <p><code>yum -y install gcc gcc-c&#43;&#43; make binutils compat-libstdc&#43;&#43;-33 elfutils-libelf elfutils-libelf-devel elfutils-libelf-devel-</code><code>static</code> <code>glibc glibc-common glibc-devel ksh libaio libaio-devel libgcc libstdc&#43;&#43; libstdc&#43;&#43;-devel numactl-devel sysstat unixODBC unixODBC-devel kernelheaders pdksh pcre-devel readline rlwrap¡¡</code></p> </td></tr></tbody></table>
<p><a name="_label0_3"></a></p>
<h1> </h1>
<p>select &#39;grant select on A.&#39; || tname || &#39; to B;&#39; from tab</p>
<p>¸³¸øBÓû§Äܹ»²éѯAÓû§ÏÂÃæËùÓÐÊý¾Ý，Ö´Ðкó»áÉú³É¶ÔËùÓбíµÄ¸³È¨ÏÞÓï¾ä</p>
<h1><a href="https://www.cnblogs.com/Mercurial/p/8622501.html" id="cb_post_title_url">Linux¾²Ä¬°²×°Oracle·½·¨(centos7&#43;oracle11g)</a></h1>
<p>1¡¢ Ôö¼ÓÐéÄâÄÚ´æ</p>
<pre class="blockcode"><code class="language-html">dd if&#61;/dev/zero of&#61;/swapadd bs&#61;1024 count&#61;2006424
mkswap /swapadd
swapon /swapadd</code></pre>
<p>2¡¢ ¼ì²éÒÀÀµ°ü</p>
<pre class="blockcode"><code class="language-html">rpm -q binutils compat-libstdc&#43;&#43;-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c&#43;&#43; glibc-2.5 glibc-common glibc-devel glibc-headers ksh libaio libaio-devel libgcc libstdc&#43;&#43; libstdc&#43;&#43;-devel make sysstat unixODBC unixODBC-devel</code></pre>
<p>3¡¢ °²×°ÒÀÀµ°ü</p>
<p><img alt="¸´ÖÆ´úÂë" class="blockcode" src="https://beijingoptbbs.oss-cn-beijing.aliyuncs.com/cs/5606289-48304ba5e6f9fe08f3fa1abda7d326ab.gif"></p>
<pre class="blockcode"><code class="language-html">yum install compat-libstdc&#43;&#43;-33
yum install elfutils-libelf-devel
yum install gcc-c&#43;&#43;
yum install glibc-2.5
yum install ksh
yum install libaio
yum install libaio-devel
yum install libstdc&#43;&#43;-devel
yum install unixODBC
yum install unixODBC-devel</code></pre>
<p><img alt="¸´ÖÆ´úÂë" class="blockcode" src="https://beijingoptbbs.oss-cn-beijing.aliyuncs.com/cs/5606289-48304ba5e6f9fe08f3fa1abda7d326ab.gif"></p>
<p>4¡¢ ´´½¨Óû§ºÍ×é</p>
<p><img alt="¸´ÖÆ´úÂë" class="blockcode" src="https://beijingoptbbs.oss-cn-beijing.aliyuncs.com/cs/5606289-48304ba5e6f9fe08f3fa1abda7d326ab.gif"></p>
<pre class="blockcode"><code class="language-html">groupadd oinstall  
groupadd dba  
groupadd asmadmin  
groupadd asmdba  
useradd -g oinstall -G dba,asmdba oracle -d /home/oracle  
passwd oracle </code></pre>
<p><img alt="¸´ÖÆ´úÂë" class="blockcode" src="https://beijingoptbbs.oss-cn-beijing.aliyuncs.com/cs/5606289-48304ba5e6f9fe08f3fa1abda7d326ab.gif"></p>
<p>5¡¢ ÐÞ¸ÄÄں˲ÎÊý</p>
<p><img alt="¸´ÖÆ´úÂë" class="blockcode" src="https://beijingoptbbs.oss-cn-beijing.aliyuncs.com/cs/5606289-48304ba5e6f9fe08f3fa1abda7d326ab.gif"></p>
<pre class="blockcode"><code class="language-html">vim /etc/sysctl.conf  Ôö¼Ó»òÕßÐÞ¸Ä
fs.aio-max-nr &#61; 1048576
fs.file-max &#61; 6815744
kernel.shmall &#61; 2097152
kernel.shmmax &#61; 536870912
kernel.shmmni &#61; 4096
kernel.sem &#61; 250 32000 100 128
net.ipv4.ip_local_port_range &#61; 9000 65500
net.core.rmem_default &#61; 262144
net.core.rmem_max &#61; 4194304
net.core.wmem_default &#61; 262144
net.core.wmem_max &#61; 1048576</code></pre>
<p><img alt="¸´ÖÆ´úÂë" class="blockcode" src="https://beijingoptbbs.oss-cn-beijing.aliyuncs.com/cs/5606289-48304ba5e6f9fe08f3fa1abda7d326ab.gif"></p>
<p>6¡¢ ÐÞ¸ÄÓû§ÏÞÖÆ</p>
<p><img alt="¸´ÖÆ´úÂë" class="blockcode" src="https://beijingoptbbs.oss-cn-beijing.aliyuncs.com/cs/5606289-48304ba5e6f9fe08f3fa1abda7d326ab.gif"></p>
<pre class="blockcode"><code class="language-html">vim /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
vim /etc/pam.d/login
session  required   pam_limits.so
vim /etc/profile
if [ $USER &#61; &#34;oracle&#34; ]; then
   if [ $SHELL &#61; &#34;/bin/ksh&#34; ]; then
      ulimit -p 16384
      ulimit -n 65536
      else
      ulimit -u 16384 -n 65536
   fi
fi
source /etc/profile</code></pre>
<p><img alt="¸´ÖÆ´úÂë" class="blockcode" src="https://beijingoptbbs.oss-cn-beijing.aliyuncs.com/cs/5606289-48304ba5e6f9fe08f3fa1abda7d326ab.gif"></p>
<p>7¡¢ ´´½¨°²×°Ä¿Â¼</p>
<p><img alt="¸´ÖÆ´úÂë" class="blockcode" src="https://beijingoptbbs.oss-cn-beijing.aliyuncs.com/cs/5606289-48304ba5e6f9fe08f3fa1abda7d326ab.gif"></p>
<pre class="blockcode"><code class="language-html">mkdir -p /u01/app/
chown -R oracle:oinstall /home/oracle  
chmod -R 775 /home/oracle  
chown -R oracle:oinstall /u01/app/
chmod -R 775 /u01/app/
´´½¨vim /etc/oraInst.loc
inventory_loc&#61;/u01/app/oracle/oraInventory
inst_group&#61;oinstall
chown oracle:oinstall /etc/oraInst.loc
chmod 664 /etc/oraInst.loc</code></pre>
<p><img alt="¸´ÖÆ´úÂë" class="blockcode" src="https://beijingoptbbs.oss-cn-beijing.aliyuncs.com/cs/5606289-48304ba5e6f9fe08f3fa1abda7d326ab.gif"></p>
<p>8¡¢ ÉèÖÃoracle»·¾³±äÁ¿</p>
<p><img alt="¸´ÖÆ´úÂë" class="blockcode" src="https://beijingoptbbs.oss-cn-beijing.aliyuncs.com/cs/5606289-48304ba5e6f9fe08f3fa1abda7d326ab.gif"></p>
<pre class="blockcode"><code class="language-html">su