感恩的闫 發表於 2020-9-27 10:18:00

Oracle_20200927_在 Fedora 19 X86_64 上安装

<h2><span style="font-family: &quot;Microsoft YaHei&quot;">一、前期配置</span></h2>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">root</span></div>
<h4><span style="font-family: &quot;Microsoft YaHei&quot;">1.yum install 依赖包</span></h4>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">binutils-2.17.50.0.6-2.el5</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;2&nbsp;compat-libstdc++-33-3.2.3-61</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;3&nbsp;elfutils-libelf-0.125-3.el5</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;4&nbsp;elfutils-libelf-devel-0.125</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;5&nbsp;glibc-2.5-12</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;6&nbsp;glibc-common-2.5-12</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;7&nbsp;glibc-devel-2.5-12</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;8&nbsp;glibc-headers-2.5-12</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;9&nbsp;gcc-4.1.1-52</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">10&nbsp;gcc-c++-4.1.1-52</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">11&nbsp;libaio-0.3.106</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">12&nbsp;libaio-devel-0.3.106&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">13&nbsp;libgcc-4.1.1-52</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">14&nbsp;libstdc++-4.1.1&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">15&nbsp;libstdc++-devel-4.1.1-52.e15</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">16&nbsp;make-3.81-1.1</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">17&nbsp;numactl-devel-0.9.8.i386</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">18&nbsp;sysstat-7.0.0</span></div>
<h4><span style="font-family: &quot;Microsoft YaHei&quot;">2.关闭防火墙和selinux</span></h4>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">vi /etc/sysconfig/selinux</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">SELINUX=disable &nbsp; 禁用SeLinux</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">SELINUX=enforcing &nbsp; 使用SeLinux</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">Fedora 17及以前的版本关闭防火墙用systemctl stop iptables.service即可,其他linux版本用service stop iptables</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">Fedora 18以上用一个名叫firewalld的玩意,所以需要:</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">systemctl stop firewalld.service有必要的话就</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">systemctl disable firewalld.service</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<h4><span style="font-family: &quot;Microsoft YaHei&quot;">3.配置内核参数</span></h4>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;查看当前内核参数:&nbsp;# /sbin/sysctl&nbsp;-a&nbsp;|&nbsp;grep&nbsp;&lt;param-name&gt;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;将下面信息添加到文件&nbsp;/etc/sysctl.conf</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">#Instal&nbsp;Oracle&nbsp;Config</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">fs.aio-max-nr&nbsp;=&nbsp;1048576</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">fs.file-max&nbsp;=&nbsp;6815744</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">kernel.shmall&nbsp;=&nbsp;2097152</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">kernel.shmmax&nbsp;=&nbsp;2147483648</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">kernel.shmmni&nbsp;=&nbsp;4096</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">kernel.sem&nbsp;=&nbsp;250&nbsp;32000&nbsp;100&nbsp;128</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">net.ipv4.ip_local_port_range&nbsp;=&nbsp;9000&nbsp;65500</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">net.core.rmem_default&nbsp;=&nbsp;262144</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">net.core.rmem_max&nbsp;=&nbsp;4194304</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">net.core.wmem_default&nbsp;=&nbsp;262144</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">net.core.wmem_max&nbsp;=&nbsp;1048576</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;输入以下命令来更改内核参数的当前值:&nbsp;&nbsp;&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;# /sbin/sysctl&nbsp;-p</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">在"/etc/security/limits.conf"文件末尾添加下列内容:</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">#Install&nbsp;Oracle&nbsp;Config</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">oracle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;soft&nbsp;&nbsp;&nbsp;&nbsp;nproc&nbsp;&nbsp;&nbsp;2047</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">oracle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;hard&nbsp;&nbsp;&nbsp;&nbsp;nproc&nbsp;&nbsp;&nbsp;16384</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">oracle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;soft&nbsp;&nbsp;&nbsp;&nbsp;nofile&nbsp;&nbsp;1024</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">oracle&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;hard&nbsp;&nbsp;&nbsp;&nbsp;nofile&nbsp;&nbsp;65536</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">把下面的内容添加到/etc/pam.d/login文件当中</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">#Install&nbsp;Oracle&nbsp;Config</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">session&nbsp;&nbsp;&nbsp;&nbsp;required&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;pam_limits.so</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<h4><span style="font-family: &quot;Microsoft YaHei&quot;">4.添加新的组和用户</span></h4>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">#&nbsp;groupadd&nbsp;oinstall</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">#&nbsp;groupadd&nbsp;dba</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">#&nbsp;useradd&nbsp;-g&nbsp;oinstall&nbsp;-G&nbsp;dba&nbsp;oracle</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">#&nbsp;passwd&nbsp;oracle</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<h4><span style="font-family: &quot;Microsoft YaHei&quot;">5.为oracle的安装建立一个新的目录</span></h4>
<div><span style="font-family: &quot;Microsoft YaHei&quot;"># mkdir&nbsp;-p&nbsp;/u01/app/oracle/product/11.2.0/dbhome_1</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;"># chown&nbsp;-R&nbsp;oracle:oinstall&nbsp;/u01</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;"># chmod&nbsp;-R&nbsp;775&nbsp;/u01</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<h4><span style="font-family: &quot;Microsoft YaHei&quot;">6.编辑/etc/redhat-release文件,把里面的内容替换为下面的内容</span></h4>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">redhat&nbsp;release&nbsp;5</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">oracle</span></div>
<h4><span style="font-family: &quot;Microsoft YaHei&quot;">7.用oracle用户登录,把下面的内容添加到~.bash_profile(/home/oracle/.bash_profile)的末尾(oracle用户操作):</span></h4>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">#&nbsp;Oracle&nbsp;Settings</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">export&nbsp;TMP=/tmp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">export&nbsp;TMPDIR=$TMP;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">export&nbsp;ORACLE_HOSTNAME=localhost.localdomain;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">export&nbsp;ORACLE_BASE=/u01/app/oracle;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">export&nbsp;ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">export&nbsp;ORACLE_SID=DB11G;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">export&nbsp;ORACLE_TERM=xterm;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">export&nbsp;ORACLE_UNQNAME=DB11G;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">export&nbsp;PATH=/usr/sbin:$ORACLE_HOME/bin:$PATH;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">export&nbsp;LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">export&nbsp;CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">if&nbsp;[&nbsp;$USER&nbsp;=&nbsp;"oracle"&nbsp;];&nbsp;then</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;&nbsp;if&nbsp;[&nbsp;$SHELL&nbsp;=&nbsp;"/bin/ksh"&nbsp;];&nbsp;then</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;&nbsp;&nbsp;&nbsp;ulimit&nbsp;-p&nbsp;16384</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;&nbsp;&nbsp;&nbsp;ulimit&nbsp;-n&nbsp;65536</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;&nbsp;else</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;&nbsp;&nbsp;&nbsp;ulimit&nbsp;-u&nbsp;16384&nbsp;-n&nbsp;65536</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;&nbsp;fi</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">fi</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">#&nbsp;Oracle&nbsp;terminal&nbsp;Chinese&nbsp;fonts&nbsp;2010-09-10 解决sqlplus 显示中文为 ???</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">export&nbsp;NLS_LANG="SIMPLIFIED&nbsp;CHINESE_CHINA.UTF8"</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<h3><span style="font-family: &quot;Microsoft YaHei&quot;">二、安装</span></h3>
<h4><span style="font-family: &quot;Microsoft YaHei&quot;">1.解压安装文件</span></h4>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">$ unzip&nbsp;linux.x64_11gR2_database_1of2.zip</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">$ unzip&nbsp;linux.x64_11gR2_database_2of2.zip</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<h4><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;2.把中文字体增加到oracle安装文件,解决安装时中文是"囗囗囗囗囗囗囗囗"</span></h4>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;进入刚解压的database/stage/Components/oracle.jdk/1.5.0.17.0/1/DataFiles /all.jar就是JDK喽.在桌面新建一个文件夹命名为fallback/找一个zysong.ttf中文字体放入里面去。再用归档管理器打开它进入 /jdk/jre/lib/fonts/(all.jar包的目录)把在桌面建好的fallback文件夹拖放进来,完成后的目录结构应该是/jdk /jre/lib/fonts/fallback/zysong.ttf。</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">root</span></div>
<h4><span style="font-family: &quot;Microsoft YaHei&quot;">3.xhost切换两次</span></h4>
<div><span style="font-family: &quot;Microsoft YaHei&quot;"># su root</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;"># xhost +</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">提示:xhost: unable to open display “”</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;"># export DISPLAY=:0.0</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;"># xhost +</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">提示:access control disabled, clients can connect from any host</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">切换oracle用户</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;"># su – oracle</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">再执行# sh runInstaller</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<h4><span style="font-family: &quot;Microsoft YaHei&quot;">4.$&nbsp;./runInstaller</span></h4>
<h4><span style="font-family: &quot;Microsoft YaHei&quot;">5.若遇到ld-linux.so.2相关的报错</span></h4>
<div><span style="font-family: &quot;Microsoft YaHei&quot;"># yum whatprovides ld-linux.so.2--查找相关依赖包</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;"># yum install 包名(为上条命令返回的结果)--安装依赖包</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">如果oracle安装程序检查依赖包还有未安装的话用yum install &lt;包名&gt; 安装上.但除包名为‘pdksh’以外(我安装是就剩下一个pdksh没有安装,因为我已经安装上了ksh这个包,所以让它通过)。</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">保证内存大于1G,依赖包全部安装,其他错误可以忽略。</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">先仅按照数据库</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<h4><span style="font-family: &quot;Microsoft YaHei&quot;">6.安装成功后oracle会提示你使用root用户手动执行2个脚本</span></h4>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<h4><span style="font-family: &quot;Microsoft YaHei&quot;">7.成功安装完成后再接着配置</span></h4>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;&nbsp;&nbsp;&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1.编辑/etc/oratab文件,设置下面一行的标志为"Y":</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DB11G:/u01/app/oracle/product/11.2.0/dbhome_1:Y</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2.最后把/etc/redhat-release文件的内容改为原来的</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Fedora&nbsp;release&nbsp;12&nbsp;(Constantine)</span></div>
<h4><span style="font-family: &quot;Microsoft YaHei&quot;">8.dbca</span></h4>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<h3><span style="font-family: &quot;Microsoft YaHei&quot;">三、安装成功后启动</span></h3>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">sqlplus</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">/ as sysdba</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">startup</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">--报错1:ORA-00845: MEMORY_TARGET not supported on this system</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">--原因:/dev/shm小于MEMORY_TARGET的大小</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">--解决方法:</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">$ df -Th&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">文件系统&nbsp; &nbsp; &nbsp; 类型&nbsp; &nbsp; 容量&nbsp; 已用 可用 已用% 挂载点&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">/dev/sda2&nbsp; &nbsp; ext3&nbsp; &nbsp; 16G&nbsp; 11G&nbsp; 3.9G&nbsp; 74% /&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">/dev/sda3&nbsp; &nbsp; ext3&nbsp; &nbsp; 1.6G&nbsp; 37M&nbsp; 1.4G&nbsp; 3% /tmp</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">/dev/sda1&nbsp; &nbsp; ext3&nbsp; &nbsp; 99M&nbsp; 12M&nbsp; 83M&nbsp; 13% /boot</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">tmpfs&nbsp; &nbsp; &nbsp; &nbsp; tmpfs&nbsp; &nbsp; 252M&nbsp; &nbsp; 0&nbsp; 252M&nbsp; 0% /dev/shm</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;"># free -m&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; total&nbsp; &nbsp; &nbsp; used&nbsp; &nbsp; &nbsp; free&nbsp; &nbsp; shared&nbsp; &nbsp; buffers&nbsp; &nbsp; cached&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">Mem:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 503&nbsp; &nbsp; &nbsp; &nbsp; 368&nbsp; &nbsp; &nbsp; &nbsp; 134&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; 26&nbsp; &nbsp; &nbsp; &nbsp; 283&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">-/+ buffers/cache:&nbsp; &nbsp; &nbsp; &nbsp; 58&nbsp; &nbsp; &nbsp; &nbsp; 444&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">Swap:&nbsp; &nbsp; &nbsp; &nbsp; 2525&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; 2525&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">--/dev/shm最好大于mem;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;"># vim /etc/fstab</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">内容如下</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">LABEL=/&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; /&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ext3&nbsp; &nbsp; defaults&nbsp; &nbsp; &nbsp; &nbsp; 1 1&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">LABEL=/tmp&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; /tmp&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ext3&nbsp; &nbsp; defaults&nbsp; &nbsp; &nbsp; &nbsp; 1 2&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">LABEL=/boot&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; /boot&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ext3&nbsp; &nbsp; defaults&nbsp; &nbsp; &nbsp; &nbsp; 1 2&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">tmpfs&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; /dev/shm&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; tmpfs&nbsp; defaults,size=1G&nbsp; &nbsp; &nbsp; &nbsp; 0 0&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">devpts&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; /dev/pts&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; devpts&nbsp; gid=5,mode=620&nbsp; 0 0&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">sysfs&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; /sys&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; sysfs&nbsp; defaults&nbsp; &nbsp; &nbsp; &nbsp; 0 0&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">proc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; /proc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; proc&nbsp; &nbsp; defaults&nbsp; &nbsp; &nbsp; &nbsp; 0 0&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">LABEL=SWAP-sda5&nbsp; &nbsp; &nbsp; &nbsp; swap&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; swap&nbsp; &nbsp; defaults&nbsp; &nbsp; &nbsp; &nbsp; 0 0&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">~</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">下面这一行可能没有,没有就新加一行,有就更新。size最好用整数G</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">tmpfs&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; /dev/shm&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; tmpfs&nbsp; defaults,size=1G&nbsp; &nbsp; &nbsp; &nbsp; 0 0</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">重新挂载</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;"># umount /dev/shm/&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;"># mount /dev/shm/&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;"># mount&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">若进程忙:</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">umount /mnt/net1</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">umount: /mnt/net1: device is busy.</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (In some cases useful info about processes that use</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; the device is found by lsof(8) or fuser(1))</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">这种问题解决方案:</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">一、查找使用这个文件的进程和命令,具体的操作代码</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;"># lsof |grep /mnt/net1</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">lsof: WARNING: can't stat() cifs file system /mnt/net1</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Output information may be incomplete.</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">bash&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18841&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; root&nbsp; cwd&nbsp;&nbsp; unknown&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /mnt/net1/TDDOWNLOAD/软件 (stat: No such device)</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">二、然后执行ps命令可以查找执行此进程的命令</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;"># ps -ef|grep 18841</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">root&nbsp;&nbsp;&nbsp;&nbsp; 18841 18839&nbsp; 0 Nov29 pts/2&nbsp;&nbsp;&nbsp; 00:00:00 /bin/bash -l</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">root&nbsp;&nbsp;&nbsp;&nbsp; 29496 25604&nbsp; 0 16:26 pts/0&nbsp;&nbsp;&nbsp; 00:00:00 grep 18841</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">三、强行结束无关进程</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;"># kill -9 18841</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">四、然后卸载相关挂载</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;"># umount /mnt/net1</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">五、然后可以在功过mount命令进行查看。</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">完成后重新startup</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">--报错2:</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">ORA-01078: failure in processing system parameters</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">ORA-01565: error in identifying file 'D:\oracle\product\10.2.0\db_1/dbs/spfileor</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">cl.ora'</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">解决办法:</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">方法一:将$ORACLE_BASE/admin/orcl/pfile目录下的init.ora.0212012125517形式的文件copy到$ORACLE_HOME/dbs目录下initoracl.ora即可。(注:initoracl.ora中的oracl为你的实例名 ORACLE_SID,这里我的SID为:orcl10g)</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">方法二:将$ORACLE_HOME/dbs目录下spflieoracl.ora改名为spfileorcl10g.ora即可。(注:spfileorcl10g.ora中的orcl10g为环境变量中设置的SID,我的是orcl10g)</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">$ find /u01 &nbsp;-name pfile &nbsp; &nbsp;//查看pfile位置&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">/u01/ora/admin/orcl/pfile&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">$ ls -l /u01/app/admin/orcl/pfile</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">$ cp /u01/app/admin/orcl/pfile/init.ora.0212012125517 &nbsp;/u01/app/oracle/product/10.2.0/db_1/dbs/initorc1.ora</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">重新startup</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">shutdown immediate</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">exit</span></div>
<div><span style="font-family: &quot;Microsoft YaHei&quot;">&nbsp;</span></div>
<p><span style="font-family: &quot;Microsoft YaHei&quot;"></span></p><br><br>
来源:https://www.cnblogs.com/yanchhe/p/13737990.html
頁: [1]
查看完整版本: Oracle_20200927_在 Fedora 19 X86_64 上安装