PTC Arbortext Content Delivery Requirements for the Oracle Database
• Determine which versions of Oracle are supported for your application. For more information, see the software matrix available from the PTC Reference Documents site.
• On Windows systems, the installing user needs to be a member of the Administrator's group. It does not matter whether the user is a local user or a domain user.
• You must have 5 GB available hard disk space for an Oracle server installation with a PTC Arbortext Content Delivery database. More hard disk space might be needed for larger databases.
|
Bundle Size
|
Recommended Hard Disk Space for Oracle Database
|
|
11 GB
|
5.5 GB
|
|
75 GB
|
15 GB
|
|
1 TB
|
1 TB
|
 |
This is only a recommendation as it depends on the content of the bundles.
|
• For additional installation requirements, consult the Oracle documentation.
• When you use Oracle database for PTC Arbortext Content Delivery, in the SQLNET.ORA file, set the SQLNET.EXPIRE_TIME=10 on Oracle Listener to PTC Arbortext Content Delivery.
• To complete the installation, you must configure Oracle with the following settings. PTC recommends you gather this information in advance to allow the installation to proceed without interruption:
◦ Name to assign to the listener.
▪ Default is LISTENER.
◦ Protocol type.
▪ Default is TCP/IP.
◦ Port number for the protocol type.
▪ The default for TCP/IP is 1521.
• Database block size: 8K, 16K.
• Database NLS_CHARACTERSET: AL32UTF8 and NLS_NCHAR_CHARACTERSET: AL16UTF16.
• NLS_LENGTH_SEMANTICS: Set to BYTE
• Required Tablespaces:
◦ USERS or Database Default Tablespace
◦ BLOBS
◦ INDX
◦ WCAUDIT
The following is a sample script to create a tablespace:
CREATE TABLESPACE “<Tablespace_Name>”
LOGGING
DATAFILE '<absolute path to the datafile name>' SIZE
1000M
AUTOEXTEND
ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 128K SEGMENT SPACE MANAGEMENT AUTO;
LOGGING
DATAFILE '<absolute path to the datafile name>' SIZE
1000M
AUTOEXTEND
ON NEXT 1M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL
UNIFORM SIZE 128K SEGMENT SPACE MANAGEMENT AUTO;
• Function-based indexes support enabled
Enable the following Oracle database properties to activate Function -based indexes support:
◦ query_rewrite_enabled='true'
◦ query_rewrite_integrity='enforced'
• The database schema user must be granted followings privileges
◦ Connect
◦ Resource
◦ Create Sequence
◦ Create View
◦ Query Rewrite
◦ Select any dictionary
◦ Unlimited Tablespace
|
|
Do not grant DBA or Database Admin roles or privileges to PTC Arbortext Content Delivery database users.
|