Activation is hanging, no errors found in the event_log or rmp log
Activation is hanging, no errors found in the event_log or rmp log. Supplemental logging turned on, Checked the rmp log and confirmed that activation is not moving forward
Event_log : 01/09/07 16:49 Logging user command: oracle activate config vint_config 01/09/07 16:49 Process launched: sp_tconf (for o.vint) [pid = 331458] 01/09/07 16:49 Notice: Oracle env - vint:/ora01/oracle/product/220.127.116.11.0 [sp_tconf(pdb)/331458] 01/09/07 16:49 Compiling a configuration file: datasrc - o.vint; file - vint_config 01/09/07 16:49 Notice: Oracle version 92 [sp_tconf(osp)/331458] 01/09/07 16:49 Notice: New activation id 36 [sp_tconf/331458] 01/09/07 16:49 Warning: 13007 - NO_UNIQUE_KEY_WITH_LONG found on object id: 21495 [sp_tconf(osp)/331458] 01/09/07 16:49 Warning: 13007 - NO_UNIQUE_KEY_WITH_LOB found on object id: 7481 [sp_tconf(osp)/331458]
Source database is not in archive log mode, shareplex was hanging when it tries to update internal tables.
Check the database to see if you can log in through SQL PLUS. If not try to find out the cause and fix database issue. In this case database was not in archive log mode. Turn on archiving and activation succeeds.