WebSphere WebSphere Enterprise Service Bus, Version 6.0.1 Operating Systems: AIX, HP-UX, Linux, Solaris, Windows

Oracle database response file

An Oracle database response file specifies parameters for configuring an Oracle event database.

Purpose

These parameters can also be specified in the installation response file if CONFIGURE_DB is set to true and DB_TYPE is set to ORACLE. A sample Oracle database response file called OracleResponseFile.txt is available in the $WAS_HOME/event/dbconfig/oracle directory of the Common Event Infrastructure development system.

Parameters

SHARE_DB=[server|node|cell]
The scope at which the configured database will be shared. This is the scope at which JDBC data sources will be created. This parameter is optional; the default value is server.
WAS_SERVER=server
The name of the WebSphere application server where the database is installed. This parameter is applicable only if SHARE_DB is set to server. If you do not specify a server name, the default value is server1.
ORACLE_HOME=path
The path to the Oracle home directory.
DB_NAME=name
The name of the event database. This name is used as the Oracle System ID (SID). This parameter is optional; the default value is event.
JDBC_PROVIDER=provider
The name of the Java Database Connectivity (JDBC) provider to configure. The value must be the name of a JDBC driver supported by WebSphere Process Server Version 5.1. The Oracle JDBC Provider (XA) driver is recommended:
JDBC_CLASSPATH=path
The path to the JDBC driver (not including file name).
JDBC_DRIVER_TYPE=[thin|oci8]
The JDBC driver type.
DB_HOST_NAME=hostname
The host name of the database server.
DB_INSTANCE_PORT=port
The database instance port number.
EXECUTE_SCRIPTS=[YES|NO]
Specifies whether the database configuration scripts should be automatically run. If this parameter is set to NO, the scripts for configuring the database will be generated but will not be run.
DB_TYPE=ORACLE
The type of database being configured. For an Oracle database, this must be ORACLE.
SCHEMA_NAME=CEI
The database schema name to use. This should always be CEI.
PROFILE=profile
Specifies the profile for the schema user in the Oracle database. The default value is cei_profile.
ROLE=role
Specifies the application role for the schema user in the Oracle database. The default value is cei_role.
TABLE_SPACE_BASE_NAME=name
Specifies the default table space name. This name must be no longer than 18 characters. The default value is cei_ts_base.
TABLE_SPACE_BASE_PATH=path
Specifies the default table space path. The default value is cei_ts_base.
TABLE_SPACE_BASE_INITIAL_SIZE_MB=size
Specifies the initial size (in MB) of the default table space. The default size is 102 MB.
TABLE_SPACE_NEXT_EXTENT_SIZE_MB=size
Specifies the automatic increment size (in MB) of the default table space. The default size is 10 MB.
TABLE_SPACE_TEMP_NAME=temp
Specifies the temporary table space name. This name must be no longer than 18 characters. The default value is cei_ts_temp.
TABLE_SPACE_TEMP_PATH=path
Specifies the temporary table space path. The default value is cei_ts_temp.
TABLE_SPACE_TEMP_SIZE_MB=size
Specifies the initial size (in MB) of the temporary table space. The default size is 7 MB.
TABLE_SPACE_EXTENDED_NAME=name
Specifies the extended table space name. This name must be no longer than 18 characters. The default value is cei_ts_extended.
TABLE_SPACE_EXTENDED_PATH=path
Specifies the extended table space path. The default value is cei_ts_extended.
TABLE_SPACE_EXTENDED_INITIAL_SIZE_MB=size
Specifies the initial size (in MB) of the extended table space. The default size is 204 MB.
TABLE_SPACE_EXTENDED_NEXT_EXTENT_SIZE_MB=size
Specifies the automatic increment size (in MB) of the extended table space. The default size is 20 MB.
TABLE_SPACE_CATALOG_NAME=name
Specifies the table space name for the event catalog. This name must be no longer than 18 characters. The default value is cei_ts_catalog.
TABLE_SPACE_CATALOG_PATH
Specifies the table space path for the event catalog. The default value is cei_ts_catalog_path.
TABLE_SPACE_CATALOG_INITIAL_SIZE_MB
Specifies the initial size (in MB) of the event catalog table space. The default size is 10 MB.
TABLE_SPACE_CATALOG_NEXT_EXTENT_SIZE_MB=size
Specifies the automatic increment size (in MB) of the event catalog table space. The default size is 5 MB.

Reference topic

Terms of Use | Rate this page

Timestamp iconLast updated: 13 Dec 2005
http://publib.boulder.ibm.com/infocenter/dmndhelp/v6rxmx/index.jsp?topic=/com.ibm.websphere.wesb.doc\doc\rcei_install_oracleResponseFile.html

(C) Copyright IBM Corporation 2005. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)