Oracle requirements

Your Oracle RDBMS must be active before you attempt to install and run USoft Developer. The client PC must have been set up with the appropriate Oracle client software, and connections to the RDBMS must be working. Refer to your Oracle documentation for details.

There are a number of specific system requirements which must be satisfied if you intend to use USoft Developer with an Oracle RDBMS. You must check that your system complies with these requirements before you proceed with the installation of USoft Developer.

Refer to your Oracle documentation for more detailed explanations of the requirements described here.

Supported versions of Oracle

Oracle versions 11 and 12 are currently supported by USoft Developer, in line with the policy that USoft should actively support the two most recent versions of Oracle.

In principle, Oracle 10 is also supported by USoft Developer, but support is limited.

Oracle network software for client PCs

If you use the Oracle RDBMS, you need Oracle client software to run Oracle on a network.

Creating USoft tables in Oracle

USoft Developer must be able to create tables in Oracle. Refer to your Oracle documentation for details of how to set up new users, and how to grant them CREATE TABLE, CREATE PROCEDURE, CREATE SEQUENCE, CREATE ROLE, and CREATE VIEW privileges. These privileges are only required for the application owner.

Tablespaces

If you install the complete USoft Product Set, table space for up to 300 tables, plus the associated indexes and sequences, will be required. This requirement will increase as applications are developed. As a guide, 10 Mb of table space will be required to install the complete USoft product set. Refer to your Oracle documentation for details of how to alter table space settings. For additional USoft Developer users, the table space requirement will depend on your environment:

•If each user has their own repository, add 10 Mb per user.

•If all users share the repository, add 1 Mb per user.

•For each Web Designer user account, reserve 10 Mb of table space.