三节点Oracle.docx
《三节点Oracle.docx》由会员分享,可在线阅读,更多相关《三节点Oracle.docx(11页珍藏版)》请在冰豆网上搜索。
三节点Oracle
三节点Oracle10.2.0.1Rac升级到10.2.0.4
环境:
OS:
LinuxAS4U432bit
DBMS:
Oracle10.2.0.4
节点:
IBM3655,主机名分别为rac01、rac02、rac03
存储:
EMCCelerraNS40,采用ASM
补丁下载地址:
ftp:
//
升级过程如下:
1停止数据库服务,用rman做了全库备份,再用tar备份了ORA_CRS_HOME和ORACLE_HOME
2找到安装rac安装时第一台节点,将Patchset上载到rac01服务器,解压安装包
3升级crs,oracle10g支持滚动升级crs,我使用了非滚动升级
3.1每个节点分别停止 EM和 isqlplus
[oracle@rac01orcl]$emctlstopdbconsole
TZsettoAsia/Chungking
OracleEnterpriseManager10gDatabaseControlRelease10.2.0.1.0
Copyright(c)1996,2005OracleCorporation.Allrightsreserved.
http:
//rac01:
1158/em/console/aboutApplication
StoppingOracleEnterpriseManager10gDatabaseControl...
...Stopped.
[oracle@rac01~]$isqlplusctlstop
iSQL*Plus10.2.0.1.0
Copyright(c)2003,2005,Oracle.Allrightsreserved.
iSQL*Plusinstanceonport5561isnotrunning...
3.2关闭每个节点上的监听程序
oracle@rac02backup]$srvctlstoplistener-nrac01
[oracle@rac02backup]$srvctlstoplistener-nrac02
[oracle@rac02backup]$srvctlstoplistener-nrac03
3.3停止 数据库实例
[oracle@rac01orcl]$srvctlstopdatabase-dorcl
3.4停止每个节点的ASM实例
[oracle@rac01orcl]$srvctlstopasm-nrac01
[oracle@rac01orcl]$sshrac02
Lastlogin:
FriAug103:
59:
582008fromrac01
[oracle@rac02~]$srvctlstopasm-nrac02
[oracle@rac02~]$srvctlstopasm-nrac03
3.5停止数据库服务(此环境没有配置数据库服务)
[oracle@rac01orcl]$srvctlstopservice-dorcl-sorcl
PRKO-2120:
Theinternaldatabaseserviceorclcannotbemanagedwithsrvctl.
3.6停止每个节点的ASM实例
[oracle@rac01orcl]$srvctlstopasm-nrac01
[oracle@rac01orcl]$sshrac02
Lastlogin:
FriAug103:
59:
582008fromrac01
[oracle@rac02~]$srvctlstopasm-nrac02
[oracle@rac02~]$srvctlstopasm-nrac03
3.7停止每个节点的应用
[oracle@rac02~]$srvctlstopnodeapps-nrac01
[oracle@rac02~]$srvctlstopnodeapps-nrac02
[oracle@rac02~]$srvctlstopnodeapps-nrac03
3.8查看CRS资源状态,全部成了offline
[oracle@rac02~]$crs_stat-t
NameTypeTargetStateHost
------------------------------------------------------------
ora.orcl.dbapplicationOFFLINEOFFLINE
ora....orcl.csapplicationOFFLINEOFFLINE
ora....cl1.srvapplicationOFFLINEOFFLINE
ora....cl2.srvapplicationOFFLINEOFFLINE
ora....cl3.srvapplicationOFFLINEOFFLINE
ora....l1.instapplicationOFFLINEOFFLINE
ora....l2.instapplicationOFFLINEOFFLINE
ora....l3.instapplicationOFFLINEOFFLINE
ora....SM1.asmapplicationOFFLINEOFFLINE
ora....01.lsnrapplicationOFFLINEOFFLINE
ora.rac01.gsdapplicationOFFLINEOFFLINE
ora.rac01.onsapplicationOFFLINEOFFLINE
ora.rac01.vipapplicationOFFLINEOFFLINE
ora....SM2.asmapplicationOFFLINEOFFLINE
ora....02.lsnrapplicationOFFLINEOFFLINE
ora.rac02.gsdapplicationOFFLINEOFFLINE
ora.rac02.onsapplicationOFFLINEOFFLINE
ora.rac02.vipapplicationOFFLINEOFFLINE
ora....SM3.asmapplicationOFFLINEOFFLINE
ora....03.lsnrapplicationOFFLINEOFFLINE
ora.rac03.gsdapplicationOFFLINEOFFLINE
ora.rac03.onsapplicationOFFLINEOFFLINE
ora.rac03.vipapplicationOFFLINEOFFLINE
3.9停止每个节点上的CRS
[root@rac01~]#/u02/app/oracle/product/10.2.0/crs/bin/crsctlstopcrs
Stoppingresources.
SuccessfullystoppedCRSresources
StoppingCSSD.
ShuttingdownCSSdaemon.
Shutdownrequestsuccessfullyissued.
[root@rac01~]#sshrac02
root@rac02'spassword:
Lastlogin:
FriAug103:
54:
092008from172.16.0.129
[root@rac02~]#/u02/app/oracle/product/10.2.0/crs/bin/crsctlstopcrs
Stoppingresources.
SuccessfullystoppedCRSresources
StoppingCSSD.
ShuttingdownCSSdaemon.
Shutdownrequestsuccessfullyissued.
[root@rac02~]#sshrac03
root@rac03'spassword:
Lastlogin:
FriAug100:
56:
252008from172.16.0.40
[root@rac03~]#/u02/app/oracle/product/10.2.0/crs/bin/crsctlstopcrs
Stoppingresources.
SuccessfullystoppedCRSresources
StoppingCSSD.
ShuttingdownCSSdaemon.
Shutdownrequestsuccessfullyissued.
3.10运行runInstaller开始启动oui,注意选择ORA_CRS_HOME目录,随后oracle自动选择了RAC中的所有节点
3.11一直往下next,全部成功。
最后出现的窗口上要求在每个节点上完成以下两步:
●以root用户身份登录,停止crs服务
#CRS_home/bin/crsctlstopcrs
●以root用户身份执行root102脚本
#CRS_home/install/root102.sh
先停止crs
[root@rac01~]#/u02/app/oracle/product/10.2.0/crs/bin/crsctlstopcrs
Stoppingresources.
SuccessfullystoppedCRSresources
StoppingCSSD.
ShuttingdownCSSdaemon.
Shutdownrequestsuccessfullyissued.
执行root102.sh脚本,脚本提示补丁包应用成功
[root@rac01~]#/u02/app/oracle/product/10.2.0/crs/install/root102.sh
Creatingpre-patchdirectoryforsavingpre-patchclusterwarefiles
Completedpatchingclusterwarefilesto/u02/app/oracle/product/10.2.0/crs
Relinkingsomesharedlibraries.
Relinkingofpatchedfilesiscomplete.
WARNING:
directory'/u02/app/oracle/product/10.2.0'isnotownedbyroot
WARNING:
directory'/u02/app/oracle/product'isnotownedbyroot
WARNING:
directory'/u02/app/oracle'isnotownedbyroot
PreparingtorecopypatchedinitandRCscripts.
RecopyinginitandRCscripts.
Startupwillbequeuedtoinitwithin30seconds.
StartinguptheCRSdaemons.
WaitingforthepatchedCRSdaemonstostart.
Thismaytakeawhileonsomesystems..
10204patchsuccessfullyapplied.
clscfg:
EXISTINGconfigurationversion3detected.
clscfg:
version3is10GRelease2.
SuccessfullyaccumulatednecessaryOCRkeys.
Usingports:
CSS=49895CRS=49896EVMC=49898andEVMR=49897.
node:
node1:
rac01rac01_privrac01
CreatingOCRkeysforuser'root',privgrp'root'..
Operationsuccessful.
clscfg-upgradecompletedsuccessfully
4升级数据软件
4.1在每个节点上停止isqlplus
[oracle@rac01~]$isqlplusctlstop
iSQL*Plus10.2.0.1.0
Copyright(c)2003,2005,Oracle.Allrightsreserved.
iSQL*Plusinstanceonport5561isnotrunning...
[oracle@rac01~]$sshrac02
Lastlogin:
FriAug104:
03:
292008fromrac01
4.2在每个节点上停止EM
[oracle@rac02~]$emctlstopdbconsole
TZsettoAsia/Chungking
OracleEnterpriseManager10gDatabaseControlRelease10.2.0.1.0
Copyright(c)1996,2005OracleCorporation.Allrightsreserved.
http:
//rac01:
1158/em/console/aboutApplication
StoppingOracleEnterpriseManager10gDatabaseControl...
...Stopped.
4.3关闭ASM实例
[oracle@rac02backup]$srvctlstopasm-nrac01
[oracle@rac02backup]$srvctlstopasm-nrac02
[oracle@rac02backup]$srvctlstopasm-nrac03
4.4关闭数据库
oracle@rac02backup]$srvctlstopdatabase-dorcl
4.5关闭每个节点上的监听程序
oracle@rac02backup]$srvctlstoplistener-nrac01
[oracle@rac02backup]$srvctlstoplistener-nrac02
[oracle@rac02backup]$srvctlstoplistener-nrac03
4.6执行runInstaller启动oui,选择ORACLE_HOME,同样Oracle已经自动选择了所有rac节点;一直next,没出现什么错误。
4.7执行最后一个界面时,Oracle提示在每个节点以root用户执行root.sh脚本
在rac01上的执行过程如下:
[root@rac01~]#/u01/app/oracle/product/10.2.0/db_1/root.sh
RunningOracle10root.shscript...
Thefollowingenvironmentvariablesaresetas:
ORACLE_OWNER=oracle
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
Enterthefullpathnameofthelocalbindirectory:
[/usr/local/bin]:
Thefile"dbhome"alreadyexistsin/usr/local/bin.Overwriteit?
(y/n)
[n]:
y
Copyingdbhometo/usr/local/bin...
Thefile"oraenv"alreadyexistsin/usr/local/bin.Overwriteit?
(y/n)
[n]:
y
Copyingoraenvto/usr/local/bin...
Thefile"coraenv"alreadyexistsin/usr/local/bin.Overwriteit?
(y/n)
[n]:
y
Copyingcoraenvto/usr/local/bin...
Entrieswillbeaddedtothe/etc/oratabfileasneededby
DatabaseConfigurationAssistantwhenadatabaseiscreated
Finishedrunninggenericpartofroot.shscript.
Nowproduct-specificrootactionswillbeperformed.
5升级数据库,我使用了DBUA工具
5.1启动dbua工具后,会让用户选择升级ASM还是数据库,由于我们的是从10.2.0.1的基础上升级,不需要升级ASM,直接跳过,如低于此版本而是必须先升级ASM。
5.2升级数据库
要求输入SYS用户密码
一直next,过程中Oracle发现无效对象,忽略
选择编译无效对象和编译并行度
执行升级
整个数据库升级过程大概持续了1个小时,最后终于大功告成,升级成功!
附:
此次升级解决的bug
为了解决一个bug,用户要求升级rac环境,要求的解决bug,metalink解决如下:
Subject:
ORA-600[kgmgchd1]
DocID:
Note:
139068.1Type:
REFERENCE
LastRevisionDate:
03-APR-2008Status:
PUBLISHED
Note:
ForadditionalORA-600relatedinformationpleasereadNote146580.1
PURPOSE:
ThisarticlerepresentsapartiallypublishedOERInote.
IthasbeenpublishedbecausetheORA-600errorhasbeen
reportedinatleastoneconfirmedbug.
Therefore,theSUGGESTIONSsectionofthisarticlemayhelp
intermsofidentifyingthecauseoftheerror.
ThisspecificORA-600errormaybeconsideredforfullpublication
atalaterdate.If/whenfullypublished,additionalinformation
willbeavailablehereonthenatureofthiserror.
SUGGESTIONS:
IftheKnownIssuessectionbelowdoesnothelpintermsofidentifying
asolution,pleasesubmitthetracefilesandalert.logtoOracle
SupportServicesforfurtheranalysis.
KnownIssues:
Bug#5721941SeeNote5721941.8
AdditionaldiagnostictforOERI[kgmgchd1]
Fixed:
10.2.0.4,11.1.0.6