OracleLinux65下安裝Oracle11g_ASM

1、Oracle Linux6.5 下安裝 Oracle11.2.0.3 _ASM目錄目錄21 集群規(guī)劃41.1 硬件環(huán)境41.2 軟件環(huán)境41.3 RAC 拓樸51.4 IP 規(guī)劃51.4.1 IP 地址要求51.5 安裝目錄規(guī)劃61.6 存儲規(guī)劃62 安裝實施72.1 安裝前準(zhǔn)備72.1.1 存儲環(huán)境準(zhǔn)備72.2 主機環(huán)境準(zhǔn)備72.2.1 操作系統(tǒng)安裝72.2.2 記錄版本信息（不是必須）82.3 節(jié)點 1 執(zhí)行82.3.1 配置 IP82.3.2 配置 Xmanager92.3.3 配置主機名92.3.4 配置/etc/hosts102.3.5 安裝必要的軟件包102.3.6 修改內(nèi)核參數(shù)1

2、12.3.7 修改 oracle 用戶限制112.3.8 修改/etc/pam.d/login122.3.9 關(guān)閉防火墻的 selinux122.3.10停用 ntp 服務(wù)122.3.11更改安裝所有者的 ulimit 設(shè)置132.3.12添加 Oracle 用戶142.4添加磁盤152.4.1 刷新磁盤152.4.2 磁盤多路徑配置162.4.2.1 安裝多路徑客戶端162.4.2.2 設(shè)置一個多路徑的配置文件162.4.2.3 啟勱 multipath 服務(wù)162.4.2.4 查看/etc/multipath/bindings162.4.2.5 配置 multipath.conf 文件17

3、2.4.2.6重啟 multipathd 服務(wù)182.4.2.7掃描磁盤：182.4.2.8查看 multipath 拓樸結(jié)構(gòu)（生成的多路徑情況）182.4.2.10 重啟 multipathd 服務(wù)192.4.2.11 清空已有的記錄192.4.2.12 重新掃描設(shè)備192.4.2.13 檢查/dev/mapper 下是否生成別名對的設(shè)備文件：192.4.3 安裝 asm 包202.4.4 配置 ASM212.4.5 共享磁盤分區(qū)212.4.6 創(chuàng)建 ASM 磁盤222.4.7 掃描磁盤 asm 磁盤，檢查有哪些 asm 磁盤：232.5 安裝 GRID232.5.1 安裝檢查342.6 配

4、置 ASM 磁盤342.7 安裝數(shù)據(jù)庫372.8 建庫441 安裝規(guī)劃1.1 硬件環(huán)境服務(wù)器：wmware 虛擬機 1.2 軟件環(huán)境數(shù)據(jù)庫：oracle11.2.0.3_Linux-x86-64集群件： oracle11.2.0.3_grid-x86-64 操作系統(tǒng)：oracle linux server6.51.3 安裝目錄規(guī)劃安裝目錄規(guī)劃原則：建立/u01 文件系統(tǒng)用來安裝 grid、datbase 程序。Oracle 用戶：ORACLE_BASE=/u01/app/oracleORACLE_HOME=$ORACLE_BASE/product/11.2.0Grid 用戶：ORACLE_BA

5、SE/u01/soft/gridORACLE_HOME=$ORACLE_BASE/product/11.2.01.4 存儲規(guī)劃序號磁盤名稱大小GBASM 磁盤組來源備注1/dev/sda30-os2/dev/sdb5DATA/dev/sdb1數(shù) 據(jù) 庫 存 儲3/dev/sdc5DATA/dev/sdc14/dev/sdd5DATA/dev/sdd15/dev/sde5FRA/dev/sde1數(shù) 據(jù) 庫 閃 回 區(qū)存儲空間2 安裝實施2.1 安裝前準(zhǔn)備2.1.1 存儲環(huán)境準(zhǔn)備1.添加虛擬機磁盤2.添加四塊磁盤，每個磁盤容量5G2.2 主機環(huán)境準(zhǔn)備2.2.1 操作系統(tǒng)安裝規(guī)劃安裝 oracle

6、linux server6.5 操作系統(tǒng)。安裝參數(shù)如下：系統(tǒng)分區(qū)文件系統(tǒng)格式大小 MB作用來源備注swapSwap3840內(nèi)存的1.5倍本地硬盤/Ext420480操作系統(tǒng)文件系統(tǒng)本地硬盤/homeExt420480用戶文件系統(tǒng)本地硬盤/optExt420480工具存放本地硬盤/u01Ext451200oracle數(shù)據(jù)庫軟件本地硬盤2.2.2 開始安裝操作系統(tǒng)操作系統(tǒng)安裝過程略。注：安裝軟件包使用Basic Server進行安裝，并需添加以下套件（1）Base SystemBase System需安裝8個套件Base System > BaseBase System > Clien

