Page 1 of 5 Header goes here
Using an Oracle Database for Indicative Data Storage
This white paper describes how a customer can configure an Indicative installation to use an Oracle database for data storage.
This white paper contains the following main topics:
• Why would I configure Indicative to use an Oracle database?
• What versions of the Oracle database are supported?
• How do I configure an Indicative installation to use an Oracle database?
• How do I move Indicative data from the embedded Solid database to an Oracle database?
• How do I backup an Indicative installation that uses an Oracle database?
• Can I use the self-management DmsDatabase-Test to manage the Oracle database?
• What are the Oracle license requirements?
• How much table space will I need for the Indicative data?
Page 2 of 5 Measuring Web Quality of Service with the Indicative HTTP Test
Why would I configure Indicative to use an Oracle database?
Many customer environments already include an Oracle database that is supported by Oracle System Administrators with well-defined data backup procedures. Indicative can be configured to fit into that environment. Indicative can use an existing Oracle database to store data.
Indicative can be configured to use an Oracle database on the local or a remote host. Multiple Indicative installations can be configured to use the same Oracle database.
Moving Indicative data to an Oracle database does not make it accessible to other database applications. Indicative data is stored in a proprietary format and cannot be directly accessed by other database applications.
What versions of the Oracle database are supported?
Indicative support for Oracle data storage has been tested with the 10 version of the Oracle database. Indicative is a Java application and communicates with the database through a JDBC driver provided with the Oracle database. We expect that Indicative will work with other Oracle versions that provide a JDBC driver.
How do I configure an Indicative installation to use an Oracle database?
Indicative always installs the embedded Solid database. The following steps configure an Indicative installation to not use the installed Solid database and to use an existing Oracle database instead.
Data from an existing Indicative installation's Solid database can be migrated to an Oracle database. If you plan to do so, please read the "How do I move Indicative data from the embedded Solid database to an Oracle database?" before continuing.
1. Stop the Indicative DMS: bin/dms stop 2. Stop the Solid database: bin/db stop
3. Edit the conf/fh.conf file:
Under the "[Environment]" section, remove the soliddrv.jar from the CLASSPATH entry and add the Oracle jdbc driver. The Oracle jdbc driver is called classes12.zip, and is located in the Oracle installation directory, [ORACLE_HOME]/jdbc/lib.
Under the [Database] section change Connection to point at the Oracle database:
Connection=jdbc:oracle:thin:@<DATABASE>
where <DATABASE> is the host:port:SID. The Oracle server can be running on a remote host. The default Oracle port for 10 is 1521, and the SID is chosen when the Oracle server is installed.
Under the [Database] section, set Driver to the name of the oracle jdbc driver class:
Page 3 of 5 Measuring Web Quality of Service with the Indicative HTTP Test
Under the [Database] section add a ServerType, User, and UserPassword entry.
EncryptedUserPassword can be used instead of the UserPassword. The password can be encrypted with the bin/fhpasswd command:
ServerType=oracle User=<database user>
EncryptedUserPassword=<encrypted database user password> UseBlobs=true
Following are the actual differences between an original "conf/fh.conf" file before and after configuration for Oracle: The changes or additions are in bold type:
CLASSPATH=.:lib/jdk1.4.2/manager.jar:lib/jdk1.4.2/agents.jar:lib/jdk1.4.2/cncr rnt.jar:lib/jdk1.4.2/fh.jar:lib/jdk1.4.2/images.jar:lib/jdk1.4.2/jcchart.jar:l ib/jdk1.4.2/manager.jar:lib/jdk1.4.2/nexus.jar:lib/jdk1.4.2/smartfrog.jar:lib/ jdk1.4.2/soliddrv.jar:lib/jdk1.4.2/ssllib.jar:lib/jdk1.4.2/sslplus.jar --- [Database] Connection=jdbc:solid://localhost:9714/ Driver=solid.jdbc.SolidDriver < CLASSPATH=.:lib/jdk1.4.2/manager.jar:lib/jdk1.4.2/agents.jar:lib/jdk1.4.2/cncr rnt.jar:lib/jdk1.4.2/fh.jar:lib/jdk1.4.2/images.jar:lib/jdk1.4.2/jcchart.jar:l ib/jdk1.4.2/manager.jar:lib/jdk1.4.2/nexus.jar:libjdk1.4.2/smartfrog.jar:/extr a/oracle/OraHome1/jdbc/lib/classes12.zip:lib/jdk1.4.2/ssllib.jar:lib/jdk1.4.2/ sslplus.jar --- [Database] < ServerType=oracle < Driver=oracle.jdbc.driver.OracleDriver < Connection=jdbc:oracle:thin:@db-host:1521:ce4877d < User=SYSTEM < UserPassword=manager < UseBlobs=true
4. If the Indicative installation is on Windows then use the Control Panel Services utility to change the "Indicative-DB" service to manual startup.
5. Start the Oracle database server if not already started. Starting the Oracle server is specific to the customer environment. The bin/db start command will not start the Oracle server.
6. Test that Indicative can access the Oracle database server:
bin/db status
7. If moving data from Solid to Oracle, load the data now.
8. Start the Indicative DMS:
bin/dms start
Page 4 of 5 Measuring Web Quality of Service with the Indicative HTTP Test
How do I move Indicative data from the embedded Solid database to an
Oracle database?
If you want to migrate Indicative data from the Solid database to an Oracle database, you must first save the data to files by following this procedure before configuring the Indicative installation for Oracle.
1. Stop the Indicative dms:
bin/dms stop
2. Make a directory. There should be at least twice the disk space available as used by the
db/solid directory:
mkdir /data_dir
3. Copy the data from the Solid database to files in /data_dir:
bin/dbcmd -o dump -m all -n /data_dir
4. Configure the Indicative installation to use the Oracle database. Follow the procedure described in "How do I configure an Indicative installation to use an Oracle database?", but do not start the Indicative DMS.
5. Load the data saved to /data_dir into the Oracle database:
bin/dbcmd -o load -m all -n /data_dir 6. Start the Indicative DMS:
bin/dms start
All Indicative data is now accessible. The /data_dir directory and files can be removed.
How do I backup an Indicative installation that uses an Oracle database?
Use the Indicative bin/fhbackup command to backup the Indicative installation. Then use your environment specific Oracle backup procedure to backup the Indicative data in the Oracle database.
Can I use the self-management DmsDatabase-Test to manage the Oracle
database?
The Availability measurement will monitor the availability of the Oracle server configured for use by the DMS on the target host. The size of the Oracle database depends on your specific Oracle installation and cannot be monitored by the TotalSize measurement
.
Page 5 of 5 Measuring Web Quality of Service with the Indicative HTTP Test
What are the Oracle license requirements?
If you already have a "processor" license for the Oracle database on a server, then you can configure Indicative to use that database without an additional license requirement.
If you have a "named user" license then you must have a named user for the Indicative program and a named user for each person authorized to use the Indicative program. An example of a named user is a person that uses the Indicative GUI or Web-GUI.
If you have a custom license agreement or are licensed under an older Oracle licensing scheme such as UPU pricing then you should contact your Oracle representative to translate the
requirements described above.
There is no relationship between the number of measurements and capabilities of an Indicative license and Oracle license requirements other than indirectly because of scale and performance requirements.
How much table space will I need for the Indicative data?
The table space required depends on the service model. The number of measurements, their frequency, the actual data saved, the number of baselines, how many events are emitted, and the data aging policies determine how much table space is required. A service model with 10,000 measurements at a 5-minute frequency, 1,600 baselines, emitting 150 events every 5 minutes, and has the default aging policies will require 4 GB of table space. Since service models can vary greatly, you should regularly monitor the Oracle table space and extend it as required.
Legal Notices
Copyright © 2007 Indicative Software, Inc. All Rights Reserved.