单实例环境下安装ASM

【精编推荐】OracleRestart加ASM加RHEL安装手册Oracle Restart+ASM+RHEL5安装手册Oracle restart数据库是在原来单实例数据库的基础上，利用了Clusterware增强了单实例数据库的可用性.可以使用srvctl,crsctl命令管理单实例数据库，当服务器重起或进程异常终止时，能够自动启动数据库.一OS环境配置1 创建用户2 版本及kernel3 安装rpm包查询rpm包是否安装4 kernel参数5 用户限制6 环境变量二安装Grid Infrastructure1 安装gridGrid用户执行runInstaller[grid@HA2-BI-CS01 gird]$ ./runInstaller选择skip software updates注: 此处可选择install oracle grid infrastructure software only或configure oracle grid infrastructure a standalone server，时选择后者时ocr必须放在ASM上。

选择os group dba指定oracle_base,grid_home路径指定oraInventory路径检查包,参数配置等注:oracle restart不需要要使用dns,无需配置resove.conf 可忽略Root用户执行orainstRoot.sh ,root.sh脚本说明: orainstRoot.sh 脚本是为了设置清单目录的权限[root@HA2-BI-CS01 ~]# /oracle/oraInventory/orainstRoot.sh Changing permissions of /oracle/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /oracle/oraInventory to dba.The execution of the script is complete.[root@HA2-BI-CS01 ~]# /grid/root.shPerforming root user operation for Oracle 11gThe following environment variables are set as:ORACLE_OWNER= gridORACLE_HOME= /gridEnter the full pathname of the local bin directory: [/usr/local/bin]: Copying dbhome to /usr/local/bin ...Copying oraenv to /usr/local/bin ...Copying coraenv to /usr/local/bin ...2 配置Standalone3 检查高可用服务参数.如果使用ASM作为存储,CSS服务会自动启动.4 检查OCR三安装Oracle DatabaseOracle用户执行runInstaller[oracle@HA2-BI-CS01 database]$./runInstaller跳过mos支持。

Oracle 11gR2 for Linux 安装一．硬、软件环境：1.硬件：IBM x3650 M2，2颗Intel Xeon E54052.0Ghz CPU,2G*2=4G内存，3块146G SAS硬盘，做raid0配置。

2.软件：RHEL5.4 32位版本，linux_11gR2_grid，linux_11gR2_database，SecureCRT6.1,Xmanager3.0。

注：Xmanager3.0用于上传软件文件和x窗口映射。

二．安装完操作系统后以root用户创建oracle相关的用户和组参照oracle的官方文档，创建两个用户grid和oracle，grid用户用来安装grid 软件，oracle用户安装oracle软件，数据库文件使用ASM管理。

注：#开头的命令对应root用户执行，$开始的命令对应grid和oracle用户首先，创建四个组oinstall, dba, asmadmin, asmdba：#groupadd -g 1000 oinstall#groupadd -g 1100 dba#groupadd -g 1200 asmadmin#groupadd -g 1300 asmdba再创建两个用户grid和oracle：#useradd -u 1001 -g oinstall -G asmdba,asmadmin,dba grid#passwd grid#useradd -u 1002 -g oinstall -G dba,asmdba oracle#passwd oracle创建目录和授权：#mkdir -p /u01/app/grid 注:此目录用来安装grid软件#chown -R grid:oinstall /u01#chmod -R 775 /u01#mkdir -p /u02/app/oracle 注：此目录用来安装oracle软件#chown -R oracle:oinstall /u02#chmod -R 775 /u02三．所需的rpm包，参照oracle官方文档，根据不同的操作系统版本，rpm包的版本有所区别，包名肯定是一样的。

RHEL7上安装11gR2单机使用ASM存储搭建PhysicalStandby笔记参考文献1.执行root.sh出现ohasd failed解决方案2.inux 7安装rac 11gR2时运行root.sh报错找不到ohas服务3.Error in invoking target 'agent nmhs' of makefile4.Oracle 11g Data Guard 使用duplicate from active database 创建 standby database一、背景介绍接到需求要安装单机使用ASM存储的数据库，原本以为是轻车熟路的事情，emm，世界上哪有那么多轻松的活给你干，废话少说，进主题吧。

