-
Title
Running ora_setup in a 12c Pluggable database (PDB) results in OCIStmtExecute: Oracle error ORA-01031 -
Description
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 . . .
-
Cause
Incorrect procedure in granting the privileges prior to running ora_setup.
-
Resolution
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.
-
Additional Information
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;”