HP Storage Essentials SRM July 2008 Patch for Oracle 9.2.0.
Legal and notice information © Copyright 2007-2008 Hewlett-Packard Development Company, L.P. Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor’s standard commercial license. The information contained herein is subject to change without notice.
Contents About this guide . . . . . . . . . . . . . . . . . . . . . . . . . . Intended audience . . . . . . . Prerequisites . . . . . . . . . Document conventions and symbols HP technical support . . . . . . Subscription service . . . . . . HP Web sites . . . . . . . . . Documentation feedback . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Figures 4 1 ..Determining if a previous CPU was installed . . . . . . . . . . . . . . . . . . . . 12 2 ..Determining if the Oracle July 2008 CPU was installed 26 . . . . . . . . . . . . . . .
Tables 1 ..Document conventions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . HP Storage Essentials SRM July 2008 Patch for Oracle 9.2.0.
About this guide This guide provides information about installing the Oracle July 2008 Critical Patch Update. Intended audience This guide is intended for network administrators with knowledge of: • Storage area networks • Basic operating system commands and utilities Prerequisites Prerequisites for installing these patches include: • HP Storage Essentials Storage Resource Management (SRM) software version 5.1.1 • Oracle 9.2.0.
Document conventions and symbols Table 1 Document conventions Convention Element Blue text: Table 1 Cross-reference links and e-mail addresses Blue, underlined text: http://www.hp.
HP Web sites For additional information, see the following HP Web sites: • • • • http://www.hp.com http://www.hp.com/go/storage http://www.hp.com/service_locator http://www.hp.com/support/manuals Documentation feedback HP welcomes your feedback. To make comments and suggestions about product documentation, please send a message to storagedocs.feedback@hp.com. All submissions become the property of HP. HP Storage Essentials SRM July 2008 Patch for Oracle 9.2.0.
About this guide
1 Introduction These directions include steps to apply the Oracle July 2008 Critical Patch Update (CPU). For the patches to work properly, you must first upgrade Oracle to 9.2.0.8, and then you must install the Oracle July 2008 CPU as described in chapter 2. You can find the kit for upgrading from Oracle 9.2.0.6 to Oracle 9.2.0.8 at the following Web site: http://www.hp.
Figure 1 Determining if a previous CPU was installed 12 Introduction
2 (Servers without previous Oracle CPUs) Applying the Oracle July 2008 Critical Patch Update Each quarter Oracle issues a Critical Patch. These instructions are for the Oracle July 2008 CPU issued for Linux x86 32–bit architecture. This patch assumes you have successfully upgraded Oracle to 9.2.0.8. If you have not, you will not be able to apply the patch. IMPORTANT: • HP Storage Essentials SRM is unavailable when installing the Oracle July 2008 CPU. Plan a non-peak time to implement these steps.
su — oracle b. Start SQL*Plus by entering the following command: sqlplus /nolog c. Connect as SYSDBA by entering the following command: connect as SYSDBA d. Enter the following at the user-name prompt to login as user SYS: SYS@APPIQ SYS is the user account that owns the database and the data dictionary. e. Enter the password for user SYS. The default password for user SYS is the following: change_on_install f. Enter the following command to stop the Oracle services: shutdown immediate; g.
• 01 is the build number for the patch. The build number may be different for the patch you have. • is the destination directory. Make sure the directory path does not contain spaces. 4. Navigate to the provided in the previous step. 5. Enter the following to implement the patch: ./runCPUJul2008_Linux_9208.sh 6. The script silently installs the latest version of OPatch.
h. Enter the following to start Oracle services: startup; i. Enter the following to exit SQL*Plus: exit 2. If you are not already in the directory, navigate to it now. Make sure that the Oracle user account can create new files in this location. The is the directory where you expanded the contents of the patch. 3. Oracle recommends running the runDictionaryFix.
3 (Servers with previous Oracle CPUs) Applying the Oracle July 2008 Critical Patch Update These instructions are for applying the Oracle July 2008 CPU that is issued for Linux x86 32–bit architecture. The instructions assume you upgraded Oracle to 9.2.0.8. If you have not upgraded to Oracle 9.2.0.8, you will not be able to apply the July 2008 CPU. Pre-installation steps The pre-installation steps are the same as installing July 2008 critical patch over Oracle 9.2.0.8.
connect as SYSDBA d. Enter the following at the user-name prompt to login as user SYS: SYS@APPIQ SYS is the user account that owns the database and the data dictionary. e. Enter the password for user SYS. The default password for user SYS is the following: change_on_install IMPORTANT: If you mistakenly type one or more special characters, including slashes, when entering the password for SYS, you may see messages that are not pertinent for entering an incorrect password.
NOTE: The script for installing the Oracle July 2008 CPU will not run if its directory path contains spaces, for example /my patch/runCPUJul2008_Linux_9208. 1. Make sure you are logged in as root by entering the following command: id If you are not logged in as root, enter the following command to login as root: su — root 2. Download the CPU_July2008_Linux_9208_01.zip file to the HP Storage Essentials management server. where 01 is the build number for the patch.
Invoking fuser to check for active processes. Skipping invocation of fuser on "/opt/oracle/product/9.2.0.4/Apache/Apache/ bin/htpasswd" as the file does not exist or is a directory. Invoking fuser on "/opt/oracle/product/9.2.0.4/bin/dbsnmp" Skipping invocation of fuser on "/opt/oracle/product/9.2.0.4/Apache/Apache/ bin/rotatelogs" as the file does not exist or is a directory. Skipping invocation of fuser on "/opt/oracle/product/9.2.0.4/Apache/Apache/ bin/httpd" as the file does not exist or is a directory.
Rolling back patch 5901875... Creating log file "/opt/oracle/product/9.2.0.4/ .patch_storage/5901875/ RollBack_5901875_05-16-2008_03-41-06.log" Rolling back with all-node mode. OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only. Oracle instances have been shut down, proceeding with auto-rollback. Executing the Roll-back pre-patch script (/opt/oracle/product/9.2.0.4/ .patch_storage/5901875/custom/scripts/pre)... Removing patch 5901875... Restoring archive files...
a. Login as Oracle by entering the following command: su — oracle b. Start the Oracle listener by entering the following command: lsnrctl start It may take several minutes for the Oracle listener to start. c. Ensure that the Oracle listener is running by entering the following command: lsnrctl status d. After the Oracle listener starts, start SQL*Plus by entering the following command prompt: sqlplus /nolog e. Connect as SYSDBA by entering the following command: connect as SYSDBA f.
IMPORTANT: If you mistakenly type one or more special characters, including slashes, when entering the password for SYS, you may see messages that are not pertinent for entering an incorrect password.
(Servers with previous Oracle CPUs) Applying the Oracle July 2008 Critical Patch Update
4 Verifying that the Oracle July 2008 Critical Patch Update was successfully installed To verify that the Oracle July 2008 CPU was successfully installed: 1. Login as the Oracle user by entering the following command: su — oracle 2. Export the display by entering the following command: export DISPLAY=ipaddress:0.0 where ipaddress is the IP address of the display. 3. Enter the following: echo $DISPLAY 4.
Figure 2 Determining if the Oracle July 2008 CPU was installed 26 Verifying that the Oracle July 2008 Critical Patch Update was successfully installed
