Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Verify that you have a valid Interpoint for PeopleSoft license.
  2. Open the PeopleSoft configuration file psappsrv.cfg (usually located in the PT%version%\appserv\%domainName% folder). If EnableDBMonitoring=1, proceed to step 7. Otherwise, proceed to step 3.
  3. Disconnect all PeopleSoft users.
  4. Shut down all PeopleSoft application servers.
  5. Set the database monitoring parameter to TRUE: EnableDBMonitoring=1
  6. Restart the PeopleSoft application servers.
  7. Connect to the database that PeopleSoft is installed on. Use the user that owns the PeopleSoft database.
    To find out who owns this database, run the following query:
         select owner from dba_objects where object_name = 'PSPRCSRQST';
    The owner returned is the one who owns the PeopleSoft database.
  8. Run the following SQL script:
    create or replace trigger precise_psprcsrqst_register after update of runstatus on psprcsrqst for each row
    when (new.runstatus = 7 and old.runstatus != 7) begin dbms_application_info.set_client_info(:new.oprid
    ||',,,'|| :new.prcsinstance || ',' || :new.prcsname
    ||',');
    exception when others then null;
    end;
    /

 

Precise. Performance intelligence from click to storage. Learn more > >

...

IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal

Save

...