7、t management toolsBase System > Compatibility librariesBase System > Hardware monitoring utilitiesBase System > Large Systems PerformanceBase System > Network file system clientBase System > Performance ToolsBase System > Perl SupportOracle Linux 6.5.0上Base System中默認(rèn)已勾選套件：Base、Hard

8、ware monitoring utilities、Large Systems Performance、Network file system client、Performance Tools、Perl Support；Base System中默認(rèn)無Client management tools套件；Base System中需手動勾選Compatibility libraries套件。（2）ServersServers需安裝2個套件Servers > Server PlatformServers > System administration toolsOracle Linux 6

9、.5.0上Servers中默認(rèn)已勾選套件：Server Platform;Servers中需手動勾選System administration tools套件。（3）DesktopsDesktops需安裝7個套件Desktops > DesktopDesktops > Desktop PlatformDesktops > FontsDesktops> General Purpose DesktopDesktops > Graphical Administration ToolsDesktops > Input MethodsDesktops > X W

10、indow SystemOracle Linux 6.5.0上Desktops中默認(rèn)沒有已勾選套件;Desktops中需手動勾選Desktop、Desktop Platform、Fonts、General Purpose Desktop、Graphical Administration Tools、Input Methods、X Window System套件。（4）DevelopmentDevelopment需安裝2個套件Development > Additional DevelopmentDevelopment > Development ToolsOracle Linux

11、6.5.0上Development中默認(rèn)沒有已勾選套件;Development中需手動勾選Additional Development、Development Tools（5）ApplicationsApplications需安裝1個套件Applications > Internet BrowserOracle Linux 6.5.0上Applications中默認(rèn)沒有已勾選套件;Applications中需手動勾選Internet Browser套件；套件選擇完畢，英文版共1317個Packages，next開始安裝。中文版是1321個Packages建議使用英文版2.3 配置環(huán)境參數(shù)

12、2.3.1 配置 IP#vi /etc/sysconfig/network-scripts/ifcfg-eth0DEVICE=eth0HWADDR=F0:92:1C:07:25:1C TYPE=EthernetUUID=0b08f4d3-7339-45bc-9a9a-e90e6280a449ONBOOT=yesNM_CONTROLLED=yesBOOTPROTO=STATIC IPADDR=192.168.5.202 netmask=255.255.255.0GATEWAY=192.168.5.1#service network restart2.3.2 配置主機名#hostname yifa

13、ng#vi /etc/sysconfig/networkNETWORKING=yesHOSTNAME= yifangGATEWAY=192.168.5.2022.3.3 配置/etc/hosts#public127.0.0.1localhost192.168.5.202yifang2.3.4 安裝必要的軟件包掛載光盤將oracle_linux_patch.iso文件掛載到虛擬機系統(tǒng)下#cd /media/ORACLE_LINUX_PATCH/patch安裝軟件：binutils-2.20.51.0.2-5.36.el6.x86_64.rpm compat-libstdc+-33-3.2.3-6

14、9.el6.i686.rpm compat-libstdc+-33-3.2.3-69.el6.x86_64.rpm elfutils-libelf-0.152-1.el6.i686.rpm elfutils-libelf-0.152-1.el6.x86_64.rpm elfutils-libelf-devel-0.152-1.el6.i686.rpmelfutils-libelf-devel-0.152-1.el6.x86_64.rpm gcc-4.4.7-4.el6.x86_64.rpmgcc-c+-4.4.7-4.el6.x86_64.rpm glibc-2.12-1.132.el6.i6

15、86.rpm glibc-2.12-1.132.el6.x86_64.rpmglibc-common-2.12-1.132.el6.x86_64.rpmglibc-devel-2.12-1.132.el6.i686.rpm glibc-devel-2.12-1.132.el6.x86_64.rpm ksh-20120801-10.el6.x86_64.rpmlibaio-0.3.107-10.el6.i686.rpm libaio-0.3.107-10.el6.x86_64.rpm libaio-devel-0.3.107-10.el6.i686.rpmlibaio-devel-0.3.107

