centos7下安装oracle11gR2的详细步骤
<p>环境准备</p>
<p>
安装包:</p>
<ul>
<li>
CentOS-7-x86_64-DVD</li>
<li>
linux.x64_11gR2_database_1of2.zip</li>
<li>
linux.x64_11gR2_database_2of2.zip</li>
</ul>
<p>
本教程是在VMware下安装的，注意设置内存的时候，不要设置动态内存。</p>
<p>
<strong>安装Oracle前准备</strong></p>
<p>
创建运行oracle数据库的系统用户和用户组</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_36869">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
<div class="line number11 index10 alt2">
11</div>
<div class="line number12 index11 alt1">
12</div>
<div class="line number13 index12 alt2">
13</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">$ </code><code class="bash functions">su</code> <code class="bash plain">root </code><code class="bash comments">#切换到root</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">Password:</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain"></code><code class="bash comments"># groupadd oinstall #创建用户组oinstall</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain"></code><code class="bash comments"># groupadd dba #创建用户组dba</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain"></code><code class="bash comments"># useradd -g oinstall -g dba -m oracle #创建oracle用户，并加入到oinstall和dba用户组</code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain"></code><code class="bash comments"># passwd oracle #设置用户oracle的登陆密码，不设置密码，在CentOS的图形登陆界面没法登陆</code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">Changing password </code><code class="bash keyword">for</code> <code class="bash plain">user oracle.</code>
</div>
<div class="line number8 index7 alt1">
<code class="bash plain">New password: </code><code class="bash comments"># 密码</code>
</div>
<div class="line number9 index8 alt2">
<code class="bash plain">BAD PASSWORD: The password is shorter than 8 characters</code>
</div>
<div class="line number10 index9 alt1">
<code class="bash plain">Retype new password: </code><code class="bash comments"># 确认密码</code>
</div>
<div class="line number11 index10 alt2">
<code class="bash functions">passwd</code><code class="bash plain">: all authentication tokens updated successfully.</code>
</div>
<div class="line number12 index11 alt1">
<code class="bash plain"></code><code class="bash comments"># id oracle # 查看新建的oracle用户</code>
</div>
<div class="line number13 index12 alt2">
<code class="bash plain">uid=1001(oracle) gid=1002(dba) </code><code class="bash functions">groups</code><code class="bash plain">=1002(dba)</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
创建oracle数据库安装目录</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_252517">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
<div class="line number11 index10 alt2">
11</div>
<div class="line number12 index11 alt1">
12</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">$ </code><code class="bash functions">su</code> <code class="bash plain">root</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">Password:</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain"></code><code class="bash comments"># mkdir -p /data/oracle #oracle数据库安装目录</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain"></code><code class="bash comments"># mkdir -p /data/oraInventory #oracle数据库配置文件目录</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain"></code><code class="bash comments"># mkdir -p /data/database #oracle数据库软件包解压目录</code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain"></code><code class="bash comments"># cd /data</code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain"></code><code class="bash comments"># ls #创建完毕检查一下（强迫症）</code>
</div>
<div class="line number8 index7 alt1">
<code class="bash plain">database oracle oraInventory</code>
</div>
<div class="line number9 index8 alt2">
<code class="bash plain"></code><code class="bash comments"># chown -R oracle:oinstall /data/oracle #设置目录所有者为oinstall用户组的oracle用户</code>
</div>
<div class="line number10 index9 alt1">
<code class="bash plain"></code><code class="bash comments"># chown -R oracle:oinstall /data/oraInventory</code>
</div>
<div class="line number11 index10 alt2">
<code class="bash plain"></code><code class="bash comments"># chown -R oracle:oinstall /data/database</code>
</div>
<div class="line number12 index11 alt1">
<code class="bash plain"></code><code class="bash comments">#</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
修改OS系统标识</p>
<p>
Oracle默认不支持CentOS系统安装，Oracle Database 11g Release 2 的 OS要求参考：link</p>
<p>
修改文件 /etc/RedHat-release</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_718841">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># cat /proc/version</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">Linux version 3.10.0-327.el7.x86_64 (builder@kbuilder.dev.centos.org) (gcc version 4.8.3 20140911 (Red Hat 4.8.3-9) (GCC) ) </code><code class="bash comments">#1 SMP Thu Nov 19 22:10:57 UTC 2015</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain"></code><code class="bash comments"># cat /etc/redhat-release </code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">CentOS Linux release 7.1.1503 (Core)</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain"></code><code class="bash comments"># vi /etc/redhat-release</code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain"></code><code class="bash comments"># cat /etc/redhat-release</code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">redhat-7</code>
</div>
<div class="line number8 index7 alt1">
<code class="bash plain"></code><code class="bash comments">#</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
安装oracle数据库所需要的软件包</p>
<p>
Oracle Database Package Requirements for Linux x86-64 如下：（参考：https://docs.oracle.com/cd/E11882_01/install.112/e47689/pre_install.htm#BABCFJFG）</p>
<p>
</p>
<div class="codetitle">
<span><u>复制代码</u></span> 代码如下:</div>
<div class="codebody" id="code5070">
<br>
yum install gcc* gcc-* gcc-c++-* glibc-devel-* glibc-headers-* compat-libstdc* libstdc* elfutils-libelf-devel* libaio-devel* sysstat* unixODBC-* pdksh-*</div>
<p>
</p>
<p>
根据具体情况去安装,上面只是提供了一个大概的内容，不是很全</p>
<p>
<span><strong>关闭防火墙</strong></span></p>
<p>
CentOS 7.2默认使用的是firewall作为防火墙</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_910037">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
<div class="line number11 index10 alt2">
11</div>
<div class="line number12 index11 alt1">
12</div>
<div class="line number13 index12 alt2">
13</div>
<div class="line number14 index13 alt1">
14</div>
<div class="line number15 index14 alt2">
15</div>
<div class="line number16 index15 alt1">
16</div>
<div class="line number17 index16 alt2">
17</div>
<div class="line number18 index17 alt1">
18</div>
<div class="line number19 index18 alt2">
19</div>
<div class="line number20 index19 alt1">
20</div>
<div class="line number21 index20 alt2">
21</div>
<div class="line number22 index21 alt1">
22</div>
<div class="line number23 index22 alt2">
23</div>
<div class="line number24 index23 alt1">
24</div>
<div class="line number25 index24 alt2">
25</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># systemctl status firewalld.service #查看防火墙状态，运行中</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">● firewalld.service - firewalld - dynamic firewall daemon</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash spaces"> </code><code class="bash plain">Loaded: loaded (</code><code class="bash plain">/usr/lib/systemd/system/firewalld</code><code class="bash plain">.service; enabled; vendor preset: enabled)</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash spaces"> </code><code class="bash plain">Active: active (running) since Thu 2016-04-07 18:54:29 PDT; 2h 20min ago</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash spaces"> </code><code class="bash plain">Main PID: 802 (firewalld)</code>
</div>
<div class="line number6 index5 alt1">
<code class="bash spaces"> </code><code class="bash plain">CGroup: </code><code class="bash plain">/system</code><code class="bash plain">.slice</code><code class="bash plain">/firewalld</code><code class="bash plain">.service</code>
</div>
<div class="line number7 index6 alt2">
<code class="bash spaces"> </code><code class="bash plain">└─802 </code><code class="bash plain">/usr/bin/python</code> <code class="bash plain">-Es </code><code class="bash plain">/usr/sbin/firewalld</code> <code class="bash plain">--nofork --nopid</code>
</div>
<div class="line number8 index7 alt1">
</div>
<div class="line number9 index8 alt2">
<code class="bash plain">Apr 07 18:54:25 localhost.localdomain systemd: Starting firewalld - dynamic firewall daemon...</code>
</div>
<div class="line number10 index9 alt1">
<code class="bash plain">Apr 07 18:54:29 localhost.localdomain systemd: Started firewalld - dynamic firewall daemon.</code>
</div>
<div class="line number11 index10 alt2">
<code class="bash plain"></code><code class="bash comments"># systemctl stop firewalld.service #关闭防火墙</code>
</div>
<div class="line number12 index11 alt1">
<code class="bash plain"></code><code class="bash comments"># systemctl status firewalld.service #再次查看防火墙状态，发现已关闭</code>
</div>
<div class="line number13 index12 alt2">
<code class="bash plain">● firewalld.service - firewalld - dynamic firewall daemon</code>
</div>
<div class="line number14 index13 alt1">
<code class="bash spaces"> </code><code class="bash plain">Loaded: loaded (</code><code class="bash plain">/usr/lib/systemd/system/firewalld</code><code class="bash plain">.service; enabled; vendor preset: enabled)</code>
</div>
<div class="line number15 index14 alt2">
<code class="bash spaces"> </code><code class="bash plain">Active: inactive (dead) since Thu 2016-04-07 21:15:34 PDT; 9s ago</code>
</div>
<div class="line number16 index15 alt1">
<code class="bash spaces"> </code><code class="bash plain">Main PID: 802 (code=exited, status=0</code><code class="bash plain">/SUCCESS</code><code class="bash plain">)</code>
</div>
<div class="line number17 index16 alt2">
</div>
<div class="line number18 index17 alt1">
<code class="bash plain">Apr 07 18:54:25 localhost.localdomain systemd: Starting firewalld - dynamic firewall daemon...</code>
</div>
<div class="line number19 index18 alt2">
<code class="bash plain">Apr 07 18:54:29 localhost.localdomain systemd: Started firewalld - dynamic firewall daemon.</code>
</div>
<div class="line number20 index19 alt1">
<code class="bash plain">Apr 07 21:15:33 localhost systemd: Stopping firewalld - dynamic firewall daemon...</code>
</div>
<div class="line number21 index20 alt2">
<code class="bash plain">Apr 07 21:15:34 localhost systemd: Stopped firewalld - dynamic firewall daemon.</code>
</div>
<div class="line number22 index21 alt1">
<code class="bash plain"></code><code class="bash comments"># systemctl disable firewalld.service #禁止使用防火墙（重启也是禁止的）</code>
</div>
<div class="line number23 index22 alt2">
<code class="bash plain">Removed </code><code class="bash functions">symlink</code> <code class="bash plain">/etc/systemd/system/dbus-org</code><code class="bash plain">.Fedoraproject.FirewallD1.service.</code>
</div>
<div class="line number24 index23 alt1">
<code class="bash plain">Removed </code><code class="bash functions">symlink</code> <code class="bash plain">/etc/systemd/system/basic</code><code class="bash plain">.target.wants</code><code class="bash plain">/firewalld</code><code class="bash plain">.service.</code>
</div>
<div class="line number25 index24 alt2">
<code class="bash plain"></code><code class="bash comments">#</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<strong>关闭selinux（需重启生效）</strong></p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_621827">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># vi /etc/selinux/config </code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain"></code><code class="bash comments"># cat /etc/selinux/config</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
将 SELINUX=disabled #此处修改为disabled</p>
<p>
修改内核参数</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_413115">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># vi /etc/sysctl.conf</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
在最下面添加以下内容:</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_47923">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
<div class="line number11 index10 alt2">
11</div>
<div class="line number12 index11 alt1">
12</div>
<div class="line number13 index12 alt2">
13</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">net.ipv4.icmp_echo_ignore_broadcasts = 1</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">net.ipv4.conf.all.rp_filter = 1</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">fs.</code><code class="bash functions">file</code><code class="bash plain">-max = 6815744 </code><code class="bash comments">#设置最大打开文件数</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">fs.aio-max-nr = 1048576</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">kernel.shmall = 2097152 </code><code class="bash comments">#共享内存的总量，8G内存设置：2097152*4k/1024/1024</code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain">kernel.shmmax = 2147483648 </code><code class="bash comments">#最大共享内存的段大小</code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">kernel.shmmni = 4096 </code><code class="bash comments">#整个系统共享内存端的最大数</code>
</div>
<div class="line number8 index7 alt1">
<code class="bash plain">kernel.sem = 250 32000 100 128</code>
</div>
<div class="line number9 index8 alt2">
<code class="bash plain">net.ipv4.ip_local_port_range = 9000 65500 </code><code class="bash comments">#可使用的IPv4端口范围</code>
</div>
<div class="line number10 index9 alt1">
<code class="bash plain">net.core.rmem_default = 262144</code>
</div>
<div class="line number11 index10 alt2">
<code class="bash plain">net.core.rmem_max= 4194304</code>
</div>
<div class="line number12 index11 alt1">
<code class="bash plain">net.core.wmem_default= 262144</code>
</div>
<div class="line number13 index12 alt2">
<code class="bash plain">net.core.wmem_max= 1048576</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
使配置参数生效</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_140521">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
<div class="line number11 index10 alt2">
11</div>
<div class="line number12 index11 alt1">
12</div>
<div class="line number13 index12 alt2">
13</div>
<div class="line number14 index13 alt1">
14</div>
<div class="line number15 index14 alt2">
15</div>
<div class="line number16 index15 alt1">
16</div>
<div class="line number17 index16 alt2">
17</div>
<div class="line number18 index17 alt1">
18</div>
<div class="line number19 index18 alt2">
19</div>
<div class="line number20 index19 alt1">
20</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># sysctl -p</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">net.ipv4.icmp_echo_ignore_broadcasts = 1</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">net.ipv4.conf.all.rp_filter = 1</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">sysctl: setting key </code><code class="bash string">"fs.file-max"</code><code class="bash plain">: Invalid argument</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">fs.</code><code class="bash functions">file</code><code class="bash plain">-max = 6815744 </code><code class="bash comments">#设置最大打开文件数</code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain">fs.aio-max-nr = 1048576</code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">sysctl: setting key </code><code class="bash string">"kernel.shmall"</code><code class="bash plain">: Invalid argument</code>
</div>
<div class="line number8 index7 alt1">
<code class="bash plain">kernel.shmall = 2097152 </code><code class="bash comments">#共享内存的总量，8G内存设置：2097152*4k/1024/1024</code>
</div>
<div class="line number9 index8 alt2">
<code class="bash plain">sysctl: setting key </code><code class="bash string">"kernel.shmmax"</code><code class="bash plain">: Invalid argument</code>
</div>
<div class="line number10 index9 alt1">
<code class="bash plain">kernel.shmmax = 2147483648 </code><code class="bash comments">#最大共享内存的段大小</code>
</div>
<div class="line number11 index10 alt2">
<code class="bash plain">sysctl: setting key </code><code class="bash string">"kernel.shmmni"</code><code class="bash plain">: Invalid argument</code>
</div>
<div class="line number12 index11 alt1">
<code class="bash plain">kernel.shmmni = 4096 </code><code class="bash comments">#整个系统共享内存端的最大数</code>
</div>
<div class="line number13 index12 alt2">
<code class="bash plain">kernel.sem = 250 32000 100 128</code>
</div>
<div class="line number14 index13 alt1">
<code class="bash plain">sysctl: setting key </code><code class="bash string">"net.ipv4.ip_local_port_range"</code><code class="bash plain">: Invalid argument</code>
</div>
<div class="line number15 index14 alt2">
<code class="bash plain">net.ipv4.ip_local_port_range = 9000 65500 </code><code class="bash comments">#可使用的IPv4端口范围</code>
</div>
<div class="line number16 index15 alt1">
<code class="bash plain">net.core.rmem_default = 262144</code>
</div>
<div class="line number17 index16 alt2">
<code class="bash plain">net.core.rmem_max = 4194304</code>
</div>
<div class="line number18 index17 alt1">
<code class="bash plain">net.core.wmem_default = 262144</code>
</div>
<div class="line number19 index18 alt2">
<code class="bash plain">net.core.wmem_max = 1048576</code>
</div>
<div class="line number20 index19 alt1">
<code class="bash plain"></code><code class="bash comments">#</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
对oracle用户设置限制，提高软件运行性能</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_569649">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># vi /etc/security/limits.conf</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
在最下面部分添加内容(粗体为添加的内容)</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_108665">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
<div class="line number11 index10 alt2">
11</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">@student - maxlogins 4</code>
</div>
<div class="line number2 index1 alt1">
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">* oracle soft nproc 2047 *</code>
</div>
<div class="line number4 index3 alt1">
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">* oracle hard nproc 16384 *</code>
</div>
<div class="line number6 index5 alt1">
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">* oracle soft nofile 1024 *</code>
</div>
<div class="line number8 index7 alt1">
</div>
<div class="line number9 index8 alt2">
<code class="bash plain">* oracle hard nofile 65536 *</code>
</div>
<div class="line number10 index9 alt1">
</div>
<div class="line number11 index10 alt2">
<code class="bash plain">End of </code><code class="bash functions">file</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
配置用户的环境变量</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_352466">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># vi /home/oracle/.bash_profile</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
添加以下内容:</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_739164">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash functions">export</code> <code class="bash plain">ORACLE_BASE=</code><code class="bash plain">/data/oracle</code> <code class="bash comments">#oracle数据库安装目录</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash functions">export</code> <code class="bash plain">ORACLE_HOME=$ORACLE_BASE</code><code class="bash plain">/product/11</code><code class="bash plain">.2.0</code><code class="bash plain">/db_1</code> <code class="bash comments">#oracle数据库路径</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash functions">export</code> <code class="bash plain">ORACLE_SID=orcl </code><code class="bash comments">#oracle启动数据库实例名</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash functions">export</code> <code class="bash plain">ORACLE_TERM=xterm </code><code class="bash comments">#xterm窗口模式安装</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash functions">export</code> <code class="bash plain">PATH=$ORACLE_HOME</code><code class="bash plain">/bin</code><code class="bash plain">:</code><code class="bash plain">/usr/sbin</code><code class="bash plain">:$PATH </code><code class="bash comments">#添加系统环境变量</code>
</div>
<div class="line number6 index5 alt1">
<code class="bash functions">export</code> <code class="bash plain">LD_LIBRARY_PATH=$ORACLE_HOME</code><code class="bash plain">/lib</code><code class="bash plain">:</code><code class="bash plain">/lib</code><code class="bash plain">:</code><code class="bash plain">/usr/lib</code> <code class="bash comments">#添加系统环境变量</code>
</div>
<div class="line number7 index6 alt2">
<code class="bash functions">export</code> <code class="bash plain">LANG=en_US </code><code class="bash comments">#防止安装过程出现乱码</code>
</div>
<div class="line number8 index7 alt1">
<code class="bash functions">export</code> <code class="bash plain">NLS_LANG=AMERICAN_AMERICA.ZHS16GBK </code><code class="bash comments">#设置Oracle客户端字符集</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
生效</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_870296">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># source /home/oracle/.bash_profile</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
解压安装包</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_372149">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">$ </code><code class="bash functions">cd</code> <code class="bash plain">/usr/local/src</code><code class="bash plain"> </code><code class="bash comments">#进入/usr/local/src目录</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">$ </code><code class="bash functions">ls</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">linux.x64_11gR2_database_1of2.zip linux.x64_11gR2_database_2of2.zip</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">$ unzip linux.x64_11gR2_database_1of2.zip -d </code><code class="bash plain">/data/database/</code><code class="bash plain"> </code><code class="bash comments">#解压</code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">(省略...)</code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain">$ unzip linux.x64_11gR2_database_2of2.zip -d </code><code class="bash plain">/data/database/</code><code class="bash plain"> </code><code class="bash comments">#解压</code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">(省略...)</code>
</div>
<div class="line number8 index7 alt1">
<code class="bash plain">$ </code><code class="bash functions">su</code> <code class="bash plain">root</code>
</div>
<div class="line number9 index8 alt2">
<code class="bash plain">Password:</code>
</div>
<div class="line number10 index9 alt1">
<code class="bash plain"></code><code class="bash comments"># chown -R oracle:oinstall /data/database/database/</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<strong>oracle安装</strong></p>
<p>
登录oracle用户</p>
<p>
通过图形界面登录oracle用户</p>
<p>
启动oralce安装</p>
<p>
到/data/database/database/目录下，执行./runInstaller</p>
<p>
按照步骤进行安装</p>
<p>
安装中出现的问题</p>
<p>
<span>安装过程中连接库时,在进度68%时会出现两个错误：</span></p>
<p>
第一个：</p>
<p>
/lib64/libstdc++.so中memcpy@GLIBC_2.4找不到。</p>
<p>
问题：glibc是2.17的库，连接找的是2.14的库。</p>
<p>
解决办法：改成静态链接。</p>
<p>
查看 /usr/lib64/libc.a是否存在。</p>
<p>
修改oracle安装目录下：ORACLEHOME/ctx/lib/insctx.mkctxhx:(CTXHXOBJ)<br>
(LINKCTXHX)(CTXHXOBJ) (INSOLINK)修改为：ctxhx:(CTXHXOBJ)<br>
-static (LINKCTXHX)(CTXHXOBJ) $(INSO_LINK) /usr/lib64/libc.a</p>
<p>
然后点击retry通过。</p>
<p>
第二个：</p>
<p>
问题：undefinied reference symbol'B_DestroyKeyObject'，查看日志，实际就是没有找到nnz11这个库。</p>
<p>
解决办法：</p>
<p>
修改ORACLEHOME/sysman/lib/insemagent(MK_EMAGENT_NMECTL)</p>
<p>
修改为：</p>
<p>
$(MK_EMAGENT_NMECTL) -lnnz11</p>
<p>
然后点击retry通过。</p>
<p>
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持服务器之家。</p>
<p>
原文链接：http://blog.csdn.net/whatlookingfor/article/details/52382458</p>
頁:
[1]