Patch-ID# 111631-05
Keywords: Netbackup Oracle database 64 bit 32 bit F0788 9i
Synopsis: Netbackup 3.4 Database extention for Oracle 9i
Date: Mar/06/2003

Install Requirements: None                      
Solaris Release: 2.6 7 8 9

SunOS Release: 5.6 5.7 5.8 5.9

Unbundled Product: Veritas NetBackup

Unbundled Release: 3.4

Xref: 

Topic: 

Relevant Architectures: sparc

BugId's fixed with this patch: 4465641 4483702 4488159 4651953 4653970

Changes incorporated in this version: 4651953

Patches accumulated and obsoleted by this patch: 

Patches which conflict with this patch: 

Patches required with this patch: 

Obsoleted by: 

Files included with this patch: 

<install_dir>/openv/netbackup/dbext/OEBU.solaris2.6.tar.Z
<install_dir>/openv/netbackup/dbext/OEBU.solaris2.6.version
<install_dir>/openv/netbackup/dbext/OEBU.solaris7_64.tar.Z
<install_dir>/openv/netbackup/dbext/OEBU.solaris7_64.version
<install_dir>/openv/netbackup/dbext/install_dbext

Problem Description:

4651953 When installing 111143-04, the correct infxbsa.so isn't installed
 
(from 111631-04)
 
4653970 NetBackup Oracle module needs to support oracle 8.1.7 (8i) and 9.* (9i)
 
(from 111631-03)
 
4465641 compatibility between NetBackup 3.4 module for Oracle 8.1.6 and Solaris 8
 
(from 111631-02)
 
4488159 Inclulde update_dbclients script to patch 111631-02
 
(from 111631-01)
 
4483702 Modification on patch 111631-01 README description.

Patch Installation Instructions:
------------------------------------------------------------------------- 
Refer to the "patchadd" and "patchrm" man pages for installation and removal instructions.  Any other
ial or non-generic installation instructions should be described below.
-------------------------------------------------------------------------
 
 As root on your NetBackup for Oracle client:
 
 
1. Stop EBU instance manager if Oracle7 or RMAN if Oracle8
 
2. install the patch 
 
3. Make the library visible to Oracle.
      For EBU:
        - add /usr/openv/netbackup/bin to the library search path
                set PATH=$PATH,/usr/openv/netbackup/bin
      For RMAN:
        - Symbolically link from your current libobk location
                ln -s /usr/openv/netbackup/bin/libobk.so64.1 \
                   ${LIBOBK_LOCATION}/libobk.so
 
 
Addional script included for a remote installation of database clients. Run update dbclients script located at /usr/openv/netbackup/bin/update_dbclients.
 
If the 32-bit 3.4GA NetBackup DataBase Agent is currently installed,
the script /usr/openv/netbackup/bin/update_dbclients will report
in the trace file:
 
   Extension version files match - no update needed.
 
 
   The following is displayed to standard output:
 
        [N_number] client update(s) had up-to-date software according to
        the database extension version file.
 
        To force the installation of the database extension software
        for these client updates, you need to execute:
 
        update_dbclients -ForceInstall <dbextension_name> -ClientList <filename>
 
         or
 
        update_dbclients -ForceInstall <dbextension_name> <hardware_type> <operating_system>
 
    Run update_dbclients with the -ForceInstall option.
 
   The following are instructions updated to include Solaris 64-bit.
 
 Note: If the receiving client is a 64-bit machine, the native
        package, (64-bit NetBackup for Oracle) will be installed. If
        you are running the 32-bit version of Oracle on that type of
        client, execute <install_path>/netbackup/dbext/install_dbext
        locally on that machine after completing the Remote Install
        Procedure. When prompted, select the the 32-bit NetBackup for
        Oracle package.
 
 
       If the local machine is a 64-bit machine, you will be prompted
        as to whether to install the 32-bit or 64-bit NetBackup for
        Oracle package.  The option you choose should match the type
        of Oracle software you installed. (A remote install assumes
        that the native package (64-bit) is the one that should be
        installed.)
 
==============================
DESCRIPTION OF PROBLEMS FIXED 
==============================
 
Current patch
=============
 
Description:
    In the Oracle 9i release, Server Manager (svrmgrl) has been replaced
    with SQL*Plus (sqlplus).  The sqlplus interface requires the DBA to 
    connect as SYSDBA to perform DBA related tasks, which was done previously 
    using connect internal in svrmgrl. The syntax for SQL*Plus is:
 
    sqlplus /nolog
    connect <user>/<password> as sysdba
    <user> and <password> are optional depending on security in place for 
    the Oracle instance. For more information on the usage of sqlplus /nolog,
    refer to the "Oracle DBA Administrator Guide".
 
 
    The NetBackup sample script "cold_database_backup.sh" was modified to
    reflect these changes.  The following modifications were made to this
    script:
 
        1. There are 2 SVRMGR variable definitions, SVRMGRL="svrmgrl" for use with 
            Oracle 8i and SVRMGRL="sqlplus /nolog" for use with Oracle 9i or 8i instead
            of svrmgrl. 
        2. Added 2 lines for the LOGIN variable. LOGIN="connect internal" for use with 
           svrmgrl and LOGIN="connect <user>/<password> as sysdba" for use with
           sqlplus /nolog.
        3. Replaced the occurrences of "connect internal" with $LOGIN
 
    The SVRMGR variable is used to define the command to be executed (sqlplus or svrmgrl)
    and the LOGIN variable is used to define the login string.
 
    For example, cold_database_backup.sh was modified
 
    FROM:
 
    SVRMGR=svrmgrl
 
    echo
    echo "% ${ORACLE_HOME}/bin/$SVRMGR"
    echo "connect internal"
    echo "shutdown immediate"
    echo "exit"
    echo
 
    su - $ORACLE_USER -c "
    ORACLE_SID=$ORACLE_SID
    export ORACLE_SID
    ${ORACLE_HOME}/bin/$SVRMGR <<!
    connect internal
    shutdown immediate
    exit
    !
    "
 
    TO:
    #SVRMGR="svrmgrl"
    SVRMGRL="sqlplus /nolog"
    #LOGIN="connect internal"
    LOGIN="connect sys/change_on_install as sysdba"
       .
       .
       .
    echo
    echo "% ${ORACLE_HOME}/bin/$SVRMGR"
    echo $LOGIN
    echo "shutdown immediate"
    echo "exit"
    echo
 
    su - $ORACLE_USER -c "
    ORACLE_SID=$ORACLE_SID
    export ORACLE_SID
    ${ORACLE_HOME}/bin/$SVRMGR <<!
    $LOGIN
    shutdown immediate
    exit
    !
    "
 
    Note:
 
    Additional modifications, similar to the ones mentioned above, may be be needed
    for existing scripts to allow them to work in the Oracle 9i environment.
    I.E. use sqlplus instead of svrmgrl and specify the proper login string for sqlplus.

Special Install Instructions:
------------------------------------

None.

README -- Last modified date:  Thursday, March 6, 2003