二、关于安装思路一直以来搭建的都是RAC+ASM存储或者单机物理存储，这次说要安装单机+ASM存储，确实有点懵逼，不过还是迷之自信，毕竟是安装过十多套RAC+ASM存储和几十遍单机物理存储的男人。

一上手就按单机物理存储的安装模式直接安装DB软件，看DB创建过程中是不是会有什么选项可以创建并使用asm存储盘，可惜世界上并没有奇迹，在安装好DB软件创建DB的过程中发现要使用asm 存储一定要安装GI程序！于是铲除已安装好的DB程序，按照RAC+ASM存储的方式重新安装，在grid用户下安装GI，安装过程中发现没有分配给grid的那5个1g的存储，于是选择在oracle用户下作死安装GI和DB软件，结果又是一顿铲除重装。

单机+ASM存储的正确安装方式：grid用户安装GI，oracle用户安装DB，所有物理磁盘都拿来做data磁盘组！三、安装GI时的问题安装GI在执行root.sh脚本报错，报如下错误：ohasd failed to start at/u01/app/11.2.0/grid/crs/install/roothas.pl line 377, line 4./u01/app/11.2.0/grid/perl/bin/perl -I/u01/app/11.2.0/grid/perl/lib -I/u01/app/11.2.0/grid/crs/install/u01/app/11.2.0/grid/crs/install/roothas.pl execution failed解决方案如下：1.回退root.sh脚本操作$ORACLE_HOME/crs/install/roothas.pl -deconfig -force -verbose2.清空/var/tmp/.oracle/npohasd文件在执行root.sh脚本时出现Adding daemon to inittab的时候，在另一个窗口使用root立即执行以下命令：dd if=/var/tmp/.oracle/npohasd of=/dev/null bs=1024 count=1顺利安装结束。

Oracle单实例迁移到RAC实例--使⽤RMAN异机恢复Oracle 官⽹有关单实例迁移到RAC的⼀个步骤说明：How to Convert 10g Single-Instance database to 10g RAC using Manual Conversion procedure [ID 747457.1]RMAN 备份异机恢复并创建新DBID⼀. ⼤致操作步骤如下：1. 安装Clusterware 和 ASM 实例2. 备份源库，并将备份集copy到rac 节点上3. 在RAC 上还原并修改初始化参数⽂件，还原控制⽂件和数据⽂件4. 增加undo 表空间和redo log 线程组，创建密钥⽂件5. 配置RAC监听6. 将数据库等资源添加到CRS注意：迁移的2个db版本版本要⼀致。

包括⼩版本。

⽐如10.2.0.4.0.我这个测试的时候是从10.2.0.1.0 迁移到10.2.0.4.0. 结果在open resetlogs的时候报错了，必须要先升级后，才能打开。

Redhat 5.4 Orcle RAC 数据库从10.2.0.1升级到 10.2.0.4⼆. 具体操作步骤2.1 安装Clusterware 和ASM 实例这个参考Blog：Redhat 5.4 Oracle 10g RAC Openfiler+Multipath + RAW+ ASM 安装⽂档安装之后的进程如下：[oracle@rac1 u01]$ sh crs_stat.shName Target State Host------------------------------ ---------- --------- -------ora.rac1.ASM1.asm ONLINE ONLINE rac1ora.rac1.gsd ONLINE ONLINE rac1ora.rac1.ons ONLINE ONLINE rac1ora.rac1.vip ONLINE ONLINE rac1ora.rac2.ASM2.asm ONLINE ONLINE rac2ora.rac2.gsd ONLINE ONLINE rac2ora.rac2.ons ONLINE ONLINE rac2ora.rac2.vip ONLINE ONLINE rac22.2 在源库⽤RMAN 备份，并将备份⽂件copy到rac上相关备份脚本，参考Blog：Linux 平台下 RMAN 全备和增量备份 shell 脚本Nocatalog 下的RMAN 增量备份 shell脚本源库实例名：anqing，为了确认迁移成功，我们现在源库上创建⼀个表dave，并插⼊⼀条记录。

