AIX+ORACLE+ASM安装.doc

环境：OS：IBM AIX 5.3Database：10gr2_aix5l64_database.cpio.gz 根据oracle官方建议修改OS相关参数1查看物理内存# /usr/sbin/lsattr -E -l sys0 -a realmemrealmem 8388608 Amount of usable physical memory in Kbytes False官方安装文档要求至少1G的物理内存2查看swap空间# lsps -aPage Space Physical Volume Volume Group Size %Used Active Auto Typehd6 hdisk0 rootvg 4096MB 1 yes yes lv官方安装文档要求8G内存至少4G的swap空间如果swap空间不够可用如下命令chps -s32 hd6 32*128=4G3查看磁盘空间# df -gFilesystem GB blocks Free %Used Iused %Iused Mounted on/dev/hd4 0.25 0.23 9% 2399 5% /dev/hd2 2.00 0.74 63% 36283 18% /usr/dev/hd9var 1.00 0.98 2% 419 1% /var/dev/hd3 1.00 0.59 41% 1471 2% /tmp/dev/hd1 20.00 7.99 61% 20754 2% /home/proc - - - - - /proc/dev/hd10opt 1.25 1.18 6% 893 1% /opt要确保有足够的空间（至少4G）来安装oracle/tmp要求在400M以上如果空间不够，可用chfs 命令来动态增加chfs a size=+1024M /tmp 4操作系统版本# oslevel -s5300-06-05-08065确认系统结构# getconf HARDWARE_BITMODE646确认AIX修补和软件包安装完AIX5.3系统后再安装以下一些软件包pat.clients.rtexlC.aix50.rtexlC.rte bos.cifs_fs.rte f创建组和用户1创建用户和组mkgroup -A id=501 oinstallmkgroup -A id=502dbamkgroup -A id=503 opermkgroup -A id=504 asmadminmkgroup -A id=505 asmopermkgroup -A id=506 asmdbamkuser pgrp=oinstall groups=asmadmin,asmdba,asmoper,dba gridmkuser pgrp=oinstall groups=dba,oper,asmdba oracle2. 配置环境变量.profile# grid Environmentexport ORACLE_BASE=/home/oracleexport ORACLE_HOME=/home/oracle/gridexport PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$GRID_HOME/bin:/usr/java5/jre/bin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/precomp/lib:$LD_LIBRARY_PATHexport LIBPATH=$ORACLE_HOME/libexport AIXTHREAD_SCOPE=Sexport ORACLE_TERM=vt100export NLS_LANG=AMERICAN_AMERICA.zhs16gbk# Oracle Environmentexport ORACLE_UNQNAME=bidbexport ORACLE_BASE=/home/oracleexport ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1export GRID_HOME=/oravl01/app/11.2.0/gridexport ORACLE_SID=bidbexport PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$GRID_HOME/bin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/precomp/lib:$LD_LIBRARY_PATHexport LIBPATH=$ORACLE_HOME/libexport AIXTHREAD_SCOPE=Sexport ORACLE_TERM=vt100export NLS_LANG=AMERICAN_AMERICA.zhs16gbkORACLE_SID=ora10g#指定数据库实例的名称PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:.:/usr/local/binDISPLAY=9:0.0umask 022export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH DISPLAY3. 修改oracle用户文件大小限制：#smit chuser在User NAME 域输入oracle用户设置下列各项的值Soft FILE size -1Soft CPU time -1Soft DATA segment -1Soft STACK size -1Soft core file size -1退出，重新以oracle用户登陆使环境变量生效查看环境变量用set命令安装首先通过ftp把oracle软件包上传到Aix机器用oracle用户通过Xmanager登陆，进入oracle软件所在目录，首先是解压软件包，$gunzip 10gr2_aix5164_database.cpio.gz$cpio idcmv startupASM instance startedTotal System Global Area 130023424 bytesFixed Size 2019136 bytesVariable Size 102838464 bytesASM Cache 25165824 bytesORA-15110: no diskgroups mounted10.创建asm diskgroup :DATA、RECOVERYSQL create diskgroup DATA external redundancy disk /dev/rasmlv;Diskgroup created.SQL create diskgroup RECOVERY external redundancy disk /dev/rrecoverylv;Diskgroup created.SQL select name,state from v$asm_diskgroup;NAME STATE- -DATA MOUNTEDRECOVERY MOUNTED已经挂载了。就不用再挂载了未挂载的挂载方法：alter diskgroup DATA mount;alter diskgroup RECOVERY mount;退出不关闭11.测试asm使用oracle用户正常登录使用的库SQL create tablespace test datafile +DATA size 10m;Tablespace created.ASMCMD +data/gs/datafile ls -lType Redund Striped Time Sys NameDATAFILE UNPROT COARSE DEC 09 14:00:00 Y TEST.256.769442671ASMCMD +data/gs/datafile SQL drop tablespace test including contents and datafiles;Tablespace dropped.12.更改controlfiles、归档 等参数SQL alter system set control_files=+DATA scope=spfile;System altered.SQL alter system set db_recovery_file_dest=+RECOVERY;System altered.SQL alter system set db_create_file_dest=+DATA;System altered.13.复制database到 +DATAlink 库文件libobk.so su - oracle /usr/openv/netbackup/bin/oracle_linkrman target / nocatalog RMAN RMAN backup as copy database format +DATA;14.启动到mount切换asmalterdatabasedatafile/home/oracle/product/10.2.0/db_1/oradata/hadb/system01.dbfoffline; RMAN switch database to copy;datafile 1 switched to datafile copy +DATA/gs/datafile/system.260.769444077datafile 2 switched to datafile copy +DATA/gs/datafile/undotbs1.266.769444157datafile 3 switched to datafile copy +DATA/gs/datafile/sysaux.261.769444103datafile 4 switched to datafile copy +DATA/gs/datafile/users.267.769444165datafile 5 switched to datafile copy +DATA/gs/datafile/aomeidb.262.769444129datafile 6 switched to datafile copy +DATA/gs/datafile/tbivr.263.769444135datafile 7 switched to datafile copy +DATA/gs/datafile/dlbshop.264.769444143datafile 8 switched to datafile copy +DATA/gs/datafile/gsdlb.259.769444013datafile 9 switched to datafile copy +DATA/gs/datafile/mcdb.265.769444149RMAN recover database;Starting recover at 09-DEC-11allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=152 devtype=DISKstarting media recoverymedia recovery complete, elapsed time: 00:00:05Finished recover at 09-DEC-11RMAN alter database open;database opened15.切换tempSQL select name ,status from v$tempfile;NAME STATUS- -/u01/oracle/oradata/gs/temp.dbf ONLINESQL alter tablespace temp add tempfile +DATA size 512m;Tablespace altered.SQL alter tablespace temp drop tempfile /u01/oracle/oradata/gs/temp.dbf;Tablespace altered.16.切换redo logSQL select member from v$logfile;MEMBER-/u01/oracle/oradata/gs/redo03.log/u01/oracle/oradata/gs/redo02.log/u01/oracle/oradata/gs/redo01.logSQL alter database add logfile +DATA size 100m;Database altered.SQL alter database add logfile +DATA size 100m;Database altered.SQL alter database add logfile +DATA size 100m;Database altered.SQL alter system switch logfile;System altered.SQL select group#,status from v$log; GROUP# STATUS- - 1 CURRENT 2 INACTIVE 3 INACTIVE 4 UNUSED 5 UNUSED 6 UNUSED-等group 1、2、3变为INACTIVE就删除SQL alter database drop logfile /u01/oracle/oradata/gs/redo02.log;Database altered.SQL alter database drop logfile /u01/oracle/oradata/gs/redo03.log;Database altered.SQL alter database drop logfile /u01/oracle/oradata/gs/redo01.log;Database altered.再删除/u01/oracle/oradata下面文件就okCSS服务启不来CSS服务启不来，提示如下的错误：Giving up: Oracle CSS stack appears NOT to be running.Oracle CSS service would not start as installedAutomatic Storage Management(ASM) cannot be used until Oracle CSS service is started在单节点上使用ASM是不需要安装CRS的，但使用ASM就一定要CSS的支持，CSS在安装DATABASE的时候已经默认安装，只需要配置就行了。从技术上来讲，上述的错误只要重新配置CSS服务即可。下面的操作需要root权限：# rm -f /usr/tmp/.oracle/*# rm -f /tmp/.oracle/*# rm -f /var/tmp/.oracle/*#cd $ORACLE_HOME/bin#./localconfig delete#./localconfig add#/etc/i