Lab367 - Oracle

InstallingOracle8iandtheVCSOracleagentconsistsofthefollowinggeneralsteps:1.)Assignadrivelettertotheshareddisk2.)InstallOracleandNet8.3.)Installthedatabase.4.)StopOracleservicesonthesystem.5.)PreservetheoriginalOracleinstallation.6.)Unassignthedriveletter.7.)InstallOracleandNet8onotherclustersystems.8.)Setupthedatabaseonothersystems9.)RestoretheoriginalOracleinstallation10.)Startdatabaseservicesonotherclustersystems.NoteItisrecommendedthatyoulogonasAdministratortoinstallOraclebinaries.Thisensuresthatonlytheadministratorwillbeabletologontothedatabasewithouttheinternalpassword.Toassignadrivelettertotheshareddisk1.StarttheDiskAdministrator.(Start|Programs|AdministrativeTools(Common)|DiskAdministrator)2.Selecttheconfigureddisk.3.OpentheAssignDriveLetterwindow.(Tools|AssignDriveLetter)4.SelecttheAssignadriveletteroption.5.Selectadriveletterfromthedrop-downlist.6.ClickOK.ToInstallOracleandNet8i1.InserttheCDOracle8.1.6(8i)Release2EnterpriseEditionforWindowsNT4.0.2.RuntheSetupprogram.3.ChoosetoInstallOraclewiththeNet8services,andtheDatabaseConfigurationAssistant.4.Followthewizardinstructions,selectoptionsasperyourconfiguration,andcompletetheinstallation.Toinstallthedatabase1.Verifythattheshareddriveismountedonthelocalsystem.2.StarttheDatabaseConfigurationAssistant.Thislaunchesthedatabaseinstaller.3.SelectCustomInstall.Selectyourconfigurationoptions.4.Whenaskedtospecifytheinitializationfilename,specifyapathonthelocaldisk.5.Selecttoinstalltheshareddataontheshareddisk.Thisincludesthecontrolfiles,redologfiles,anddatafiles.Ifarchivelogfilesarecreated,theytooshouldbeontheshareddisk.6.Optimizethedatabaseonthesystembysettingtheappropriateconfigurationparameters.7.SelecttheCreateDatabaseNowoption.Followthewizardinstructionstocompletetheinstallation.8.Goto%ORACLE_HOME%\network\adminandchangethehostnametothevirtualIPaddressforthissysteminbothlistener.oraandtnsnames.orafiles.ThevirtualIPaddressisderivedfromtheIPresource.FormoreinformationontheIPagent,refertotheaccompanyingInstallationandConfigurationGuide.9.FromtheServiceControlManager(Start|Settings|ControlPanel|Services),changethestartuptypeoftheOracleandSQLNetservicestomanual.TostoptheOracleservices1.OpentheServicescontrolpanel.(Start|Settings|ControlPanel|Services)2.SelecttheOracleserviceandthelistenerservice.3.ClickStop.4.ClickYeswhentoaskedtoconfirmwhetheryouwanttostoptheservice.5.ClickClosetoexittheServicescontrolpanel.TopreservetheoriginalOracleinstallationPreservetheoriginalOracleinstallationbyrenamingtheOracleinstallationdirectory.Forexample,ifyourdatainstallationdirectoryisZ:\Oracle,youcouldrenameittoZ:\OracleTemp.Tounassignthedriveletter1.StarttheDiskAdministrator.(Start|Programs|AdministrativeTools(Common)|DiskAdministrator)2.Selecttheconfigureddisk.3.OpentheAssignDriveLetterwindow.(Tools|AssignDriveLetter)4.SelecttheDonotassignadriveletteroption.ToinstallOracleandNet8onotherclustersystemsInstallOracleandNet8oneachclustersystemwiththesameORACLE_HOMEnameandpath.Formoreinformation,seeToInstallOracleandNet8onpage5.TosetupthedatabaseonotherclustersystemsToensurethatallinstallationsareidentical,thevaluesyouspecifywhileinstallingandconfiguringtheOracledatabaseonothersystemsmustmatchthevaluesspecifiedduringtheinitialdatabaseinstallation.1.Assignadrivelettertotheshareddisk.SeeToassignadrivelettertotheshareddiskonpage5.Verifythattheshareddiskismountedfromthesystem.2.StarttheDatabaseConfigurationAssistant.(Start|Oracle-ORACLE_HOME|DatabaseAdministration|DatabaseConfigurationAssistant).Thislaunchesthedatabaseinstaller.3.SelectCustomInstall.Selectyourconfigurationoptions.4.Whenaskedtospecifytheinitializationfilename,specifyapathonthelocaldisk.5.Installtheshareddataontheshareddisk.Thisincludesthecontrolfiles,redologfiles,anddatafiles.Ifarchivelogfilesaretobecreated,theytooshouldbeontheshareddisk.6.Optimizethedatabaseonthesystembysettingtheappropriateconfigurationparameters.7.SelecttheSaveinformationtoabatchfileoption,andcompletetheinstallation.Thiscreatesparameterfilesandanemptydirectorystructurefordatafiles.8.RepeattheprocessforeveryadditionalOracleinstallation.TorestoretheoriginalOracleinstallation:1.AfteryouhavefinishedinstallingOracleonallclustersystems,deletethelastinstallationdirectory.Forexample,ifthelastOracledatabaseinstallationcreatedadirectoryZ:\Oracleontheshareddisk,deletethisdirectory.2.RenametheOracledirectorycreatedduringthefirstinstallationbacktoitsoriginalname.Forexample,ifyouhadpreservedtheoriginalinstallationdirectoryZ:\OraclebyrenamingittoZ:\OracleTemp,renameittoZ:\Oracleagain.TostartdatabaseservicesonotherclustersystemsNoteThefollowingstepsdonotapplyforthefirstsystemonwhichOracleandNet8wereinstalled.Forexample,ifthefirstsystemissystemA,andsubsequentinstallationsareperformedonsystemsBandC,performthefollowingstepsonlyfromsystemsBandC.1.UseORADIMtocreateanewmanualservicefortheinstanceSIDwherepfileindicatestheinitializationparameterfile.Todothis,typethefollowingatthecommand-prompt.setORACLE_SID=SID%ORACLE_HOME%\bin\oradim-new-sidSID-startmodemanual-pfileInitial