Patch Name: PHSS_30565

Patch Description: s700_800 11.X OV DP5.10 patch - ORACLE8 packet

Creation Date: 04/07/27

Post Date: 04/08/03

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

Products:
	DATA-PROTECTOR A.05.10

Filesets:
	DATA-PROTECTOR.OMNI-OR8-P,fr=A.05.10,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_30565

Symptoms:
	PHSS_30565:
	Change Request: 8606361989
	  The "util_orarest.exe" script may fail, stop responding
	  or end abnormally. When browsing an Oracle database from
	  Data Protector graphical user interface (GUI), the
	  following error message may be displayed:

	   "Binary util_orarest is missing. Cannot get information
	    from the remote host."

	Change Request: H555011250
	  "Disk_only" option is ignored by "ob2rman".

	Change Request: H555011429
	  The "rest_common.sh" script contains an incorrect
	  command in the lines 97 and 130:

	   "rm -f  rm -f /var/opt/omni/tmp/restore.$$"

	  Also, "svrmgrl_${OB2APPNAME}.report" is not removed
	  after the session.

	Change Request: H555012037
	  The "util_orarest.exe" command, run from the command-line
	  interface (CLI) on Tru64 systems running Oracle9i, ends
	  abnormally.

	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".

	Change Request: H555012512
	  Simple method to enable debug traces for all Data
	  Protector processes on one client is needed.

	Change Request: H555013236
	  If restore of a catalog fails, "scriptob2rman.exe" does
	  not exit properly.

	Change Request: H555013602
	  The programs "util_orarest.exe" and "util_orarest9.exe"
	  may end abnormally on RedHat 8.0 system.

	Change Request: H555013617
	  The restore of the whole Oracle database including
	  control file fails with the following message:

	   "The database should be in the mount mode in order the
	    restore to succeed."

	  This error happens although the database is put in the
	  correct nomount state.

	PHSS_29863:
	Change Request: H555010253
	  Oracle restore fails with:

	    "12:8346  Binary util_orarest failed.
	     Cannot get information from remote host."

	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: H555011041
	  Oracle Integration is not supported on Linux-IA64.

	Change Request: H555011104
	  Oracle 8i on 32 bit AIX 5.1. does not work.

	Change Request: H555011134
	  Oracle backup is randomly failing.

	PHSS_29412:
	Change Request: H555010134
	  Setting the ORA_EXP variable is ineffective.

	Change Request: H555010410
	  The Oracle8 integration (ob2rman.exe) is backing up
	  the wrong Oracle database.

	Change Request: H555010463
	  During the Oracle split mirror Proxy Copy restore
	  of a datafile on a raw disk, the following error
	  is reported and the restore aborts:

	   "ORA-27197: skgfprs: sptpcrestore returned error."

	Change Request: H555010508
	  Direct backup solution is not supported.

	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: H555010792
	  Oracle8i/9i databases cannot be recovered 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: 8606299299
	  "util_oracle8.exe" script ends abnormally.

	Change Request: 8606313981
	  Oracle database logon information is
	  incorrectly passed during Data Protector
	  backup execution.

