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.
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.
To install the Interpoint for PeopleSoft Collector’s trigger and enable the database monitoring parameter
PT%version%\appserv\%domainName%
folder). If EnableDBMonitoring=1, proceed to step 7. Otherwise, continue with the next step. 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;
/
| | | | | | | |