Date: 19 Apr 2002

Patch: 2.0-ORA-0013

Component(s): 
            Tivoli Manager for Oracle - Framework 

General Description:

   *** NOTE ***
   You must install this patch on each TMR server and Tivoli gateways
   of LCF endpoints associated with Oracle resources to be managed. You
   must have Tivoli Manager for Oracle v2.0 Framework installed prior to 
   installing this patch.  Additionally, patch 2.0-ORA-0012
   [2.0-ORA-0011F] must be installed before you can install this patch.

   Finally, to complete the  patch 2.0-ORA-0013 installation, it is
   strongly advised that the 'tmo_patch_0013.sh' script in the
   20ORA13/SUPPORT directory be run on the TMR server. This is to ensure
   that all the necessary updates are made to complete the fixes included
   in this patch.

   You do not need to remove the BEQUEATH_DETACH=YES from the SQLNET.ORA
   file as this setting will not cause conflicts with Tivoli Manager for
   Oracle. Tivoli Manager for Oracle, version 2.0 connections to the
   database should succeed with or without the BEQUEATH_DETACH parameter
   set in SQLNET.ORA file. 


 # Feature 135227 - Have toggle for update state function.
 # ---------------------------------------------------------------------
 The feature to offer more control over Tivoli Manager for Oracle object
 GUI icon updates has been included in patch 2.0-ORA-0013.

 This feature helps reduce workload on the gateway system based solely
 on icon updates by reducing the number of OracleInstanceGUI processes
 running to service Tivoli Manager for Oracle icon updates made by the
 RDBMS State monitor.

 On the TMR server:

 woiconcntrl OFF

 This would turn off icon updates requested by the RDBMS State monitor
 so that the OracleInstanceGUI processes are not started just to update
 database/instance object icons.

 Use:

 woiconcntrl ON

 to turn this functionality back on.

 # --------------------------------------------------------------------

Problems Fixed:

    APAR:    IY16153 
    Problem: DEFUNCT PROCESSES CREATED WITH ORACLE ASYNC PROBES WHEN

    APAR:    IY25938 
    Problem: ORACLESQLENGINE DEFUNCT WHEN ORACLE IS DOWN/NOT PRESENT

    FEATURE:  135227
    Problem: Have toggle for update state function.

Architecture(s): aix4-r1 hpux10 solaris2 

Patches superseded by this patch: None

Patches this patch is dependent on: 2.0-ORA-0012


Files Replaced or Added by this Patch:

  for all architectures:

 Contents#BIN:

        AMS/ORACLE/OracleDatabaseCollector
        bin/woiconcntrl

 Contents#LCF:

        bin/%INTERPS%/TME/DSMF/DSMFAgent
        bin/%INTERPS%/AMS/ORACLE/OracleSQLEngine7
        bin/%INTERPS%/AMS/ORACLE/OracleSQLEngine8

Patch Contents:

        - This README file
        - A cdrom image for this patch

Applying the Patch:

    1a) If installing on a Unix system:

        FTP the 2.0-ORA-0013.tar file to your machine. Place the
        2.0-ORA-0013.tar file into a scratch directory. For the
        purpose of this release note, assume that the symbol
        $PATCH points to this directory.

        > . /etc/Tivoli/setup_env.sh
        > cd $PATCH
        > tar xvf 2.0-ORA-0013.tar

    1b) If installing on a Windows NT system:

        Extract the contents into a scratch directory. For the
        purpose of this release note, assume that the symbol
        %PATCH% points to this directory.

        > %SystemRoot%\system32\drivers\etc\Tivoli\setup_env.sh
        > X:
          ^-- 'X' is drive letter where %PATCH% is found
        > cd %PATCH%
        > tar xvf 2.0-ORA-0013.tar

        NOTE: If you are extracting the tar image on a Windows NT
        system, you will find an executable for tar in the TME
        installation on Windows NT under bin/w32-ix86/tools/tar.exe.

    2)  Use the following steps to install the patch from the Tivoli
        desktop. NOTE: You must have the install_product and super
        authorization roles to successfully install this patch.

        a) Select the "Install -> Install Patch..." option from the
           "Desktop" menu to display the "Install Patch" dialog.

        b) Press the "Select Media..." button to display the "File
           Browser" dialog.

        c) Enter the path to the directory containing the patch,
           $PATCH, in the "Path Name:" field.

        d) Press the "Set Media & Close" button to return to the
           "Install Patch" dialog.

        e) The patch install list now contains the name of the patches:
 "Tivoli Manager for Oracle - Framework Patch 2.0-ORA-0013 E-fix (build 04/18)"
           Select item by clicking on it.

        f) Select the nodes to install this patch on. You must
           install this patch on each TMR server and Tivoli
           gateways of LCF endpoints associated with Oracle
           resources to be managed.

        g) Press the "Install" button to install the patch.


Additional Installation Instructions:

 To complete the installation, it is highly recommended
 that the 'tmo_patch_0013.sh' script be run on the TMR
 server.

 The 'tmo_patch_0013.sh' script does the following:

 1. Synchronizes all the gateways in the local TMR with the defined
    dependencies
 2. Ensures all the required binaries are downloaded to the LCF endpoints
    where the managed Oracle databases reside.
 3. Makes a backup of the DSMF Controller lists.
 4. Initiates the update of the DSMF Controller lists.
    This is to ensure that the version-specific 'OracleSQLEngine(7/8)'
    are used subsequently.

 Notes:

  - 'tmo_patch_0013.sh' only needs to be run on the TMR server.
  - Because new files may need to be downloaded to the LCF endpoint,
   'tmo_patch_0013.sh' might take a while to run.
  - Make sure your environment is setup prior to running
    'tmo_patch_0013.sh' by running 'setup_env.sh'.
  - Additionally, patch 2.0-ORA-0012 [ 2.0-ORA-0012F ] will
    need to be installed before running 'tmo_patch_0013.sh'. 

Known Defects: 
 
     None

