View Issue Details

IDProjectCategoryView StatusLast Update
0007054SymmetricDS ProBugpublic2025-09-12 12:24
Reporteremiller Assigned Toemiller  
Prioritynormal 
Status resolvedResolutionfixed 
Product Version3.14.0 
Target Version3.16.7Fixed in Version3.16.7 
Summary0007054: When a log-based Oracle node is connected to a PDB, the Oracle log miner leaves connections connected to the CDB
DescriptionWhen a log-based Oracle node is connected to a pluggable database (PDB), the Oracle log miner leaves connections connected to the container database (CDB). It encounters error ORA-65040, so it alters the session and switches to the container database (CDB), but it doesn't switch back to the PDB when it's done mining the log. Afterwards, when the log miner or another process gets this connection from the pool, it will still be connected to the CDB. This prevents SymmetricDS from retrieving metadata for tables in the PDB, which prevents the log miner from capturing changes.
Tagsdialect: oracle, log miner

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2025-09-11 18:42 emiller New Issue
2025-09-11 18:42 emiller Status new => assigned
2025-09-11 18:42 emiller Assigned To => emiller
2025-09-11 18:42 emiller Tag Attached: dialect: oracle
2025-09-11 18:42 emiller Tag Attached: log miner
2025-09-12 12:24 pbelov Status assigned => resolved
2025-09-12 12:24 pbelov Resolution open => fixed
2025-09-12 12:24 pbelov Fixed in Version => 3.16.7