9.5.20: Service Pack 2 for PATROL for Oracle 9.5.00

Enhancements

Service Pack 2 provides the following enhancements:

Support for Oracle 12c pluggable database

BMC PATROL for Oracle now supports Oracle 12c pluggable database (PDB) feature. The ORACLE_PLUGABLE_INSTANCE application class holds all the pluggable instances.  

New Application classes and parameters

The following table lists the new application classes and parameters available in BMC PATROL for Oracle 9.5.20:

SELECT ON V$PDBS and DBA_PDBS privilege added to the PATROL database users

Users will now have the SELECT privilege to the tables containing pluggable databases.

Downloading the service pack

This section provides the information that you need to download and install the service pack from the BMC Electronic Product Distribution (EPD) website.

1. To download the installation utility and service pack from the EPD website

   1. Create a directory in which to place the downloaded files.

   2. Go to http://www.bmc.com/available/epd.html.
   3. At the logon prompt, enter your user ID and password, and click Submit.
   4. On the Export Compliance and Access Terms page, provide the required information, agree to the terms of the agreements and click Continue.
   5. If you are accessing this site for the first time, create an EPD profile to specify the languages and platforms that you want to see, per the EPD site help; otherwise, skip to step f.
   6. Verify that the correct profile is displayed for your download purpose.
   7. You can download the installation utility and the product service pack using either of the following methods:
      • Using Component View
      • Using Licensed Products View

   Using Component View

   1. In the Filter Products: field, type BMC PATROL Installation Utility.
   2. Click Go.
   3. In the right pane, click BMC PATROL Installation Utility.
   4. In the Version: list, select 9.6.01 and click Go.

   5. In the Products tab, based on the operating system, select the check box next to the files.
      
      

      Link title	Actual file name
      BMC PATROL Installation Utility Version 9.6.00 - Windows Only	ins_WINDOWS_9600.zip
      BMC PATROL Installation Utility Version 9.6.00 - All UNIX/LINUX	ins_ALL_9600.tar

   6. To download the selected files, click Download (FTP) or Download Manager:
      • Download (FTP) places the selected items in an FTP directory, and the credentials and FTP instructions are sent to you in an email message.
      • Download Manager enables you to download multiple files consecutively and to resume an interrupted download.
        This method requires a one-time installation of the Akamai NetSession client program on the target computer and is usually the faster and more reliable way to transfer files. A checksum operation is used to verify file integrity automatically.
   7. Click  to close the window.
   8. In the Filter Products: field, type BMC PATROL for Oracle.
   9. Click Go.
   10. In the right pane, click BMC PATROL for Oracle.
   11. In the Version: list, select 9.5.20 and click Go.

   12. In the Products tab, based on the operating system, select the check box next to the files.

       Link title	Actual file name	Platform
       BMC PATROL Version 9.5.20 for Oracle	POK_ALL_9520.zip	Microsoft Windows/NT
       BMC PATROL Version 9.5.20 for Oracle - UNIX	POK_ALL_9520.tar	All platforms
       BMC PATROL Version 9.5.20 for Oracle KM Tools	POKR_ALL_9520.zip	Microsoft Windows/NT
       BMC PATROL Version 9.5.20 for Oracle KM Tools – UNIX	POKR_ALL_9520.tar	All platforms

   13. To download the selected files, click Download (FTP) or Download Manager:
       • Download (FTP) places the selected items in an FTP directory, and the credentials and FTP instructions are sent to you in an email message.
       • Download Manager enables you to download multiple files consecutively and to resume an interrupted download.
         This method requires a one-time installation of the Akamai NetSession client program on the target computer and is usually the faster and more reliable way to transfer files. A checksum operation is used to verify file integrity automatically.
   14. Complete the installation procedure described in the Installing the service pack section.

   Using Licensed Products View

   1. Click Go To Licensed Products View.
   2. Locate BMC Performance Manager for Databases and expand its entries to show the available version numbers.
   3. Expand BMC Performance Manager for Databases 3.7.00 to show the available components.
   4. Expand BMC PATROL for Oracle 9.5.20 to show the available files.
   5. Expand BMC PATROL Installation Utility 9.6.01 to show the available files.

   6. Select the check box next to the files, based on the appropriate platforms.

      Link title	Actual file name	Platform
      BMC PATROL Version 9.5.20 for Oracle	POK_ALL_9520.zip	Microsoft Windows/NT
      BMC PATROL Version 9.5.20 for Oracle - UNIX	POK_ALL_9520.tar	All platforms
      BMC PATROL Version 9.5.20 for Oracle KM Tools	POKR_ALL_9520.zip	Microsoft Windows/NT
      BMC PATROL Version 9.5.20 for Oracle KM Tools – UNIX	POKR_ALL_9520.tar	All platforms
      BMC PATROL Installation Utility Version 9.6.00 - Windows Only	ins_WINDOWS_9600.zip	Microsoft Windows/NT
      BMC PATROL Installation Utility Version 9.6.00 - All UNIX/LINUX	ins_ALL_9600.tar	All platforms

   7. To download the selected files, click Download (FTP) or Download Manager:
      • Download (FTP) places the selected items in an FTP directory, and the credentials and FTP instructions are sent to you in an email message.
      • Download Manager enables you to download multiple files consecutively and to resume an interrupted download.
        This method requires a one-time installation of the Akamai NetSession client program on the target computer and is usually the faster and more reliable way to transfer files. A checksum operation is used to verify file integrity automatically.

   8. Complete the installation procedure described in the Installing the service pack section.

   Installing the service pack

   Before you begin

   You must install the service pack on the following computers:

   • Hosts that are running the PATROL Agent
   • Hosts that are running the PATROL Console

   Before you install the service pack, complete the following steps:

   1. Stop the PATROL Agent.
   2. Back up the PATROL_CACHE directory.
   3. Delete all the BMC PATROL for Oracle files from the PATROL_CACHE directory.

   4. Back up the PATROL_HOME/lib/knowledge and PATROL_HOME/lib/psl directories.
      
      

      Important

      The installation packages differ for local monitoring and remote monitoring. The following table lists the packages required for the respective monitoring type.

      Monitoring type	Required package name
      Local monitoring with alert log monitoring and ORANET listener monitoring enabled	POK_ALL_9520, POKR_ALL_9520
      Local monitoring with alert log monitoring and ORANET listener monitoring disabled	POK_ALL_9520
      Remote instance monitoring	POKR_ALL_9520

   To install the BMC PATROL for Oracle 9.5.20 Service Pack

   1. Extract the installation utility for your operating system as appropriate:

      • For Windows, double-click ins_WINDOWS_9600.zip.
      • For UNIX, enter tar -xvf ins_ALL_9600.tar.
        
        The contents of the files are extracted into the bmc_products subdirectory.
   2. Extract the service pack files for your operating system as appropriate:
      • For Windows, double-click drpok_ALL_9520.zip.
      • For UNIX, enter tar -xvf drpok_ALL_9520.tar.
        
        The contents of the files are extracted into the bmc_products subdirectory. 

   3. From the bmc_products directory, run the installation utility as appropriate for your operating system:

      • For Windows, double-click setup.exe.

      • For UNIX, run setup.sh.

   4. Follow the on-screen instructions until the Select Products and Components to Install page is displayed. 

   5. On the Select Products and Components to Install page, select PATROL for Oracle - Service Pack 9.5.20.

   6. Follow the on-screen instructions to complete the installation. After you complete the installation steps, you can delete the temporary directory and its contents.