Oracle+RAC10g+R2+on+HP+new.docx

Oracle+RAC10g+R2+on+HP+new.docx

《Oracle+RAC10g+R2+on+HP+new.docx》由会员分享，可在线阅读，更多相关《Oracle+RAC10g+R2+on+HP+new.docx（34页珍藏版）》请在冰豆网上搜索。

Oracle+RAC10g+R2+on+HP+new

OracleRAC10gR2onHP-UX

1.Aimofthisdocument

Alldescribedscenariosarebasedona2nodecluster,node1referredtoas'ksc'andnode2as'schalke'.

Inthispaper,weusethefollowinglogic:

ksc#=commandneedstobeissuedasrootfromnodeksc

schalke$=commandneedstobeissuedasoraclefromnodeschalke

ksc/schalke#=commandneedstobeissuedasrootfrombothnodesksc+schalke

ThisdocumentshouldbeusedinconjunctionwiththefollowingOracledocumentation:

B25292-02Oracle®DatabaseReleaseNotes10gRelease2（10.2）forHP-UXItanium

B19067-04Oracle®DatabaseReleaseNotes10gRelease2（10.2）forHP-UXPA-RISC（64-Bit）

B14202-04OracleClusterwareandOracleRealApplicationClustersInstallationandConfigurationGuideforhpHP-UX

ItalsoincludesmaterialfromHPServiceguard+RAC10gpaperswrittenbyACSLlabswhichareavailableHPinternallyat

2.KeyNewFeaturesforRAC10gonHP-UX

2.1.OracleClusterware

NewwithRAC10g,OracleincludesitsownClusterwareandpackagemanagementsolutionwiththedatabaseproduct.TheOracleClusterwareconsistsof

●OracleClusterSynchronizationServices（CSS）toprovideclustermanagementfunctionality

●OracleClusterReadyServices（CRS）supportservicesandworkloadmanagementandhelptomaintainthecontinuousavailabilityoftheservices.CRSalsomanagesresourcessuchasthevirtualIP（VIP）addressforthenodeandtheglobalservicesdaemon.

●EventManagement（EVM）publisheseventsgeneratedbyCRS

ThisOracleClusterwareisavailableonallvariousOracleRACplatformsandbasedontheHPTruClusterproductwhichOraclelicensedacoupleofyearsago.

CustomerscannowdeployOracleRACclusterswithoutanyadditional3rdpartyclusterwareproductssuchasSG/SGeRAC.However,customersmightwanttocontinuetouseSG/SGeRACfortheclustermanagement（e.g.tomakeyourcompleteclusterhighavailableincluding3rdpartyapplication,interconnect,etc.）.InthiscaseOracleClusterwareinteractswiththeSG/SGeRACtocoordinateclustermembershipinformation.

NewFeaturesforOracleClusterwarewithRAC10gR2:

●Oracle10gR2comeswithnewClusterVerificationUtilitythatyoucanusetocheckwhetherornotyourclusterisproperlyconfigured,toavoidinstallationfailures,andtoavoiddatabasecreationfailures.

●With10gR2,OracleClusterwareprovidesthepossibilitytomirrortheOracleClusterRegistry（OCR）file,enhancingclusterreliability.

●With10gR2,CSShasbeenmodifiedtoallowyoutoconfiguremultiplevotingdisks.InRAC10gR1,youcouldconfigureonlyonevotingdisk.Byenablingmultiplevotingdiskconfiguration,theredundantvotingdisksallowyoutoconfigureaRACdatabasewithmultiplevotingdisksonindependentsharedphysicaldisks.

●WithOracle10gR2,inaddition,whilecontinuingtoberequiredforRACdatabases,OracleClusterwareisalsoavailableforusewithsingle-instancedatabasesandapplicationsthatyoudeployonclusters.TheAPIlibrariesrequiredforusewithsingle-instancedatabasesareprovidedwiththeOracleClientinstallationmedia.

2.2.OracleAutomaticStorageManagement

OracleAutomaticStorageManagement（ASM）isanewfeaturethathasbeintroducedinOracleDatabase10gtosimplifythestorageofOracledata.ASMvirtualizesthedatabasestorageintodiskgroups.TheDBAisabletomanageasmallsetofdiskgroupsandASMautomatestheplacementofthedatabasefileswithinthosediskgroups.

InsummaryASMdoesprovidethefollowingfunctionality:

●Managesgroupsofdisks,calleddiskgroups.

●Providesthreemirroringoptionsforprotectionagainstdiskfailure:

none,two-way,andthree-waymirroring.

●Spreadsdataevenlyacrossallavailablestorageresourcestooptimizeperformanceandutilization.

●EnablestheDBAtochangethestorageconfigurationwithouthavingtotakethedatabaseoffline.

●Automaticallyrebalancesfilesacrossthediskgroupafterdiskshavebeenaddedordropped.

NewFeaturesforOracleASMwith10gR2:

●ASMCommand-LineUtilityforASMfileadministration:

$asmcmdhelp

●Oracle10gR2supportsinstallationofAutomaticStorageManagementinaseparateASMhomedirectory.

●SupportsinteroperabilityforallversionsofASMandDatabaseinstancesstartingwithRAC10gR1.ThisallowstheASMinstanceandDBinstancetobeupgradedindependently:

●ASMmigrationutilitywithEnterpriseManagerGridControlGUI

2.3.HPServiceguardClusterFileSystemforOracleRAC

