Table Of ContentALM
SoftwareVersion:12.60
Installation and Upgrade Guide - Windows
GotoHELP CENTERONLINE
http://admhelp.microfocus.com/alm
DocumentReleaseDate:August2019|SoftwareReleaseDate:Noverber2018
Legal Notices
Disclaimer
Certainversionsofsoftwareand/ordocuments(“Material”)accessibleheremaycontainbrandingfromHewlett-Packard
Company(nowHPInc.)andHewlettPackardEnterpriseCompany. AsofSeptember1,2017,theMaterialisnowofferedby
MicroFocus,aseparatelyownedandoperatedcompany. AnyreferencetotheHPandHewlettPackardEnterprise/HPEmarks
ishistoricalinnature,andtheHPandHewlettPackardEnterprise/HPEmarksarethepropertyoftheirrespectiveowners.
Warranty
TheonlywarrantiesforproductsandservicesofMicroFocusanditsaffiliatesandlicensors(“MicroFocus”)aresetforthin
theexpresswarrantystatementsaccompanyingsuchproductsandservices.Nothinghereinshouldbeconstruedas
constitutinganadditionalwarranty.MicroFocusshallnotbeliablefortechnicaloreditorialerrorsoromissionscontained
herein.Theinformationcontainedhereinissubjecttochangewithoutnotice.
RestrictedRightsLegend
ContainsConfidentialInformation.Exceptasspecificallyindicatedotherwise,avalidlicenseisrequiredforpossession,useor
copying.ConsistentwithFAR12.211and12.212,CommercialComputerSoftware,ComputerSoftwareDocumentation,and
TechnicalDataforCommercialItemsarelicensedtotheU.S.Governmentundervendor'sstandardcommerciallicense.
CopyrightNotice
©Copyright2002-2019MicroFocusoroneofitsaffiliates.
ALM(12.60) Page2of198
InstallationandUpgradeGuide-Windows
Contents
ALM 1
WelcometothisGuide 8
Part1:InstallationOverview 9
Chapter1:AboutALMTechnologyandArchitecture 11
UnderstandingtheALMComponents 11
ExampleofBasicALMConfiguration 12
ExampleofClusteredALMConfiguration 13
Chapter2:HowtoInstallandUpgrade 17
Chapter3:CommonInstallationScenarios 19
NewALMInstallation 19
UpgradeALMwithNewSchema 20
UpgradeALMwithCopiedSchema 21
UpgradeALMwithSameServer 22
UpgradeALMwithSameDatabaseServer 23
Part2:PatchInstallation 25
Chapter4:InstallingALMPatches 27
Pre-InstallationChecksandConsiderations 27
SystemRequirements 28
RequiredPermissions 28
ClusteringConfiguration 29
InstallingthePatch 29
UninstallingthePatch 31
Part3:InstallationPrerequisites 33
Chapter5:Pre-InstallationChecklist 35
Chapter6:Prerequisites:WindowsOperatingSystems 39
SystemConfigurations:Windows 39
RequiredPermissions:Windows 39
Clustering:Windows 40
ALMRepositoryPath:Windows 41
Chapter7:Prerequisites:OracleDatabaseServers 43
ConnectingALMtoanOracleDatabaseServer 43
UserPermissionsforConnectingALMtoanOracleDatabaseServer 44
DatabaseAdministrativeUserPrivileges 45
ProjectUserPrivileges 47
ALM(12.60) Page3of198
InstallationandUpgradeGuide-Windows
SiteAdministrationDatabaseSchemaConsiderations: Oracle 48
OracleRACSupport 49
Chapter8:Prerequisites:MicrosoftSQLDatabaseServers 51
ConnectingALMtoaMicrosoftSQLDatabaseServer 51
UserPermissionsforConnectingALMtoaMicrosoftSQLDatabaseServer 52
SiteAdministrationDatabaseSchemaConsiderations:SQL 54
Chapter9:Prerequisites:General 55
LicenseFile 55
SecurityPassphrases 55
MailServerInformation 55
JavaInstallation 56
OracleJavaJDKorJRE 56
OpenJDK8 56
ConflictingApplications 56
Chapter10:Prerequisites:Client-side 57
SystemConfigurations 57
AdditionalConsiderations 57
PermissionsRequiredtoDownloadALMClientComponents 57
InternetExplorerConfiguration 58
EnablingUserAccountControl(UAC) 59
Part4:Pre-InstallationProjectUpgradeSteps 61
Chapter11:ProjectUpgradeConsiderations 63
UpgradeVersions 63
SuggestedALMSystemConfiguration 63
Chapter12:ProjectUpgradePre-InstallationActivities 67
BackUpProjectsinExistingALMInstallation 67
VerifyingDomainsandProjects 68
VerificationProcessOverview 68
DefineanExceptionFile 68
VerifyaProject 70
VerifyaDomain 71
RepairingDomainsandProjects 73
RepairingaProject 73
RepairingaDomain 75
RestoringBackedUpProjectsandRepositories 76
RestoringProjectsfromaMicrosoftSQLDatabaseServer 76
RestoringProjectsfromanOracleDatabaseServer 77
RestoringaRepositoryfromtheFileSystem 77
RestoringLAB_PROJECT 78
VerifyProjectsAgain 78
ALM(12.60) Page4of198
InstallationandUpgradeGuide-Windows
CopySiteAdministrationDatabaseSchematotheNewDatabaseServer 78
Chapter13:UpgradingtheSiteAdministrationDatabaseSchema 81
SchemaUpgradeGuidelines 81
RecoveringaLostConfidential DataPassphrase 82
ManagingSchemaChanges 83
Part5:ALM InstallationandConfiguration 87
Chapter14:InstallingALMonMicrosoftWindowsSystems 89
InstallationConsiderations:Windows 89
InstallingALM:Windows 91
InstallingALMinSilentMode:Windows 101
ConfiguretheIISMailService 102
Chapter15:LAB_PROJECTInstallationConsiderations 105
Chapter16:StartingALM 107
BrowsingtheALMProgramFolder 107
StartingandStoppingALMServices 107
StartingALMonaClientMachine 107
RegisteringALMonaClientMachine 110
Chapter17:IntegratingtheALMApplicationServerwithaWebServer 113
ConfiguringIIS asareverseproxy 113
ConfiguringIIS asaSecureReverseProxy 115
ConfiguringtheIISWebServerforSSL Offloading 116
ConfiguringApacheasareverseproxy 116
ConfiguringApacheasaSecureReverseProxy 117
ConfiguringtheApacheWebServerforSSL Offloading 119
Chapter18:ManagingtheALMApplicationServer 121
ChangingtheHeapMemorySize 121
ChangingtheApplicationServerPortNumber 121
ConfiguringSecureAccessonWindowsSystems 122
ConfiguretrustontheALMserver 122
ConfigureasecureconnectiontotheALMapplicationserver(Jetty) 123
UseTLS1.2insteadTLS1.1,TLS1.0orSSLv3 125
Redirecthttptohttps 126
Setupencryptedcommunicationwithcookies 126
ConfiguringSecureDatabaseAccess 126
ApplicationServerManagementTools 131
Chapter19:CustomizingSystemFiles 133
CustomizingSiteAdministration 133
CustomizingtheSiteAdministrationRepository 133
CustomizingtheqcbinApplication 134
CustomizingMenus 134
ALM(12.60) Page5of198
InstallationandUpgradeGuide-Windows
CustomizingtheALMSystemTrayIcon 136
CustomizingtheALMLoginWindow 137
Chapter20:UninstallingALM 139
UninstallingALMfromWindowsSystems 139
RemovingALMClientComponentsfromaClientMachine 139
Part6:ProjectUpgrade 141
Chapter21:UpgradingProjects 143
DeactivateandRemoveProjectsfromExistingALM/QualityCenterInstallation 143
CopyProjectDatabaseSchemastotheNewDatabaseServerMachine 144
RestoreALMProjectsinNewSiteAdministrationDatabaseSchema 144
UpgradeProjects 146
AboutUpgradingDomainsandProjects 147
UpgradingaProject 148
UpgradingaDomain 149
Chapter22:MigratingtheProjectRepository 151
AbouttheRepositoryMigration 151
RepositoryMigrationStatusWindow 152
ConfigureMigrationPriority 154
Chapter23:PerformanceCenter/LAB_PROJECTPost-UpgradeSteps 155
Part7:Appendix 157
AppendixA:TroubleshootingtheALMInstallation 159
DisablingValidationChecksfortheInstallationWizard 159
CheckingtheInstallationandConfigurationLogFiles 163
ALMInstallationAlreadyExists 164
DatabaseValidatorFails 164
MonitoringALMServerFails 165
AppendixB:UpgradePreparationTroubleshooting 167
Overview 167
QuickWarningReference 168
GeneralIssues 168
SchemaIssues 169
DataIssues 170
GeneralValidation 171
SupportedDatabaseVersion 172
ValidDatabaseUserSchemaName 172
MixedTableOwnership 172
RepositoryoverDatabaseFeature 173
VersionControlValidation 173
DatabasePermissions 173
ALM(12.60) Page6of198
InstallationandUpgradeGuide-Windows
TextSearchConfiguration 173
SchemaValidation 175
Tables 176
Columns 177
IndexesandConstraints 180
Triggers 182
Sequences 183
InternalQualityCenterChanges 184
DataValidation 186
DuplicateValues 187
DuplicateIDs 187
TreeInconsistencies 188
Views 189
OrphanedEntities 189
MissingEntities 190
MissingListsand/orListValues 190
EncryptedValues 190
ChangingtheDatabaseUserSchema 191
MissingDatabaseObjects 192
MissingListWarning 192
SequencesWarning 192
ChangedDatabaseObjects 193
ExtraDatabaseObjects 193
SendUsFeedback 197
ALM(12.60) Page7of198
InstallationandUpgradeGuide-Windows
Welcome to this Guide
WelcometoApplicationLifecycleManagement(ALM).ALMempowersorganizationstomanage
thecoreapplicationlifecycle,fromrequirementsthroughdeployment,grantingapplicationteams
thecrucialvisibilityandcollaborationneededforpredictable,repeatable,andadaptabledelivery
ofmodernapplications.
Thishelpcontainsthefollowinginformation:
Step-by-stepinstructionsforinstallingandconfiguringALM12.60.
l
Step-by-stepinstructionsforupgradingprojectsfromearlierversionsofALM/QualityCenter
l
toworkinALM12.60.
GenericinstructionsforinstallingonALM12.60.
l
Note:ToconfigureALMtoworkwithexternalauthentication,refertotheMicro
Focus ApplicationLifecycleManagementExternalAuthenticationConfiguration
Guide.
ALM(12.60) Page8of198
Part 1: Installation Overview
ALM(12.60) Page9
InstallationandUpgradeGuide-Windows
Part1:InstallationOverview
ALM(12.60) Page10
Description:Chapter 13: Upgrading the Site Administration Database Schema. 83. Schema Upgrade Guidelines. 83. Installation and Upgrade Guide - Windows.