Patch Name: PHSS_31043

Patch Description: s700_800 11.X OV DP5.00 patch - SAP packet

Creation Date: 04/08/20

Post Date: 04/08/23

Hardware Platforms - OS Releases:
	s700: 11.00 11.11
	s800: 11.00 11.11

Products:
	DATA-PROTECTOR A.05.00

Filesets:
	DATA-PROTECTOR.OMNI-SAP-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 general_release manual_dependencies

Path Name: /hp-ux_patches/s700_800/11.X/PHSS_31043

Symptoms:
	PHSS_31043:
	Change Request: H555013064
	  "Backint" inquiry may list to many files.

	Change Request: H555013360
	  During a SAP restore, the following message is displayed:

	   "Following trees from <name> "SAP", session <name> were
	    not found in database: <path>
	    Whole object will be read to perform restore."

	Change Request: H555013460
	  During a SAP backup, the "omnisap" parameters can be
	  seen in "ps" command output.

	Change Request: H555013613
	  After SAP backup some Data Protector temporary files are
	  not deleted.

	PHSS_30332:
	Change Request: H555010476
	  During SAP raw disk backup of read-only disk the
	  following is reported in the session report and the
	  disk is not backed up:

	  "Error: Cannot open object (|30| Read-only file
	  system)."

	Change Request: H555010594
	  The following error is reported when performing a SAP
	  integration backup with brarchive:

	  "BR301W SQL error -1017 at location BrDbConnect-1
	  ORA-01017: invalid username/password; logon denied
	  BR310W Connect to database instance UP2 failed."

	Change Request: H555010652
	  "util_sap.exe" configuration checking intermittently
	  fails and troubleshooting environment settings is not
	  possible.

	Change Request: H555010793
	  SAP R/3 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: H555011258
	  "Backint" intermittently ends abnormally when using
	  manual balancing.

	Change Request: H555011447
	  On some systems the "ps" command displays "brtools"
	  invocation parameters.

	PHSS_28733:
	Change Request: H555009563
	  Data Protector SAP R/3 integration does not work on
	  SAP R/3 system with Oracle 9i.

	Change Request: H555009941
	  Restore of sap tablespace on raw disk bigger than the
	  one backed up falls into loop. Restore agent is then
	  aborted due to inactivity by session manager.

	Change Request: H555009971
	  During a SAP backup session, debug.log file is being
	  filled with "Unknown state" messages.

	Change Request: H555010162
	  Executing pre-exec script causes subsequent popen
	  and/or pclose calls to fail getting return code of
	  executed process.

	PHSS_28023:
	Change Request: H555008621
	  Errors are reported in debug.log for files of size 0
	  and for missing function entry statements.

	Change Request: H555008642
	  SAP BR tools 6.10 reports:

	     "BR247E No Backup utility ID or ID longer than 16
	     characters".

	Change Request: H555008812
	  During raw device SAP restore following error is
	  reported:

	    "|Minor| From: OB2BAR_SAPREST@<host> ""  Time:<time>
	     Error: Cannot open object <raw disk path>
	     |20| Not a directory)."

	Change Request: H555008906
	  During some backint queries following error is reported:

	     "|Critical| From: OB2BAR@<host> ""  Time:<time>
	     Failed to allocate memory.
	     System error: |12| Not enough space"

	Change Request: H555008908
	  When Data Protector tries to backup nonexistent SAP
	  redo logs, session ends as failed.