Defect Description:
	PHSS_30565:
	Change Request: 8606361989
	  The "util_orarest.exe" script does not properly detect
	  and query Oracle databases of different versions.

	  Resolution:
	  To avoid failing of "util_orarest.exe", two versions of
	  this script are introduced and a configuration variable
	  "OCI" in the "omnirc" file or in the Data Protector
	  Oracle8/9 instance configuration file which is located
	  in the
	  "/etc/opt/omni/integ/config/Oracle8/<client_name>
	  %<ORACLE_SID>" file (HP-UX and Solaris systems),
	  or in the
	  "<Data_Protector_home>\Config\integ\configoracle8\
	  <client_name>%<ORACLE_SID>" file
	  (Windows systems) on the Cell Manager.

	  "Util_orarest.exe" and "util_orarest9.exe" are located
	  in the "/usr/omni/bin" directory.
	  Depending on the Oracle versions that are running on a
	  Tru64 system, the user can choose which program to use
	  or can specify the "OCI" variable:

	  a.) If only Oracle8 instances are running on a Tru64
	      system, then "util_orarest.exe" has to be used.
	  b.) If only Oracle9i instances are running on a Tru64
	      system, then util_orarest9.exe has to be used:

	      1. Rename "util_orarest.exe" to
	         "util_orarest.exe.orig"
	      2. Rename "util_orarest9.exe" to "util_orarest.exe"

	  c.) If instances of both Oracle8 and Oracle9i versions
	      are running on a Tru64 system or in case of problems
	      on configurations described under a.) and b.), the
	      configuration variable "OCI" has to be set in the
	      "omnirc" file or in the Data Protector Oracle8/9
	      instance configuration file.

	      The syntax is the following:

	       OCI='0'

	      - If variable "OCI" is set in the "omnirc" file, then
	        is valid for all instances on this system.
	      - If variable "OCI" is specified in the Data
	        Protector Oracle8/9 instance configuration file, it
	        is valid only for that specific instance.

	  Setting the "OCI" variable for a particular instance
	  makes "util_orarest.exe" and "util_orarest9.exe"
	  equivalent in behavior and both can be used for the
	  restore of Oracle8 or Oracle9i instances.

	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: H555011429
	  The "rest_common.sh" script has the following at lines
	  97 and 130:

	   "rm -f  rm -f /var/opt/omni/tmp/restore.$$"

	  Also, "svrmgrl_${OB2APPNAME}.report" is not removed
	  after the session.

	  Resolution:
	  In "rest_common.sh" the following is changed:

	   "rm -f rm -f /var/opt/omni/tmp/restore.$$" is changed to
	   "rm -f /var/opt/omni/tmp/restore.$$"

	  Also, the superfluous "svrmgrl_${OB2APPNAME}.report"
	  file is removed after the session.

	Change Request: H555012037
	  Due to differences between Oracle8 and Oracle9i on
	  Tru64 systems, it is not possible to use the same
	  "util_orarest.exe" utility  for accessing Oracle8 and
	  Oracle9i.

	  Resolution:
	  New "util_orarest.exe" utility is prepared for the Tru64
	  systems running Oracle9i.

	  Part of SSPUX510_024.

	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".

	Change Request: H555012512
	  Simple method to enable debug traces for all Data
	  Protector processes on one client is needed.

	  Resolution:
	  New environment variable "OB2DBG" is introduced in the
	  "omnirc" file. Adding "OB2DBG" to environment or
	  "omnirc" file will produce debugs for all started Data
	  Protector processes.

	   SYNOPSIS:

	      OB2DBG=<ranges> <postfix> <select>

	   EXAMPLE:

	      OB2DBG=1-200 HPDBG.txt

	  <ranges> and <postfix> options are mandatory for
	  debugging to start. For more information on Data
	  Protector debugging options, refer to the "trace" file
	  located in the "<Data_Protector_home>\Config\Options"
	  directory on Windows Cell Manager and in the
	  "/etc/opt/omni/options" directory on the UNIX Cell
	  Manager.

	Change Request: H555013236
	  If restore of a catalog fails, "scriptob2rman.exe" does
	  not exit properly.

	  Resolution:
	  If restore of a catalog fails, "scriptob2rman.exe" exits
	  properly.

	Change Request: H555013602
	  The programs "util_orarest.exe" and "util_orarest9.exe"
	  are not built properly.

	  Resolution:
	  The build procedure of programs "util_orarest.exe" and
	  "util_orarest9.exe" has been corrected.

	  Part of SSPUX510_035.

	Change Request: H555013617
	  The logic in the "ob2rman.exe" binary is incorrect.

	  Resolution:
	  The logic in the "ob2rman.exe" binary is corrected.

	PHSS_29863:
	Change Request: H555010253
	  If Oracle instance name and database name are different,
	  the database can not be browsed within Data Protector
	  Restore GUI.

	  Resolution:
	  If the database name and the instance name are
	  different, database ID is used for selecting database
	  objects instead of instance name.

	  Part of SSPUX510_015.

	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: H555011041
	  Oracle Integration is not supported on Linux-IA64.

	  Resolution:
	  Oracle Integration is supported on Linux-IA64.

	Change Request: H555011104
	  There is 32 bit Oracle 8i library (libob2oracle8.a)
	  missing in AIX 5.1. Oracle integration packet.

	  Resolution:
	  The 32-bit library libob2oracle8.a is added in Oracle
	  integration package for AIX 5.1.

	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.

	PHSS_29412:
	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: 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
	  During a backup, the incorrect object name is saved
	  to the Data Protector internal database (IDB)
	  and a restore procedure is unable to locate it.

	  Resolution:
	  Raw disk backup saves the correct object name
	  to the Data Protector internal database (IDB).
	  Raw disk restore is added to the Oracle Proxy Copy
	  restore.

	Change Request: H555010508
	  Direct backup solution is not supported.

	  Resolution:
	  Direct backup is supported. For supported
	  configurations, refer to the Direct backup support
	  matrix available at:

	  http://www.openview.hp.com/products/
	  storage_data_protector/device_matrices/
	  Direct_Backup_Support_Matrix_DP51.pdf.

	  For more information, refer to the HP OpenView Storage
	  Data Protector Administration Guide, chapters 2 and 5,
	  HP OpenView Storage Data Protector Concepts Guide,
	  chapter 9, and online Help. The updated version of
	  these guides are available with DOC patches PHSS_29143
	  and DPSOL_00027 or subsequent DOC patches.

	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: 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).

	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.

	  Resolution:
	  Scripts for launching "rman" are no longer created.

