Oracle® Collaboration Suite High Availability Configuration Release 2 (9.0.4) for UNIX and Linux Part Number B15612-01 |
|
|
View PDF |
This appendix provides information and scripts for creating Information Storage tablespaces. It contains the following sections:
Section D.1, "Recommended Sizes of Information Storage Tablespaces"
Section D.2, "Creating the Tablespaces Required for Applying the 9.0.4.2 Patch Set"
Note: In the environment described in this document, the Veritas volume manager is used to manage disk volumes. It is recommended that you use a clustered file system. |
The required size of Information Storage tablespaces depends on the number of users of your system.
The following table provides the recommended sizes of Information Storage tablespaces:
Creating a Raw Volume for... | File Size (MB) |
---|---|
SYSTEM tablespace |
380 |
server parameter file |
5 |
USERS tablespace |
25 |
TEMP tablespace |
40 |
UNDOTBS tablespace 1 |
250 |
UNDOTBS tablespace 2 |
250 |
EXAMPLE tablespace |
160 |
CWMLITE tablespace |
20 |
XDB tablespace |
50 |
ODM tablespace |
45 |
INDX tablespace |
25 |
TOOLS tablespace |
10 |
DRSYS tablespace |
20 |
First control file | 110 |
Second control file | 110 |
At least 2 redo log files for each instance | 500 |
srvcfg (Voting disk for clusterware) |
100 |
RTC_BIG_DATA |
100 |
RTC_DATA |
100 |
RTC_INDEX |
100 |
See Also: For more information about sizing the database, refer to the Oracle Collaboration Suite documentation at |
Run the following commands to create the tablespaces required for applying the 9.0.4.2 patch set.
Note: If you are going to use raw volumes, then you will have to create the raw volumes before running the following scripts. |
CREATE TABLESPACE rtc_lookup_data DATAFILE '/dev/vx/rdsk/ocsstore-dg/rtc_lookup_data' SIZE 16m REUSE; CREATE TABLESPACE rtc_lookup_index DATAFILE '/dev/vx/rdsk/ocsstore-dg/rtc_lookup_index' SIZE 8m REUSE; CREATE TABLESPACE rtc_transaction_data DATAFILE '/dev/vx/rdsk/ocsstore-dg/rtc_transaction_data' SIZE 256m REUSE; CREATE TABLESPACE rtc_transaction_index DATAFILE '/dev/vx/rdsk/ocsstore-dg/rtc_transaction_index' SIZE 64m REUSE; CREATE TABLESPACE rtc_archive_data DATAFILE '/dev/vx/rdsk/ocsstore-dg/rtc_archive_data' SIZE 64m REUSE; CREATE TABLESPACE rtc_archive_index DATAFILE '/dev/vx/rdsk/ocsstore-dg/rtc_archive_index' SIZE 16m REUSE; CREATE TABLESPACE rtc_document_data DATAFILE '/dev/vx/rdsk/ocsstore-dg/rtc_document_data' SIZE 64m REUSE; CREATE TABLESPACE rtc_document_index DATAFILE '/dev/vx/rdsk/ocsstore-dg/rtc_document_index' SIZE 8m REUSE; CREATE TABLESPACE rtc_recording_data DATAFILE '/dev/vx/rdsk/ocsstore-dg/rtc_recording_data' SIZE 64m REUSE; CREATE TABLESPACE rtc_recording_index DATAFILE '/dev/vx/rdsk/ocsstore-dg/rtc_recording_index' SIZE 8m REUSE; CREATE TABLESPACE rtc_transient_data DATAFILE '/dev/vx/rdsk/ocsstore-dg/rtc_transient_data' SIZE 128m REUSE; CREATE TABLESPACE rtc_transient_index DATAFILE '/dev/vx/rdsk/ocsstore-dg/rtc_transient_index' SIZE 500m REUSE; CREATE TABLESPACE rtc_transient_lob_data DATAFILE '/dev/vx/rdsk/ocsstore-dg/rtc_transient_lob_data' SIZE 64m REUSE; CREATE TABLESPACE rtc_transient_lob_index DATAFILE '/dev/vx/rdsk/ocsstore-dg/rtc_transient_lob_index' SIZE 8m REUSE; CREATE TABLESPACE rtc_report_data DATAFILE '/dev/vx/rdsk/ocsstore-dg/rtc_report_data' SIZE 64m REUSE; CREATE TABLESPACE rtc_report_index DATAFILE '/dev/vx/rdsk/ocsstore-dg/rtc_report_index' SIZE 8m REUSE; CREATE TEMPORARY TABLESPACE rtc_temp tempfile '/dev/vx/rdsk/ocsstore-dg/rtc_temp' SIZE 128m REUSE;