中国移动NgBoss数据库安装配置

中国移动通信集团业务支撑系统－NG数据库安装配置Version 0.2©中国移动通信集团信息技术中心2010年1月18日文档信息文档变更记录审核批准目录操作系统准备 (4)创建dba、oinstall组 (4)创建oracle用户 (4)建立两节点信任关系 (5)网络配置 (5)NTP配置 (6)设备配置 (6)环境变量配置 (7)安装CRS 10.2.0.1 (7)以root用户执行vipca (13)安装Oracle DB 10.2.0.1 (20)升级CRS 至10.2.0.4.0 (25)备份Oracle Database 10.2.0.1的rawutl (25)确认CRS 10.2.0.4.0升级结果 (32)升级Oracle 数据库软件至10.2.0.4.0 (33)确认Oracle 10g 10.2.0.4.0软件升级结果 (39)使用DBCA创建数据库 (39)使用10.2.0.1的rawutl 替换10.2.0.4.0的版本 (39)口令加固 (43)数据库相关补丁加载 (51)数据库隐含参数和事件设置 (52)归档模式调整 (52)创建watch用户 (53)EM DBConsole配置 (54)修改EM DBConsole端口从5000改为1158 (56)操作系统准备检查操作系统依赖补丁，参考Doc ID：169706.135936--->3894936242--->3894937185--->3894935900--->3894936248--->3854436249--->3805335936--->38949后面是替代补丁zwdb21[/]#show_patches |grep -e 38949 -e 38053 –e 38055 PHKL_38053 esdisk cumulative patchPHKL_38949 vm cumulative patchPHKL_38055 scheduler cumulative patch创建dba、oinstall组# /usr/sbin/groupadd –g 300 oinstall# /usr/sbin/groupadd –g 301 dba创建oracle用户# /usr/sbin/useradd -u 300 -g oinstall -G dba oracle# /usr/sbin/usermod -g oinstall -G dba oracle# passwd oraclezwdb21#[/]getprivgrp dbadba:zwdb21#[/]setprivgrp dba MLOCK RTPRIO RTSCHEDzwdb21#[/]echo "dba MLOCK RTPRIO RTSCHED">/etc/privgroup zwdb21#[/]getprivgrp dbadba MLOCK RTPRIO RTSCHEDzwdb21#[/]getprivgrp oinstalloinstall:zwdb21#[/]setprivgrp oinstall MLOCK RTPRIO RTSCHEDzwdb21#[/]echo "oinstall MLOCK RTPRIO RTSCHED ">>/etc/privgroup zwdb21#[/]getprivgrp oinstalloinstall MLOCK RTPRIO RTSCHEDTo enable you to successfully relink Oracle products after installing this software, enter the following commands to create required X library symbolic links in the /usr/lib directory:# cd /usr/lib# ln -s libX11.3 libX11.sl# ln -s libXIE.2 libXIE.sl# ln -s libXext.3 libXext.sl# ln -s libXhp11.3 libXhp11.sl# ln -s libXi.3 libXi.sl# ln -s libXm.4 libXm.sl# ln -s libXp.2 libXp.sl# ln -s libXt.3 libXt.sl# ln -s libXtst.2 libXtst.sl建立两节点信任关系/.rhostszwdb21 rootzwdb22 rootzwdb21_priv rootzwdb22_priv root/etc/hosts.equivzwdb21 oraclezwdb22 oraclezwdb21_priv oraclezwdb22_priv oracle网络配置NTP配置================================================== Ntp Configure on HP-UX================================================== cp /etc/ntp.conf /etc/ntp.conf.origcp /etc/hosts /etc/hosts.origecho "#ntp server" >> /etc/hostsecho "10.32.196.60 a500_h2" >> /etc/hostsecho "10.32.196.61 a500_k2" >> /etc/hostsecho "server 10.32.196.60" >> /etc/ntp.confecho "server 10.32.196.61" >> /etc/ntp.confecho "driftfile /etc/ntp.drif" >> /etc/ntp.conf#/sbin/init.d/xntpd stop#vi /etc/rc.config.d/netdaemons添加：export NTPDATE_SERVER='a500_h2 a500_k2'添加：export XNTPD=1添加：export XNTPD_ARGS="-l /var/adm/syslog/ntp.log"ntpdate a500_h2/sbin/init.d/xntpd startntpq -p设备配置# chown oracle:oinstall/dev/vgdb*/r*# chmod 755 /dev/vgdb*# chmod 660 /dev/vgdb*/r*OCR:# chown root:oinstall /dev/vgdb*/rocr*# chmod 640 /dev/vgdb*/rocr*Oracle Clusterware voting disk or database files:# chown oracle:dba/dev/vgdb*/rvot*# chmod 660 /dev/vgdb*/rvot*ll /dev/vgdb*/r*|grep -e ocr -e vote环境变量配置root用户/.profileexport ORACLE_SID=zwdb??export ORACLE_BASE=/oracle/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/10g/dbexport ORA_CRS_HOME=$ORACLE_BASE/product/10g/crsexport CRS_HOME=$ORACLE_BASE/product/10g/crsexport PATH=$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:$CRS_HOME/bin:$PATHumask 022oracle用户EDITOR=vi; export EDITORexport ORACLE_SID=zwdb??export ORACLE_BASE=/oracle/app/oracleexport ORACLE_HOME=$ORACLE_BASE/product/10g/dbexport ORA_CRS_HOME=$ORACLE_BASE/product/10g/crsexport CRS_HOME=$ORACLE_BASE/product/10g/crsexport PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORA_CRS_HOME/bin export TEMP=/tmpexport DBCA_RAW_CONFIG=/oracle/rawfile.confexport PS1=$LOGNAME@`hostname`:'$PWD''$ '#export LANG=zh_CN.hp15CN#export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"umask 022alias gohome='cd $ORACLE_HOME'alias gocrs='cd $ORA_CRS_HOME'alias bdump='cd $ORACLE_BASE/admin/zwdb2/bdump'alias udump='cd $ORACLE_BASE/admin/zwdb2/udump'export DISPLAY=???安装CRS 10.2.0.1$/Disk1/cluvfy/runcluvfy.sh stage -pre crsinst -n zwdb21,zwdb22 –verbose$/Disk1/cluvfy/runcluvfy.sh comp nodecon -n zwdb21,zwdb22 –verbose$/Disk1/cluvfy/runcluvfy.sh stage –post hwos -n zwdb21,zwdb22 –verbose$ runcluvfy.sh comp sys -n zwdb21,zwdb22 -p crs -osdba dba -orainv oinstall –verbose$ runcluvfy.sh comp sys -n zwdb21,zwdb22 -p database -osdba dba -orainv oinstall –verbose ./runInstaller –ignoreSysPrereqsCRSHome1在两个节点zwdb21/22上以root用户分别执行以上脚本以root用户执行vipca成功后再点击上图OK#export DISPLAY=10.32.144.143:0.0#vipca填上zwdb21_vip zwdb22_vip地址和子网掩码为防止出现以下问题：Subject: OUI Reports OUI-10058 At The End Of An Installation Doc ID: 743639.1原因分析：zwdb21[/oracle/app/oracle/oraInventory/logs]#vi oraInstall2009-01-05_09-52-34AM.err "oraInstall2009-01-05_09-52-34AM.err" 71 lines, 5515 charactersjava.io.FileNotFoundException: /var/opt/oracle/oraInst.loc (Permission denied)解决办法：分别在两个节点执行：zwdb21[/oracle/app/oracle/oraInventory]#chmod 644 /var/opt/oracle/oraInst.loc zwdb22[/oracle/app/oracle/oraInventory]# chmod 644 /var/opt/oracle/oraInst.loc点击OK完成CRS 10.2.0.1的安装。