Page History

Post-installation action items

When the Oracle Tier schema is installed, post-installation tasks may be required. This mainly depends on factors such as the Oracle version, the operating system, and the granted privileges. In addition, this depends on whether Precise for Storage or Interpoint is installed.

For installation details, see the appropriate section for the specific product.

Installing the Interpoint for PeopleSoft Collector’s trigger

If you have installed the Interpoint for PeopleSoft Collector to monitor PeopleSoft activities, you need to create a trigger on the table PSPRCSRQST in the PeopleSoft database. In addition, you need to enable the database monitoring parameter in the PeopleSoft configuration file.

...

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 3continue with the next step.
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;
     /