Resolving Issues with Oracle 11g Patch 13 for Windows
If your APTARE StorageConsole Oracle 11g database is on a Windows server, you must apply Oracle Patch 13 (13247523) AFTER you install BOTH the Oracle 11g binaries and the APTARE StorageConsole Portal software. This is a mandatory patch. This Oracle 11g patch fixes a connection time-out issue that resulted in “Report Fails to Load” errors. See the Patch Download page on the Customer Portal for instructions.
While applying the mandatory Oracle 11g patch for Windows, the process may fail because some files are in use. A message similar to the following will indicate which files are in use.
Sample Error Message During Oracle 11g Windows Patch Process
[exec] Oracle Home : c:\opt\oracle
[exec] Central Inventory : C:\opt\oracle\oraInventory
[exec] OPatch version : 11.2.0.1.6
[exec] OUI version : 11.2.0.2.0
[exec] Log file location : c:\opt\oracle\cfgtoollogs\opatch\opatch2012-03-20_13-51-50PM.log
[exec]
[exec] Applying interim patch '13247523' to OH 'c:\opt\oracle'
[exec] Verifying environment and performing prerequisite checks...
[exec] Prerequisite check "CheckActiveFilesAndExecutables" failed.
[exec] The details are:
[exec]
[exec] Following files are active :
[exec] c:\opt\oracle\bin\oci.dll
[exec] Log file location: c:\opt\oracle\cfgtoollogs\opatch\opatch2012-03-20_13-51-50PM.log
[exec]
[exec] Recommended actions: OPatch needs to modify files which are being used by some processes.
Procedure to Resolve the Patch Issue
If the patch fails with a message similar to the above sample error message, follow these steps.
NOTE: These steps refer to the Sample Error Message above, but you will need to substitute the file names and services specific to your error message.
1. Open a command prompt window.
2. Run the following tasklist command to list the processes that are using the file mentioned in the error message. In our example, the file is: c:\opt\oracle\bin\oci.dll. Use the file name that is referenced in your error message.
Example Command: tasklist /m oci.dll
Note that using the full path (for example, c:\opt\oracle\bin\oci.dll) in the tasklist command will not work.
Command Output:
Image Name PID Modules
========================= ======== ========
oracle.exe 2744 oci.dll
TNSLSNR.EXE 2784 oci.dll
oravssw.exe 3064 oci.dll
3. Use the following command to identify the process associated with the Image Names from the tasklist command output.
tasklist /svc
Command Output:
Image Name PID Services
========================= ======== =======================
oracle.exe 2744 OracleServicescdb
oravssw.exe 3064 OracleVssWriterscdb
TNSLSNR.EXE 2784 OraclescdbTNSListener
4. Check if the services related to the Image Names can be stopped until the patch is applied.
5. If the services can be stopped, use the Windows Services Panel to stop the services associated with the Image Names.
6. cd c:\opt\oracle\Patches\112020_P3\13247523
7. Apply the patch using the following command:
C:\opt\oracle\Patches\12714463> C:\opt\oracle\OPatch\opatch apply -silent -ocmrf c:\opt\oracle\ocm.rsp
This step will take about 5-6 minutes to complete.
8. Load the modified .sql files into the existing database use the following commands:
> cd %ORACLE_HOME%\Bundle\Patch13
> sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catcpu.sql
SQL> exit
9. To ensure that all dependent objects are valid after running catcpu.sql, execute the following:
> cd %ORACLE_HOME%\rdbms\admin
> sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql
10. If the above script indicates any invalid objects, execute validate_sp.sql:
>cd c:\opt\oracle\database\tools
>sqlplus portal/portal
SQL> @validate_sp
11. As a final step, go to the Windows Services Panel and re-start all the processes that you stopped in step 5.