There is No specific processor built only for Oracle but if you are talking about Oracle DB then one can use ExecuteSQL/PutSQL with DBCPConnectionPool Controller where DBCPConnectionPool controller ie generic implementation to connect any DB and it requires a local copy of Database specific client driver and driver class name.
If you found this response assisted with your issue, please take a moment to login and click on "Accept as Solution" below this post.
Regarding a CDC in NiFi for an Oracle instance, I highly recommend the following article as it guides you step by step in order to perform a partial CDC, only for UPDATE and INSERT:
This solution will not work for DELETE, but based on that example you can create your own. This will however eat lots of resources if not configured properly.
You need to look at CDC tools like Cloudera Kafka Connect with Debezium or Cloudera SQL Streaming Builder with Debezium.
Or you can do Oracle GoldenGate with Kafka.
I have some examples in this article