中国移动NgBoss数据库安装配置.docx
《中国移动NgBoss数据库安装配置.docx》由会员分享，可在线阅读，更多相关《中国移动NgBoss数据库安装配置.docx（61页珍藏版）》请在冰点文库上搜索。
中国移动NgBoss数据库安装配置
中国移动通信集团
业务支撑系统－NG数据库安装配置
Version0.2
©中国移动通信集团信息技术中心
2010年1月18日
文档信息
文档名称:
数据库安装配置
文档编号:
文档版本号:
0.1
文档变更记录
版本编号
版本日期
作者
说明
审核批准
职务
签字
时间
批准代表（打印）
目录
操作系统准备4
创建dba、oinstall组4
创建oracle用户4
建立两节点信任关系5
网络配置5
NTP配置6
设备配置6
环境变量配置7
安装CRS10.2.0.17
以root用户执行vipca13
安装OracleDB10.2.0.120
升级CRS至10.2.0.4.025
备份OracleDatabase10.2.0.1的rawutl25
确认CRS10.2.0.4.0升级结果32
升级Oracle数据库软件至10.2.0.4.033
确认Oracle10g10.2.0.4.0软件升级结果39
使用DBCA创建数据库39
使用10.2.0.1的rawutl替换10.2.0.4.0的版本39
口令加固43
数据库相关补丁加载51
数据库隐含参数和事件设置51
归档模式调整52
创建watch用户52
EMDBConsole配置53
修改EMDBConsole端口从5000改为115855
操作系统准备
检查操作系统依赖补丁，参考DocID：
169706.1
35936--->38949
36242--->38949
37185--->38949
35900--->38949
36248--->38544
36249--->38053
35936--->38949
后面是替代补丁
zwdb21[/]#show_patches|grep-e38949-e38053–e38055
PHKL_38053esdiskcumulativepatch
PHKL_38949vmcumulativepatch
PHKL_38055schedulercumulativepatch
创建dba、oinstall组
#/usr/sbin/groupadd–g300oinstall
#/usr/sbin/groupadd–g301dba
创建oracle用户
#/usr/sbin/useradd-u300-goinstall-Gdbaoracle
#/usr/sbin/usermod-goinstall-Gdbaoracle
#passwdoracle
zwdb21#[/]getprivgrpdba
dba:
zwdb21#[/]setprivgrpdbaMLOCKRTPRIORTSCHED
zwdb21#[/]echo"dbaMLOCKRTPRIORTSCHED">/etc/privgroup
zwdb21#[/]getprivgrpdba
dbaMLOCKRTPRIORTSCHED
zwdb21#[/]getprivgrpoinstall
oinstall:
zwdb21#[/]setprivgrpoinstallMLOCKRTPRIORTSCHED
zwdb21#[/]echo"oinstallMLOCKRTPRIORTSCHED">>/etc/privgroup
zwdb21#[/]getprivgrpoinstall
oinstallMLOCKRTPRIORTSCHED
ToenableyoutosuccessfullyrelinkOracleproductsafterinstallingthissoftware,enterthefollowingcommandstocreaterequiredXlibrarysymboliclinksinthe/usr/libdirectory:
#cd/usr/lib
#ln-slibX11.3libX11.sl
#ln-slibXIE.2libXIE.sl
#ln-slibXext.3libXext.sl
#ln-slibXhp11.3libXhp11.sl
#ln-slibXi.3libXi.sl
#ln-slibXm.4libXm.sl
#ln-slibXp.2libXp.sl
#ln-slibXt.3libXt.sl
#ln-slibXtst.2libXtst.sl
建立两节点信任关系
/.rhosts
zwdb21root
zwdb22root
zwdb21_privroot
zwdb22_privroot
/etc/hosts.equiv
zwdb21oracle
zwdb22oracle
zwdb21_privoracle
zwdb22_privoracle
网络配置
Node
InterfaceName
Type
IPAddress
InterfaceCard
zwdb21
zwdb21
zwdb21_vip
RAC虚拟地址
zwdb21_priv
RAC心跳
zwdb21_hrt
M/CSG心跳
zwdb22
zwdb22
zwdb22_vip
zwdb22_priv
RAC心跳
zwdb22_hrt
M/CSG心跳
NTP配置
==================================================
NtpConfigureonHP-UX
==================================================
cp/etc/ntp.conf/etc/ntp.conf.orig
cp/etc/hosts/etc/hosts.orig
echo"#ntpserver">>/etc/hosts
echo"10.32.196.60a500_h2">>/etc/hosts
echo"10.32.196.61a500_k2">>/etc/hosts
echo"server10.32.196.60">>/etc/ntp.conf
echo"server10.32.196.61">>/etc/ntp.conf
echo"driftfile/etc/ntp.drif">>/etc/ntp.conf
#/sbin/init.d/xntpdstop
#vi/etc/rc.config.d/netdaemons
添加：
exportNTPDATE_SERVER='a500_h2a500_k2'
添加：
exportXNTPD=1
添加：
exportXNTPD_ARGS="-l/var/adm/syslog/ntp.log"
ntpdatea500_h2
/sbin/init.d/xntpdstart
ntpq-p
设备配置
#chownoracle:
oinstall/dev/vgdb*/r*
#chmod755/dev/vgdb*
#chmod660/dev/vgdb*/r*
OCR:
#chownroot:
oinstall/dev/vgdb*/rocr*
#chmod640/dev/vgdb*/rocr*
OracleClusterwarevotingdiskordatabasefiles:
#chownoracle:
dba/dev/vgdb*/rvot*
#chmod660/dev/vgdb*/rvot*
ll/dev/vgdb*/r*|grep-eocr-evote
环境变量配置
root用户/.profile
exportORACLE_SID=zwdb?
?
exportORACLE_BASE=/oracle/app/oracle
exportORACLE_HOME=$ORACLE_BASE/product/10g/db
exportORA_CRS_HOME=$ORACLE_BASE/product/10g/crs
exportCRS_HOME=$ORACLE_BASE/product/10g/crs
exportPATH=$ORACLE_HOME/bin:
$ORA_CRS_HOME/bin:
$CRS_HOME/bin:
$PATH
umask022
oracle用户
EDITOR=vi;exportEDITOR
exportORACLE_SID=zwdb?
?
exportORACLE_BASE=/oracle/app/oracle
exportORACLE_HOME=$ORACLE_BASE/product/10g/db
exportORA_CRS_HOME=$ORACLE_BASE/product/10g/crs
exportCRS_HOME=$ORACLE_BASE/product/10g/crs
exportPATH=$PATH:
$ORACLE_HOME/bin:
$ORACLE_HOME/OPatch:
$ORA_CRS_HOME/bin
exportTEMP=/tmp
exportDBCA_RAW_CONFIG=/oracle/rawfile.conf
exportPS1=$LOGNAME@`hostname`:
'$PWD''$'
#exportLANG=zh_CN.hp15CN
#exportNLS_LANG="SIMPLIFIEDCHINESE_CHINA.ZHS16GBK"
umask022
aliasgohome='cd$ORACLE_HOME'
aliasgocrs='cd$ORA_CRS_HOME'
aliasbdump='cd$ORACLE_BASE/admin/zwdb2/bdump'
aliasudump='cd$ORACLE_BASE/admin/zwdb2/udump'
exportDISPLAY=?
?
?
安装CRS10.2.0.1
$/Disk1/cluvfy/runcluvfy.shstage-precrsinst-nzwdb21,zwdb22–verbose
$/Disk1/cluvfy/runcluvfy.shcompnodecon-nzwdb21,zwdb22–verbose
$/Disk1/cluvfy/runcluvfy.shstage–posthwos-nzwdb21,zwdb22–verbose
$runcluvfy.shcompsys-nzwdb21,zwdb22-pcrs-osdbadba-orainvoinstall–verbose
$runcluvfy.shcompsys-nzwdb21,zwdb22-pdatabase-osdbadba-orainvoinstall–verbose
./runInstaller–ignoreSysPrereqs
CRSHome1
在两个节点zwdb21/22上以root用户分别执行以上脚本
以root用户执行vipca
成功后再点击上图OK
#exportDISPLAY=10.32.144.143:
0.0
#vipca
填上zwdb21_vipzwdb22_vip地址和子网掩码
为防止出现以下问题：
Subject:
OUIReportsOUI-10058AtTheEndOfAnInstallation
DocID:
743639.1
原因分析：
zwdb21[/oracle/app/oracle/oraInventory/logs]#vioraInstall2009-01-05_09-52-34AM.err
"oraInstall2009-01-05_09-52-34AM.err"71lines,5515characters
java.io.FileNotFoundException:
/var/opt/oracle/oraInst.loc（Permissiondenied）
解决办法：
分别在两个节点执行：
zwdb21[/oracle/app/oracle/oraInventory]#chmod644/var/opt/oracle/oraInst.loc
zwdb22[/oracle/app/oracle/oraInventory]#chmod644/var/opt/oracle/oraInst.loc
点击OK
完成CRS10.2.0.1的安装。
安装OracleDB10.2.0.1
在两个节点zwdb21/22上依次执行/oracle/app/oracle/product/10g/db/root.sh
点击Exit完成Oracle10gDB10.2.0.1.0的安装。
升级CRS至10.2.0.4.0
备份OracleDatabase10.2.0.1的rawutl
$cp$ORACLE_HOME/bin/rawutl$ORACLE_HOME/bin/rawutl.10201
oracle@zwdb21:
/oracle/app/oracle/product/10g/db/bin$cprawutlrawutl.10201
oracle@zwdb22:
/oracle/app/oracle/product/10g/db/bin$cprawutlrawutl.10201
oracle@zwdb21:
/archlog1/software/patchset/Disk1$./runInstaller-ignoreSysPrereqs
TheinstallerhasdetectedthatyourClusterReadyServices（CRS）installationisdistributedacrossthefollowingnodes:
zwdb21
zwdb22
Becausethesoftwareconsistsoflocalidenticalcopiesdistributedacrosseachofthenodesinthecluster,itispossibletopatchyourCRSinstallationinarollingmanner,onenodeatatime.
Tocompletetheinstallationofthispatchset,youmustperformthefollowingtasksoneachnode:
1.Loginastherootuser.
2.Astherootuser,performthefollowingtasks:
a.ShutdowntheCRSdaemonsbyissuingthefollowingcommand:
/oracle/app/oracle/product/10g/crs/bin/crsctlstopcrs
b.Runtheshellscriptlocatedat:
/oracle/app/oracle/product/10g/crs/install/root102.sh
ThisscriptwillautomaticallystarttheCRSdaemonsonthe
patchednodeuponcompletion.
3.Aftercompletingthisprocedure,proceedtothenextnodeandrepeat.
节点一zwdb21:
zwdb21[/oracle/app/oracle/oraInventory/logs]#/oracle/app/oracle/product/10g/crs/bin/crsctlstopcrs
Stoppingresources.
SuccessfullystoppedCRSresources
StoppingCSSD.
ShuttingdownCSSdaemon.
Shutdownrequestsuccessfullyissued.
zwdb21[/oracle/app/oracle/oraInventory/logs]#/oracle/app/oracle/product/10g/crs/install/root102.sh
Creatingpre-patchdirectoryforsavingpre-patchclusterwarefiles
Completedpatchingclusterwarefilesto/oracle/app/oracle/product/10g/crs
Relinkingsomesharedlibraries.
Relinkingofpatchedfilesiscomplete.
WARNING:
directory'/oracle/app/oracle/product/10g'isnotownedbyroot
WARNING:
directory'/oracle/app/oracle/product'isnotownedbyroot
WARNING:
directory'/oracle/app/oracle'isnotownedbyroot
WARNING:
directory'/oracle/app'isnotownedbyroot
WARNING:
directory'/oracle'isnotownedbyroot
PreparingtorecopypatchedinitandRCscripts.
RecopyinginitandRCscripts.
Startupwillbequeuedtoinitwithin30seconds.
/usr/lib/hpux64/dld.so:
Unabletofindlibrary'libclntsh.so.10.1'.
su:
8370Killed
/usr/lib/hpux64/dld.so:
Unabletofindlibrary'libclntsh.so.10.1'.
su:
8436Killed
/usr/lib/hpux64/dld.so:
Unabletofindlibrary'libclntsh.so.10.1'.
su:
8480Killed
StartinguptheCRSdaemons.
WaitingforthepatchedCRSdaemonstostart.
Thismaytakeawhileonsomesystems.
.
10204patchsuccessfullyapplied.
clscfg:
EXISTINGconfigurationversion3detected.
clscfg:
version3is10GRelease2.
SuccessfullyaccumulatednecessaryOCRkeys.
Usingports:
CSS=49895CRS=49896EVMC=49898andEVMR=49897.
node:
node1:
zwdb21zwdb21_privzwdb21
CreatingOCRkeysforuser'root',privgrp'sys'..
Operationsuccessful.
clscfg-upgradecompletedsuccessfully
zwdb21[/oracle/app/oracle/oraInventory/logs]#
问题：
出现权限问题
/usr/lib/hpux64/dld.so:
Unabletofindlibrary'libclntsh.so.10.1'.
su:
8370Killed
/usr/lib/hpux64/dld.so:
Unabletofindlibrary'libclntsh.so.10.1'.
su:
8436Killed
/usr/lib/hpux64/dld.so:
Unabletofindlibrary'libclntsh.so.10.1'.
su:
8480Killed
位置：
/oracle/app/oracle/product/10g/crs/lib
解决办法：
zwdb21[/oracle/app/oracle/product/10g/crs/lib]#lllib*|greproot
lrwx------1rootsys54Jan511:
26libagtsh.so->/oracle/app/oracle/product/10g/crs/lib/libagtsh.so.1.0
-rwx------1rootsys9466816Jan511:
26libagtsh.so.1.0
lrwx------1rootsys17Jan511:
26libclntsh.so->libclntsh.so.10.1
-rwx------1rootsys36877088Jan511:
25libclntsh.so.10.1
-rwx------1rootsys52481664Jan511:
26libttsh10.so
zwdb21[/oracle/app/oracle/product/10g/crs/lib]#chmod755libagtsh.so.1.0
zwdb21[/oracle/app/oracle/product/10g/crs/lib]#c
升级会员 