After upgrade from version 4.5 to 5.3 Ora_setup fails for existing user:
Creating SharePlex objects . . .
SPLEX.SHAREPLEX_ACTID already exists; continuing setup . . .
SQL> INSERT INTO splex.SHAREPLEX_ACTID(actid,seqno,offset,activation_flag,ab_flag,que_seq_no_1,que_seq_no_2,sp_thread_msg_seq,sp_thread_msg_seq_wrap,log_start_offset)
VALUES(0,0,0,0,0,0,0,0,0,0)OCIStmtExecute: Oracle error ORA-00904: invalid column name
./ora_setup: Failed to create objects.
This is caused when the shareplex actid table has no rows .
Check the SHAREPLEX_ACTID and if it has no rows insert a row with 0 values into shareplex_actid table.
INSERT INTO <SHAREPLEX_USER>.SHAREPLEX_ACTID
VALUES
(0,0,0,0,0,0,0,0,0,0,0,0)
commit;
Run ora_setup.
OR
If this a TARGET MACHINE and you have stopped post prior to upgrade process. Drop the shareplex oracle user and recreate the user while running ora_setup.
