Running ora_setup in a 12c container database environment results in errors “OCIStmtExecute: Oracle error ORA-65048” and ORA-00959 (4300630)

Running ora_setup in a 12c container database environment results in errors “OCIStmtExecute: Oracle error ORA-65048” and ORA-00959

When running ora_setup in a 12c container database environment, the following errors are observed:

./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.

.

.

.

Enter the Oracle SID for which SharePlex should be installed [containerSID] :

.

.

These are the existing tablespaces.

SYSTEM SYSAUX UNDOTBS1 TEMP SHAREPLEX_DATA

Enter the default tablespace for use by SharePlex [ ] : SHAREPLEX_DATA

The current default tablespace for user c##sp_admin is TOOLS.

Do you want to change to SHAREPLEX_DATA? [y] : y

Enter the temporary tablespace for use by SharePlex [TEMP] :

Enter the index tablespace for use by SharePlex [ ] : SHAREPLEX_DATA

The current index tablespace for user c##sp_admin is TOOLS.

Do you want to change to SHAREPLEX_DATA? [y] :

SQL> Alter USER c##sp_admin DEFAULT TABLESPACE SHAREPLEX_DATA

OCIStmtExecute: Oracle error ORA-65048: error encountered when processing the current DDL statement in pluggable database pluggableSID

ORA-00959: tablespace 'SHAREPLEX_DATA' does not exist

The ora_setup has been run for the container SID whereas it needs to be run for the SID of a pluggable database within that container.

Re-run the ora_setup for the SID of the pluggable database within the container and not for the SID of the container database.