EVENT_LOG ERRORS:
11/06/06 13:50 Error: Failed to retrieve Shareplex_Trans info: rc = 942, ORA-00942: table or view does not exist. [sp_opst (for o.ph1t-o.ph1t queue ausph2)/1462
8]
11/06/06 13:50 Error: 15030 - error getting information on SHAREPLEX_TRANS table,poster exit. [sp_opst (for o.ph1t-o.ph1t queue ausph2)/14628]
11/06/06 13:50 Process exited sp_opst (for o.ph1t-o.ph1t queue ausph2) [pid = 14628] - exit(1)
9i DDL replication was turned on during upgrade, shareplex_trans table may be dropped.
Before you upgrade oracle and shareplex
1. Disable 9i DDL replication
sp_ctrl> reset param SP_OCT_REPLICATE_ALL_DDL
2. Shutdown shareplex
3. Perform your Oracle upgrade
4. Perform your Shareplex upgrade
5. You can re-enable 9i ddl replication by:
sp_ctrl> set param SP_OCT_REPLICATE_ALL_DDL 1
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center