Enhancement:
	No (superseded patches contained enhancements)
	PHSS_29863:
		General release patch PHSS_29863/DPSOL_00047
		introduces Data Protector A.05.10 Oracle
		integration on Linux IA-64 operating system.
	PHSS_29412:
		General release patch PHSS_29412
		introduces Data Protector A.05.10 Direct
		backup solution.

		For more information about the above
		functionality, install the Documentation
		Patch PHSS_29143 on the Cell Manager system
		and read the respective changes in the
		Release Notes, chapters 2 and 6.

SR:
	H555011250 H555012037 H555013617 8606361989 H555012059
	H555012512 H555011429 H555013236 H555013602 H555011104
	H555010253 H555011041 H555010742 H555011134 H555010463
	H555010134 H555010410 H555010508 H555010589 8606299299
	H555010792 8606313981 H555010591

Patch Files:
	
	DATA-PROTECTOR.OMNI-OR8-P,fr=A.05.10,fa=HP-UX_B.11.00_32/64,
		v=HP:
	/opt/omni/databases/vendor/oracle8/sun/sparc/solaris-26/
		A.05.10/packet.Z
	/opt/omni/databases/vendor/oracle8/hp/sia64/hp-ux-1122/
		A.05.10/packet.Z
	/opt/omni/databases/vendor/oracle8/hp/s800/hp-ux-11/A.05.10/
		packet.Z
	/opt/omni/databases/vendor/oracle8/ibm/rs6000/aix-51/
		A.05.10/packet.Z
	/opt/omni/databases/vendor/oracle8/ibm/rs6000/aix-43/
		A.05.10/packet.Z
	/opt/omni/databases/vendor/oracle8/gpl/ia64/linux-ia64/
		A.05.10/packet.Z
	/opt/omni/databases/vendor/oracle8/gpl/ia64/linux-ia64/
		A.05.10/require.dat
	/opt/omni/databases/vendor/oracle8/gpl/i386/linux-60/
		A.05.10/packet.Z
	/opt/omni/databases/vendor/oracle8/dec/alpha/osf1-5/A.05.10/
		packet.Z

