AIX6.1上安装oracle 10.2.0.3.docx

10.2 RAC 在aix6.1的安装一安装前准备1.1检查硬件 查看系统是否满足需求：#uname查看版本#oslevel s #两个节点版本号需完全一致查看硬盘大小#lscfg vp|grep hdisk #这个只能看本地盘大小，不能看到存储划过来的盘的大小#bootinfo -s diskn #可以看到所有盘(包括存储盘)的大小查看内存大小# /usr/sbin/lsattr -E -l sys0 -a realmem查看交换分区# /usr/sbin/lsps a修改交换分区一般来说系统安装好后交换分区默认是512M，而小机一般实际内存为16G或者32G，或者更多，可根据实际情况确定交换分区的大小，并做修改修改方法如下：查询磁盘PP值：#lsvg rootvg算出增加交换空间的值A（总交换空间大小-当前交换空间大小）/PP=A#smitty chps回车选择：number of additional logical partitions输入值:A回车显示成功后退出再次查看交接空间，确认修改成功：#/usr/sbin/lsps -a查看TMP目录大小，不能小于400Mdf -g /tmp查看系统架构，oracle 10g rac要求为64位，如果不是64位，需要修改为64位# /usr/bin/getconf HARDWARE_BITMODE扩rootvg下的lv：操作系统安装时默认的系统lv很小，可根据实际情况来扩rootvg下的lv#chfs -a size=xxG /xxx例如：原来/tmp空间为1G，现在扩为4G#chfs a size=4G /tmp查看lv信息#df g如果要单独划挂载ORACLE目录来存放oracle软件，需新增加lv或者文件系统(建议)，如果oracle软件存放在系统默认的目录下，比如/opt目录下，这一步可以不做例子：挂一个空间为30G的文件系统，挂载点为：/oracle#smittysystem storage managementfile systemadd/change/show/delete file systemenhanced journaled file systemadd enhanced journaled file systemrootvg输入单位数量：62914560，输入挂载点：/oracle，将光标移到：mount automatically at system restartF4选择：yes回车回车注：aix默认单位数量为512 byte,这里30G算出来的单位为：62914560确认新建成功：#df g1.2检查软件补丁包系统文件包：JDK 1.4.2 (64-bit) lslpp -l bos.adt.base bos.adt.lib bos.adt.libm bos.perf.perfstat bos.perf.libperfstat ctools Fileset Level State Description -Path: /usr/lib/objrepos bos.adt.base COMMITTED Base Application Development Toolkit bos.adt.lib COMMITTED Base Application Development Libraries bos.adt.libm COMMITTED Base Application Development Math Library bos.perf.libperfstat COMMITTED Performance Statistics Library Interface bos.perf.perfstat COMMITTED Performance Statistics Interface ctools COMMITTED Proc Filesystem Tools Path: /etc/objrepos bos.adt.base COMMITTED Base Application Development Toolkit bos.perf.libperfstat COMMITTED Performance Statistics Library Interface bos.perf.perfstat COMMITTED Performance Statistics Interface 查看oracle所需AIX要打补丁集是否已经打上：#/usr/sbin/instfix -ik IZ10223 查看ha的安装版本：# lslpp -h cluster* Fileset Level Action Status Date Time -Path: /usr/lib/objrepos cluster.adt.es.client.include COMMIT COMPLETE 04/15/11 14:50:19 cluster.adt.es.client.samples.clinfo COMMIT COMPLETE 04/15/11 14:50:19 . Path: /usr/share/lib/objrepos cluster.man.en_US.es.data COMMIT COMPLETE 04/15/11 14:48:52 APPLY COMPLETE 04/15/11 15:14:46 1.3建oracle用户和组查看用户和组：#lsgroup -a id oinstall,dba#lsuser -a id oracle建oinstall组# smit securitygroup添加组设置组名和组ID：oinstall,301回车确认成功退出或者：#mkgroup -A id=301 oinstall 建dba组# smit securitygroup添加组设置组名和组ID：dba,302回车确认成功退出或者：#mkgroup -A id=302 dba 建ORACLE用户# smit securityuser添加组设置用户名和用户ID，用户主组，用户附属组以及用户home目录：username:oracle,userid:301,primary group:oinstall,group set：dba,home directory:/home/oracle回车确认成功退出或者：#useradd -u 301 -g oinstall -G dba -d /oracle oracle修改oracle用户密码：#passwd oracle(注：确保两个节点的gid,uid必须相同) 查看用户信息：#id oracle#id nobody(注：如果nobody不存在，必须创建) 确定root和oracle用户拥有以下能力，如果没有需添加：CAP_PROPAGATE,CAP_BYPASS_RAC_VMM,CAP_NUMA_ATTACH查看：#lsuser oracle#lsuser root为用户添加以下能力：#/usr/bin/chuser capabilities=CAP_PROPAGATE,CAP_BYPASS_RAC_VMM,CAP_NUMA_ATTACH oracle#/usr/bin/chuser capabilities=CAP_PROPAGATE,CAP_BYPASS_RAC_VMM,CAP_NUMA_ATTACH root 建ORACLE目录mkdir -p /oracle/product/10.2.0/db_1mkdir -p /oracle/product/10.2.0/crschown -R oracle:oinstall /oraclechmod -R 755 /oracle1.4内核参数调试查看用户限制#ulimit a#cat /etc/security/limits 修改用户限制：#chuser fsize=-1 oracle #chuser stack=-1 oracle #chuser rss=-1 oracle #chuser core=-1 oracle #chuser data=-1 oracle #chuser nofiles=-1 oracle#chuser fsize=-1 root #chuser stack=-1 root #chuser rss=-1 root #chuser core=-1 root #chuser data=-1 root #chuser nofiles=-1 oracle注： 我认为还是这样手动输入的比较好，如果是粘贴内容到/etc/security/limits 文件中时，要注意不同用户间要有一行空格。 修改系统配置参数：maxuproc#chdev -l sys0 -a maxuproc=16384 注：oracle官方给出参考值为：2048 修改内核参数脚本(修改后需重启系统才能生效)：#vmo -p -o maxperm%=90; #vmo -p -o minperm%=3 -need nextboot #vmo -p -o maxclient%=90 #vmo -p -o strict_maxperm=0 #vmo -p -o strict_maxclient=1 #vmo -p -o lru_file_repage=0 -need nextboot #vmo -r -o page_steal_method=1 -need nextboot (need to reboot to take into effect) 网络参数配置#no -a|more 查看 查看系统是否运行在兼容模式下：#/usr/sbin/lsattr -El sys0 -a pre520tune如果系统运行在兼容模式下，使用下面命令修改：# /usr/sbin/no -o parameter_name=valueFor example:# /usr/sbin/no -o udp_recvspace=655360 如果系统运行在非兼容模式下，使用下面命令修改：/usr/sbin/no -r -o ipqmaxlen=512Other parameter:/usr/sbin/no -p -o parameter=value参数修改脚本：/usr/sbin/no -r -o ipqmaxlen=512/usr/sbin/no -p -o rfc1323=1/usr/sbin/no -p -o sb_max=1310720/usr/sbin/no -p -o tcp_sendspace=65536/usr/sbin/no -p -o tcp_recvspace=65536/usr/sbin/no -p -o udp_sendspace=65536/usr/sbin/no -p -o udp_recvspace=655360检查网络设置# cat /etc/netsvc.conf | grep hosts查看主机名#hostname查看域名# domainname查看hosts配置#cat /etc/hosts1 node12 node23 node1-vip4 node2-vip node1-priv node2-priv1.5配置节点信任关系配置节点信任有两种方式，可以任选一种一种用.rhosts一种用sshRhosts配置：在root和oracle用户的主目录下修改或者新建.rhosts文件，内容如下：root用户：node1 rootnode2 rootnode1-vip rootnode2-vip rootnode1-priv rootnode2-priv rootoracle用户：node1 oraclenode2 oraclenode1-vip oraclenode2-vip oraclenode1-priv oraclenode2-priv oracle 完成后使用rlogin,rsh进行测试#rlogin node2#rsh node2 date. 配置SSH等效，需要先安装ssh包用oracle用户登录mkdir /.sshchmod 700 /.ssh/usr/bin/ssh-keygen -t rsa/usr/bin/ssh-keygen -t dsatouch /.ssh/authorized_keyscd /.sshlscat /oracle/.ssh/id_rsa.pub authorized_keyscat id_dsa.pub authorized_keyscat id_rsa.pub authorized_keys#scp oraclenode2:/home/oracle/.ssh/authorized_keys /home/oracle/.ssh/authorized_keys2scp oraclenode1:/home/oracle/.ssh/authorized_keys /home/oracle/.ssh/authorized_keys1cat authorized_keys1 authorized_keyscat authorized_keys2 authorized_keys$ chmod 600 /.ssh/authorized_keys打开ssh等效性exec /usr/bin/ssh-agent $SHELL/usr/bin/ssh-add设置DISPLAY$ export DISPLAY=hostname(ip):0.0验证ssh等效性$ ssh nodename1 date$ ssh nodename2 date1.7配置磁盘1.8用户环境变量设置：cat .profileexport ORACLE_BASE=/oracleexport ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1export CRS_HOME=$ORACLE_BASE/product/10.2.0/crsexport ORACLE_SID=db1export TEMP=/tmpexport TMP=/tmpexport TMPDIR=/tmpexport PATH=$PATH:$ORACLE_HOME/bin:$CRS_HOME/binexport AIXTHREAD_SCOPE=Sumask 022export DISPLAY=5:0.0export LIBPATH=$ORACLE_HOME/lib:$CRS_HOME/install/prepatch10204/lib32/if -t 0 ; thenstty intr Cfi注：以上所有操作都必须在两个节点上执行二ORACLE安装2.1CRS安装1.以root用户在两个节点上运行rootpre.sh,在安装前必须运行这个脚本（METALINK: id: 404474 is required when using HACMP 5.4.1 with a fresh install of Oracle RAC clusterware or when upgrading from Oracle 10gR1 to Oracle 10gR2. ）注：补丁p6718715需在metalink上下载su - rootunzip p6718715_10203_AIX64-5L.zip# chmod 755 *# ./rootpre.sh2.安装crs前得cluvfy 检查：$ /u01/app/oracle/product/10.2/crs_1/bin/cluvfy stage -post crsinst -n NMS_ODS_NDB1,NMS_ODS_NDB23切换到oracle用户,如果上面命令运行成功(会报VIP错误，这里可以忽略)，执行下面命令开始安装数据库：#su oracle进入安装目录：$./runInstaller ignoreSysPreReqs在这里会提示你是否运行过rootpre.sh，如果已经运行选择Y，如果没运行，请选N退出后以root用户运行，然后再次安装在安装界面会显示有几个错误和警告，可以忽略继续向下。刚开始安装的时候，在OCR里使用裸设备VPATH文件时提示没权限，后来才知道要使用LV裸设备文件才可以。# chown oracle:dba /dev/rvpath11# chown oracle:dba /dev/rvpath12# ls -l /dev/rvpath*crw- 1 root system 43, 0 Apr 28 21:51 /dev/rvpath0crw- 1 root system 43, 1 Apr 28 21:51 /dev/rvpath1crw- 1 root system 43, 10 Apr 28 21:51 /dev/rvpath10crw-rw- 1 oracle dba 43, 11 Apr 28 21:51 /dev/rvpath11crw-rw- 1 oracle dba 43, 12 Apr 28 21:51 /dev/rvpath12crw- 1 root system 43, 13 Apr 28 21:51 /dev/rvpath13crw- 1 root system 43, 2 Apr 28 21:51 /dev/rvpath2crw- 1 root system 43, 3 Apr 28 21:51 /dev/rvpath3crw- 1 root system 43, 4 Apr 28 21:51 /dev/rvpath4crw- 1 root system 43, 5 Apr 28 21:51 /dev/rvpath5crw- 1 root system 43, 6 Apr 28 21:51 /dev/rvpath6crw- 1 root system 43, 7 Apr 28 21:51 /dev/rvpath7crw- 1 root system 43, 8 Apr 28 21:51 /dev/rvpath8crw- 1 root system 43, 9 Apr 28 21:51 /dev/rvpath9使用dd命令写入时，也提示无法对vpath文件进行直接读写。# dd if=/dev/zero of=/dev/rvpath11 bs=1M count=100dd: /dev/rvpath11: There is an input or output error.#Lsvg l oraclevg.crs安装完成后，运行的脚本信息：=# /u01/app/oracle/oraInventory/orainstRoot.shChanging permissions of /u01/app/oracle/oraInventory to 775.Changing groupname of /u01/app/oracle/oraInventory to oinstall.The execution of the script is complete# /u01/app/oracle/product/10.2/crs_1/root.shWARNING: directory /u01/app/oracle/product/10.2 is not owned by rootWARNING: directory /u01/app/oracle/product is not owned by rootWARNING: directory /u01/app/oracle is not owned by rootWARNING: directory /u01/app is not owned by rootWARNING: directory /u01 is not owned by rootChecking to see if Oracle CRS stack is already configuredChecking to see if any 9i GSD is up/etc/oracle does not exist. Creating it now.Setting the permissions on OCR backup directorySetting up NS directoriesOracle Cluster Registry configuration upgraded successfullyWARNING: directory /u01/app/oracle/product/10.2 is not owned by rootWARNING: directory /u01/app/oracle/product is not owned by rootWARNING: directory /u01/app/oracle is not owned by rootWARNING: directory /u01/app is not owned by rootWARNING: directory /u01 is not owned by rootclscfg: EXISTING configuration version 3 detected.clscfg: version 3 is 10G Release 2.Successfully accumulated necessary OCR keys.Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.node : node 3: nms_ods_ndb1 nms_ods_ndb1_pri nms_ods_ndb1node 4: nms_ods_ndb2 nms_ods_ndb2_pri nms_ods_ndb2clscfg: Arguments check out successfully.NO KEYS WERE WRITTEN. Supply -force parameter to override.-force is destructive and will destroy any previous clusterconfiguration.Oracle Cluster Registry for cluster has already been initializedStartup will be queued to init within 30 seconds.Adding daemons to inittabAdding daemons to inittabExpecting the CRS daemons to be up within 600 seconds.CSS is active on these nodes. nms_ods_ndb1 nms_ods_ndb2CSS is active on all nodes.Waiting for the Oracle CRSD and EVMD to startOracle CRS stack installed and running under init(1M)Running vipca(silent) for configuring nodeappsInvalid node name NMS_ODS_NDB1 entered in an input argument.Invalid node name NMS_ODS_NDB1 entered in an input argument. 安装完成后的效果：6.crs安装完的效果：$ crs_stat -tName Type Target State Host -ora.db1.gsd application ONLINE OFFLINE ora.db1.ons application ONLINE ONLINE nms_.ndb1 ora.db1.vip application ONLINE ONLINE nms_.ndb1 ora.db2.gsd application ONLINE OFFLINE ora.db2.ons application ONLINE ONLINE nms_.ndb2 ora.db2.vip application ONLINE ONLINE nms_.ndb2 升级cluster 。安装 cluster# cd Disk1# pwd/u01/soft/cls_patch/Disk1# su - oracle$ export DISPALY=:0.0$ cd /u01/soft/cls_patch/Disk1$ ./runInstaller*Your platform requires the root user to perform certain pre-installationOS preparation. The root user should execute /usr/sbin/slibclean on all the nodes beforeyou proceed with Patchset Installation.Answer y if root has run /usr/sbin/slibclean so you can proceed with Oracle Patchset installation.Answer n to abort installation and then ask root to run /usr/sbin/slibclean.*Has /usr/sbin/slibclean been run by root? y/n (n)yStarting Oracle Universal Installer.Checking installer requirements.Checking operating system version: must be 5200 or 5300 Failed Exiting Oracle Universal Installer, log for this session can be found at /tmp/OraInstall2011-05-12_06-01-17PM/installActions2011-05-12_06-01-17PM.log$ 修改ini文件：修改oraparam.ini Certified VersionsSolaris=5.8,5.9Linux=redhat-2.1ASHPUX=B.11.00,B.11.11Decunix=V5.1A,V5.1AIX=5200,5300,6100 -增加aix 的6100版本信息。oraparam.ini 140 lines, 5368 characters 升级完成后的界面：按照提示，需要停止crs并执行root102.sh脚本1.Log in as the root user.2.As the root user, perform the following tasks:a.Shutdown the CRS daemons by issuing the following command:/u01/app/oracle/product/10.2/crs_1/bin/crsctl stop crsb.Run the shell script located at:/u01/app/oracle/product/10.2/crs_1/install/root102.shThis script will automatically start the CRS daemons on thepatched node upon completion.3.After completing this procedure, proceed to the next node and repeat.节点1执行：节点1执行：# /u01/app/oracle/product/10.2/crs_1/bin/crsctl stop crsStopping resources.Successfully stopped CRS resources Stopping CSSD.Shutting down CSS daemon.Shutdown request successfully issued.# /u01/app/oracle/product/10.2/crs_1/install/root102.shCreating pre-patch directory for saving pre-patch clusterware filesCompleted patching clusterware files to /u01/app/oracle/product/10.2/crs_1Relinking some shared libraries.ld: 0711-224 WARNING: Duplicate symbol: .aio_nwaitld: 0711-224 WARNING: Duplicate symbol: aio_nwaitld: 0711-224 WARNING: Duplicate symbol: .aio_nwait_timeoutld: 0711-224 WARNING: Duplicate symbol: aio_nwait_timeoutld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.ld: 0711-224 WARNING: Duplicate symbol: .aio_nwaitld: 0711-224 WARNING: Duplicate symbol: aio_nwaitld: 0711-224 WARNING: Duplicate symbol: .aio_nwait_timeoutld: 0711-224 WARNING: Duplicate symbol: aio_nwait_timeoutld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.ld: 0711-783 WARNING: TOC overflow. TOC size: 67184 Maximum size: 65536 Extra instructions are being generated for each reference to a TOC symbol if the symbol is in the TOC overflow area.ld: 0711-224 WARNING: Duplicate symbol: .aio_nwaitld: 0711-224 WARNING: Duplicate symbol: aio_nwaitld: 0711-224 WARNING: Duplicate symbol: .aio_nwait_timeoutld: 0711-224 WARNING: Duplicate symbol: aio_nwait_timeoutld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.ld: 0711-224 WARNING: Duplicate symbol: .aio_nwaitld: 0711-224 WARNING: Duplicate symbol: aio_nwaitld: 0711-224 WARNING: Duplicate symbol: .aio_nwait_timeoutld: 0711-224 WARNING: Duplicate symbol: aio_nwait_timeoutld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.ld: 0711-783 WARNING: TOC overflow. TOC size: 67184 Maximum size: 65536 Extra instructions are being generated for each reference to a TOC symbol if the symbol is in the TOC overflow area.Relinking of patched files is complete.WARNING: directory /u01/app/oracle/product/10.2 is not owned by rootWARNING: directory /u01/app/oracle/product is not owned by rootWARNING: directory /u01/app/oracle is not owned by rootWARNING: directory /u01/app is not owned by rootWARNING: directory /u01 is not owned by rootPreparing to recopy patched init and RC scripts.Recopying init and RC scripts.Startup will be queued to init within 30 seconds.Starting up the CRS daemons.Adding daemons to inittabWaiting for the patched CRS daemons to start. This may take a while on some systems.10203 patch successfully applied.clscfg: EXISTING configuration version 3 detected.clscfg: version 3 is 10G Release 2.Successfully accumulated necessary OCR keys.Using ports: CSS=49895 CRS=49896 EVMC=49898 and EVMR=49897.node : node 3: nms_ods_ndb1 nms_ods_ndb1_pri nms_ods_ndb1Creating OCR keys for user r