Oracle Database 10G - Real Application Clusters Vo

RACInstallationandConfiguration(PartII)Copyright©2005,Oracle.Allrightsreserved.ObjectivesAftercompletingthislesson,youshouldbeabletodothefollowing:•InstalltheOracledatabasesoftware•ConfigurevirtualIPswiththeVirtualInternetProtocolConfigurationAssistant(VIPCA)•Performpreinstallationdatabasetasks•Createaclusterdatabase•Performpostinstallationdatabasetasks•IdentifybestconfigurationpracticesforRAC3-2Copyright©2005,Oracle.Allrightsreserved.OracleDatabase10g:RealApplicationClusters3-2OUIDatabaseConfigurationOptionsConfigurationDescriptionAdvantagesTypeGeneralInstallsastarterdatabase,Minimalinputpurpose,Oracleoptions,networkingrequired.YoucanOLTP,DWservices,andutilities.Atthecreateyourendoftheinstallation,thedatabasemoreDBCAcreatesyourRACquickly.database.AdvancedEnablesyoutocustomizeCreatetablespacesyourdatabaseoptionsandanddatafiles.storagecomponents.CustomizeyourDatabase.DonotcreateInstallsonlythesoftware.BestconfigurationastarterDoesnotconfiguretheflexibility.databaselistenersornetworkinfrastructureanddoesnotcreateadatabase.3-3Copyright©2005,Oracle.Allrightsreserved.OUIDatabaseConfigurationOptionsWhenyouruntheOracleUniversalInstaller(OUI)andchoosetocreatethedatabase,youcanselecttheGeneralPurpose,TransactionProcessing,DataWarehouse,orAdvanceddatabaseconfigurationtypes.IfyouselecttheAdvancedconfiguration,thenyoucanusetheDatabaseConfigurationAssistant(DBCA)tocreatethedatabase.ItisrecommendedthatyouusetheDBCAtocreateyourdatabase.YoucanalsoselecttheAdvancedconfiguration,selectapreconfiguredtemplate,customizethetemplate,andusetheDBCAtocreateadatabasebyusingthetemplate.ThesetemplatescorrespondtotheGeneralPurpose,TransactionProcessing,andDataWarehouseconfigurationtypes.YoucanalsousetheDBCAwiththeAdvancedtemplatetocreateadatabase.ItisrecommendedthatyouuseoneofthepreconfigureddatabaseoptionsorusetheAdvancedoptionandtheDBCAtocreateyourdatabase.However,ifyouwanttoconfigureyourenvironmentandcreateyourdatabasemanually,selecttheDonotcreateastarterdatabaseconfigurationoption.OracleDatabase10g:RealApplicationClusters3-3InstalltheDatabaseSoftware$idoracle$/cdrom/dbs/runInstaller3-4Copyright©2005,Oracle.Allrightsreserved.InstalltheDatabaseSoftwareTheOUIisusedtoinstalltheOracleDatabase10gsoftware.TheOUImustberunastheoracleuser.StarttheOUIbyexecutingtherunInstallercommandfromtherootdirectoryoftheOracleDatabase10gRelease1(10.1.0.2)CD-ROMorthesoftwarestaginglocation.WhentheOUIdisplaystheWelcomepage,clicktheNextbutton.TheSpecifyFileLocationspageisdisplayed.OracleDatabase10g:RealApplicationClusters3-4SpecifyFileLocations3-5Copyright©2005,Oracle.Allrightsreserved.SpecifyFilelocationsTheSourcefieldontheSpecifyFileLocationspageisprepopulatedwiththepathtotheOracleDatabase10gproducts.xmlfile.Youneednotchangethislocationundernormalcircumstances.IntheDestinationsectionofthepage,therearefieldsfortheinstallationnameorOracleHomenameandthepathfortheinstalledproducts.Notethatthedatabasesoftwarecannotsharethesamelocation(OracleHome)asthepreviouslyinstalledClusterReadyServices(CRS)software.TheNamefieldispopulatedwithadefaultorsuggestedinstallationname.AcceptthesuggestednameorenteryourownOracleHomename.Next,inthePathfield,enterthefullyqualifiedpathnamefortheinstallation,/u01/app/oracle/product/10.0.1/db_1intheexampleintheslide.Afterenteringtheinformation,reviewitforaccuracy,andclicktheNextbuttontocontinue.OracleDatabase10g:RealApplicationClusters3-5SpecifyClusterInstallation3-6Copyright©2005,Oracle.Allrightsreserved.SpecifyClusterInstallationTheSpecifyHardwareClusterInstallationModepageisdisplayednext.BecausetheOUIisnodedependent,youmustindicatewhetheryouwanttheinstallationtobecopiedtotherecognizedandselectednodesinyourcluster,orwhetheryouwantasingle,nonclusterinstallationtotakeplace.MostinstallationscenariosrequiretheClusterInstallationoption.Todothis,clicktheClusterInstallationoptionbuttonandmakesurethatallnodeshavebeenselectedinNodeNamelist.Notethatthelocalnodeisalwaysselectedfortheinstallation.Additionalnodesthataretobepartofthisinstallationmustbeselectedbyselectingthecheckbox.Ifyoudonotseeallyournodeslistedhere,exittheOUIandmakesurethatCRSisrunningonallyournodes.RestarttheOUI.ClicktheNextbuttonwhenyouarereadytoproceedwiththeinstallation.IftheOUIdoesnotdisplaythenodesproperly,performclusterwarediagnosticsbyexecutingtheolsnodes-vcommandfromtheORA_CRS_HOME/bindirectory,andanalyzeitsoutput.Refertoyourclusterwaredocumentationifthedetailedoutputindicatesthatyourclusterwareisnotrunning.OracleDatabase10g:RealApplicationClusters3-6SelectInstallationType3-7Copyright©2005,Oracle.Allrightsreserved.SelectInstallationTypeTheSelectInstallationTypepageisdisplayednext.Yourinstallationoptionsinclude:•EnterpriseEdition•StandardEdition•CustomFormostinstallations,theEnterpriseEditioninstallationisthecorrectchoice(butStandardEditionisalsosupported).SelectingtheCustominstallationtypeoptionenablesyoutoinstallonlythoseOracleproductcomponentsthatyoudeemnecessary.Forthis,youmusthaveagoodknowledgeoftheinstallableOraclecomponentsandofanydependenciesorinteractionsthatmayexis