IBM Support

Creating P8 Domain error: ORA-01950: no privileges on tablespace SYSTEM, for FileNet Content Engine

Troubleshooting


Problem

FileNet Content Platform Engine error when creating P8 domain - ORA-01950: no privileges on tablespace SYSTEM

Symptom

When attempting to create a new FileNet P8 Domain in FileNet Content Platform Engine (CPE), the following error message displayed :

ORA-01950: no privileges on tablespace 'SYSTEM'

Cause

This behavior will occur if the Oracle user configured for the Global Configuration Data ( GCD) JDBC datasources has the default tablespace configured be SYSTEM. The documented minimum required permissions for the CPE database user for Oracle state the following grant :

Alter user set QUOTA UNLIMITED on all table spaces used by db user

Diagnosing The Problem

Determine if the Oracle user used for the GCD datasources has the default tablespace set to SYSTEM.

Resolving The Problem

If the default tablespace for the user is set to SYSTEM, it is highly recommended to create a separate tablespace for the GCD ( and other object stores) and apply the quota grant rather than using the SYSTEM tablespace.

[{"Product":{"code":"SSNW2F","label":"FileNet P8 Platform"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Content Engine","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"5.2.1;5.2","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
17 June 2018

UID

swg21701524

Page Feedback