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.