IBM Tivoli Composite Application Manager for Application Diagnostics, Version 7.1.0.1
Manually creating Oracle tables
If your database is Oracle:
- Extract the oracle-remote-scripts.zip file from the MS_/path/to/install\base\scripts directory into a temporary directory.
- Run the following command to export the ORACLE_SID used by the Managing Server:
export ORACLE_SID=octigate- Run the oracleinstall.bat script, which has the following format:
cd c:\temp\oracle bin\oracleinstall.bat oracle_sid sqlplus_user sqlplus_password tablespace jdbc_user jdbc_password user_interface_user
- oracle_sid is used to identify the Oracle environment. To find this value, see the value for the ORACLE_SID environment variable for the operating system.
- sqlplus_user was determined when the Oracle environment was configured prior to starting the Managing Server installation. If you do not know this value, consult your database administrator.
- tablespace is the name of the table space to be created when you run the oracleinstall.bat script. This is the table space the Managing Server will use. This tablespace will be removed if it exists.
- jdbc_user is the Schema user. The Schema user is the user that the Managing Server uses to connect with Oracle, using JDBC. This Schema user must exist in the local operating system. This was specified during the Managing Server installation.
- user_interface_user is the user to be used when logging in and operating the Managing Server's ITCAM for Application Diagnostics Managing Server after installation and configuration. This value is the installation user (default) or a value you specified during the Managing Server installation.
Parent topic:
Manually creating database tables