Windchill Requirements for the Oracle Database
• Database block size: 8K, 16K.
• Database NLS_CHARACTERSET: AL32UTF8 and NLS_NCHAR_CHARACTERSET: UTF8.
• NLS_LENGTH_SEMANTICS: Set to BYTE
• Database must have Oracle Text, Enterprise Manager Repository and Oracle XML DB feature installed
• Required Tablespaces:
◦ USERS
◦ BLOBS
◦ INDX
◦ WCAUDIT
The following is a sample script to create a tablespace:
• Function-based indexes support enabled
Enable following database properties to activate Function -based indexes support:
◦ query_rewrite_enabled='true'
◦ query_rewrite_integrity='enforced'
• Database user must be granted followings privileges:
◦ Connect
◦ Resource
◦ Create Sequence
◦ Create View
◦ Unlimited Tablespace
• Database must have a defined Service Name that is registered with Oracle listener. If Windchill Business reporting (WBR) is being installed then database SID and Service Name must be defined with the same name.
|
|
Do not grant DBA or Database Admin roles or privileges to Windchill database users.
|
