How can I restore a corrupted PeopleSoft password using VigilEnt Password Manager for Oracle? (NETIQKB30501)

goal
How can I restore a corrupted PeopleSoft password using VigilEnt Password Manager for Oracle?

fact
VigilEnt Password Manager for Oracle 5.0

fact
VigilEnt Password Manager for Oracle 6.x

fact
VigilEnt Security Agent for Oracle 1.x

fix
The steps are outlined below for restoring corrupted PeopleSoft passwords:

These steps are designed for the following combination of VPMO and Oracle versions:

• VPMO v5 & v6 on an Oracle 7.x database
• VPMO v5 on an Oracle 8.x database.

NOTE: These steps were NOT designed for VPMO v6 on an Oracle 8.x database. 

1.  Clear the pwd history for the ID.
2. Log onto a SQL session as SYSADM or any privileged user and run the following SQL:
   
   update sqlcqr.sqlcqr_userdata set pwdhist = NULL where username = 'THEUSERID';
   commit;
3. Log onto a SQL session as SYSADM or another privileged user and run the included SQL. This will change the Oracle password directly.
   
   alter user XXX identified by XXX;
   commit;
4.  Log onto a SQL session as SYSADM or another privileged user and run the included SQL. This will set the new password value into the PeopleSoft PSOPRDEFN table.
   
   update sysadm.psoprdefn
   set OPERPSWD='XXX', ACCESSPSWD='SYSADM', ACCESSACCTPSWD='UNENCR'
   where OPRID='XXX';
   COMMIT;
   
   NOTE: Change SYSADM to your local access id if different. ACCESSACCTPSWD='UNENCR' is the value for PeopleSoft 7.x, substitute ENCRYPTED=0 FOR VERSION 7.5.
5. Logon to the datamover as SYSADM or privileged user and execute the following command exactly as shown:
   
   ENCRYPT_PASSWORD OPRID;
   
   This ID should now be able to log into PeopleSoft.

Formerly known as NETIQKB30501