AppManager for Oracle UNIX provides a comprehensive solution for monitoring the activity on an Oracle RDBMS on computers with UNIX or Linux operating systems.
This release extends support to Oracle RDBMS version 11g and12c and resolves some issues. Many of these improvements were made in direct response to suggestions from our customers. We thank you for your time and valuable input. We hope you continue to help us ensure that our products meet all your needs. You can post feedback in the AppManager for Oracle UNIX forum on NetIQ Communities, our online community that also includes product information, blogs, and links to helpful resources.
The documentation for this product is available on the NetIQ Web site in HTML and PDF formats on a page that does not require you to log in. If you have suggestions for documentation improvements, click comment on this topic at the bottom of any page in the HTML version of the documentation posted at the AppManager Modules page. To download this product, see the AppManager for Oracle UNIX Module Upgrades & Trials Web site.
This release of AppManager for Oracle UNIX provides the following enhancement:
Support for Oracle Database 19c: With this hotfix release, AppManager for Oracle UNIX provides support for Oracle Database 19c.
To get the updates provided in this release, you must install the module to the AppManager repository (QDB) and on the agent computer, and then propagate changes to any running jobs for the Knowledge Scripts that were updated in this release. AppManager 7.x does not automatically update renamed or copied Knowledge Scripts. For more information, see the “Upgrading Knowledge Script Jobs” section in the management guide.
This release of AppManager for Oracle UNIX replaces all Previous Releases.
For the most recently updated list of supported application versions, see the AppManager Supported Products page. Unless noted otherwise, this module supports all updates, hotfixes, and service packs for the releases listed below.
AppManager for Oracle UNIX has the following system requirements:
|
Item |
Requirement |
|---|---|
|
AppManager repository, management server, and Control Center Console |
7.0 or later |
|
NetIQ UNIX Agent |
7.5 or later |
|
Operating system on agent computers |
One of the following:
|
|
Oracle |
One of the following:
NOTE:If you are using any 9.2 Oracle home on an HP-UX computer, upgrade the client libraries to 9.2.0.2 or later. |
For more information, see the AppManager for Oracle RDBMS on UNIX or Linux Servers Management Guide, included in the download package.
The download package includes this Release Notes, a management guide, and several files that are used during installation:
p75p12.zip, the patch file you install on any computers you want to monitor that have UNIX agent 7.5 installed.
p80p8.zip, the patch file you install on any computers you want to monitor that have UNIX agent 8.0 installed.
p81p3.zip, the patch file you install on any computers you want to monitor that have UNIX agent 8.1 installed.
p82p4.zip, the patch file you install on any computers you want to monitor that have UNIX agent 8.2 installed.
AM-70-OracleUNIX-8.0.228.0.msi, the module installer.
AM70-OracleUNIX-8.0.228.0.ini, a configuration file used with the AppManager setup program.
AM70-OracleUNIX-OracleUNIX-8.0.228.0.xml, a configuration file used for deploying the module with Control Center. This is the file you check into the Control Center Web Depot.
AM70-OracleUNIX-8.0.228.0-RepositoryFiles.exe, a compressed file that contains the QDB and console files. You do not need to run this file during installation.
When you download the module, these files are copied by default to the local folder on the download computer. Consider copying these files to the \windows_installation\setup\Setup Files folder on the same distribution computer on which you saved your main AppManager software and documentation. By doing so, you maintain all AppManager software in one location that is easily accessible when you want to add more repositories, management servers, or agents.
The following steps provide an overview of how to install this module:
On computers that you want to monitor, install UNIX agent 8.1 with patch 8.1.0.3, UNIX agent 8.0 with patch 8.0.0.8, or UNIX agent 7.5 with patch 7.5.0.12. The files you need to install the patches are included in this download package.
Install the Knowledge Scripts to your AppManager repository (QDB) using AM70-OracleUNIX-8.0.228.0.msi, which is included in this download package.
Install the Help and console extensions to all AppManager consoles using AM70-OracleUNIX-8.0.228.0.msi. You do not need to use this installer on the UNIX Agent Manager console.
Add the computers you want to monitor to the list of computers in all consoles you use to monitor those computers.
Discover any new computers you want to monitor.
If you are upgrading from a previous version of the module, upgrade any running jobs.
Run the module installer only once on each of these computers.
For more information about installing these components, see the AppManager for Oracle RDBMS on UNIX or Linux Servers on the AppManager Modules page.
NetIQ Corporation strives to ensure our products provide quality solutions for your enterprise software needs. The following issues are currently being researched. If you need further assistance with any issue, please contact Technical Support.
Instance relocates to another node. When a database instance relocates to another node in a cluster, the Knowledge Scripts are unable to connect to the instance and throw an error. The running jobs will continue to throw error events. The workaround is to re-run the discovery and the jobs with the proper target objects. (DOC342755)
UNIX Agent does not restart itself when discovering OracleRAC. When UNIX Agent restarts, it takes 120 seconds and is killed by the startup script so UNIX Agent does not start up automatically. The fix for this is available after applying the respective agent patches. After applying the agent patch, the user must use the Configure AM option in the UNIX Agent Manager (UAM). Alternatively the user can run $PSHOME/netiq/bin/wcAppManConfig from a UNIX agent machine and accept the default and necessary values to modify the UNIX Agent startup script. (DOC342670)
Listener Knowledge Scripts are not monitoring multi-threaded database background processes. In a multi-threaded environment, the Listener Knowledge Script does not identify dependent database processes that are running. (ENG339173)
If you need further assistance with any issue, please contact Technical Support.
This release of AppManager for Oracle UNIX includes enhancements added to the previous releases.
This release of AppManager for Oracle Unix Provides the following enhancements:
Provides support for Oracle UNIX RAC with the following Knowledge Scripts:
|
Knowledge Scripts |
What It Does |
|---|---|
|
Discovery_OracleRACUnix |
Discovers Oracle RAC on UNIX computers for all UNIX platforms. |
|
AlertLog |
Scans the Oracle RAC database instance, ASM instance, and cluster alert logs and returns entries that match the search strings. |
|
ASMDISKIOStat |
Monitors the ASM disk IO statistics. |
|
ASMDiskUtilization |
Monitors the ASM disk usage. |
|
ClusterwareStatus |
Monitors the status of the Oracle RAC clusterware daemon services. |
|
DataFileSpace |
Monitors the size and usage of Oracle RAC datafiles. |
|
IntelligentDataPlacement |
Lists the files that have the most number of cold reads and cold writes. |
|
RACHealthCheck |
Monitors health check for Oracle RAC clusters. |
|
RACNodeCPUUtil |
Monitors RAC Node CPU utilization. |
|
RedoLog |
Monitors the Redo Log Contention, the number of Redo Log files that are not archived and the Redo Log Space wait ratio for an Oracle RAC database. |
|
SysStat |
Retrieves statistics from V_$SYSSTAT table of an Oracle RAC database. |
|
TablespaceAvail |
Monitors the amount of disk space available to the tablespaces in an Oracle RAC database. |
|
TopResourceConsumingSQL |
Monitors the most resource intensive SQL statements. |
|
TopResourceUsers |
Monitors the resource usage of current user sessions. |
|
User |
Monitors various user ratios. |
|
VotingDiskStatus |
Monitors the status of voting disk(s) in Oracle RAC. |
This release of AppManager for Oracle UNIX resolves the following issues.
The OraLog files expands until exhausting the file system space. This release, introduces a Log Rotation feature that resolves this issue. The user can configure the Oracle Module back-end log maximum size and Oracle Module Knowledge Scripts log maximum size by using the wcAppManConfig script or by using the UNIX Agent Manager (UAM). (ENG341294)
Discovery_OracleUnix fails due to ndFillObjTable_xml: invalid typename/p_typename. This release resolves the issue by creating a single root server for all the versions of Oracle software installations. All the databases are listed under the same root object. (ENG341470)
NOTE:NETIQ recommends deselecting the option Keep version number in root node? when there are multiple versions of Oracle databases running and delta discovery is enabled.
This release of AppManager for Oracle UNIX supports Oracle RDBMS version 12.
This release of AppManager for Oracle UNIX resolves the following issues:
OracleUNIX_AlertLog does not allow for exclusion filters. This release fixed the exclusion filter in the AlertLog Knowledge Script. (ENG210774)
Request for Oracle pSQL -- OracleUNIX_BlockingSessions. This release fixed the pSQL in the BlockingSessions Knowledge Script.(ENG324770)
Many CreateEvent settings in Oracle Knowledge Scripts are hard coded. This release fixed the hard coded severity for internal failure in CreateEvent in multiple Knowledge Scripts. (ENG335997)
Performance Knowledge Script reports job iteration difference message. This release fixed the differences in messages across job iterations for the Performance Knowledge Script. (ENG333698)
The description for the tablespace exclusion in the TablespaceAvail Knowledge Scrips is wrong. This release fixed the tablespace exclusion filter details in the AppManager for Oracle RDBMS on UNIX or Linux Servers Management Guide for TablespaceAvail Knowledge Script. (DOC283841)
This release supports all new operating system platforms and features of the NetIQ UNIX Agent version 7.2 and provides the following enhancements.
Support for Oracle RDBMS version 11g Release 1 (11.1).
Enhanced security for the Oracle UNIX Managed Object to connect to Oracle Database.
Tablespace exception list for global monitoring policy
Support for monitoring Oracle job status using the ScheduledJobs Knowledge Script.
Consolidation of the following Knowledge Scripts:
DataRatios (ConsistentChangeRatio, ContinuedRowRatio, RowSourceRatio, and SortOverflowRatio)
HealthCheck (SetMonitoringOptions, ClusterInstanceDown, DatabaseConnect, and DatabaseDown)
Memory (BGProc, BufferBusyWaits, Cache, and FreeListWaits)
Performance (OpenCursors, TopCpuUsers, TopIOUsers, TopLockUsers, and TopMemoryUsers)
RedoLog (RedoLogContention, RedoLogsNotArchived, and RedoLogSpaceWaitRatio)
Transaction (ActiveTransactions, CallRate, CallsPerTransaction, and TransactionRate)
User (BlockingSessions, UserCallsPerParse, UserRollbackRatio, and UserSessions)
This release resolved the following issue:
Works with UNIX agent. The NetIQ UNIX agent allows you to secure and manage your UNIX and Linux systems from a central point of control. The UNIX agent also works with NetIQ Security Manager and NetIQ Secure Configuration Manager. The NetIQ UNIX agent provides additional features to the AppManager for Oracle UNIX module. Key features include:
UNIX Agent Manager console to install, configure, and manage UNIX agents across your enterprise
Remote deployment for UNIX agents and modules
Management of UNIX resource access from one console
This initial release resolved the following issue:
Works with UNIX agent. The NetIQ UNIX agent allows you to secure and manage your UNIX and Linux systems from a central point of control. The UNIX agent also works with NetIQ Security Manager and NetIQ Secure Configuration Manager. The NetIQ UNIX agent provides additional features to the AppManager for Oracle UNIX module. Key features include:
UNIX Agent Manager console to install, configure, and manage UNIX agents across your enterprise
Remote deployment for UNIX agents and modules
Management of UNIX resource access from one console
This initial release resolved the following issue:
Support for Oracle RDBMS version 11g Release 1 (11.1).
Enhanced security for the Oracle UNIX Managed Object to connect to Oracle Database.
Tablespace exception list for global monitoring policy
Support for monitoring Oracle job status using the ScheduledJobs Knowledge Script.
Consolidation of the following Knowledge Scripts:
DataRatios (ConsistentChangeRatio, ContinuedRowRatio, RowSourceRatio, and SortOverflowRatio)
HealthCheck (SetMonitoringOptions, ClusterInstanceDown, DatabaseConnect, and DatabaseDown)
Memory (BGProc, BufferBusyWaits, Cache, and FreeListWaits)
Performance (OpenCursors, TopCpuUsers, TopIOUsers, TopLockUsers, and TopMemoryUsers)
RedoLog (RedoLogContention, RedoLogsNotArchived, and RedoLogSpaceWaitRatio)
Transaction (ActiveTransactions, CallRate, CallsPerTransaction, and TransactionRate)
User (BlockingSessions, UserCallsPerParse, UserRollbackRatio, and UserSessions)
This initial release added support for HP-UX version 11.23 on 64-bit Itanium systems.
This initial release added the following new features:
Support for Oracle RDBMS 10gR2
Support for Red Hat Linux Advanced Server/Enterprise Server 3.0 and 4.0 on AMD Opteron 64-Bit and Intel EMT 64-Bit hardware
Support for Suse Linux 8.3 Enterprise, 9.0, and 10.0 on AMD Opteron 64-Bit, Intel EMT 64-Bit hardware
Our goal is to provide documentation that meets your needs. If you have suggestions for improvements, please email Documentation-Feedback@netiq.com. We value your input and look forward to hearing from you.
For detailed contact information, see the Support Contact Information Web site.
For general corporate and product information, see the NetIQ Corporate Web site.
For interactive conversations with your peers and NetIQ experts, become an active member of our community. The NetIQ online community provides product information, useful links to helpful resources, blogs, and social media channels.
For information about NetIQ legal notices, trademarks, disclaimers, warranties, export and other use restrictions, U.S. Government restricted rights, patent policy, and FIPS compliance, see https://www.netiq.com/company/legal/.
Copyright © 2019 NetIQ Corporation. All rights reserved.