This topic provides information about upgrading and performing post installation tasks for BMC PATROL for Oracle.
No matter what method you use for upgrading and migrating customizations, you must first perform the following tasks:
Note
Throughout this section, all references to PATROL_HOME represent $PATROL_HOME in UNIX and %PATROL_HOME% in Windows; all references to PATROL_CACHE represent $HOME/patrol in UNIX and %PATROL_CACHE% in Windows.
Before you install, you must remove the current PATROL for Oracle files from the PATROL_CACHE directory for the console. If you do not, old product files in PATROL_CACHE are loaded instead of the newly installed files from PATROL_HOME.
Remove all PATROL for Oracle files with the following naming patterns from PATROL_CACHE\knowledge and PATROL_CACHE\psl:
Note
If you are using History.km, do not delete ORACLE_history_loader.km.
After you have migrated and merged your customizations, you must create an installation package that can be used with the installation utility.
When you upgrade to the latest version of PATROL for Oracle, if your PATROL account was created by the SYS user, collectors go into the alarm state due to missing privileges. To prevent the collectors from going into the alarm state, create the Over The Top script. This script grants the necessary privileges to the PATROL account.
Before you create Over The Top script, you must have read, write, and execute permissions on the conf directory at the following location:
If you do not have the specified permissions or if you do not have the sufficient disk space to create the script, the product displays the following error message:
Right-click the Oracle KM icon and choose KM Commands > Configuration > Create Over The Top Scripts.
This command creates the following files:
Operating system | Files |
---|---|
Windows |
|
UNIX |
|
Note
BMC recommends that you do not modify the above files.
Enter the following command: cd %PATROL_HOME%\oracle\conf\OverTheTopFiles\<
Agent-Port-Number >\
Note
You must have write permission on the < Agent-Port-Number> directory.
OverTheTopScript.bat
Enter the following command:
cd $PATROL_HOME/../oracle/conf/OverTheTopFiles/<Agent-Port-Number>/
Note
You must have write permission on the < Agent-Port-Number> directory.
./OverTheTopScript.sh
Y
or y
or N
or n
on the following Do you really want to continue (y/n) : command prompt.N
or n
, the script does not give the privileges to that instance. If you press Enter
, the script defaults to Y
and gives the privileges.After you enter the SYS password in step 3, the following privileges are given to the PATROL account:
If the instance is part of a RAC database, the SELECT ANY DICTIONARY privilege is revoked from the PATROL database monitoring user and the following RAC-specific privileges are granted to the user:
In addition, a log file, OverTheTopGrants.log, is created at the following location:
This log file contains the information whether the script is executed for a particular instance. It also contains the history of operations performed during execution of the script.