Activation worked on demo table but failed with real config due to the following error:
06/27/06 15:22 Notice: New activation id 198 [sp_tconf/19604]
06/27/06 15:22 Notice: Oracle compatible parameter='9.2.0.5' [sp_tconf/19604]
06/27/06 15:22 Notice: Performing a checkpoint on instance(s) [sp_tconf(rom)/19604]
06/27/06 15:22 Error: 1 - Error logging onto database 12560 [sp_tconf(rom)/19604]
06/27/06 15:22 Error: Failed to build rowmap [sp_tconf/19604]
06/27/06 15:22 Config compilation completed: datasrc - o.PTD2; file - pwtr_rep
06/27/06 15:22 Bad config file: file - pwtr_rep; sp_tconf error - Failed to build rowmap, check event_log and rmp log for details.
06/27/06 15:22 Process exited sp_tconf (for o.PTD2) [pid = 19604] - exit(1)
It may not have enough disk space for the tablespace where shareplex_rowidmap resides or resource is busy and shareplex can not lock the table for analyzing row-chaining.
RESOLUTION:
For database on 9i/10g, this issue can be resolved by enabling supplemental logging so that shareplex activation will skip analyzing row-chaining and reduce activation time.
Perform the following steps:
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
ALTER SYSTEM SWITCH LOGFILE
Then activate config again
sp_ctrl > activate config config_name
See solution 737 as well if you are on 8i database.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy