After I created a gold image for 18.7 on Linux and wrote this post about it, it was time to do the same for Windows. But here things weren’t so simple.
Unzipping the files
Just like on Linux, I downloaded 2 zip files:
- WINDOWS.X64_180000_db_home.zip – 18.3 files for Windows
- p30901451_180000_MSWIN-x86-64.zip – RU 18.10 for Windows
Then I unzipped both, the first to a temporary home (c:\oracle\gold) and the other one to a different directory for the patch (C:\oracle\30901451).
The goal was to patch the temp home with 18.10, then zip it so I can distribute it to other servers.
INS-32099 The username field is empty
After unzipping, I used the same command as in Linux to apply the RU into the home, but got an error:
C:\oracle\gold>setup.exe -silent -applyru C:\oracle\30901451
Launching Oracle Database Setup Wizard...
[FATAL] [INS-32099] The username field is empty.
CAUSE: The username should not be empty.
ACTION: Provide a non-empty username.
I tried to debug the installer and checked the logs. It looked like there is a problem with setting the Windows user (there is a part in the installation that asks for a user or a built-in account and I suspected the error is related to this). The thing is that I didn’t think the user is relevant as I’m not really installing the home, I’m just applying the RU.
In any case, I opened an SR. The support engineer helped me by providing MOS note 885643.1, which shows how to provide command line parameters to the installer.
INS-32825 Applying PSU is not supported in this platform
In the mentioned note I found the “oracle.install.IsBuiltInAccount” parameter, so I decided to use it, hoping that this will workaround the issue, but this is what I got:
C:\oracle\gold>setup.exe -silent -applyRU C:\oracle\30901451
[INS-32825] Applying PSU is not supported in this platform.
Apparently, applyRU is not supported on Windows, even though it shows in the setup.exe help:
C:\oracle\gold>setup /h
[INS-04007] Invalid argument passed from command line: /h
Usage: runInstaller [<flag>] [<option>]
Following are the possible flags:
-help - display help.
-silent - run in silent mode. The inputs can be a response file or a list of command line variable value pairs.
[-ignorePrereqFailure - ignore all prerequisite checks failures.]
-responseFile - specify the complete path of the response file to use.
-logLevel - enable the log of messages up to the priority level provided in this argument. Valid options are: severe, warning, info, config, fine, finer, finest.
-executePrereqs | -executeConfigTools | -createGoldImage
-executePrereqs - execute the prerequisite checks only.
-executeConfigTools - execute the config tools for an installed home.
[-all - execute all the config tools for an installed home, including the config tools that have already succeeded.]
-createGoldImage - create a gold image from the current Oracle home.
-destinationLocation - specify the complete path to where the created gold image will be located.
[-exclFiles - specify the complete paths to the files to be excluded from the new gold image.]
-debug - run in debug mode.
-printdiskusage - log the debug information for the disk usage.
-printmemory - log the debug information for the memory usage.
-printtime - log the debug information for the time usage.
-waitForCompletion - wait for the completion of the installation, instead of spawning the installer and returning the console prompt.
-noconfig - do not execute the config tools.
-noconsole - suppress the display of messages in the console. The console is not allocated.
-ignoreInternalDriverError - ignore any internal driver errors.
-noCopy - perform the configuration without copying the software on to the remote nodes.
-applyRU - apply release update to the Oracle home.
-applyOneOffs - apply one-off patch to the Oracle home. Multiple one-off patches can be passed as a comma separated list of locations.