IBM Tivoli Composite Application Manager for Application Diagnostics, Version 7.1.0.1

Procedure

To prepare an existing local Oracle environment:

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

    For the Solaris operating system, make sure that the UNIX sqlplus user (oracle's) environment variables are defined in a users_home_dir/.profile file (if using ksh or sh) and .bash_profile (if using bash). For example:

    /export/home/oracle/.profile

  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 scripts for configuring an existing database as a guide for creating your own script to configure your database.

  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;

  7. For Solaris, the sqplplus user must use an sh shell and variables must be defined in the .profile file. To verify this run the following command, which will return your sqlplus path:
    su - sqlplus_user(oracle) -c "which sqlplus"

  8. For an Oracle 10g instance, follow the tuning instructions described in the file: MS_/path/to/install/base/etc/oracle10g-readme.txt.


Parent topic:

Prepare an existing local Oracle environment

+

Search Tips   |   Advanced Search