I believe I have an answer. In my attempts to sequence Oracle 11G on AppV5 I came across a few issues and have come up with solutions that work for various applications that rely on this tool.
The first issue:
Oracle 11G only allows paths without spaces and special characters.
 |
| On Windows systems, if the path to your Java installation includes a space character, you must provide the path in DOS 8.3 format, as shown in the previous example. |
This *maybe* fixed now, but I experienced issues with trying to install Oracle 11g to the 8.3 folder structure to place it under "Program Files" or "Program Files (x86)". The sequenced application would be broken. This was a known/reported issue with AppV 5SP2 HF4 that was marked as 'fixed' by Microsoft for SP3+. I have not had the ability to confirm that and will continue this post with what I know works... I also believe that when expanded out it uses the full path with spaces as opposed to the 8.3 path.
Second Issue:
Installing Oracle 11G to the default 'recommended' directory will fail if you move your PackageInstallationRoot to a different drive.
This is because the second folder (apps - in this example) is not tokenized. Forcing AppV5 to utilize the token "appvPackgeDrive" which can expand out differently then you expect, breaking the application.
Third Issue:
Cannot install to PVAD.
The reason I chose to NOT utilize PVAD is if you do then Oracle cannot be used in connection groups.
So how do you resolve all these issues and sequence Oracle 11G R2?
The direction I went was to ensure the directory I sequenced the installer to was a tokenized directory. It also needed to a directory that, when expanded in the virtualized environment, does not contain any spaces or special characters.
The list of directories AppV5 tokenize's can be found in the AppV 5.0 Sequencing Guide.
I'll list them here:
Known Folder Token
|
Known Folder Path
|
AccountPictures
|
C:\Users\
|
Administrative Tools
|
C:\Users\
|
AppData
|
C:\Users\
|
Application Shortcuts
|
C:\Users\
|
Cache
|
C:\Users\
|
CD Burning
|
C:\Users\
|
Common Administrative Tools
|
C:\ProgramData\Microsoft\Windows\Start
Menu\Programs\Administrative Tools
|
Common AppData
|
C:\ProgramData
|
Common Desktop
|
C:\Users\Public\Desktop
|
Common Documents
|
C:\Users\Public\Documents
|
Common Programs
|
C:\ProgramData\Microsoft\Windows\Start
Menu\Programs
|
Common Start Menu
|
C:\ProgramData\Microsoft\Windows\Start
Menu
|
Common Startup
|
C:\ProgramData\Microsoft\Windows\Start
Menu\Programs\Startup
|
Common Templates
|
C:\ProgramData\Microsoft\Windows\Templates
|
CommonDownloads
|
C:\Users\Public\Downloads
|
CommonMusic
|
C:\Users\Public\Music
|
CommonPictures
|
C:\Users\Public\Pictures
|
CommonRingtones
|
C:\ProgramData\Microsoft\Windows\Ringtones
|
CommonVideo
|
C:\Users\Public\Videos
|
Contacts
|
C:\Users\
|
Cookies
|
C:\Users\
|
CredentialManager
|
C:\Users\
|
CryptoKeys
|
C:\Users\
|
Desktop
|
C:\Users\
|
Device Metadata Store
|
C:\ProgramData\Microsoft\Windows\DeviceMetadataStore
|
DocumentsLibrary
|
C:\Users\
|
Downloads
|
C:\Users\
|
DpapiKeys
|
C:\Users\
|
Favorites
|
C:\Users\
|
Fonts
|
C:\windows\Fonts
|
GameTasks
|
C:\Users\
|
History
|
C:\Users\
|
ImplicitAppShortcuts
|
C:\Users\
|
Libraries
|
C:\Users\
|
Links
|
C:\Users\
|
Local AppData
|
C:\Users\
|
LocalAppDataLow
|
C:\Users\
|
MusicLibrary
|
C:\Users\
|
My Music
|
C:\Users\
|
My Pictures
|
C:\Users\
|
My Video
|
C:\Users\
|
NetHood
|
C:\Users\
|
Personal
|
C:\Users\
|
PicturesLibrary
|
C:\Users\
|
Podcast Library
|
C:\Users\
|
Podcasts
|
C:\Users\
|
PrintHood
|
C:\Users\
|
Profile
|
C:\Users\
|
ProgramFiles
|
C:\Program Files
|
ProgramFilesCommon
|
C:\Program Files\Common Files
|
ProgramFilesCommonX64
|
C:\Program Files\Common Files
|
ProgramFilesCommonX86
|
C:\Program Files (x86)\Common
Files
|
ProgramFilesX64
|
C:\Program Files
|
ProgramFilesX86
|
C:\Program Files (x86)
|
Programs
|
C:\Users\
|
Public
|
C:\Users\Public
|
PublicAccountPictures
|
C:\Users\Public\AccountPictures
|
PublicGameTasks
|
C:\ProgramData\Microsoft\Windows\GameExplorer
|
PublicLibraries
|
C:\Users\Public\Libraries
|
Quick Launch
|
C:\Users\
|
Recent
|
C:\Users\
|
RecordedTVLibrary
|
C:\Users\Public\Libraries\RecordedTV.library-ms
|
ResourceDir
|
C:\windows\resources
|
Ringtones
|
C:\Users\
|
Roamed Tile Images
|
C:\Users\
|
Roaming Tiles
|
C:\Users\
|
SavedGames
|
C:\Users\
|
Searches
|
C:\Users\
|
SendTo
|
C:\Users\
|
Start Menu
|
C:\Users\
|
Startup
|
C:\Users\
|
System
|
C:\windows\system32
|
SystemCertificates
|
C:\Users\
|
SystemX86
|
C:\windows\SysWOW64
|
Templates
|
C:\Users\
|
User Pinned
|
C:\Users\
|
UserProfiles
|
C:\Users
|
VideosLibrary
|
C:\Users\
|
Windows
|
C:\windows
|
Custom Token
|
Custom Token Expansion
|
AppVAllUsersDir
|
C:\Users\All Users
|
AppVComputerName
|
|
AppVCurrentUserSID
|
S-1-5-21-124525095-708259637-1543119021-705252
|
AppVEnvironmentVariableCommonProgramFiles
|
%commonprogramfiles%
|
AppVEnvironmentVariableProgramFiles
|
%ProgramFiles%
|
AppVPackageDrive
|
C:
|
AppVPackageRoot
|
C:\AppInstallFolder
|
AppVSystem32Catroot
|
C:\windows\system32\catroot
|
AppVSystem32Catroot2
|
C:\windows\system32\catroot2
|
AppVSystem32DriversEtc
|
C:\windows\system32\drivers\etc
|
AppVSystem32Driverstore
|
C:\windows\system32\driverstore
|
AppVSystem32Logfiles
|
C:\windows\system32\logfiles
|
AppVSystem32Spool
|
C:\windows\system32\spool
|
There are multiple directories we can choose. I opted to use "Common AppData". That means I will install the Oracle client here: "C:\ProgramData". It does not contain a space, is tokenized, and when expanded will remain on the C:\ drive. I created a 'response' file for the Oracle install.
I called the script through this command:
And that's it!
And that's it!
