How do I upgrade VigilEnt Password Manager for Oracle 5.0 to 6.0? (NETIQKB28225)

  • Document ID:7728225
  • Creation Date:02-Feb-2007
  • Modified Date:08-Sep-2008
    • Micro Focus Products:
      Secure Configuration Manager

Resolution

goal
How do I upgrade VigilEnt Password Manager for Oracle 5.0 to 6.0?

fact
VigilEnt Password Manager for Oracle 5.0.X

fact
VigilEnt Password Manager for Oracle 6.0.X

fact
VigilEnt Security Agent for Oracle 1.0.X

fix
To upgrade VigilEnt Password Manager for Oracle (VPMO) from version 5 to version 6, follow these steps:

  1. Stop the password server process.

  2. Remove any jobs owned by SQLCQR for VPMO 5.0  (Other products such as, Database Security Manager, Policy Manager, and VigilEnt Audit Manager may also own jobs).

  3. Check that no session exists for SQLCQR in the Oracle "V$session" table.

  4. Remove the PeopleSoft connection with Password Manager 5 API components, using the following SQL statement:

    drop function sqlcqr.sqlcqr_logincheck;
    drop public synonym sqlcqr.sqlcqr_logincheck;
    drop function sqlcqr.sqlcqr_pwd_checkandset;
    drop public synonym sqlcqr.sqlcqr_pwd_checkandset;

  5. Remove the main package for Password Manager using the following SQL statement:

    drop package sqlcqr.sqlcqr_private_pkg;
    drop package sqlcqr.sqlcqr_pwd;

  6. Increase the column width for PARAMVAL from 100 to 255 in the table SQLCQR_PWDMGR_PARAMS, using the following SQL statement:

    alter table ?SQLCQR?.?SQLCQR_PWDMGR_PARAMS? modify (?PARAMVAL? VARCHAR2 (255));

  7. Increase the column widths for PARAMNAME and PARAMVAL from 30 to 50, using the following SQL statement:

    alter table ?SQLCQR?.?SQLCQR_PWDMGR_NOTIFY_PARAMS? modify (?PARAMNAME? VARCHAR2 (50), ?PARAMVAL? VARCHAR2 (50));

  8. Run the new Schema Installer for VigilEnt Password Manager for Oracle 6.

    Note: Due to the fact that you already have a SQLCQR user, the Schema Installer generates an error if you attempt to install the step that creates a SQLCQR user. You may either ignore this error or skip over the step entirely.

  9. Check to see that Job_Queue_Processes and Job_Queue_Interval are set to 4 and 60, respectively.

  10. Paste the new license key into the Parameters tab.

  11. Stop and re-start the password listener.

  12. Test a password change on an Oracle account.

  13. Install the API components.


Additional Information

Formerly known as NETIQKB28225