Useful for:

  • Changing the location of your Oracle database
  • Rescuing an Oracle database used by QPS

Procedure:
To update the QPS link to a new Oracle database location:

  1. Quit QPS Server.
  2. Make a cold back up of the Oracle Database.
  3. Move all the files to the new machine (where Oracle will be installed).
  4. Restore the backup files.
  5. Navigate to the QPS Server machine and open the conf folder located inside the QPS Server folder.
  6. Open the file named “ServerApp.properties”
  7. Edit the following entry with the latest information:
    set qpp.jdbc.url = jdbc:oracle:thin:@<hostname><:portnumber><:oracle_sid>
  8. Save the “ServerApp.properties” file and close it.
  9. Restart QPS Server.