9.7.11.01: Fix pack 1 for PATROL for Oracle Database
The PATROL for Oracle Database 9.7.11.01 fix pack is an update to this KM that includes changes to the supported features for this product.
For more information about the issues corrected in this fix pack, see Known and corrected issues.
This topic also provides instructions for downloading and installing this fix pack:
The Oracle Extended Tablespace Monitoring (ETSM) feature is improved by querying the DBA_TABLESPACE_USAGE_METRICS Oracle Static Data Dictionary View.
If you are upgrading from an earlier PATROL for Oracle Database version, you must login to the Oracle Database as a privileged user and grant the following privilege to the monitoring user:
grant select on dba_tablespace_usage_metrics to <Oracle monitoring user>
We also improved the monitoring of database availability and tablespaces to avoid scalability issues.
On Oracle v12cR2 or earlier versions, the tablespace monitoring is impacted by v9.7.11.01 of the KM because it has a dependency with the Oracle DBA_TABLESPACE_USAGE_METRICS Static Data Dictionary View, which doesn’t provide always the expected information.
Oracle reported several bugs in earlier supported versions for the Oracle DBA_TABLESPACE_USAGE_METRICS Static Data Dictionary View. Because the KM has a dependency on this view, it is required to install the latest Oracle patches to enable complete monitoring of all tablespaces in the environment. For Oracle v12cR2 itself there is still no solution and hence the UNDO tablespace is not monitored by v9.7.11.01 of the KM.
Support for the following features were dropped in this fix pack.
|Dropped feature and component||PATROL Menu Commands|
Oracle Server Administration utilities
Used for accessing Oracle utilities through the PATROL console
For more information, see Using Oracle utilities.
Oracle Server Admin
Used to determine if the Oracle server, tablespace, or objects need any adjustments or tuning
For more information see the following:
Auto Extend DBFiles
Free Space Deficit
Object Space Analysis
Space Usage by Object
Redo Log Files
Trace Files Space Analysis
Oracle License Limits
Parameter File (init.ora)
Schema Function Info
Schema Package Info
Schema Procedure Info
Schema Table Info
Schema Trigger Info
Commit Point Strength
Buffer Cache Contents
Buffer/Lib/Dict Cache Info
Redo Log Cache Info
SGA Memory Analysis
All Problem Users
Display Oracle Users
User Account Info
User/Role Column Privileges
User Session Data
User/Objects in SYSTEM
Users with DBA Role
Allowed for schedule jobs to run at specific times from PATROL for Oracle Database using the Batch Scheduler
For more information, see Batch reporting.
View Log file Admin
Delete Log File
List Log File
Move Log File
Used to monitor the replication activities and the database links used in your replication environment
For more information, see Replication activities.
Monitoring SQL statements
Used the PATROL for Oracle Database functions to obtain information about SQL commands used in Oracle processes
Used to stop and start a listener process from within PATROL
For more information, see Starting and stopping a listener.
Downloading the installation files
The following table provides links to the pages in the EPD website that contain the installation files for this product. From the EPD page, you can select and download the installation files for your platform. Access to the EPD website requires that you provide your BMC Support credentials. You might also be prompted to complete the Export Compliance Form.
|Component||EPD link||Installation file name|
|PATROL for Oracle Database fix pack (9.7.11.01)|
|PATROL Installation Utility 11.0.00|
Installing the PATROL for Oracle Database 9.7.11.01 fix pack
The PATROL for Oracle Database 9.7.11.01 fix pack contains all of the files that are required for a complete product release. You can install the fix pack over an existing installation of the KM, or as a fresh installation.
To install the PATROL for Oracle Database 9.7.11.01 fix pack in a PATROL environment
Follow the typical installation instructions in Installing in a PATROL environment.
To install the PATROL for Oracle Database 9.7.11.01 fix pack using a TrueSight Presentation Server
Follow the instructions in Installing using a TrueSight console.
Upgrading to the PATROL for Oracle Database 9.7.11.01 fix pack
If you are using an earlier version of the KM and want to preserve the configuration settings and monitoring history, you can upgrade to the 9.7.11.01 fix pack by following the Upgrading instructions.