Defect Description:
	PHSS_31043:
	Change Request: H555013064
	  "Backint" performs an incorrect search comparison,
	  listing files for additional Data Protector SAP objects.

	  Resolution:
	  Name comparison now checks numbers of objects to be
	  listed (SID.x) properly.

	Change Request: H555013360
	  Data Protector cannot find the file in the catalog
	  because the database query is incorrectly composed.

	  Resolution:
	  Database query is changed (to source only) before it is
	  sent to Restore Session Manager (RSM).

	Change Request: H555013460
	  The parameters are not concealed.

	  Resolution:
	  The "omnisap" parameters are preceded by a long empty
	  option when started from "inet". After the start,
	  "omnisap" changes its title, concealing the parameters.

	Change Request: H555013613
	  Temporary files may be opened twice.

	  Resolution:
	  Double file creation is removed.

	PHSS_30332:
	Change Request: H555010476
	  Raw disks are opened for check in read-write mode.

	  Resolution:
	  During backup disks are opened in read-only mode.

	Change Request: H555010594
	  Error is reported when performing a SAP
	  integration backup with "brarchive".

	  Resolution:
	  Setting the "OB2NOBRTSECU" to 1 in .omnirc file
	  results in sending properly formatted logon
	  information to "brarchive -b" command during a
	  backup session.

	Change Request: H555010652
	  Environment is not written to debugs.

	  Resolution:
	  Values of environment variables are logged
	  into debugs for troubleshooting.

	Change Request: H555010793
	  During a SAP R/3 ZDB backup, only replicas
	  of the database data files should be created.

	  Resolution:
	  SAP R/3 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 7 (Integrating Data
	  Protector, HP SureStore Virtual Array and SAP R/3) and
	  Appendix.

	  HP OpenView Storage Data Protector HP SureStore Disk
	  Array XP Integration Guide, chapter 6 (Integrating Data
	  Protector, HP SureStore Disk Array XP, and SAP R/3) 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: H555011258
	  If "backint" receives exactly 100 files for backup that
	  are not specified in the manual balancing, it attempts
	  to read past the end of this internally made list.

	  Resolution:
	  Mechanism for checking the end of the new files list
	  is improved.

	Change Request: H555011447
	  Invocation parameters are passed by the here document
	  that is displayed on some systems in the output of the
	  "ps" command.

	  Resolution:
	  Invocation parameters are hidden from the "ps" command
	  process listing. The here document is not used for
	  invocation parameters.

	PHSS_28733:
	Change Request: H555009563
	  Oracle Server Manager (svrmgrl) is obsoleted with
	  Oracle 9i. sqlplus needs to be used instead.

	  Resolution:
	  Data Protector SAP R/3 integration works on SAP R/3
	  system with Oracle 9i.

	  Part of SSPUX500_017.

	Change Request: H555009941
	  Size of data to be restored is mistakenly overwritten
	  by disk size checking function.

	  Resolution:
	  Disk size checking function is changed in a manner that
	  it properly calculates destination directory properties.

	Change Request: H555009971
	  All information messages in switch.log, except #SUCCESS
	  and #ERROR, are being treated as serious error.

	  Resolution:
	  Status of information messages is lowered from "error"
	  to normal.

	Change Request: H555010162
	  Handling child processes incorrectly discards child
	  process return code after script execution.

	  Resolution:
	  Child process state is restored to initial state after
	  script execution.

	PHSS_28023:
	Change Request: H555008621
	  CheckFile checks marked error if parameter is null.
	  Debugs are initialized after function entry is marked.

	  Resolution:
	  Error messages are not written to the debug.log file.

	Change Request: H555008642
	  Set ID number searching is not strict enough and gets
	  confused by new SAP BR tools format.

	  Resolution:
	  Stricter checking is applied to see if it really is
	  backint ID.

	Change Request: H555008812
	  Data Protector ignores the following caution in the SAP
	  specification:

	    "Caution: By restoring raw partition to a different
	    one, the <dest_dir> means directly the new raw
	    partition, not the directory containing the special
	    file."

	  Resolution:
	  Destination directory forming procedure is changed.

	Change Request: H555008906
	  Some parts of structures for query are allocated but
	  not released.

	  Resolution:
	  All allocated structures are released.

	Change Request: H555008908
	  By design, whenever there are no objects backed up,
	  Data Protector ends session as failed.

	  Resolution:
	  Two new global variables have been introduced:

	  a) SessSucessfullWhenNoObjectsBackedUp=0
	  By setting this variable to 1 user can change the
	  Data Protector behavior in order to end the session
	  as successful when there are no objects backed up.
	  b) TreatScriptReturnAsNormal=<script return>
	  Setting this variable to a certain number instructs
	  Data Protector to treat all the script returns equal
	  to the specified number as normal.

Enhancement:
	No

SR:
	H555013613 H555013460 H555013064 H555013360 H555011258
	H555010594 H555010652 H555011447 H555010476 H555010793
	H555009941 H555009563 H555010162 H555009971 H555008906
	H555008908 H555008812 H555008642 H555008643 H555008621

