Running ora_setup in a 12c Pluggable database (PDB) results in OCIStmtExecute: Oracle error ORA-01031: insufficient privileges as shown below:
./ora_setup
Welcome to the Oracle SharePlex setup process for port 2100.
This process creates tables and user accounts needed to run
Oracle SharePlex replication.
Will the SharePlex install be using a BEQUEATH connection? (Entering 'n' implies
a SQL*net connection) [y] : n
Please note the following:
** In response to prompts, a carriage return will choose the default
given in brackets. If there is no default, a reply must be entered.
** To exit the program while the program is waiting for input, use the
CTRL-C key sequence.
This sequences can be entered by holding down the CONTROL key and
pressing the C key.
Enter the TNS alias for which SharePlex should be installed [tnaalias1] : TNAALIAS2
Verifying TNS supplied ... done.
In order to create the SharePlex tables and user account, we must
connect to the database as a DBA user
Enter a DBA user for TNAALIAS2 : system
NOTE: Appending the tns alias to the password via @ sign is not needed.
Enter password for the DBA account, which will not echo :
connecting--This may take a few seconds.
validating user name and password. . . This may take a few seconds.
SharePlex objects will need to be created under a special
account. You can pick an existing user or create a new one.
Would you like to create a new SharePlex user ? [y] : n
NOTE: Appending the tns alias to the password via @ sign is not needed.
Enter username of an existing user : c##username
Enter user password for c##password
validating user name and password. . . This may take a few seconds.
Warning: This user is now being granted unlimited tablespace.
This privilege will remain in effect until it is explicitly changed.
SQL> GRANT SELECT ON SYS.USER$ TO c##username
OCIStmtExecute: Oracle error ORA-01031: insufficient privileges
Warning: Unable to grant select.
Do you want to enable replication of tables with TDE? [n] :
To enable replication of tables with TDE in the future, please rerun ora_setup.
Setup will now install SharePlex objects.
These are the existing tablespaces.
SYSTEM SYSAUX TEMP USERS
Enter the default tablespace for use by SharePlex [ ] : USERS
The current default tablespace for user c##sp_admin is TOOLS.
Do you want to change to USERS? [y] : y
Enter the temporary tablespace for use by SharePlex [TEMP] :
Enter the index tablespace for use by SharePlex [ ] : USERS
The current index tablespace for user c##sp_admin is TOOLS.
Do you want to change to USERS? [y] : y
Creating SharePlex objects [Installation type: Fresh]. . .
Creating SharePlex Oracle-timezone-region map . . . Done.
Creating Conflict Resolution Package . . . Done.
Creating SharePlex Dataequator package . . .
Loading Compare Package from "/opt/local/data1/cdbd1031/quest/splex8.6.2/product/
.app-modules/../util/sp_deq_pkg.plb"...Done.
Loading Compare Varray Package from "/opt/local/data1/cdbd1031/quest/splex8.6.2/p
roduct/.app-modules/../util/sp_deq_v_pkg.plb"...Done.
Will the current setup for sid: [TNAALIAS2] be used as source (including cases as
source for failover or master-master setups)? [y] :
Setup of SharePlex objects successful . . .
Incorrect procedure in granting the privileges prior to 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.
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy