VACOLS VM Trigger Fix M1 - department-of-veterans-affairs/caseflow GitHub Wiki

Download VACOLS_VM_trigger_fix_M1.zip and follow the instructions below

ON THE VACOLS VM:

  1. Log in to VACOLS VM (UTM)
    1. Oracle password is password
  2. Open a command prompt (search ‘cmd’ from start menu)
  3. Type sqlplus '/ as sysdba’ (include the single quotes) to run the SQL*Plus command line utility
  4. In SQL*Plus, run the following SQL command:
    1. GRANT CREATE TRIGGER TO VACOLS_TEST;
    2. Don’t forget the semicolon at the end!
    3. You should see “Grant succeeded” after running the command
    4. You can leave this open for the last steps

ON YOUR LOCAL MACHINE:

  1. Open SQLDeveloper and create a new connection to the VACOLS DB with the following settings:
    1. Name: vacols_test
    2. Username: VACOLS_TEST
    3. Password: VACOLS_TEST
    4. Hostname: localhost
    5. Port: 1521
    6. SID: BVAP
  2. After saving the connection, find it in “Connections” window on the left side of the program and click the “+” to connect and expand it
  3. Expand the “Triggers” folder
  4. For each trigger:
    1. Click to open it in the editor
    2. Replace all of the code for the trigger with the code from the associated file in the zip file above
    3. Save the file
    4. Verify that the “messages” window that pops up at the bottom of the screen says “Compiled” and does not say with errors

ON THE VACOLS VM (again):

  1. If you closed SQL*Plus, follow steps 1-3 to open it again
  2. In SQL*Plus, run the following SQL command:
    1. REVOKE CREATE TRIGGER FROM VACOLS_TEST;
    2. Don’t forget the semicolon at the end!
    3. You should see “Revoke succeeded” after running the command
  3. Type ‘exit’ to exit SQL*Plus and close the command prompt