16、-10.el6.x86_64.rpm libgcc-4.4.7-4.el6.i686.rpmlibgcc-4.4.7-4.el6.x86_64.rpm libstdc+-4.4.7-4.el6.i686.rpm libstdc+-4.4.7-4.el6.x86_64.rpm libstdc+-devel-4.4.7-4.el6.i686.rpm libstdc+-devel-4.4.7-4.el6.x86_64.rpm libstdc+-docs-4.4.7-4.el6.x86_64.rpm make-3.81-20.el6.x86_64.rpmnumactl-devel-2.0.7-8.el

17、6.i686.rpm numactl-devel-2.0.7-8.el6.x86_64.rpm sysstat-9.0.4-22.el6.x86_64.rpm unix2dos-2.2-35.el6.x86_64.rpm unixODBC-2.2.14-12.el6_3.i686.rpm unixODBC-2.2.14-12.el6_3.x86_64.rpmunixODBC-devel-2.2.14-12.el6_3.i686.rpm unixODBC-devel-2.2.14-12.el6_3.x86_64.rpm# rpm -ivh ./* -nodeps -force2.3.6 修改內(nèi)核

18、參數(shù)# vi /etc/sysctl.confkernel.shmmax=4398046511104kernel.shmall=1073741824kernel.shmmni=4096kernel.sem=250 32000 100 128net.ipv4.ip_local_port_range=9000 65500 net.core.rmem_default=262144 net.core.rmem_max=4194304 net.core.wmem_default=262144 net.core.wmem_max=1048576fs.aio-max-nr=1048576fs.file-ma

19、x=6815744注：上述參數(shù)在其它 linux 系統(tǒng)中可能需要調(diào)整，在 oraclelinux6.5 中為系統(tǒng)默認(rèn)，可省去 修改。2.3.7 修改 oracle 用戶限制Vi /etc/security/limits.conf 末尾添加：oraclesoftnofile1024oraclehardnofile65536oraclesoftnproc2047oraclehardnproc16384oraclesoftstack10240oraclehardstack32768grid softnofile1024grid hardnofile65536grid softnproc2047gri

20、d hardnproc16384grid softstack10240grid hardstack327682.3.8 修改/etc/pam.d/loginVi /etc/pam.d/login 末尾添加：Session reauired/lib64/security/pam_limits.so2.3.9 關(guān)閉防火墻的 selinux停掉 iptables、selinux 服務(wù)：#service iptables stop#chkconfig iptables off#setenforce 0#getenforce修改配置文件：# vi /etc/selinux/config# This fi

21、le 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 - No SELinux policy is loaded.#SELINUX=enforcingSELINUX=disabled# SELINUXTYPE= can take o

22、ne of these two values:#targeted - Targeted processes are protected,#mls - Multi Level Security protection. SELINUXTYPE=targeted2.3.10停用 ntp 服務(wù)# service ntpd stop# chkconfig ntpd off# mv /etc/ntp.conf /etc/ntp.conf.bak# rm -rf /etc/ntp.conf2.3.11更改安裝所有者的 ulimit 設(shè)置vi /etc/profile末尾添加：if /$USER = &quo

23、t;oracle" ; thenif /$SHELL = "/bin/ksh" ; then ulimit -p 16384ulimit -n 65536 elseulimit -u 16384 -n 65536fiumask 022 fi2.3.12添加 Oracle 用戶注：Oraclelinux6.5 中已經(jīng)默認(rèn)創(chuàng)建有 oracle 用戶及 oinstall、dba 組。為了丌影響我們 創(chuàng)建用戶：groupadd -g 501 oinstallgroupadd -g 502 dbagroupadd -g 503 opergroupadd -g 504 asm

24、admingroupadd -g 506 asmdbagroupadd -g 505 asmoperuseradd -m -u 501 -g oinstall -G dba,asmdba,oper -d /home/oracle -s /bin/bash oracleuseradd -m -u 502 -g oinstall -G dba,asmdba,asmoper,asmadmin -d /home/grid -s /bin/bash grid2.3.13設(shè)置 oracle、grid 用戶密碼echo oracle | passwd -stdin oracleecho grid | pas

25、swd -stdin grid2.3.14創(chuàng)建 oracle 安裝目錄mkdir -p /u01/soft/grid/chown -R grid:oinstall /u01/soft/grid/mkdir -p /u01/app/oraclechown -R oracle:oinstall /u01/app/oraclechmod -R 755 /u01mkdir -p /u01/oraInventorychown -R oracle:oinstall /u01/oraInventorychown -R grid:oinstall /u01/oraInventory2.3.15設(shè)置 oracl

