Activation errors “StmtExecute failed with ORA 1031” and “Oracle error getting objectid for” when activating in Oracle 12c or higher (4302111)

Activation errors “StmtExecute failed with ORA 1031” and “Oracle error getting objectid for” when activating in Oracle 12c or higher

The following errors are seen in the event_log when activating in Oracle 12c or higher:

Error    2016-04-26 17:36:25.593589 5301 1 Command server: Oracle error getting objectid for OWNER.TABLE_NAME  (connecting from server_name) [module ocf]

Error    2016-04-26 17:36:25.590582 5301 1 Command server: StmtExecute failed with ORA-1031.  (connecting from server_name) [module osp]

Inadequate privileges granted to SharePlex user in the database when running ora_setup.

As a workaround, carry out the following steps:

1.      Grant the following privilege to SharePlex user by logging in as sysdba:

SQL> grant select on sys.user$ to <shareplex schema> with grant option container=ALL;

2.      Re-run ora_setup.

3.      Activate again.

In Oracle 12c and up, the following needs to be done prior to running ora_setup (as taken from SharePlex Installation Guide): Required privileges to run Oracle Setup The user who runs Oracle Setup must have the following privileges: Non-multitenant (standard) database The user running Oracle Setup must have DBA privileges, but if support for TDE is required, then this user must have SYSDBA privileges. Multitenant database The user running Oracle Setup must be a common user with DBA privileges. The minimum following grants are required: create user c##sp_admin identified by sp_admin; grant dba to c##sp_admin container=ALL;