**FOR CUSTOMERS USING ORACLE : PLEASE REFER TO SOLUTION DEF131090 PRIOR TO/AFTER UPGRADING** ... 2. E-mail attachments are no longer dropped during e-mail ... This defect has been fixed in 6.6.1.08. ... This change was introduced since Oracle has ... 8. Users no longer receive Oracle ODBC errors when creating ... This defect has been fixed in ... Oracle and are configured for UTF-8. ... 4. On systems using an Oracle DBMS, search results are now
create user PCMS_SYS identified by ****** default tablespace PCMS_DATA temporary tablespace PCMS_TEMP QUOTA UNLIMITED ON PCMS_DATA QUOTA UNLIMITED ON PCMS_IDX ERROR at line 1: ORA-65096: invalid common user or role name
The Dimensions installation creates a database schema called PCMS_SYS and a tablespace called PCMS_DATA. A minimum of 300 MB of disk space is required for PCMS_DATA; otherwise the installer will fail.
User should create a pcms_sys schema on the remote Oracle database and assign resource, connect and DBA roles to it, then run the install again, it should complete. SQL>create user pcms_sys identified by pcms_sys default tablespace pcms_data temporary tablespace pcms_temp; SQL>grant connect,resource,dba to pcms_sys;
Resolution for Dim 10.1 The error is caused by a PCMS_SYS schema that is not up-to-date. Use sqlplus to update the table admsys_basedbs in the pcms_sys schema.
To resolve this error, add the grants in the following ways to those newly imported base datrabases: Add grants on the pcms_sys database objects (adjust the path accordingly for the relevant Operating System) dmdba pcms_sys/pcms_sys@<service>
