How do I upgrade Audit Manager from version 3.2.6 to version 4.0?. (NETIQKB33966)

  • 7733966
  • 02-Feb-2007
  • 08-Sep-2008

Resolution

goal
How do I upgrade Audit Manager from version 3.2.6 to version 4.0?.

fact
VigilEnt Audit Manager for Oracle 3.2.6

fact
VigilEnt Audit Manager for Oracle 4.0

fix
To upgrade from version 3.2.6 to 4.0, please refer to the following. There are three phases to this process:
  1. Update all the Microsoft Windows executables and files from the latest CD media.
  2. Complete the steps listed below for migration/upgrade of the database schema objects.
  3. Rebuild (recompiling) all "user-defined" audits.
Once all phases have been successfully completed the VigilEnt Audit Manager for Oracle will be upgraded to version 4.0.

List of files included in the kit.

  • DefaultInstall.data
  • DefaultInstall.html
  • SchemaInstall.exe
  • USRAUDIT_V326_V4_UPGRADE.SQL
  • USRAUDIT_V326_V4_UPGRADE_MERGE.SQL

Phase I

Install the latest CD (this would be v1.0.4 of the Oracle agent) and use the setup executable (setup.exe) to install the Windows files to the default directory.

Phase II

Steps for migration/upgrade:

  1. Save the attached files into a directory below the original VigilEnt Audit Manager for Oracle.
  2. Start the SchemaInstaller executable.
  3. Select Upgrade Audit Manager for Oracle V3.2.6 to V4.0. This will upgrade the standard installation of VigilEnt Audit Manager for Oracle.
  4. Select OK button and read the requirements tab.
  5. Select Next Step.
  6. Enter "Password" for the SYS user and a "Database Alias" for the target database instance.
  7. Select Perform Pre-Installation check.
  8. Select Install (large button).
  9. When prompted, enter the password for the SQLCQR user.
  10. Select OK when finished and close the SchemaInstaller executable.

NOTE:  The Merge/Purge feature is an optional  'Add-on Component' of the VigilEnt Audit Manager for Oracle product. If this component is being used, it should also be upgraded to be compatible with version 4.x.  Run steps 1 thru 10 above,  replacing the choice in step 3 with: Upgrade Audit Manager for Oracle V3.2.6 to V4.0 (Merge/Purge).

Phase III

There was a change made in the trigger base component, which is used during the creation of 'user-defined' audits. This change requires that each 'user-defined' be recompiled in order for the change to take effect. (The trigger base is the part of the 'user-defined' audits that allows VigilEnt Audit Manager to record certain information.)

  1. Start the VigilEnt Audit Manager main console using the SQLCQR user.
  2. Go to the Audit Options menu and select User-Defined.
  3. Highlight each user-defined audit and select Save.


note
Contact Technical Support for the upgrade kit.

Additional Information

Formerly known as NETIQKB33966