The following errors are observed when ora_setup fails:
Creating SharePlex objects [Installation type: Fresh]. . .
SQL> CREATE TABLE SPLEX.SHAREPLEX_ACTID
(ACTID NUMBER,SEQNO NUMBER,OFFSET NUMBER,INSTANCE_NAME VARCHAR2(16),HOST_NAME VARCHAR2(64),AB_FLAG NUMBER,
QUE_SEQ_NO_1 NUMBER,QUE_SEQ_NO_2 NUMBER,SP_THREAD_MSG_SEQ NUMBER,SP_THREAD_MSG_SEQ_WRAP NUMBER,COMMAND VARCHAR2(255),ACTIVATION_FLAG NUMBER, LOG_START_OFFSET NUMBER,END_RECOVERY_SEQNO NUMBER,END_RECOVERY_OFFSET NUMBER)
TABLESPACE SPLEX
.
.
ORA-01653: unable to extend table table_name by nnn in tablespace tablespace_name
The tablespace in question cannot extend due to inadequate size of the datafile(s) associated with it.
Either add a datafile or resize the current data file to add more space to the tablespace in question.
Then run ora_setup again.
When ora_setup is run, it creates or modifies Shareplex internal tables and some associated indexes in the database. In either case it may run out of space in the tablespace that houses those objects, if the tablespace is not adequately sized. Hence the corrective action described above may be required.
Here is the description of ORA-01653:
ORA-01653: | unable to extend table string.string by string in tablespace string |
Cause: | Failed to allocate an extent of the required number of blocks for a table segment in the tablespace indicated. |
Action: | Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated. |