OS ：rhel6.5 x64version: oracle 11.0.2.41、环境配置a）网络配置vi /etc/hosts192.168.1.60 nodeb）存储配置Disk /dev/sdc: 107.4 GB, 107374182400 bytes255 heads, 63 sectors/track, 13054 cylindersUnits = cylinders of 16065 * 512 = 8225280 bytesSector size (logical/physical): 512 bytes / 512 bytesI/O size (minimum/optimal): 512 bytes / 512 bytesDisk identifier: 0xda7e2c0bDevice Boot Start End Blocks Id System/dev/sdc1 1 1306 10490413+ 83 Linux/dev/sdc2 1307 2612 10490445 83 Linux/dev/sdc3 2613 3918 10490445 83 Linux/dev/sdc4 3919 13054 73384920 5 Extended /dev/sdc5 3919 5224 10490413+ 83 Linux/dev/sdc6 5225 6530 10490413+ 83 Linux2、安装环境a）必须的软件包binutils-2.20.51.0.2-5.11.el6 (x86_64)compat-libcap1-1.10-1 (x86_64)compat-libstdc++-33-3.2.3-69.el6 (x86_64)compat-libstdc++-33-3.2.3-69.el6.i686gcc-4.4.4-13.el6 (x86_64)gcc-c++-4.4.4-13.el6 (x86_64)glibc-2.12-1.7.el6 (i686)glibc-2.12-1.7.el6 (x86_64)glibc-devel-2.12-1.7.el6 (x86_64)glibc-devel-2.12-1.7.el6.i686kshlibgcc-4.4.4-13.el6 (i686)libgcc-4.4.4-13.el6 (x86_64)libstdc++-4.4.4-13.el6 (x86_64)libstdc++-4.4.4-13.el6.i686libstdc++-devel-4.4.4-13.el6 (x86_64)libstdc++-devel-4.4.4-13.el6.i686libaio-0.3.107-10.el6 (x86_64)libaio-0.3.107-10.el6.i686libaio-devel-0.3.107-10.el6 (x86_64)libaio-devel-0.3.107-10.el6.i686make-3.81-19.el6sysstat-9.0.4-11.el6 (x86_64)b）内核参数修改##edit sysctlMEM1=`cat /proc/meminfo|grep MemTotal|awk '{ print $2 }'`MEM2=$[$MEM1*512]sed -i '/kernel.shmmax/'d /etc/sysctl.confKSHMALL=`cat /proc/sys/kernel/shmall`if [ $KSHMALL -lt 2097152 ];thensed -i 's/kernel.shmall =.*/kernel.shmall = 2097152/g' /etc/sysctl.conf ficat <<ENDoracle >> /etc/sysctl.conf############## oracle ##############kernel.shmmax = $MEM2fs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmmni = 4096net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default=4194304net.core.rmem_max=4194304net.core.wmem_default=262144net.core.wmem_max=1048586ENDoraclesysctl -p##edit limitscat <<ENDlimits >> /etc/security/limits.conf# For Oraclegrid soft nproc 2047grid hard nproc 16384grid soft nofile 65536grid hard nofile 101365oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 65536oracle hard nofile 101365ENDlimitsc）修改pamvi /etc/pam.d/login 添加session required /lib64/security/pam_limits.so修改profilevi /etc/profile 添加if [ \$USER = "oracle" ] || [ \$USER = "grid" ]; thenif [ \$SHELL = "/bin/ksh" ]; thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fiumask 022fid）创建用户groupadd -g 1000 oinstallgroupadd -g 1100 asmadmingroupadd -g 1200 dbagroupadd -g 1201 opergroupadd -g 1300 asmdbagroupadd -g 1301 asmoperuseradd -u 1100 -g oinstall -G asmadmin,asmdba,asmoper,dba -s /bin/bash grid useradd -u 1101 -g oinstall -G dba,oper,asmdba -s /bin/bash oracle设置密码为oracle创建目录mkdir /oraclemkdir /gridmkdir -p /grid/gridbasemkdir -p /grid/11.2.0/gridmkdir -p /oracle/product/11.2.0chown -R grid:oinstall /gridchown -R oracle:oinstall /oraclechmod -R 775 /oraclechmod -R 775 /gridvi /etc/udev/rules.d/60-raw.rules 添加ACTION=="add", KERNEL=="sdc1", RUN+="/bin/raw /dev/raw/raw1 %N" KERNEL=="raw1", OWNER="oracle", GROUP="oinstall", MODE="660"ACTION=="add", KERNEL=="sdc2", RUN+="/bin/raw /dev/raw/raw2 %N" KERNEL=="raw2", OWNER="oracle", GROUP="oinstall", MODE="660"ACTION=="add", KERNEL=="sdc3", RUN+="/bin/raw /dev/raw/raw3 %N" KERNEL=="raw3", OWNER="oracle", GROUP="oinstall", MODE="660"ACTION=="add", KERNEL=="sdc5", RUN+="/bin/raw /dev/raw/raw5 %N" KERNEL=="raw5", OWNER="oracle", GROUP="oinstall", MODE="660"ACTION=="add", KERNEL=="sdc6", RUN+="/bin/raw /dev/raw/raw6 %N" KERNEL=="raw6", OWNER="oracle", GROUP="oinstall", MODE="660"# start_udeve）编辑环境变量vi /home/grid/.bash_profileORACLE_SID=+ASM; export ORACLE_SIDORACLE_BASE=/grid/gridbase; export ORACLE_BASEORACLE_HOME=/grid/11.2.0/grid; export ORACLE_HOMEGRID_HOME=/grid/11.2.0/grid; export GRID_HOMEPATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:/usr/local/bin export PATH LD_LIBRARY_PATH=$ORACLE_HOME/libLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/libLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/libLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/ctx/libexport LD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/JRECLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlibCLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlibCLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlibexport CLASSPATHexport TMP=/tmpexport TMPDIR=/tmpexport TEMP=/tmpexport NLS_LANG=AMERICAN_AMERICA.ZHS16GBKexport SQLPATH=~/admin/sql:/$ORACLE_HOME/sqlplus/adminexport NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'umask 022vi /home/oracle/.bash_profileORACLE_SID=testy; export ORACLE_SIDORACLE_UNQNAME=testy; export ORACLE_UNQNAMEORACLE_BASE=/oracle; export ORACLE_BASEORACLE_HOME=$ORACLE_BASE/product/11.2.0; export ORACLE_HOMEORACLE_TERM=xterm; export ORACLE_TERMTNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMINPATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/binPATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/binPATH=$PATH:$ORACLE_HOME/OPatchexport PATHLD_LIBRARY_PATH=$ORACLE_HOME/libLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/libLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/libLD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/ctx/libexport LD_LIBRARY_PATHCLASSPATH=$ORACLE_HOME/JRECLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlibCLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlibCLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlibexport CLASSPATHexport TMP=/tmpexport TMPDIR=/tmpexport TEMP=/tmpexport NLS_LANG=AMERICAN_AMERICA.ZHS16GBKalias sql="sqlplus / as sysdba"alias al='vi $ORACLE_BASE/admin/$ORACLE_SID/bdump/alert_$ORACLE_SID.log' alias alt='tail -f$ORACLE_BASE/admin/$ORACLE_SID/bdump/alert_$ORACLE_SID.log'export SQLPATH=~/admin/sql:/$ORACLE_HOME/sqlplus/adminexport NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'umask 0223、a）验证安装环境# unzip /backup/linux.x64_11gR2_grid.zip验证# chown -R grid:oinstall /backup/gridgrid$ cd /backup/gridgrid$ ./runcluvfy.sh stage -pre hacfg4、安装grida）图形下#xhost+#su - grid$cd /backup/grid$./runInstallerb）选择Install and Configure Grid Infrastructure for a Standalone Server语言添加Simplified Chinesec）disk group name：DATAredundancy:normalAU:16MB选择/dev/raw/raw1 /dev/raw/raw2 /dev/raw/raw3 /dev/raw/raw5asm密码设置使用相同密码：oraclec）确定操作组OSDBA asmdbaOSOPER asmoperOSASM asmadmin确定安装路径ORACLE_BASE: /grid/gridbaseSOFT_LOCATION: /grid/11.2.0/grid产品目录：/grid/oraInventory执行检查：解决警告开始安装gridroot用户执行脚本# /grid/oraInventory/orainstRoot.sh# /grid/11.2.0/grid/root.sh完成grid安装5、安装dbms软件上传安装文件服务器/bak，并解压# unzip linux.x64_11gR2_database_1of2.zip# unzip linux.x64_11gR2_database_2of2.zip# chown -R oracle:oinstall databasesu - oracleoracle$ cd /bak/databaseoracle$ ./runInstaller取消“I wish to receive security updates via My Oracle Support”的选中选择“Install database software only”grid Options”选择single instance database installation语言选择添加中文支持版本选择企业版Select Options”默认安装路径：ORACLE_BASE: /oracleSOFT_LOCATION: /oracle/product/11.2.0确定对应的操作系统组：OSDBA（dba组）、OSOPER（oper组）程序安装前的检查。

