IBM Tivoli Composite Application Manager for Application Diagnostics, Version 7.1.0.1

Prepare the remote Oracle environment

To prepare the remote Oracle environment:

  1. Create the SID for use by the Managing Server. Record the name of the SID; you may use the default name, octigate.

    If you use a SID name other than octigate, explicitly specify this name when installing the Managing Server using custom or silent installation.

  2. Create a temporary directory on the remote server. Example: /tmp.

  3. ftp the file oracle-remote-scripts.tar to the temporary directory.

    The oracle-remote-scripts.tar file is provided with the Managing Server distribution (in in MS_/path/to/install/base/scripts/).

  4. Log in as a user with dba privileges. For example: oracle.

  5. Untar the oracle-remote-scripts.tar file.

  6. Run the following command to export the ORACLE_SID used by the Managing Server: 

    export ORACLE_SID=octigate
    If you are using a SID name other than octigate, specify that SID name instead.

  7. Run the oracleinstall.sh script, which has the following format: 

    cd /tmp/oracle
    sh bin/oracleinstall.sh sqlplus_user sqlplus_password tablespace schema_user
 schema_password adminVEuser
    oracle_sid is the SID name you have just created.

    sqlplus_user and sqlplus_password are credentials for Oracle SQL Plus. The user must have privilege to create tablespace and users. You can specify the Oracle system user credentials.

    tablespace is the name of the table space to be created when you run the oracleinstall.sh script. This is the table space the Managing Server will use. This tablespace will be removed if it exists.

    schema_user and schema_password are the login and password of the user that the Managing Server uses to connect with Oracle, using JDBC. This same login and password must be used during the Managing Server installation. This Schema user must exist in the local operating system.

    adminVEuser is the operating system user to be used for the Visualization Engine component. This user is also the default administrative user in the Visualization Engine user interface. See Custom installation and upgrade: creating the user interface user.

  8. For Solaris, the sqlplus 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"

  9. 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 remote Oracle environment

+

Search Tips   |   Advanced Search