26、e 用戶環(huán)境變量$ vi .bash_profileumask 022export ORACLE_BASE=/u01/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0 export ORACLE_SID=orclexport ORACLE_UNQNAME=yifangexport NLS_LANG=AMERICAN_AMERICA.UTF8export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss" export PATH=.:$PATH:$HOME/bin:$ORACLE_HO

27、ME/binexport PATH=$PATH:/usr/bin:/bin:/usr/bin/X11:/usr/local/binexport PATH=$PATH:$ORACLE_BASE/common/oracle/bin export ORACLE_PATH=$PATH:$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin export ORACLE_TERM=xtermexport TNS_ADMIN=$ORACLE_HOME/network/adminexport LD_LIBRARY_PATH=$ORACLE_HOME/

28、libexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/oracm/libexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/lib:/usr/lib:/usr/local/lib export CLASSPATH=$ORACLE_HOME/JREexport CLASSPATH=$CLASSPATH:$ORACLE_HOME/jlibexport CLASSPATH=$CLASSPATH:$ORACLE_HOME/rdbms/jlib export CLASSPATH=$CLASSPATH:$ORACLE_

29、HOME/network/jlib export THREADS_FLAG=nativeexport TEMP=/tmp export TMPDIR=/tmpexport PATH=$PATH:$ORACLE_HOME/bin2.3.16 設(shè)置 grid 用戶環(huán)境變量gridcredit1 $ vi .bash_profileumask 022export ORACLE_BASE=/u01/soft/gridexport ORACLE_HOME=/$ORACLE_BASE/product/11.2.0export ORACLE_SID=+ASMexport NLS_LANG=AMERICAN_

30、AMERICA.UTF8export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss" export PATH=.:$PATH:$HOME/bin:$ORACLE_HOME/binexport PATH=$PATH:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin export PATH=$PATH:$ORACLE_BASE/common/oracle/binexport ORACLE_PATH=$PATH:$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/

31、admin export ORACLE_TERM=xtermexport TNS_ADMIN=$ORACLE_HOME/network/adminexport LD_LIBRARY_PATH=$ORACLE_HOME/libexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/oracm/libexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/lib:/usr/lib:/usr/local/lib export CLASSPATH=$ORACLE_HOME/JREexport CLASSPATH=$CLASSP

32、ATH:$ORACLE_HOME/jlibexport CLASSPATH=$CLASSPATH:$ORACLE_HOME/rdbms/jlib export CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib export THREADS_FLAG=nativeexport TEMP=/tmp export TMPDIR=/tmpexport PATH=$PATH:$ORACLE_HOME/bin2.4添加磁盤2.4.1 安裝 asm 包查看本機內(nèi)核版本：# uname -rm2.6.18-194.el5 i686oracleasm-support

33、的安裝oracleasm 的安裝asmlib 的安裝#cd /media/ORACLE_LINUX_PATCH/oracle asm# rpm -ivh ./* -nodeps -force2.4.2 配置 ASM兩邊配置 asmrootrac1 asm# /etc/init.d/oracleasm configureThis will configure the on-boot properties of the Oracle ASM library driver.The following questions will determine whether the driver is loa

34、ded on boot and what permissions it will have.The current values will be shown in brackets ('').Hitting <ENTER> without typing an answer will keep that current value.Ctrl-C will abort.Default user to own the driver interface : oracle Default group to own the driver interface : oinstall

35、 Start Oracle ASM library driver on boot (y/n) n: y Scan for Oracle ASM disks on boot (y/n) y: yWriting Oracle ASM library driver configuration: doneInitializing the Oracle ASMLib driver: OK Scanning the system for Oracle ASMLib disks:OK2.4.3 共享磁盤分區(qū)所有共享磁盤分區(qū)#fdisk -l#fdisk /dev/sdbCommand (m for help

36、): nCommand actioneextendedpprimary partition (1-4)pPartition number (1-4): 1First cylinder (1-261, default 3):回車Using default value 3Last cylinder, +cylinders or +sizeK,M,G (3-261, default 261): 回車Using default value 261Command (m for help): wThe partition table has been altered! Calling ioctl() to re-read partition table.重復(fù)以上步驟分別格式化 sdc,sdd,sde磁盤2.4.4 創(chuàng)建 ASM 磁盤# /etc/init.d/oracleasm enable rootdb1 # /etc/init.d/oracleasm enableWriting Oracle ASM library driver configuratio