QPR Knowledge Base

Set Up Oracle for QPR Products

Hide Navigation Pane

Set Up Oracle for QPR Products

Previous topic Next topic No expanding text in this topic  

Set Up Oracle for QPR Products

Previous topic Next topic JavaScript is required for expanding text Mail us feedback on this topic!  

Comments (...)

Here are the instructions for setting up an Oracle DBMS for QPR products:

 

Install Oracle.

 

 For Oracle installation instructions, see the Oracle manual.

 

Create and configure a database for QPR products.

 

All QPR products use a single database instance, so you need to create and configure only one database for the whole system.

 

Please consult your Oracle manual for instructions on creating a new database.

     

A minimum QPR database should work fine with the default database configurations. However, make sure that there is enough hard drive space allocated for the database tablespace as well as the transaction log. They both should have space for at least 100 MB of data. With larger amounts of data the allocations and database settings most probably need to be adjusted.

 

You can test your database configuration by clicking the Test Database Configuration button at the Database tab of the Common section in the QPR Configuration Manager utility, which can be found at the Utilities folder under your QPR 8.1 installation folder.

 

Verify also that there is an ODBC data source configured for the database and configure it if needed. In 64-bit Windows environments, the data sources configured with the ODBC Data Source Administrator available in the Control Panel cannot be seen in QPR Configuration Manager. To be visible, the data source must be configured with "odbcad32.exe", which can be found in C:\WINDOWS\SysWOW64.

 

 

Continuing with the Installation

 

Database installation is complete. However, before taking the database into use, you need to create the product-specific contents to it by using the QPR Configuration Manager utility. The database contents are created with the Create new database option in the Database Operations tab of the Common section. Note that you need to install the software before you can access the configuration utility, so you will have to create the QPR contents later during the installation procedure.

Comments (...)