Disable DLP

  • For Windows, execute the disableDLP.bat file from Argus Release Media\Database\Argus Safety\Utilities\DLP_Setup.
  • For Linux or Unix, execute the disableDLP shell script.

Note:

Oracle Argus Safety Case Save will not function in case any DLP trigger (s) starting with T_DLP_CASE exists in Oracle Argus Safety application schema. This fail safe is to prevent any case data corruption in DLP Schema, in case any trigger is disabled.

  • To check if DLP trigger is disabled, use the following SQL from Oracle Argus Safety Application Login:
    SELECT trigger_name FROM user_triggers WHERE trigger_name LIKE 'T_DLP_CASE%' AND status='DISABLED';
    
  • If all the triggers are enabled, check the value of CMN Profile Global Switch DLP_TRIGGER_ENABLED and update the value if it is 0:
    SELECT key,value FROM cmn_profile_global WHERE key ='DLP_TRIGGER_ENABLED' ;
    
    UPDATE cmn_profile_global SET value = 1 WHERE key ='DLP_TRIGGER_ENABLED' AND value != 1;
    COMMIT;