Patch Files:
	
	DATA-PROTECTOR.OMNI-SAP-P,fr=A.05.00,fa=HP-UX_B.11.00_32/64,
		v=HP:
	/opt/omni/databases/vendor/sap/sun/sparc/solaris-26/A.05.00/
		packet.Z
	/opt/omni/databases/vendor/sap/ibm/rs6000/aix-42/A.05.00/
		packet.Z
	/opt/omni/databases/vendor/sap/hp/s800/hp-ux-11/A.05.00/
		packet.Z
	/opt/omni/databases/vendor/sap/hp/s800/hp-ux-1020/A.05.00/
		packet.Z
	/opt/omni/databases/vendor/sap/gpl/i386/linux-60/A.05.00/
		packet.Z
	/opt/omni/databases/vendor/sap/dec/alpha/osf1-4/A.05.00/
		packet.Z

what(1) Output:
	
	DATA-PROTECTOR.OMNI-SAP-P,fr=A.05.00,fa=HP-UX_B.11.00_32/64,
		v=HP:
	/opt/omni/databases/vendor/sap/sun/sparc/solaris-26/A.05.00/
		packet.Z:
		None
	/opt/omni/databases/vendor/sap/ibm/rs6000/aix-42/A.05.00/
		packet.Z:
		None
	/opt/omni/databases/vendor/sap/hp/s800/hp-ux-11/A.05.00/
		packet.Z:
		None
	/opt/omni/databases/vendor/sap/hp/s800/hp-ux-1020/A.05.00/
		packet.Z:
		None
	/opt/omni/databases/vendor/sap/gpl/i386/linux-60/A.05.00/
		packet.Z:
		None
	/opt/omni/databases/vendor/sap/dec/alpha/osf1-4/A.05.00/
		packet.Z:
		None

cksum(1) Output:
	
	DATA-PROTECTOR.OMNI-SAP-P,fr=A.05.00,fa=HP-UX_B.11.00_32/64,
		v=HP:
	2255546054 1646709 /opt/omni/databases/vendor/sap/dec/alpha/
		osf1-4/A.05.00/packet.Z
	2447977928 1010217 /opt/omni/databases/vendor/sap/gpl/i386/
		linux-60/A.05.00/packet.Z
	490023682 1397675 /opt/omni/databases/vendor/sap/hp/s800/
		hp-ux-1020/A.05.00/packet.Z
	1732335232 1431800 /opt/omni/databases/vendor/sap/hp/s800/
		hp-ux-11/A.05.00/packet.Z
	3996133984 1234813 /opt/omni/databases/vendor/sap/ibm/
		rs6000/aix-42/A.05.00/packet.Z
	3467292769 1299577 /opt/omni/databases/vendor/sap/sun/sparc/
		solaris-26/A.05.00/packet.Z

Patch Conflicts: None

Patch Dependencies: None

Hardware Dependencies: None

Other Dependencies:
	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_31040:
	CORE packet patch,
	release date: Late August 2004
	Change Request: H555013460
	PHSS_31040 is required for this defect fix.

	PHSS_30574:
	CORE packet patch,
	release date: Available
	Change Request: H555010793
	PHSS_30574 is required for this defect fix.

	PHSS_30331:
	Documentation packet patch,
	release date: Available
	Change Request: H555010793
	PHSS_30331 is required for this defect fix.

Supersedes:
	PHSS_30332 PHSS_28733 PHSS_28023

Equivalent Patches: None

Patch Package Size: 7550 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_31043

	5. Run swinstall to install the patch:

		swinstall -x autoreboot=true -x patch_match_target=true \
			  -s /tmp/PHSS_31043.depot

	By default swinstall will archive the original software in 
	/var/adm/sw/save/PHSS_31043.  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_31043.text file is 
	available in the product readme:

		swlist -l product -a readme -d @ /tmp/PHSS_31043.depot

	To put this patch on a magnetic tape and install from the
	tape drive, use the command:

		dd if=/tmp/PHSS_31043.depot of=/dev/rmt/0m bs=2k

Special Installation Instructions:
	PHSS_31043:
	NOTE!
	This patch has to be installed on the Installation
	Server host.

	The DP SAP agent must be redistributed to the SAP
	client system(s) after the installation of the patch
	in order to get the fixes into effect.

	For distribution of the SAP agent, refer to
	the Data Protector Installation guide.

	Patch includes the following Site Specific Patches:
	   SSPUX500_017

	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 SAP agent
	is installed on your system, then you
	must re-apply this SSP after installing
	this SAP agent patch.