How to Change the Oracle Database and Update Quark Publishing System (QPS)

Our Technical Support Portal has changed as we have moved to a new platform. Please visit support.quark.com to access your support tickets or to log a new ticket with us. All our existing customers should look for an email from support@quark.com for activation of their New Support Account. If you face any difficulty in accessing the new portal, please write to us at support@quark.com

How to Change the Oracle Database and Update Quark Publishing System (QPS)

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.
Was this answer helpful?YesNo
Topic Information
  • Topic #: 30026-1687
  • Date Created: 11/20/2012
  • Last Modified Since: 11/20/2012
  • Viewed: 1218
Welcome Guest