oracle linux 安装oracle11g - baidu.docx

oracle linux5.10 安装oracle11gR21介绍：本文通过Oracle VM VirtualBox 做虚拟机，在其上安装linux和oracle1.1：所需软件序号软件名称备注1VirtualBox-4.3.20-96997-Win.exe虚拟机软件，安装此软件后可以在其上安装虚拟服务器。2Oracle Linux Release 5 Update 10 Media Pack v1 for x86_64 (64 bit) .isoOracle linux 安装介质iso3linux.x64_11gR2_database_1of2.ziplinux.x64_11gR2_database_2of2.zipOracle 数据库安装程序2：Oracle VM VirtualBox 的具体安装方法在此不多介绍，仅介绍安装完后需要注意的地方2.1：安装完成后会在个人机器生成一个虚拟网卡，注意此处的ip，这个就是后面虚拟机需要用到的网关。这个界面是我已经安装好的一个服务器后的VirtualBox界面。3：通过 VirtualBox 安装 Oracle linux.3.1 点击新建按钮3.2 自定义虚拟机名称3.3设置虚拟机的内存3.4 磁盘修改大一点。3.5 红框部分就是我们刚才设置完毕后的状态3.6 鼠标左键点中要操作的虚拟机，然后点击设置按钮，或者在点中的虚拟机上点击鼠标右键，最终都是要点击“设置”3.7 共享粘贴板，默认是已禁用，此处设置为双向。个人认为无需再配置软驱3.8 设置网络连接方式：3.9 选择一个虚拟光盘，就是加载我们需要安装的ISO镜像文件。3.10 此时已经把光盘加载到光驱，可以开机安装linux了。可以直接回车。3.11 点击后，热点就在虚拟机里了，想要切换回来，需要点击右边的Ctrl键。3.12正式开始安装linux一般都是跳过。3.13 下面开始进行网络配置3.14 设置时区此处选择完毕后，点击NEXT重新启动3.15 创建oracle用户，密码也是oracle3.16 Linux安装刚刚安装成功，此时建议暂时关机，先做一次VirtualBox的镜像备份3.17 备份镜像：备份系统镜像3.18 然后再次启动linux，通过root用户登录：密码：oracle3.19 需要安装增强功能，否则显示器太小，安装oracle的时候看不全界面双击“autorun.sh”直接运行按回车结束此窗口。重启服务器3.20 现在可以全屏了，Linux安装结束。4：开始配置Linux4.1 查看当前IProottestora # ifconfigeth0 Link encap:Ethernet HWaddr 08:00:27:41:C0:77 inet addr:21 Bcast:55 Mask: inet6 addr: fe80:a00:27ff:fe41:c077/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:2 errors:0 dropped:0 overruns:0 frame:0 TX packets:46 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:148 (148.0 b) TX bytes:6562 (6.4 KiB)4.2 查看主机名roottestora # cat /etc/sysconfig/networkNETWORKING=yesNETWORKING_IPV6=yesHOSTNAME=testoraGATEWAY=4.3修改hostsvi /etc/hosts4.4 修改 /etc/sysctl.conf文件,加上如下参数 #vi /etc/sysctl.conffs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 536870912kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 10485864.4 修改用户限制 #vi /etc/security/limits.conf文件，加上下面的参数 oracle soft nproc16384 oracle hard nproc65535 oracle soft nofile 16384 oracle hard nofile 655364.5 修改用户验证选项 #vi /etc/pam.d/login文件加上如下参数 session required pam_limits.so4.6 查看config文件roottestora # cat /etc/selinux/config# This file controls the state of SELinux on the system.# SELINUX= can take one of these three values:# enforcing - SELinux security policy is enforced.# permissive - SELinux prints warnings instead of enforcing.# disabled - SELinux is fully disabled.SELINUX=disabled# SELINUXTYPE= type of policy in use. Possible values are:# targeted - Only targeted network daemons are protected.# strict - Full SELinux protection.SELINUXTYPE=targeted4.7 设置PROFILE变量 修改用户bash shell (针对oracle用户)$ vi .bash_profile (#vi oracle/.bash_profile) 增加 export ORACLE_BASE=/home/oracle/appexport ORACLE_SID=ocpexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1 export PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin export LANG=enroottestora # su - oracleoracletestora $ pwd/home/oracleoracletestora $ lltotal 0oracletestora $ mkdir apporacletestora $ lltotal 4drwxrwxr-x 2 oracle oracle 4096 Dec 9 00:46 apporacletestora $ ll -atotal 68drwx- 5 oracle oracle 4096 Dec 9 00:46 .drwxr-xr-x 3 root root 4096 Dec 8 23:46 .drwxrwxr-x 2 oracle oracle 4096 Dec 9 00:46 app-rw-r-r- 1 oracle oracle 33 Jul 10 2013 .bash_logout-rw-r-r- 1 oracle oracle 176 Jul 10 2013 .bash_profile-rw-r-r- 1 oracle oracle 124 Jul 10 2013 .bashrc-rw-r-r- 1 oracle oracle 515 Jun 21 2011 .emacsdrwxr-xr-x 3 oracle oracle 4096 Aug 12 2002 .kdedrwxr-xr-x 4 oracle oracle 4096 Aug 7 2013 .mozillaoracletestora $ cat .bash_profile # .bash_profile# Get the aliases and functionsif -f /.bashrc ; then . /.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/binexport PATHexport ORACLE_BASE=/home/oracleexport ORACLE_SID=ocpexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1 export PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin export LANG=en4.8 建立download目录，等待接收zip文件oracletestora $ pwd/home/oracleoracletestora $ mkdir downloadoracletestora $ lltotal 8drwxrwxr-x 2 oracle oracle 4096 Dec 9 00:46 appdrwxrwxr-x 2 oracle oracle 4096 Dec 9 00:53 downloadoracletestora $ cd downloadoracletestora download$ lltotal 04.9 通过ssh工具上传zip文件SSH Secure File Transfer Client4.10 继续用图形化界面操作，不过需要更换为oracle用户4.11 把两个压缩文件解压到同一个目录5：安装oracle前，再做一次镜像5.1 开始安装oracle 11g R2默认英语5.2 设置管理密码，需要 “大写+小写+数字”5.3 通过root用户只需修复脚本roottestora # cd /tmp/CVU_.0_oracleroottestora CVU_.0_oracle# lltotal 2148-rwxr-xr-x 1 oracle oracle 8173 Jul 15 2009 cvuqdisk-1.0.7-1.rpm-rwxr-xr-x 1 oracle oracle 2093821 Aug 1 2009 exectask-rwxr-xr-x 1 oracle oracle 223 Aug 1 2009 exectask.shdrwxr-xr-x 3 oracle oracle 4096 Dec 9 11:51 fixup-rw-r-r- 1 oracle oracle 24 Dec 9 11:51 fixup.enable-rw-r-r- 1 oracle oracle 54 Dec 9 11:51 fixup.response-rwxr-xr-x 1 oracle oracle 61253 Aug 1 2009 orarun.sh-rwxr-xr-x 1 oracle oracle 975 Aug 1 2009 runfixup.shdrwxrwxrwx 2 oracle oracle 4096 Dec 9 11:51 scratchroottestora CVU_.0_oracle# ./runfixup.sh Response file being used is :./fixup.responseEnable file being used is :./fixup.enableLog file location: ./orarun.loguid=500(oracle) gid=500(oracle) groups=500(oracle)5.4 执行上述脚本后，点击“OK”按钮再次重新检查已经解决了部分问题。5.5 解决其他问题This is a prerequisite condition to test whether the package sysstat-7.0.2 is available on the system.(more details)Expected Value:sysstat-7.0.2Actual Value:missiThis is a prerequisite condition to test whether the package unixODBC-2.2.11 is available on the system.(more details)Expected Value :unixODBC-2.2.11 (i386)Actual Value:missingThis is a prerequisite condition to test whether the package unixODBC-2.2.11 is available on the system.(more details)Expected Value:unixODBC-2.2.11 (x86_64)Actual Value:missingThis is a prerequisite condition to test whether the package unixODBC-devel-2.2.11 is available on the system.(more details)Expected Value:unixODBC-devel-2.2.11 (i386)Actual Value:missingThis is a prerequisite condition to test whether the package unixODBC-devel-2.2.11 is available on the system.(more details)Expected Value:unixODBC-devel-2.2.11 (x86_64)Actual Value:missing5.5.1 打开安装操作系统时用iso，进入Server目录。roottestora Server# cd /media/roottestora media# lltotal 4drwxr-xr-x 8 oracle root 4096 Oct 3 2013 OL5.10 x86_64 dvd 20131002roottestora media# cd OL5.10 x86_64 dvd 20131002/roottestora OL5.10 x86_64 dvd 20131002# cd Server/roottestora Server# pwd/media/OL5.10 x86_64 dvd 20131002/Server5.5.2 安装缺的包roottestora Server# ll libaio-devel-0.3.106-5.*-rw-r-r- 1 oracle root 11790 Nov 17 2010 libaio-devel-0.3.106-5.i386.rpm-rw-r-r- 1 oracle root 11675 Nov 17 2010 libaio-devel-0.3.106-5.x86_64.rpmroottestora Server# rpm -ivh libaio-devel-0.3.106-5.i386.rpm warning: libaio-devel-0.3.106-5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159Preparing. # 100% 1:libaio-devel # 100%roottestora Server# rpm -ivh libaio-devel-0.3.106-5.x86_64.rpm warning: libaio-devel-0.3.106-5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159Preparing. # 100% 1:libaio-devel # 100%roottestora Server# ll sysstat-7.0.2-12.0.1.el5.x86_64.rpm -rw-r-r- 1 oracle root 192038 Oct 23 2012 sysstat-7.0.2-12.0.1.el5.x86_64.rpmroottestora Server# rpm -ivh sysstat-7.0.2-12.0.1.el5.x86_64.rpm warning: sysstat-7.0.2-12.0.1.el5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159Preparing. # 100% 1:sysstat # 100%/*warning: unixODBC-2.2.11-10.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159rpm -import /etc/pki/rpm-gpg/RPM*/roottestora Server# ll unixODBC-2.2.11-10.el5.*-rw-r-r- 1 oracle root 296693 Dec 28 2011 unixODBC-2.2.11-10.el5.i386.rpm-rw-r-r- 1 oracle root 298179 Dec 28 2011 unixODBC-2.2.11-10.el5.x86_64.rpmroottestora Server# rpm -ivh unixODBC-2.2.11-10.el5.i386.rpmwarning: unixODBC-2.2.11-10.el5.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159error: Failed dependencies: libodbc.so.1 is needed by unixODBC-2.2.11-10.el5.i386 libodbcinst.so.1 is needed by unixODBC-2.2.11-10.el5.i386 unixODBC-libs = 2.2.11-10.el5 is needed by unixODBC-2.2.11-10.el5.i386roottestora Server# rpm -import /etc/pki/rpm-gpg/RPM*roottestora Server# rpm -ivh unixODBC-2.2.11-10.el5.i386.rpmerror: Failed dependencies: libodbc.so.1 is needed by unixODBC-2.2.11-10.el5.i386 libodbcinst.so.1 is needed by unixODBC-2.2.11-10.el5.i386 unixODBC-libs = 2.2.11-10.el5 is needed by unixODBC-2.2.11-10.el5.i386roottestora Server#/*error: Failed dependencies: libodbc.so.1 is needed by unixODBC-2.2.11-10.el5.i386 libodbcinst.so.1 is needed by unixODBC-2.2.11-10.el5.i386 unixODBC-libs = 2.2.11-10.el5 is needed by unixODBC-2.2.11-10.el5.i386rpm -ivh unixODBC-libs*.*/roottestora Server# ll unixODBC-libs*.*-rw-r-r- 1 oracle root 564491 Dec 28 2011 unixODBC-libs-2.2.11-10.el5.i386.rpm-rw-r-r- 1 oracle root 567675 Dec 28 2011 unixODBC-libs-2.2.11-10.el5.x86_64.rpmroottestora Server# rpm -ivh unixODBC-libs*.*Preparing. # 100% 1:unixODBC-libs # 50% 2:unixODBC-libs # 100%roottestora Server# rpm -ivh unixODBC-2.2.11-10.el5.i386.rpmPreparing. # 100% 1:unixODBC # 100%roottestora Server# rpm -ivh unixODBC-2.2.11-10.el5.x86_64.rpmPreparing. # 100% 1:unixODBC # 100%roottestora Server# ll unixODBC-devel-2.2.11-10.el5.*-rw-r-r- 1 oracle root 755981 Dec 28 2011 unixODBC-devel-2.2.11-10.el5.i386.rpm-rw-r-r- 1 oracle root 812394 Dec 28 2011 unixODBC-devel-2.2.11-10.el5.x86_64.rpmroottestora Server# rpm -ivh unixODBC-devel-2.2.11-10.el5.*Preparing. # 100% 1:unixODBC-devel # 50% 2:unixODBC-devel # 100%5.5.3 点击“Check Again”按钮5.5.4 安装完成后执行最后的配置脚本roottestora Server# cd /home/oracle/oraInventoryroottestora oraInventory# lltotal 28drwxrwx- 2 oracle oracle 4096 Dec 9 12:44 ContentsXML-rw-rw- 1 oracle oracle 37 Dec 9 12:44 install.platformdrwxrwx- 2 oracle oracle 4096 Dec 9 12:34 logs-rw-rw- 1 oracle oracle 301 Dec 9 12:34 oraIperties-rw-rw- 1 oracle oracle 58 Dec 9 12:44 oraInst.loc-rwxrwx- 1 oracle or