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