9.40 Maintenance Pack installation can become unresponsive

9.40 Maintenance Pack installation can get stuck on the "Post-Patch changes being applied" step.

Problem

The 9.40 Maintenance Pack installation can become un-responsive during the Oracle Patching portion of the process.

Symptom

The Maintenance Pack will not progress beyond the 'Post-Patch changes' progress bar after more than 45 minutes.

Cause

The logged-in Windows user account applying the Maintenance Pack is a different Windows user than the one originally used to install Retail Pro 9.4 and is consequently not in the necessary Windows user groups.

Solution

Before running the Maintenance Pack installation, make sure the user is in the following Windows user groups:

• ORA_ASMDBA
• ORA_DBA
• ORA_ODS12cr1_SYSBACKUP
• ORA_ODS12cr1_SYSDG
• ORA_ODS12cr1_SYSKM

Step 1:Go to Windows RUN command and launch compmgmt.msc

Step 2:?Double-click on the group you wish to affect

Step 3: Then use the Add... button to add the account to the group

Step 4:Repeat the steps for each group in the list provided above.

Once your user is in all of the necessary groups, you can apply the Maintenance Pack under that particular user without it hanging during the 'Post-Patch changes' progress bar.

Note:If you find that you are in a situation where the Maintenance Pack is already in this hung state, and therefore must stop installing the Maintenance Pack, do the following.

1. Confirm this issue by locating a process called Perl.exe running on the system in the task manager (under "processes").

2. Kill setup.exe and all of it's child processes. (*End Process Tree)

3. Now add the user you are logged-in as to the Oracle groups as described above.