IBM Tivoli Composite Application Manager for Application Diagnostics, Version 7.1.0.1
Procedure
To prepare an existing local Oracle environment:
- Create an Oracle database with an SID name of octigate, using utility:
dbcaFor 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- 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.
- Create a user ID and password for the table space for which the user has authority to create and edit tables.
- Configure a rollback segment using the Oracle default size for rollback segments.
- 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.
- (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;- 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"- 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