Oracle Installation and Configuration
aPriori requires a MySQL, Oracle, or SQL Server database. This section describes the requirements for Oracle database configuration. If you are using MySQL or SQL Server instead, please go to either:
Oracle configuration should be performed by a certified Oracle Database Administrator.
NOTE: The aPriori client does not support client-side load balancing via the Oracle Real Application Clusters (RAC). If RAC is being implemented on your Oracle database, you must specify one particular USER/SCHEMA instance.
Installing Oracle
Before beginning Oracle installation and configuration, you should note the following information that is required by the aPriori client:
• Names of users, SIDs, service names, and port number are not assumed by the aPriori client. This means you are free to provide any values for the Oracle database, SID, username, password, etc. Make note of the following information because it is required during the installation of the client software:
• Oracle host name
• Oracle SID or Service Name
• Oracle username
• Oracle password
• aPriori assumes that this user is the owner of the database objects. Therefore, in order to use a username to connect which is different from the user who owns the database objects (tables and sequences), you must create synonyms which point to the actual objects.
To install and configure Oracle
You may decide to use an existing Oracle server for aPriori. If you need to install Oracle, the following steps outline the installation and configuration used by aPriori Quality Assurance for the servers used for certification.
Run the Oracle Setup file and during the installation use defaults except:
• In Step 2, choose: Create and configure a database. Specify any database name you wish.
• In Step 4: Specify Use Standard Edition, and Change Character Set to Unicode AL32UTF8
Note: aPriori uses Standard Edition for testing and certification, however, since this represents a subset of functionality of the Enterprise Edition, that should also work.
Once the installation is complete:
1 Set the PROCESSES initialization parameter to at least 150 + (5 * number of expected concurrent aPriori users)
2 Create a tablespace with any name you choose. Allocate at least 32Gb of available space for up to 100 total aPriori users and an addition 32Gb for each additional 100 users. Or choose unlimited tablespace.
3 Create a user with the Default Tablespace you created. This is the user that the aPriori client uses to connect to the server and owns the production database objects (unless you create synonyms to other user’s objects). Create any name and password you wish. This user is referred to as the master database since it contains the user and license information.
4 Grant the following System Privileges to the user created in the previous step:
• CREATE SESSION
• UNLIMITED QUOTA
5 (Optional) Create another user with the Default Tablespace you created. This user owns the database objects for the test deployment. It is recommended that the username have the word ‘test’ in it to indicate its purpose. The intent of the test deployment is as a safe place to test configuration changes.
6 Grant the following System Privileges to the user created in the previous step:
• CREATE SESSION
• UNLIMITED QUOTA
7 (Optional) Create another user with the Default Tablespace you created. This user owns the database objects for the training deployment. It is recommended that the username have the word ‘training’ in it to indicate its purpose. The intent of the training deployment is as a safe place to train new users on the software.
8 Grant the following System Privileges to the user created in the previous step:
• CREATE SESSION
• UNLIMITED QUOTA
9 Configure your server to listen on a public interface
To import the Oracle data files
1 Unzip the file named aPriori_databases_<version>.zip that was provided with the installation media. This file contains Oracle datapump dump files that can be imported into Oracle 12c or 11g.
2 Import the file into the user(s) you created in the previous section using the Oracle Data Pump Import command impdp. The specific parameters required can be found in the readme.txt file also included in the installation media.
Here are examples of the command. Replace the items in angle brackets ("< >") with the actual values and do not include the brackets. Note: This example uses the EZ_CONNECT method as opposed to TNSNAMES.ora.
For Service Name:
impdp <DBAusername/DBApassword@//hostname:port/serviceName>
dumpfile=STANDARDDATA<version>.sql directory=<your_server_datapump_dir>
SCHEMAS=APRIORI_DB REMAP_SCHEMA= APRIORI_DB:<your_schema_user>
REMAP_TABLESPACE= APRIORI_DB:<your_tablespace>
For SID:
If you use SID rather than Service Name, change the first line as shown:
impdp <DBAusername/DBApassword@//hostname:port:SID>
.
.
.
Additional Oracle information
• If you limit the number of connections to the aPriori database, set the number to 10 times the number of expected concurrent connections, as each client may have up to 10 connections at one time.
• Load balancing – aPriori does not support client-side load balancing currently. When installing the aPriori client, you must enter only one host name (or IP address). In client-side load balancing, the client application is given multiple IP addresses for the host and selects one of them at random when connecting.