IBM Tivoli Composite Application Manager for Application Diagnostics, Version 7.1.0.1

Prepare an existing local Oracle environment

Perform these tasks if you want to use an existing local Oracle environment with the Managing Server. This section describes configuration tasks and requirements for setting up an existing Oracle environment that can be used to support the Managing Server. The Oracle configuration tasks described in this chapter are meant to serve as a general guide to the basic requirements for setting up the environment, not as comprehensive instructions. A database administrator might use a different approach. For detailed Oracle information, consult the Oracle documentation.

To use an existing Oracle environment create a database file manually. You must also have a valid user name and password to give you access to the required database for the Managing Server.

To prepare an existing local Oracle environment:

  1. Create an Oracle database with an SID name of octigate, using utility: 
    dbca

  2. Create sufficient table space for the management repository.

    One month of operational data might require a minimum of 10 GB. Your space requirements might vary, depending on your environment and monitoring configuration. For test purposes, a smaller database (300 MB to 400 MB) is sufficient.

  3. Create a user ID and password for the table space for which the user has authority to create and edit tables.

  4. Configure a rollback segment using the Oracle default size for rollback segments.

  5. Review the sample configuration scripts in Sample script for configuring existing databases as a guide for creating your own script to configure your environment.

  6. (Double-byte character environments only) If your operating system is enabled for a single-byte character set, it does not automatically accept double-byte character sets. You must enable your Oracle environment to store monitoring information that comes in double-byte character strings. The following sample command for creation of a database includes the CHARACTER SET UTF8 string (in bold text). This string enables storage of double-byte character sets: 
    CREATE DATABASE v920u
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'C:\Oracle\oradata\v920u\system01.dbf' SIZE 200M REUSE AUTOEXTEND ON
    NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE 'C:\Oracle\oradata\v920u\temp01.dbf'
    SIZE 10M REUSE AUTOEXTEND ON NEXT  640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE 'C:\Oracle\oradata\v920u\undotbs01.dbf' SIZE
    50M REUSE AUTOEXTEND ON NEXT  5120K MAXSIZE UNLIMITED
CHARACTER SET UTF8
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('C:\Oracle\oradata\v920u\redo01.log') SIZE 102400K, GROUP 2 ('C:\Oracle\oradata\v920u\redo02.log') SIZE 102400K, GROUP 3 ('C:\Oracle\oradata\v920u\redo03.log') SIZE 102400K;


Parent topic:

Configure an existing database environment to work with the Managing Server on Windows

+

Search Tips   |   Advanced Search