QuercusPlus 8.0 Installation Guide<>

QuercusPlus baseline installer

Scope of this chapter

This section addresses the installation of the QuercusPlus database schema and the base set of static data.

Note: the information in this chapter applies to new databases installed as part of a clean set-up. It does not apply to upgrades.

Prerequisites

Knowledge of Oracle Database software.

Familiarity with SQL*Plus.

Knowledge and familiarity with Oracle IMP routine.

Assumptions:

An empty database built using the Oracle Database Configuration Assistant – see section 4.1

The empty database has the following custom tablespaces defined:

Quercus_Data

Quercus_IDX

LOB_Data

Note: the standard Oracle tablespaces should also exist in this database.

Installation

If not already present, copy the zipped installation media to the root directory of the installation drive of the server and unzip it, hereafter $MEDIA. This creates a directory with a number of sub-directories below it.

1Create a desktop shortcut for SQLPlus on the desktop by copying it from the Start Menu and pasting it to the desktop.

2Right-Click the desktop SQLPlus icon to edit its properties.

3Set the Start in field to the root of the $MEDIA directory on the installation disk and click OK.

4Double click the new shortcut to run SQLPlus and Login as the system user to the database instance.

The SQL> prompt will be displayed.

Set-up users and roles

To set up users and roles

1Using the SQLPlus shortcut on the desktop, connect to the QuercusPlus database as the SYSTEM user and run the following script:

SQL> @Create_users_and_roles.sql

This creates the necessary users and roles and generates a log file, which is located in the $MEDIA\logs directory.

2Exit SQLPlus.

Importing system tables and Quercus schema

Included in the installation media are three Oracle DMP files that contain the database schema for each user created in To set up users and roles (above). These DMP files have to be imported into the database using the Oracle IMP executable.

Quercus Schema

To import the QUERCUS user objects into the database instance

1Open a DOS prompt and type:

imp system/<<password>>@<<DBNAME>>

2When prompted for an export file enter:

$MEDIA\dump_files\QUERCUS_BASELINE.DMP

3Respond to the subsequent prompts as follows:

Prompt

Response

Buffer Size

accept default

List the contents of import file only

N

Ignore errors due to existence of objects

N

Import grants

N

Import table data

N

Import entire export file

N

Username

QUERCUS

List of tables to import

accept default

CITSYS Schema

To import the CITSYS user objects into the database instance

1Open a DOS prompt and type:

imp system/<<password>>@<<DBNAME>>

2When prompted for an export file enter:

$MEDIA\dump_files\CITSYS_BASELINE.DMP

3Respond to the subsequent prompts as follows:

Prompt

Response

Buffer Size

accept default

List the contents of import file only

N

Ignore errors due to existence of objects

N

Import grants

N

Import table data

N

Import entire export file

N

Username

CITSYS

List of tables to import

accept default

Note: The filenames are likely to change over time; copies of the latest baseline database should be obtained from the development team.

Inserting the static data

The static data is built by running a script named runall.sql. To run the script start SQLPlus via the previously created shortcut on the desktop.

1Connect to the database as the SYSTEM user.

2At the prompt type:

@run_update.sql

This launches the static data build, calling the scripts necessary for setting up the appropriate static data, based on the values of the variables that have been set in the SetSQLEnv.sql file. It also creates the synonyms for all the tables, objects, views and types in the QuercusPlus schema and grants each of the roles the appropriate privileges.

The scripts generate log files in the $MEDIA\logs directory. These should be checked for errors.

Check for successful build

If the build has succeeded it should be possible to connect to the database via the QuercusPlus application and run the application without any errors.