what(1) Output:
	
	DATA-PROTECTOR.OMNI-OR8-P,fr=A.05.10,fa=HP-UX_B.11.00_32/64,
		v=HP:
	/opt/omni/databases/vendor/oracle8/sun/sparc/solaris-26/
		A.05.10/packet.Z:
		None
	/opt/omni/databases/vendor/oracle8/hp/sia64/hp-ux-1122/
		A.05.10/packet.Z:
		None
	/opt/omni/databases/vendor/oracle8/hp/s800/hp-ux-11/A.05.10/
		packet.Z:
		None
	/opt/omni/databases/vendor/oracle8/ibm/rs6000/aix-51/
		A.05.10/packet.Z:
		None
	/opt/omni/databases/vendor/oracle8/ibm/rs6000/aix-43/
		A.05.10/packet.Z:
		None
	/opt/omni/databases/vendor/oracle8/gpl/ia64/linux-ia64/
		A.05.10/packet.Z:
		None
	/opt/omni/databases/vendor/oracle8/gpl/ia64/linux-ia64/
		A.05.10/require.dat:
		None
	/opt/omni/databases/vendor/oracle8/gpl/i386/linux-60/
		A.05.10/packet.Z:
		None
	/opt/omni/databases/vendor/oracle8/dec/alpha/osf1-5/A.05.10/
		packet.Z:
		None

cksum(1) Output:
	
	DATA-PROTECTOR.OMNI-OR8-P,fr=A.05.10,fa=HP-UX_B.11.00_32/64,
		v=HP:
	610318461 13486915 /opt/omni/databases/vendor/oracle8/dec/
		alpha/osf1-5/A.05.10/packet.Z
	2743087410 8307838 /opt/omni/databases/vendor/oracle8/gpl/
		i386/linux-60/A.05.10/packet.Z
	2072486793 12885857 /opt/omni/databases/vendor/oracle8/gpl/
		ia64/linux-ia64/A.05.10/packet.Z
	233025976 15 /opt/omni/databases/vendor/oracle8/gpl/ia64/
		linux-ia64/A.05.10/require.dat
	910448063 3532827 /opt/omni/databases/vendor/oracle8/ibm/
		rs6000/aix-43/A.05.10/packet.Z
	545225451 3527778 /opt/omni/databases/vendor/oracle8/ibm/
		rs6000/aix-51/A.05.10/packet.Z
	544894752 5304640 /opt/omni/databases/vendor/oracle8/hp/
		s800/hp-ux-11/A.05.10/packet.Z
	283504398 10604700 /opt/omni/databases/vendor/oracle8/hp/
		sia64/hp-ux-1122/A.05.10/packet.Z
	836991382 4522781 /opt/omni/databases/vendor/oracle8/sun/
		sparc/solaris-26/A.05.10/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_30567:
	CORE packet patch,
	release date: Available
	Change Request: H555011041
	Change Request: H555010508
	PHSS_30567 is required for these enhancements.
	Change Request: H555011429
	Change Request: H555010463
	Change Request: H555010792
	PHSS_30567 is required for these defect fixes.

	PHSS_30327:
	Cell Console (CC) packet patch,
	release date: Available
	Change Request: H555010508
	PHSS_30327 is required for this enhancement.

	PHSS_30328:
	Cell Server (CS) packet patch,
	release date: Available
	Change Request: H555010508
	PHSS_30328 is required for this enhancement.

	PHSS_30134:
	Documentation packet patch,
	release date: Available
	Change Request: H555010508
	PHSS_30134 is required for this enhancement.
	Change Request: H555010792
	PHSS_30134 is required for this defect fix.

	PHSS_30563:
	SSEA Agent packet patch,
	release date: Available
	Change Request: H555010508
	PHSS_30563 is required for this enhancement.

	PHSS_30345:
	Media Agent (MA) packet patch,
	release date: Available
	Change Request: H555010508
	PHSS_30345 is required for this enhancement.

Supersedes:
	PHSS_29863 PHSS_29412

Equivalent Patches: None

Patch Package Size: 58630 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_30565

	5. Run swinstall to install the patch:

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

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

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

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

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

Special Installation Instructions:
	PHSS_30565:

	NOTE!

	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:
	   SSPUX510_015
	   SSPUX510_024
	   SSPUX510_035

	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.