When creating a schema owner for you may receive ORA -65096: invalid common user or role name If the pluggable database option was installed on the Oracle server
ODBC connection to Oracle fails and the following error appears when you attempt to connect to an Oracle 12c Release 2 database: [SBM][ODBC Oracle Wire Protocol driver][ Oracle ] ORA -28040: No matching authentication protocol When you attempt a test connection on the Database Server tab in SBM Configurator, it will fail as well.
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
possible to install directly into an Oracle 19 c database as the installer will not recognise the 19 c ORACLE _HOME. Full installer support is coming with the CM 14.5.2 release. For CM 14.5.1 we have released the attached updated DBIO libraries so that users can migrate their existing database to 19c.
The variable needs to be set to a valid version of Oracle , such as 9.2.0.0.0. Just modify the init<SID>.ora file and then stop/restart Oracle along with the Dimensions services.
Or SYSTEM> upgrade <basedatabasename> Note: The above can also be done directly on the table within Oracle Enterprise Manager. Disable the constraints, perform the upgrade and then reset.
