• No results found

Using an Oracle Database for Indicative Data Storage

N/A
N/A
Protected

Academic year: 2021

Share "Using an Oracle Database for Indicative Data Storage"

Copied!
5
0
0

Loading.... (view fulltext now)

Full text

(1)

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?

(2)

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:

(3)

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

(4)

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

.

(5)

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.

References

Related documents

A comparison of the Oracle ZS3 Series with the EMC Data Domain deduplication storage systems in backing up Oracle Database shows that the Oracle ZS3 Series provides a superior

Secondary bond market intervention by EFSF has a twofold objective. First, it serves to support the functioning of the debt markets and appropriate price formation in

Therefore a focus group enable us to answer the research questions regarding potential reverse mortgage borrowers’ perceptions and fulfill the purpose of getting

objectives The purpose of this use case is to define a working infrastructure for an Oracle RAC environment with an Oracle 10 TB data warehouse database deployed on VMAX storage,

The storage-based replication (hot backup mode) of an Oracle single-instance database on a Celerra NS-480 storage array was to demonstrate that the Oracle 11g database

The minimum requirements on the qualifications and experience of the key personnel of a registered specialist contractor in site formation works category (RSC(SF)) are given in

The results of present investigation revealed that the irri- gation with magnetically water have similar effect as shown by pre-sowing seed magnetic field treatment and could possi-

Some researchers set forth to correct the ‘quantitative bias’ typical of the previous studies on gentrification by adopting “socio-anthropological methodologies” that