esxi5.5环境下oracle单机在asm环境部署数据库软件环境：esxi 5.5 redhat 5.8 oracle 10.2.0.1升级到10.2.0.5先部署1个硬盘25Goracle环境设置修改hosts文件127.0.0.1 localhost.localdomain localhost::1 localhost6.localdomain6 localhost6192.168.1.102 检查oracle数据库安装必备的软件包binutils-2.17.50.0.6-2.el5compat-db-4.2.52-5.1compat-gcc-34-3.4.6-4compat-gcc-34-c++-3.4.6-4compat-libstdc++-33-3.2.3-61compat-libstdc++-33-3.2.3-61(i386)compat-libstdc++-296(i386)gcc-4.1.1-52.el5.2gcc-c++-4.1.1-52.el5.2glibc-2.5-12glibc-2.5-12(i386)glibc-common-2.5-12glibc-devel-2.5-12glibc-devel-2.5-12(i386)glibc-headers-2.5-12libgcc-4.1.1-52.el5(i386)libXp-1.0.0(i386)libXt-1.0.2(i386)libXtst-1.0.1(i386)libaio-0.3.106-3.2libaio-devel-0.3.106-3.2libgcc-4.1.1-52.el5libstdc++-4.1.1-52.el5.2libstdc++-devel-4.1.1-52.el5.2libgomp-4.1.1-52.EL5make-3.81-1.1numactl-devel-0.9.8.x86_64sysstat-7.0.0-3.el5我的缺以下几个rpm -ivh compat-gcc-34-3.4.6-4.1.x86_64.rpmrpm -ivh compat-gcc-34-c++-3.4.6-4.1.x86_64.rpm rpm -ivh libXp-1.0.0-8.1.el5.i386.rpmrpm -ivh libaio-devel-0.3.106-5.x86_64.rpmrpm -ivh numactl-devel-0.9.8-12.el5_6.x86_64.rpm rpm -ivh sysstat-7.0.2-11.el5.x86_64.rpm添加用户groupadd oinstallgroupadd dbauseradd -g oinstall -G dba oracle修改系统版本支持vi/etc/redhat-releaseRed Hat Enterprise Linux Server release 5.8 (Tikanga) 改成Red Hat Enterprise Linux Server release 4.8 (Tikanga) 修改内核参数/etc/sysctl.confkernel.shmall = 2097152kernel.shmmax = 2147483648 #物理内存的一半kernel.shmmni = 4096kernel.sem = 250 32000 100 128fs.file-max = 65536net.ipv4.ip_local_port_range = 1024 65000net.core.rmem_default = 262144net.core.rmem_max = 262144net.core.wmem_default = 262144net.core.wmem_max = 262144黄色部分跟IDC配置有出入修改/etc/security/limits.conforacle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024oracle hard nofile 65536修改/etc/pam.d/loginsession required pam_limits.so修改/etc/profileif [ $USER = "oracle" ]; thenif [ $SHELL = "/bin/ksh" ]; thenulimit -p 16384ulimit -n 65536elseulimit -u 16384 -n 65536fifivi /home/oracle/.bash_profileexport ORACLE_BASE=/oracleexport ORACLE_HOME=$ORACLE_BASE/db10g export ORACLE_SID=orclexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin export PATHexport NLS_LANG=AMERICAN_AMERICA.zhs16gbk设置目录权限chown -R oracle:oinstall /oracle/chmod -R 775 /oracle/先安装oracle 10.2.0.1部署到本地硬盘，只装软件，不装数据库关闭虚拟机添加第2个硬盘16G安装数据库fdisk /dev/sdb分2个同样大小的2个主分区vim /etc/sysconfig/rawdevices/dev/raw/raw1 /dev/sdb1/dev/raw/raw2 /dev/sdb2vim /etc/rc.localchown oracle:dba /dev/raw/raw1chmod 660 /dev/raw/raw1chown oracle:dba /dev/raw/raw2chmod 660 /dev/raw/raw2ntsysv 修改使rawdevices开机启动重启虚拟机/etc/init.d/rawdevices start安装asm支持软件，我的系统是redhat 5.8，所以在此页面查找对应的软件请用uname -a 命令查看系统内核/technetwork/server-storage/linux/downloads/rhel5-084877.htmlDrivers for kernel 2.6.18-308.el5oracleasm-2.6.18-308.el5-2.0.5-1.el5.x86_64.rpmLibrary and Toolsoracleasm-support-2.1.8-1.el5.x86_64.rpmoracleasmlib-2.0.4-1.el5.x86_64.rpm配置asm/etc/init.d/oracleasm configureConfiguring the Oracle ASM library driver.This will configure the on-boot properties of the Oracle ASM librarydriver. The following questions will determine whether the driver isloaded on boot and what permissions it will have. The current valueswill be shown in brackets ('[]'). Hitting <ENTER> without typing ananswer will keep that current value. Ctrl-C will abort.Default user to own the driver interface []: oracleDefault group to own the driver interface []: dbaStart Oracle ASM library driver on boot (y/n) [n]: yScan 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: [ OK ]创建ASM磁盘/etc/init.d/oracleasm createdisk VOL1 /dev/sdb1Marking disk "/dev/sdb1" as an ASM disk: [ OK ]/etc/init.d/oracleasm createdisk VOL2 /dev/sdb2Marking disk "/dev/sdb2" as an ASM disk: [ OK ]记得先root用户/oracle/db10g/bin/localconfig add 启动css服务，可以加载在启动里切换到oracle用户dbca安装数据库安装数据库的时候，先选择配置asm，选择asm磁盘，Redundancy选择normal，group名命名为asm_group默认冗余（normal redundancy）：表示Oracle提供2份镜像来保护数据，有效磁盘空间是所有磁盘设备大小之和的1/2配置玩asm，直接安装数据库，选择安装在asm磁盘，会问你sys密码，可能会报错，忽略就行其它的跟装普通oracle数据库一致配置侦听netca升级到10.2.0.5关闭所有oracle服务和数据库实例emctl stop dbconsoleisqlplusctl stoplsnrctl stopsqlplus / as sysdbaSQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> exitkill相关css进程unzip p8202632_10205_Linux-x86-64.zip按图示安装10.2.0.5的升级包，不再详述安装em的小补丁，解决10.2.0.5版本不能正常启动的bug unzip p8350262_10205_Generic.zipcd 8350262//oracle/db10g/OPatch/opatch apply启动lsnrctl start监听升级数据库dbua按图进行数据库升级操作重启以后，先加载asm实例export ORACLE_SID=+ASMsqlplus / as sysdbaSQL> startupASM instance startedTotal System Global Area 130023424 bytesFixed Size 2094544 bytesVariable Size 102763056 bytesASM Cache 25165824 bytesASM diskgroups mounted然后再加载orcl实例export ORACLE_SID=orclsqlplus / as sysdbaSQL> startupORACLE instance started.Total System Global Area 918552576 bytes Fixed Size 2100552 bytes Variable Size 243270328 bytes Database Buffers 666894336 bytes Redo Buffers 6287360 bytes Database mounted.Database opened.。

