Ask Your Question
1

Getting a writable operation error while using Oracle CDC

asked 2019-05-01 13:09:02 -0500

Dep gravatar image

updated 2019-05-02 17:17:56 -0500

metadaddy gravatar image

Dear Team, I am getting the following error while connecting through Oracle CDC client and my origin database is read only database but the error is database required for writable operation. what is the Oracle CDC execution process why I am getting writable required error

Caused by: java.sql.SQLException: ORA-01300: writable database required for specified LogMiner options ORA-06512: at "SYS.DBMS_LOGMNR", line 58 ORA-06512: at line 1

Thanks.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted
1

answered 2019-05-02 17:17:10 -0500

metadaddy gravatar image

updated 2019-05-02 17:20:59 -0500

This is a limitation of LogMiner itself - the LogMiner dictionary requires write access to the database for all modes except Extracting the LogMiner Dictionary to a Flat File, which does not guarantee transactional consistency. Oracle recommends using the online catalog or extracting the dictionary from redo log files, which are the options that Data Collector offers.

See the Oracle LogMiner documentation.

edit flag offensive delete link more

Comments

@metadaddy Thank you, We enable the supplemental logging and now we are fetching the data through Online catalog only incrementals, How do we get the batch data and sync to incremental data using Oracle CDC Client?

Dep gravatar imageDep ( 2019-05-04 04:23:51 -0500 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-05-01 13:09:02 -0500

Seen: 165 times

Last updated: May 02