Patch Name: PHSS_30333 Patch Description: s700_800 11.X OV DP5.00 patch - ORACLE8 packet Creation Date: 04/04/28 Post Date: 04/05/04 Hardware Platforms - OS Releases: s700: 11.00 11.11 s800: 11.00 11.11 Products: DATA-PROTECTOR A.05.00 Filesets: DATA-PROTECTOR.OMNI-OR8-P,fr=A.05.00,fa=HP-UX_B.11.00_32/64,v=HP Automatic Reboot?: No Status: General Release Critical: No Category Tags: defect_repair enhancement general_release manual_dependencies Path Name: /hp-ux_patches/s700_800/11.X/PHSS_30333 Symptoms: PHSS_30333: Change Request: 8606331369 Proxy copy backup of an Oracle database with a large number of files can fail due to the maximum number of connections reached. Restore of the proxy copy backup is slow. Change Request: H555010589 Recovery Manager (RMAN) allocation of channels fails instantly if an environment variable is longer then 2,000 characters. The following is reported: "RMAN-03009: failure of allocate command on test channel at mm/dd/yyyy hh:mm:ss ORA-03113: end-of-file on communication channel." Note that the environment can be inherited from running "sqlplus" and is not necessary the same as the Oracle user environment. Change Request: H555010591 During a configuration, available databases are not displayed and cannot be selected from the GUI. util_oracle8.exe -APP is not browsing the information from "oratab". Change Request: H555010742 If Oracle catalog database has different version and catalog database export binary is configured catalog export in some environments fails. Change Request: H555010792 Oracle8i/9i databases cannot be recovered beyond the last backup time (i.e. until now) after instant recovery. Online logs and control files have to be removed from the list of data files and control files of the Production Database in order to avoid resolving of the mirror disks with these files. Change Request: H555011134 Oracle backup is randomly failing. Change Request: H555011250 "Disk_only" option is ignored by "ob2rman". Change Request: H555012059 When import of the recovery catalog database completes successfully without warnings, the received message is that "Import of the Recovery Catalog Database failed". PHSS_29150: Change Request: H555010134 Setting the ORA_EXP variable is ineffective. Change Request: H555010279 The proxy copy backup and restore in some cases aborts with message: "No more work". Change Request: H555010410 The Oracle8 integration (ob2rman.exe) is backing up the wrong Oracle database. Change Request: H555010463 Oracle split mirror proxy copy restore of the datafile on a raw disk aborts with following error: "ORA-27197: skgfprs: sptpcrestore returned error". Change Request: 8606299299 "util_oracle8.exe" script ends abnormally. Change Request: 8606313981 When searching through the files in the Data Protector temporary directory during the backup, the root user can find the username and password for connection to the Oracle database. PHSS_28337: Change Request: H555008622 Data Protector Oracle8 integration is not supported on IBM AIX 5L operating system. Change Request: H555008671 ob2rman.exe fails to export environment variables on Linux systems. Change Request: H555009216 Backup of Oracle8 database fails with: "RMAN-00558: error encountered while parsing input command." Change Request: H555009291 Backup of Oracle8 database fails on Sun Solaris system if OMNI_HOSTS variable is set. Change Request: H555009415 Oracle 8 restore on Solaris OS fails with message: "RMAN-10038: database session for channel dev_0 terminated unexpectedly". Change Request: H555009600 Oracle 8 BAR agent fails with RMAN error: "OB2_StartObjectBackup()failed ERR(-2)" and Session Manager error: "Got unexpected close from OB2BAR Backup DA". Defect Description: PHSS_30333: Change Request: 8606331369 Backup agent starts agents for all files at once. Restore of files is performed serially. Resolution: Oracle integration concept is changed extensively. Proxy copy backup and restore performance is enhanced. For more detailed information about changes in the backup concept and backup flow, refer to the Oracle8i/9i chapters of the following disk array guides: -HP OpenView Storage Data Protector HP SureStore Disk Array XP Integration Guide -HP OpenView Storage Data Protector HP SureStore Virtual Array Integration Guide -HP OpenView Storage Data Protector EMC Symmetrix/Fastrax Integration Guide. For more detailed information on changes in the backup specifications, refer to the Oracle chapters of the HP OpenView Storage Data Protector UNIX Integration Guide. Updated versions of these guides are available with the Cell Console (CC) patch DPWIN_00050 and Documentation (DOC) patches PHSS_30331 and DPSOL_00069 or subsequent CC and DOC patches. Part of SSPUX500_047. Change Request: H555010589 Message for trace file and debugs is composed without length checking. Resolution: Message is checked for length and limited to 2,000 characters. Change Request: H555010591 During a configuration, available databases are not displayed and cannot be selected from the GUI. util_oracle8.exe -APP is not browsing the information from the "oratab" file. Resolution: All available databases listed in the "oratab" file are visible. Change Request: H555010742 Environment for export binary is the same as for target database. Resolution: New configuration parameter RCVCAT_ORACLE_HOME is added to the .omnirc file. It specifies catalog database home directory. If set, environment is set for catalog database export utility. Change Request: H555010792 During an Oracle8i/9i ZDB backup, only replicas of the database data files should be created. Resolution: Oracle8i/9i databases can be recovered after instant recovery. New environment variable ZDB_ORA_INCLUDE_CF_OLF=(0|1) is introduced in the "omnirc" file. When this variable is not present in the environment or it is set to 0, only database data files are resolved/split. In this case, the control files and redo logs can reside on local disks. If set to 1, control files and online redo logs are also resolved/split. Value 1 is to be used only if the user needs to start the database instance on the backup host for other purposes then backup. In both cases, the control files and online redo logs should not reside on the same disks/logical volumes as database data files. If ZDB_ORA_INCLUDE_CF_OLF=1 option is to be used, then control files and online redo logs must also reside on original units (mirrored disks). Prerequisites: If instant recovery is to be performed, the control files and the online redo logs must not reside on the same original units as the data files. IMPORTANT: If the above rule is not followed, data loss may occur (e.g. older version of the redo logs and the control files will overwrite the current versions of these files). For more information, please refer to the: HP OpenView Storage Data Protector HP SureStore Virtual Array Integration Guide, chapter 6 (Integrating Data Protector, HP SureStore Virtual Array and Oracle8/8i/9i) and Appendix. HP OpenView Storage Data Protector HP SureStore Disk Array XP Integration Guide, chapter 5 (Integrating Data Protector, HP SureStore Disk Array XP, and Oracle8/8i/9i) and Appendix. Updated versions of these guides are available with the Cell Console (CC) patch DPWIN_00050, the Documentation (DOC) patch PHSS_30331, and the Documentation (DOC) patch DPSOL_00069 or subsequent CC and DOC patches. Change Request: H555011134 Bar agent tries to connect to crs in loop. The number of retries is 10. When it fails for the first time, the error is not cleared although connection is successful for the second time. Even though connection is ok, error checking picks up first error. Resolution: Error is cleared before each retry. Change Request: H555011250 Command line options for the BAR agent contain empty option before "disk_only". "ob2rman" is reading options only until an empty one is found. Resolution: Empty command line option is removed. "ob2rman" option parsing changed to read all command line options. Change Request: H555012059 Incorrect message when the import completes successfully without warnings. The received message is that "Import of the Recovery Catalog Database failed". Resolution: The message is corrected. When import of the recovery catalog database completes successfully without warnings, the received message is that "Import of the Recovery Catalog Database succeeded". PHSS_29150: Change Request: H555010134 Wrong call is retrieved and decode is used on the plain string. Resolution: Retrieval is changed and decoding is removed. Change Request: H555010279 Finished objects status checking is incorrect. Resolution: Status handling is changed and counter is corrected. Part of SSPUX500_025. Change Request: H555010410 Problem appears when ORACLE_SID is set as default for the whole system so even "inetd" has the variable set. Resolution: ORACLE_SID is set to OB2APPNAME variable instead of ORACLE_SID. Change Request: H555010463 The wrong object name is saved to the database during the backup and the restore procedure is unable to locate it. Resolution: Raw disk backup saves the correct name to the database. Raw disk restore is added to the Oracle proxy restore. Change Request: 8606299299 "util_oracle8.exe" ends abnormally if the NLS_LANG variable is not set before executing it. Resolution: "util_oracle8.exe" script is looking into the configuration files if NLS_LANG is set. If set, it will export it to the environment before executing the requested command. Change Request: 8606313981 The temporary script for connection to Oracle is created in the Data Protector temporary directory during the backup, containing the username and password in plain text. Resolution: Scripts for launching "rman" are no longer created. PHSS_28337: Change Request: H555008622 Data Protector Oracle8 integration is not supported on IBM AIX 5L operating system. Resolution: Data Protector Oracle8 integration is supported on IBM AIX 5L operating system. Change Request: H555008671 Redirected "while" command executes in subshell on Linux systems causing environment variables not to be properly exported. Resolution: Environment variables are properly exported on Linux systems. Change Request: H555009216 Recovery Manager fails in cases when it receives input from barlists with very long lines. Resolution: Barlists are being sent to Recovery Manager as files and not as a single line. Change Request: H555009291 IP address in not properly converted on 64-bit Sun Solaris system where OMNI_HOSTS variable is set. Resolution: IP addresses are properly resolved regardless of OMNI_HOSTS variable settings. Change Request: H555009415 Memory for string is not aligned properly. Resolution: Memory allocated with correct alignment. Part of SSPSOL500_002. Change Request: H555009600 Handle number for Session Manager is lost. Resolution: Handle number assignment is changed. Enhancement: No (superseded patches contained enhancements) PHSS_28337: General release patch PHSS_28337/DPSOL_00014 introduces Data Protector 5.00 Oracle8 integration on IBM AIX 5L operating system. Before installing Data Protector's Oracle8 agent on IBM AIX 5L client make sure that Core patch patch PHSS_28735/DPSOL_00017 (or later) is installed on Installation server system. SR: H555011250 8606331369 H555010589 H555010792 H555012059 H555010742 H555011134 H555010591 H555010463 H555010279 H555010134 H555010410 8606299299 8606313981 H555008622 H555009291 H555009035 H555008671 H555009216 H555009600 H555009059 H555009415 Patch Files: DATA-PROTECTOR.OMNI-OR8-P,fr=A.05.00,fa=HP-UX_B.11.00_32/64, v=HP: /opt/omni/databases/vendor/oracle8/hp/s800/hp-ux-11/A.05.00/ packet.Z /opt/omni/databases/vendor/oracle8/hp/s800/hp-ux-1020/ A.05.00/packet.Z /opt/omni/databases/vendor/oracle8/sun/sparc/solaris-26/ A.05.00/packet.Z /opt/omni/databases/vendor/oracle8/ibm/rs6000/aix-51/ A.05.00/packet.Z /opt/omni/databases/vendor/oracle8/ibm/rs6000/aix-51/ A.05.00/require.dat /opt/omni/databases/vendor/oracle8/ibm/rs6000/aix-42/ A.05.00/packet.Z /opt/omni/databases/vendor/oracle8/dec/alpha/osf1-4/A.05.00/ packet.Z /opt/omni/databases/vendor/oracle8/gpl/i386/linux-60/ A.05.00/packet.Z what(1) Output: DATA-PROTECTOR.OMNI-OR8-P,fr=A.05.00,fa=HP-UX_B.11.00_32/64, v=HP: /opt/omni/databases/vendor/oracle8/hp/s800/hp-ux-11/A.05.00/ packet.Z: None /opt/omni/databases/vendor/oracle8/hp/s800/hp-ux-1020/ A.05.00/packet.Z: None /opt/omni/databases/vendor/oracle8/sun/sparc/solaris-26/ A.05.00/packet.Z: None /opt/omni/databases/vendor/oracle8/ibm/rs6000/aix-51/ A.05.00/packet.Z: None /opt/omni/databases/vendor/oracle8/ibm/rs6000/aix-51/ A.05.00/require.dat: None /opt/omni/databases/vendor/oracle8/ibm/rs6000/aix-42/ A.05.00/packet.Z: None /opt/omni/databases/vendor/oracle8/dec/alpha/osf1-4/A.05.00/ packet.Z: None /opt/omni/databases/vendor/oracle8/gpl/i386/linux-60/ A.05.00/packet.Z: None cksum(1) Output: DATA-PROTECTOR.OMNI-OR8-P,fr=A.05.00,fa=HP-UX_B.11.00_32/64, v=HP: 1171716799 677480 /opt/omni/databases/vendor/oracle8/gpl/ i386/linux-60/A.05.00/packet.Z 4242900086 1863613 /opt/omni/databases/vendor/oracle8/dec/ alpha/osf1-4/A.05.00/packet.Z 158041927 1185109 /opt/omni/databases/vendor/oracle8/ibm/ rs6000/aix-42/A.05.00/packet.Z 1681833116 1184574 /opt/omni/databases/vendor/oracle8/ibm/ rs6000/aix-51/A.05.00/packet.Z 3223604252 19 /opt/omni/databases/vendor/oracle8/ibm/rs6000/ aix-51/A.05.00/require.dat 2745777322 1911959 /opt/omni/databases/vendor/oracle8/sun/ sparc/solaris-26/A.05.00/packet.Z 2134127929 1380285 /opt/omni/databases/vendor/oracle8/hp/ s800/hp-ux-1020/A.05.00/packet.Z 475571877 2379347 /opt/omni/databases/vendor/oracle8/hp/ s800/hp-ux-11/A.05.00/packet.Z Patch Conflicts: None Patch Dependencies: None Hardware Dependencies: None Other Dependencies: Due to extensive concept changes in the Oracle integration, you must install Oracle, Core, Cell Server, and Cell Console patches for the Oracle integration to function properly. According to the OS platforms, the respective equivalent patches or their successors must be applied: Oracle patches: PHSS_30333 for HP-UX DPSOL_00071 for Solaris DPWIN_00059 for Windows Core patches: PHSS_30341 for HP-UX DPSOL_00077 for Solaris DPWIN_00055 for Windows Cell Server patches: PHSS_30337 for HP-UX DPSOL_00075 for Solaris DPWIN_00065 for Windows Cell Console patches: PHSS_30338 for HP-UX DPSOL_00076 for Solaris DPWIN_00050 for Windows After installing the required patches from the above list and upgrading all Oracle, Cell Console, and Cell Manager clients, you must perform the following steps on the Cell Manager system(s): a.) On HP-UX and Solaris Cell Manager systems: 1. Copy the new Oracle templates from the "/opt/omni /newconfig/etc/opt/omni/dltemplates/lists/oracle8/" directory to the "/etc/opt/omni/dltemplates/lists /oracle8" directory. 2. Upgrade all Oracle backup specifications stored on the Cell Manager by running the following command: "/opt/omni/sbin/mrgcfg -ora_barlists" b.) On Windows Cell Manager systems: 1. Copy the new Oracle templates from the "\NewConfig\dltemplates\lists \oracle8\" directory to the " \Config\dltemplates\lists\oracle8\" directory. 2. Upgrade all Oracle backup specifications stored on the Cell Manager by running the following command: "\bin\mrgcfg -ora_barlists" Some of the defect fixes contained in this patch depend on the following other patches or their successors in order to completely resolve the problem: PHSS_30331: Documentation packet patch, release date: Late April 2004 Change Request: 8606331369 Change Request: H555010792 PHSS_30331 is required for this defect fix. PHSS_30338: Cell Console (CC) packet patch, release date: Late April 2004 Change Request: 8606331369 PHSS_30338 is required for these defect fixes. PHSS_30337: Cell Server (CS) packet patch, release date: Late April 2004 Change Request: 8606331369 PHSS_30337 is required for this defect fix. PHSS_30341: Core packet patch, release date: Late April 2004 Change Request: 8606331369 Change Request: H555010792 PHSS_30341 is required for these defect fixes. PHSS_30143: Core packet patch, release date: Available Change Request: H555010463 Change Request: H555008622 PHSS_30143 is required for these defect fixes. Supersedes: PHSS_29150 PHSS_28337 Equivalent Patches: None Patch Package Size: 9900 KBytes Installation Instructions: Please review all instructions and the Hewlett-Packard SupportLine User Guide or your Hewlett-Packard support terms and conditions for precautions, scope of license, restrictions, and, limitation of liability and warranties, before installing this patch. ------------------------------------------------------------ 1. Back up your system before installing a patch. 2. Login as root. 3. Copy the patch to the /tmp directory. 4. Move to the /tmp directory and unshar the patch: cd /tmp sh PHSS_30333 5. Run swinstall to install the patch: swinstall -x autoreboot=true -x patch_match_target=true \ -s /tmp/PHSS_30333.depot By default swinstall will archive the original software in /var/adm/sw/save/PHSS_30333. If you do not wish to retain a copy of the original software, include the patch_save_files option in the swinstall command above: -x patch_save_files=false WARNING: If patch_save_files is false when a patch is installed, the patch cannot be deinstalled. Please be careful when using this feature. For future reference, the contents of the PHSS_30333.text file is available in the product readme: swlist -l product -a readme -d @ /tmp/PHSS_30333.depot To put this patch on a magnetic tape and install from the tape drive, use the command: dd if=/tmp/PHSS_30333.depot of=/dev/rmt/0m bs=2k Special Installation Instructions: PHSS_30333: Patch has to be installed on the Installation Server host. The Oracle 8 packets must be redistributed to the Oracle 8 client system(s) afterwards to get the fixes into effect. Patch includes the following Site Specific Patches: SSPSOL500_002 SSPUX500_025 SSPUX500_047 A Site Specific Patch is a temporary hotfix that you might have received from HP Support if you have encountered a problem with Data Protector for which no General Release patch was or is available yet. If any newer Site Specific Patch - that is one with a higher number - for the Oracle 8 agent is installed on your system, then you must re-apply this SSP after installing this Oracle 8 agent patch.