ORACLE10g创建单实例ASM1、启动CSS服务bash-3.2# /export/home/oracle/app/ora10g/product/10gr2/bin/localconfig add2、创建初始化实例⽂件[oracle@Solarisora10g ~/app/ora10g/product/10gr2/dbs 12:33:48]$cat asmpfile.orainstance_type=asmprocesses=1003、修改磁盘临时归属[root@localhost dev]# ll /dev/sd*brw-r----- 1 root disk 8, 0 09-20 09:28 /dev/sdabrw-r----- 1 root disk 8, 1 09-20 09:29 /dev/sda1brw-r----- 1 root disk 8, 2 09-20 09:28 /dev/sda2brw-r----- 1 root disk 8, 3 09-20 09:29 /dev/sda3brw-r----- 1 oracle oinstall 8, 16 09-20 09:28 /dev/sdbbrw-r----- 1 oracle oinstall 8, 32 09-20 09:28 /dev/sdcbrw-r----- 1 oracle oinstall 8, 48 09-20 09:28 /dev/sddbrw-r----- 1 oracle oinstall 8, 64 09-20 09:28 /dev/sdebrw-r----- 1 oracle oinstall 8, 80 09-20 09:28 /dev/sdf4、修改磁盘永久归属root@localhost ~]# cd /dev/disk/by-id/[root@localhost by-id]# ll总计 0lrwxrwxrwx 1 root root 9 09-21 10:08 scsi-SATA_VBOX_HARDDISK_VB0000af62-dccaad4e -> ../../sdalrwxrwxrwx 1 root root 10 09-21 10:08 scsi-SATA_VBOX_HARDDISK_VB0000af62-dccaad4e-part1 -> ../../sda1lrwxrwxrwx 1 root root 10 09-21 10:08 scsi-SATA_VBOX_HARDDISK_VB0000af62-dccaad4e-part2 -> ../../sda2lrwxrwxrwx 1 root root 10 09-21 10:08 scsi-SATA_VBOX_HARDDISK_VB0000af62-dccaad4e-part3 -> ../../sda3lrwxrwxrwx 1 root root 9 09-21 10:08 scsi-SATA_VBOX_HARDDISK_VB1b9a7262-2935ca32 -> ../../sdclrwxrwxrwx 1 root root 9 09-21 10:08 scsi-SATA_VBOX_HARDDISK_VB28964494-77102e5f -> ../../sdblrwxrwxrwx 1 root root 9 09-21 10:08 scsi-SATA_VBOX_HARDDISK_VB40f9ab9c-3c85ccbd -> ../../sdelrwxrwxrwx 1 root root 9 09-21 10:08 scsi-SATA_VBOX_HARDDISK_VB5fbccb0f-8346180f -> ../../sddlrwxrwxrwx 1 root root 9 09-21 10:08 scsi-SATA_VBOX_HARDDISK_VBf28664f8-5466eeb9 -> ../../sdf[root@localhost udev]# cd /etc/udev/rules.d/[root@localhost rules.d]# ls05-udev-early.rules 51-hotplug.rules 60-pcmcia.rules 61-uinput-stddev.rules 88-clock.rules 90-hal.rules 99-oracle-asmdevices.rules 40-multipath.rules 60-libsane.rules 60-raw.rules 61-uinput-wacom.rules 90-alsa.rules 95-pam-console.rules bluetooth.rules50-udev.rules 60-net.rules 60-wacom.rules 85-pcscd_ccid.rules 90-dm.rules 98-kexec.rules[root@localhost rules.d]# cat 99-oracle-asmdevices.rulesKERNEL=="sd*",BUS=="scsi",ENV{ID_SERIAL}=="SATA_VBOX_HARDDISK_VB28964494-77102e5f", NAME="sdb",KERNEL=="sd*",BUS=="scsi",ENV{ID_SERIAL}=="SATA_VBOX_HARDDISK_VB28964494-77102e5f", NAME="sdb", OWNER="oracle", GROUP="dba", MODE="0660"KERNEL=="sd*",BUS=="scsi",ENV{ID_SERIAL}=="SATA_VBOX_HARDDISK_VB1b9a7262-2935ca32", NAME="sdc", OWNER="oracle", GROUP="dba", MODE="0660"KERNEL=="sd*",BUS=="scsi",ENV{ID_SERIAL}=="SATA_VBOX_HARDDISK_VB5fbccb0f-8346180f", NAME="sdd", OWNER="oracle", GROUP="dba", MODE="0660"KERNEL=="sd*",BUS=="scsi",ENV{ID_SERIAL}=="SATA_VBOX_HARDDISK_VB40f9ab9c-3c85ccbd", NAME="sde", OWNER="oracle", GROUP="dba", MODE="0660"KERNEL=="sd*",BUS=="scsi",ENV{ID_SERIAL}=="SATA_VBOX_HARDDISK_VBf28664f8-5466eeb9", NAME="sdf", OWNER="oracle", GROUP="dba", MODE="0660"[root@localhost rules.d]# start_udev restart启动 udev： [确定]5、修改asm_diskstring、asm_diskgroups、asm_power_limit参数SQL> alter system set asm_diskstring='/dev/sd*';SQL>CREATE DISKGROUP data EXTERNAL REDUNDANCY DISK '/dev/sdb';SQL>alter system set asm_diskgroups='DATA';。