文档解释
ORA-01356: active logminer sessions found
Cause: Logminer sessions are currently active.
Action: End all logminer sessions and retry.
ORA-01356错误是由Oracle数据库的LogMiner功能引起的，它表示仍然有活动的LogMiner会话与基础架构仍处于初始化状态，而初始化尚未完成。
官方解释
ORA-01356: active logminer sessions found
Cause: Some LogMiner sessions are still active while LogMiner was being initialized.
Action: Commit or rollback the transactions from all active LogMiner sessions and retry.
常见案例
一般情况下，当开发人员尝试初始化LogMiner时，就会发生这种情况。
正常处理方法及步骤
1. 首先，查找所有活动的LogMiner会话：
select sid, serial# from v$session
where program like ‘%LogMiner%’;
2. 关闭此会话：
alter system kill session ‘SID,Serial#’;
3. 再次初始化LogMiner：
begin
dbms_logmnr.add_logfile();
dbms_logmnr.start_logmnr(
options=>dbms_logmnr.dict_from_online_catalog);
end;
/
