Oracle Setup
The following steps are required in order to use Database Monitors with an Oracle database. Cleo provides the Oracle.zip file in theutils directory of your Clarify Server installation folder. Within that file is OracleInstallers.zip, which can be used to execute the required setup of your database.
Procedure
- Extract OracleInstallers.zip to the machine where the database resides.
- Execute the correct file based on operating system:
- For Windows, use the DbmonOraInst.bat file
- For Linux, use the DbmonOraInst.sh file.
Usage
This process requires you to provide the path to the location of the database on the
filesystem as well as the target database. These variables must be passed in as
parameters.
* In order for installation to succeed, user login must be an Oracle system/DBA-level
account.
| Var | Name | Description |
|---|---|---|
| 1 | OraBinPath | Path to Oracle bin directory where the loadjava command is located. |
| 2 | OraUser | Oracle username to login to target database*. |
| 3 | OraPwd | The password for the Oracle username specified in OraUser. |
| 4 | OraDbase | The name of the database the objects will be configured to. |
The JAVASYSPRIV role must be granted to any user of the Database Monitor for an Oracle database. Please contact your DBA for additional assistance.
The generic format for calling the file:
DBMonOraInst.bat <OraBinPath> <OraUser> <OraPwd> <OraDbase>
Note: When creating the EXTOL_DBMONITOR schema, you will be prompted for a password for
EXTOL_DBMONITOR user creation.
Results
Completion of the configuration process results in the following:
- Creates a user and schema (EXTOL_DBMONITOR).
- Loads and registers the stored procedure code, including dependencies.
- Creation of the database queuing table (EXTOL_DBMONITOR); the stored procedure uses this to queue messages for delivery to Clarify.
- Grants required permissions to the EXTOL_DBMONITOR table.
- Creates the stored procedures that will invoke the stored procedure code.
- Grants necessary execute permissions to the stored procedures.
- Creates an Oracle sequence object.