InSeptember2005,HPannouncedtheavailabilityofthenewHPServiceguardStorageManagementSuitethatoffersenhanceddatabase,cluster,andperformancemanagementcapabilitiesforHP-UX11ienvironmentsbyintegratingHPServiceguardandSymantecVERITASStorageFoundation.ThisnewproductsuiteisideallysuitedtocustomerswhoneedthehighestlevelsofavailabilityandsuperiorOracledatabaseperformanceorwhohaveanapplicationthatwouldbenefitfromaclusteredfilesystem.

TheHPServiceguardClusterFileSystemforOracleRACSuiteincludesthefollowingtechnologiesfromSymantecVERITASStorageFoundation:

●ClusterFileSystem（CFS）—providesexcellentI/OperformanceandsimplifiestheinstallationandongoingmanagementofaRACdatabase

●Advancedvolumemanagementandfilesystem（AVMFS）capabilities—offersdynamicmultipathing,databasetablespacegrowth,andhotrelocationoffailedredundantstorage.Italsoprovidesavarietyofonlineoptions,includingstoragereconfigurationandvolumeandfilesystemcreationandresizing.

●OracleDiskManager（ODM）—deliversalmostrawperformancerunningdirectI/Obycachingfrequentlyaccesseddata

●Qualityofstorageservice（QoSS）—enablesadministratorstosetpoliciesthatsegmentcompanydatabasedonvariouscharacteristicsandassignthedatatoappropriateclassesofstorageovertime

●FlashSnap—helpsdatabaseadministratorseasilyestablishadatabaseclone,aduplicatedatabaseonasecondaryhostforoff-hostprocessing

ThisHPServiceguardStorageManagementSuiteisofferedandsupporteddirectlyfromHPforasinglepointofcontactforallyoursupportneeds.

HPProductNumber:

T2777BA（HPServiceguardCFSforRACLTU）.

3.SupportedConfigurationswithRAC10gonHP-UX

Customersdohaveavarietyofchoiceswithregardstotheinstallationandset-upofOracleRealApplicationClusters10gontheHP-UXplatform.

Firstcustomersneedtomakeadecisionwithregardstotheunderlyingclustersoftware.CustomershavethepossibilitytodeploytheirRACclusteronlywithOracleClusterware.Alternatively,customersmightwanttocontinuetouseHPServiceguard&HPServiceguardExtensionforRAC（SGeRAC）fortheclustermanagement.InthiscaseOracle’sCSSinteractswithHPSG/SGeRACtocoordinateclustermembershipinformation.

Forstoragemanagement,customershavethechoicetouseOracleASM,HP'sClusterFile

SystemsorRAWDevices.Pleasenote,forRACwithStandardEditioninstallations,OraclemandatesthattheOracledatamustbeplacedunderASMcontrol.

ThefigurebelowillustratesthesupportedconfigurationswithOracleRAC10gR2onHP-UX.

ThefollowingtableshowsthestorageoptionssupportedforstoringOracleClusterwarefiles,Oracledatabasefiles,andOracledatabaserecoveryfiles.Oracledatabasefilesincludedatafiles,controlfiles,redologfiles,theserverparameterfile,andthepasswordfile.OracleClusterwarefilesincludeOracleClusterRegistry（OCR）andVotingdisk.OracleRecoveryfilesincludearchivelogfiles.

4.GeneralSystemInstallationRequirements

4.1.HardwareRequirements

●atleast1GBofphysicalRAM.Usethefollowingcommandtoverifytheamountofmemoryinstalledonyoursystem:

⏹#/usr/contrib/bin/machinfo|grep-iMemoryor

⏹#/usr/sbin/dmesg|grep"Physical:

"

●SwapspaceequivalenttothemultipleoftheavailableRAM,asindicatedhere:

⏹IfRAMbetween1GBand2GB,thenswapspacerequiredis1.5timesthesizeofRAM

⏹IfRAM>2GB,thenswapspacerequiredisequaltothesizeofRAM

⏹Usethefollowingcommandtodeterminetheamountofswapspaceinstalledonyoursystem:

#/usr/sbin/swapinfo–a

●400MBofdiskspaceinthe/tmpdirectory.Todeterminetheamountofdiskspaceavailableinthe/tmpdirectory,enterthefollowingcommand:

#bdf/tmp

⏹Ifthereislessthan400MBofdiskspaceavailableinthe/tmpdirectoryextendthefilesystemorsettheTEMPandTMPDIRenvironmentvariableswhensettingtheoracleuser'senvironment.Thisenvironmentvariablescanbeusedtooverride/tmp.:

$exportTEMP=/directory

$exportTMPDIR=/directory

●4GBofdiskspacefortheOraclesoftware.Youcandeterminetheamountoffreediskspaceonthesystemusing

#bdf–k

●1.2GBofdiskspaceforapreconfigureddatabasethatusesfilesystemstorage（optional）

●OperatingSystem:

HP-UX11.23（Itanium2）,11.23（PA-RISC）,11.11（PA-RISC）.Todetermineifyouhavea64-bitconfigurationenterthefollowingcommand:

#/bin/getconfKERNEL_BITS

●TodeterminewhichversionofHP-UXisinstalled,enterthefollowingcommand:

#uname–a

●AsnycI/OisrequiredforOracleonRAWdevicesandconfiguredonHP-UX11.23bydefault.Youcancheckifyouhavethefollowingfile:

#ll/dev/async

#crw-rw-rw-1binbin1010x000000Jun909:

38/dev/async

●IfyouwanttouseOracleonRAWdevicesandAsyncI/Oisnotconfigured,then

⏹Createthe/dev/asynccharacterdevice

#/sbin/mknod/dev/asyncc1010x0

#chownoracle:

dba/dev/async

#chmod660/dev/async

⏹ConfiguretheasyncdriverinthekernelusingSAM

=>KernelConfiguration

=>Kernel

=>thedriver