HP Storage Essentials SRM July 2008 Patch for Oracle 10.2.0.3 Guide for Microsoft Windows Servers (September 2008)

•SNMPservice
• MSDTC (Microsoft Distributed Transaction Coordinator)
•MicrosoftIIS(admin)
• Microsoft COM+ Event System
•MTSrecovery
•BackupExecagent
•ArcServeagent
• IBM Directory Support Program
6. Run the installOracle10gPatch25.cmd script to install the patch. Alternatively, you
can launch the Windows Explorer and browse to the patch25 folder and then double-click
installOracle10gPatch25.cmd.
Thescriptstopsthefollowingservices:
• AppStorManager (the ser vice for HP Storage Essentials SRM)
• Distributed Transaction Coordinator (MSDTC)
• HP Systems Insight M anager (if you are using the integrated version of HP Storage Essentials SRM)
• Oracle services including:
• OracleOraHome10TNSListener
•OracleJobSchedulerAPPIQ
•OracleServiceAPPIQ
The script starts any services that it stopped after it installs the patch.
The following log files are created:
• %SystemDrive%\srmInstallLogs\opatch7252496.log — Console output from opatch
when installing Patch 25 (7252496).
• %ProgramFile%\oracle\inventory\logs\opatch<time stamp>.log —Outputfrom
running opatch. You will need to find the one corresponding to your current execution.
• %ORACLE_HOME%\bundle\patch25\APPLY_APPIQ_<time stamp>.log —Outputfrom
running the Oracle catcpu.sql script in the post patch processing.
• %ORACLE_HOME%\bundle\view_recompile\vcomp_APPIQ_<time stamp>.log —
Output from running the Oracle view_recompile_jan2008cpu.sql scriptinthepostpatch
processing.
7. Please review the log files for proper operation. The following errors from O racle can be ignored:
• ORA-29809: cannot drop an operator with dependent objects
•ORA-29931:specified association does not e xist
•ORA-29830:operatordoesnotexist
•ORA-00942:tableorviewdoesnotexist
• ORA-0 0955: name is already used by an existing o bject
• ORA-01430: column being added alrea dy exists in table
• ORA-01432: public synonym to be dropped does not exist
• ORA-01434:privatesynonymtobedroppeddoesnotexist
•ORA-01435:userdoesnotexist
• ORA-01917:userorrole’XDB’doesnotexist
• ORA -01920: user name ’<user-name>’ conflicts with another user or role name
• ORA-01921: role name ’<role na me>’ conflictswithanotheruserorrolename
• O R A - 01951: R O L E ’ C O N N EC T ’ n o t g ra n t e d to ’ W KSYS ’
• ORA-01952: sy s tem pr ivileges not granted to ’WKSYS’
• ORA-02303:cannotdroporreplaceatypewithtypeortabledependents
• ORA-02443: Cannotdropconstraint-nonexistentconstraint
10
Applying the Oracle July 2008 Critical Patch Update