While activating the config in SOURCE, received below error in event_log
Warning 2020-01-12 01:13:51.386794 24843 2012734928 Activation: 13007 – No unique keys or primary key for object id 22581 (activating datasource o.DOYEN01) [module osp]
Error 2020-01-12 01:14:30.267352 24843 2012734928 Activation: Failed to find hostname for instance: ‘i3’ thread: ‘3’. ORA-01403: no data found (activating datasource o.DOYEN01) [module ocf]
Error 2020-01-12 01:14:30.279690 24843 2012734928 Activation: Instance: ‘i3’ thread: ‘3’ might be down. (activating datasource o.DOYEN01) [module ocf]
Error 2020-01-12 01:14:30.290149 24843 2012734928 Compile of “FIN_CONFIG_ALL_SCHEMAS_19” for database o.DOYEN01 failed: Error: Unable to activate config for ‘i3’ thread ‘3’.
Info 2020-01-12 01:14:30.560116 19816 1152180800 Activation exited with code=1, pid = 24843 (activating datasource o.DOYEN01)
“event_log” 27159L, 4685300C
Cause: It is trying to read the all redo threads in DOYEN01 and there are unused redo logs.
Solution: Drop unused redo logs and make sure valid threads are available.
Select * from gv$thread;
select * from gv$log; -> Drop all unused redo logs.
